@greven sweet!
I’m very curious to know what it would take to make a drop-in replacement for Postgres in Phoenix …
it’s probably still a bit “early” to use in production as they are still actively developing it.
But the combination of Graph, Document and SQL-like queries could be epic.
In case of any interest, I played a bit with SurrealDB and wrote it down here thanks to the package SurrealEx.
Not talking of ETS, if you are looking for an embedded DB, SQLite performs much better. I didn’t put Redis in front either. However, SurrealDB promises easy sync and WebSockets and Live queries, not been documented yet. I didn’t either try a serverless version, to compare SurrealDB with say a headless Postgres, such as ElephantQL
I quickly looked through the mentioned libraries, SurrelaDB docs and concluded that the way forward would be replicating Redix with the difference of connecting through websockets.
That’s the only way forward to the production-grade library that I see.