Introducing NeoSQLite by cwt in c/python@programming.dev
[-] cwt@lemmy.ml 2 points 1 month ago

20250903: I’ve made a lot of updates since my last post. Performance has improved thanks to the use of temp table. Please check it out and give it a try!

Introducing NeoSQLite by cwt in c/python@programming.dev
[-] cwt@lemmy.ml 6 points 1 month ago

What you said is the old concept of relational databases. SQLite, years ago, added native JSON and JSON operations such as JSON_EXTRACT, JSON_EACH, JSON_SET, etc., which blurred the line between SQL and NoSQL. However, not many developers utilize it, so I'm trying to bring it to the easiness of PyMongo APIs. If you read the examples and test cases in my repo, you will no longer mention subsets. While it's true, I've already addressed most of them and am still progressing.

20
Introducing NeoSQLite (www.youtube.com)
submitted 1 month ago by cwt@lemmy.ml to c/python@programming.dev
6 comments fedilink

Introducing NeoSQLite — a Python library with an API highly compatible with PyMongo, allowing you to use SQLite almost like MongoDB.
https://github.com/cwt/neosqlite This project integrates two of my other open-source projects:

  • fts5-icu-tokenizer (GitHub - cwt/fts5-icu-tokenizer: FTS5 ICU Tokenizer for SQLite (mirror) (https://github.com/cwt/fts5-icu-tokenizer)): An ICU-powered tokenizer for SQLite's FTS5, enabling full-text search support for languages worldwide. In NeoSQLite, it powers the $text operator for advanced multilingual search capabilities.

  • quez (GitHub - cwt/quez: Pluggable, compressed in-memory queues and deques for both sync and asyncio applications. (https://github.com/cwt/quez)): A tool that compresses SQLite query results, reducing memory usage by 50% to 80%, which is especially beneficial when working with large datasets.

NeoSQLite is ideal for lightweight, embeddable applications that need MongoDB-like query flexibility with the simplicity and portability of SQLite.

Feel free to check it out and share your feedback.

1
Akeana unveils 10 RISC-V cores suitable for microcontrollers up to data center chips - CNX Software (www.cnx-software.com)
submitted 1 year ago by cwt@lemmy.ml to c/riscv@lemmy.ml
0 comments fedilink

cwt

joined 4 years ago