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?

=> ๐Ÿš€ jsreed5

2024-07-09 ยท 6 months ago

4 Comments โ†“

=> ๐Ÿ allknowingfrog ยท 2024-07-09 at 16:24:

SQLite is a bit of a unicorn. I've not run across anything similar in the world of NoSQL.

Incidentally, what makes you want to explore NoSQL? In my experience, it's great for prototyping and for efficiently querying large amounts of data. In all other situations, I would rather have SQL.

=> ๐Ÿ›ฐ๏ธ lufte ยท 2024-07-09 at 16:34:

There are tinydb and picodb in github but I haven't used any of them.

=> ๐Ÿš€ jsreed5 [OP] ยท 2024-07-09 at 23:52:

There are two main reasons I want to explore NoSQL. One is that I'm curious how different paradigms scale in different use cases. The second is that I come across both SQL and NoSQL databases in a professional setting, but I'm less familiar with NoSQL.

=> ๐Ÿ’€ requiem ยท 2024-07-10 at 17:37:

FileXDB seems really cool:

https://github.com/FileXdb/FileXdb.py

Proxy Information
Original URL
gemini://bbs.geminispace.org/u/jsreed5/18439
Status Code
Success (20)
Meta
text/gemini; charset=utf-8
Capsule Response Time
81.049561 milliseconds
Gemini-to-HTML Time
0.545021 milliseconds

This content has been proxied by September (ba2dc).