When to Use Record Links vs. Graph Edges in SurrealDB
A practical guide to choosing between SurrealDB’s record links and graph edges for modeling relationships, with a worked example, trade‑offs, and verification steps.
Loading…
ReadMeFeed / Community knowledge
#data-modeling
Real questions. Useful conversations. Find the people who know your stack.
surrealdbFirestore Read Optimization: When to Stop Normalizing Your Data
Stop performing expensive client-side joins in Firestore. Learn how to use the Fan-out pattern and Cloud Functions to optimize read performance through strategic denormalization.
ShotGrid Data Modeling: Built-in Asset Entity vs. Custom Entities
Deciding between ShotGrid's built-in Asset entity and a custom entity? Learn the trade-offs between setup speed and data isolation, with a Python implementation guide for custom props.
shotgridStop Using Join Tables: Managing Relationships with SurrealDB Record Links
Stop managing cumbersome join tables. Learn how to use SurrealDB Record Links and Graph Edges to simplify your schema and perform high-performance data traversals.
Choosing Between Custom Fields and Custom Entities in Shopware 6
A decision guide for Shopware 6 developers choosing between Custom Fields (JSON metadata on existing tables) and Custom Entities (dedicated DAL definitions with relationships and indexes). Includes migration examples, performance trade-offs, and a validation checklist.
Cassandra Materialized Views: Quick Reads, Hidden Costs, and When to Use Them
Materialized views let Cassandra auto‑replicate a table with a different primary key, speeding up read patterns that would otherwise require client‑side filtering. This blog walks through how they work, a concrete example, the trade‑offs, and a quick decision checklist.
cassandraKeeping Denormalized Cosmos DB Documents Consistent with TransactionalBatch
Denormalized Cosmos DB models often require two documents to change together. TransactionalBatch gives you atomic, all-or-nothing writes within one logical partition — here's how it works, a .NET example, and where it falls down.
azureSolving Data Fragmentation in Notion with Relations and Rollups
Stop duplicating data in Notion. Learn how to use Relation and Rollup properties to connect databases and automate progress tracking and data aggregation.
Firestore Data Modeling: When to Denormalize for Performance
Stop fighting the lack of JOINs in Firestore. Learn when to duplicate data via denormalization to reduce latency and costs, and how to handle the resulting update complexity.