3 ms·
I built a pseudo-graph database for relational data for my company on DynamoDB that has been really amazing in both performance and utility. The data model is d
by jugg1es 5y ago
I built a pseudo-graph database for relational data for my company on DynamoDB that has been really amazing in both performance and utility. The data model is defined entirely by configuration, so adding use cases is just modifying the configuration. I've only had to touch the core system once or twice in 3 years and we've added about 10 use cases to it. The only thing it can't do well are things that a RDBMS has no trouble doing - namely getting all of one entity for analytical purposes, but we solved that problem using redshift and dynamoDB streams.
- j6m8 5y agoHey cool! I'm super curious to hear more about this. I _also_ wrote a pseudo-graph-database on DynamoDB (https://github.com/aplbrain/grand https://github.com/aplbrain/grand) :) It pretends it's a networkx.Graph, generally, but we also have a Cypher implementation on top of it. Would love to chat more about this sometime if you were interested!
- jugg1es 5y agoWhy do you call yours a pseudo-graph database? I use that term because my system only allows 1 true level of depth before you have to query again. You also have to predefine the data model, but that's so that it can automatically choose the right entity type (to format the PK/SK correctly) and so that it supports automatic Global Secondary Index selection as it dynamically generates the query. It also means that each entity can only have up to 5 extra indexable key pairs. Well, I was wrong. I just looked it up and you can now have 20 GSI. It used to be 5 haha. Anyway, it would be cool to talk about your project. I'll check it out this week.