Exploring Specialized Storage Paradigms

Just a guy who loves to write code and watch anime.
Search for a command to run...

Just a guy who loves to write code and watch anime.
No comments yet. Be the first to comment.
Qualities that make outstanding builders.

Bipedal vs quadrupedal: how many legs This is about the number of legs the creature walks on. Bipedal. Two legs. Humans, ostriches, T-rex, kangaroos, most fantasy humanoids. Quadrupedal. Four legs. Do

Intro You hear "lerp" and "smoothstep" everywhere in game dev. They sound like math jargon. They're not. Both are small tools that do the same job: smoothly move from one value to another. The problem

What is Kinematics Kinematics is the math field. It's the study of how things move without worrying about forces (which would be dynamics). FK and IK are the two branches: forward kinematics and inver

Intro Textures are usually the biggest cost in a 3D scene. Memory, bandwidth, and load time all get eaten by them. Resizing them is the obvious lever. There's more. This post is about the less obvious

In the world of databases, we don't just have SQL or NoSQL databases. Specialized storages exist for different use cases.
Blob Storage, standing for Binary Large Object, is designed for handling unstructured data such as files, images, and videos. Unlike relational databases that require data to be stored in a structured format, Blob Storage allows for the storage of massive amounts of unstructured data.
Access to blobs is typically done through a key-value interface, where a unique key is used to upload, retrieve, or delete the blob. This simplicity makes Blob Storage highly efficient for specific tasks.
Storing large multimedia files
Backing up data
Serving images or documents directly to a browser
Amazon S3
Google Cloud Storage
Azure Blob Storage
A Time Series Database is optimized for handling data that changes over time, such as sensor readings, stock market prices, or application logs. These databases excel at storing, retrieving, and analyzing time-indexed data.
Efficient storage and querying of time-stamped data
Built-in functions for time-based aggregations and calculations
IoT device monitoring
Financial market analysis
Application performance monitoring
InfluxDB
Prometheus
Graphite
Graph Databases use graph structures (nodes, edges, and properties) to represent and store data, focusing on the relationships between data points. They are particularly useful for data models where relationships are as important as the data itself.
Handles complex searches on highly connected data well
Easier to model certain types of data relationships
Social networks
Recommendation systems
Fraud detection
Neo4j
Amazon Neptune
Azure Cosmos DB
Graph databases make it easy to search through connections between data points. For example, with Neo4j’s Cypher query language, you can quickly find the shortest path between two points or gather data from a network of connections.
Spatial Databases are optimized for storing and querying data related to objects in space, including locations on the earth, geographic information, and maps. They handle spatial data more efficiently than traditional relational databases.
Spatial databases often use data structures like Quadtrees to efficiently store and query spatial information. A Quadtree is a tree structure where each node represents a spatial region, and branches divide that region into four smaller quadrants, recursively.
Geographic information systems (GIS)
Location-based services (e.g., finding nearby restaurants)
Spatial analysis in various industries
Spatial queries, such as finding all points within a given distance from a location, are much faster using spatial databases thanks to their optimized indexing methods.