Conduit is a simple, fast and reliable chat server powered by Matrix. Conduit is an alternative to Synapse and tries to be lightweight and easy to install, but it is still in development.
Given Conduit’s focus on being lightweight with simple setup, imo using an embedded DB makes sense. The main perf issue with SQLite is usually concurrent access, and that doesn’t really apply without more users than the project’s target audience really would have.
I want to talk to this dev and sell them on postgres lol. With a rust server, your bottleneck is not the code, its your storage system.
They made their database pluggable afaik, so you could fairly easily write a thingy for postgres. In fact, I believe it’s planned for the future.
Given Conduit’s focus on being lightweight with simple setup, imo using an embedded DB makes sense. The main perf issue with SQLite is usually concurrent access, and that doesn’t really apply without more users than the project’s target audience really would have.