Another article advocating GraphQL and graph databases:
Similar to how big tech moved with the NoSQL movement, well-known tech innovators are at the fore of the GraphQL wave. Following Facebook’s initiation of the GraphQL movement, Netflix, Twitter, Airbnb, PayPal, Shopify, and many more tech companies have jumped on board. The wave hasn’t stopped with the tech industry - companies like Starbucks, the New York Times, NBC, Fairfax, KLM airlines, Intuit, and Yelp are converting their tech stacks to GraphQL in response to business needs. Even companies that service the tech industry like GitHub and Atlassian have moved to GraphQL. The GraphQL Foundation lists many GraphQL adopters, and the list is growing daily.
Dolt supports most git like operations, where you can clone remote databases, branch data, commit, push, etc. All operations are also versioned so you can see history, roll back, etc. Dolt also has a MySQL compatible interface. Written in #go. Likely not the fastest database out there, but would be really interesting for workflows.
Ben also wrote a tool that replicates a SQLite database to S3 in real-time.
This is all very interesting as I’d like a better database solution in Simple IoT. Genji has done pretty well, but the Db file format is still changing every release, so that makes SIOT upgrades more painful. I’m also realizing that we’ll need to cache quite a bit in SIOT to get the performance we need, so the database is less important. Anyway, it seems SQLite could be a good solution that will scale from embedded edge systems to server/cloud systems with real-time backups.