When the CGIs on my capsule need to store data, I use SQLite as the backend. I'd like to try out a document-oriented NoSQL database for my next project. MongoDB is the obvious choice, but I don't like its licensing terms, and I like that SQLite doesn't require a process to run all the time. Is there an open-source document-oriented database analogous to SQLite?
1 month ago
You can technically use sqlite but with 2 columns per table, key and JSON value. Then you can use ->, ->>, json_set(), etc' to filter and modify values. · 1 month ago