goatfish

I wrote something like this: https://github.com/stochastic-technologies/goatfish I very much support NoSQL (schemaless, really) databases on SQLite, as it's a great RDBMS and schemaless databases are very handy for various things. I'd love an embedded Redis, but this is pretty much the second best thing.

That's exactly what I did! https://github.com/stochastic-technologies/goatfish

I wrote a very simple thing to sort-of emulate this on SQLite. It works rather well for prototyping! https://github.com/stochastic-technologies/goatfish It also supports indexing on arbitrary fields and is only a few lines of code. It did come in very handy.

Yeah, I have experimented with schemaless stores a bit (mostly with JSON fields in postgres, for now), to avoid adding columns for various things to the database, and I am not impressed. Not only is initialization and migration hard, but I've come to realize that there's no downside in adding these to the schema itself. Sure, the schema gets a bit bloated and dirty, but having undocumented fields in a dict whose existence is signified only by a line of code assigning something is not better. Where schemaless stores are great is prototyping. Especially for more algorithmic code, where I don't really know what storage I'll be needing and the algorithm will only live there for a few days, schemas are just a burden. That's why I wrote Goatfish: https://github.com/stochastic-technologies/goatfish