Maintainer here. That's a very good idea! Let us know if you ever have some time to work with us on this.

You should speak to PayloadCMS guys. It can be mutually benefiting (publicity/more users/etc.). It needs Mongo, but if it works with Ferret backed by SQLite (and others) that would be game changer.

https://payloadcms.com/

Great project of yours! Thank you

* will try to hack docker-compose for this if time allows

Thank you, we will take a look!

Awesome! This might be my new Sunday project once I'm done with the current one.

Mongo's sharding is nice but I'm really tired of their support. They force you to run smaller machines in the contract so they can charge more for # of nodes, and it adds complexity to your architecture so you're swayed into buying Atlas. I could replace it all with a few PG shards with bigger machines.

Yes this is one of the reasons we started FerretDB. Atlas is very easy to use, but it is nearly impossible to move away from later on, as there is no alternative (unless you are ready to rewrite your app). We think that most of its killer features, like easy sharding, can be done with Postgres and/or SQLite.

I agree. I'd love to work on this full time if I could.

Might also be an interesting idea to use sqllite's inmemory feature.

Right, we are going to add support for it.