NanaSQLite
Python dict that auto-saves to SQLite. No SQL needed.
What it does
NanaSQLite is a dict-like SQLite wrapper for Python — persist data instantly without writing any SQL. Just use it like a regular Python dict: db["user"] = {"name": "Alice", "age": 20} print(db["user"]) # auto-saved to SQLite Key features: • 7.7× faster initialization • 19.9× faster batch processing with memory caching • Built on APSW for reliability • Zero boilerplate — no schema, no setup → pip install nanasqlite
Does the same job
all alternatives →- IWI wrote a RDBMS (SQLite clone) from scratch in pure Python2023 · github.com · ▲371
I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
- EAEmbed an SQLite database in your PostgreSQL table2024 · github.com · ▲180
pglite-fusion is a PostgreSQL extension that allows you to embed SQLite databases into your PostgreSQL tables by enabling the creation of columns with the `SQLITE` type. This means every row in the table can have an embedded SQLite database. In addition to the PostgreSQL `SQLITE` type, pglite-fusion provides the `query_sqlite`` function for querying SQLite databases and the `execute_sqlite` function for updating them. Additional functions are listed in the project’s README. The pglite-fusion extension is written in Rust using the pgrx framework [1]. ---- Implementation Details The PostgreSQL…
- SPSimpleSQLite – Python library to simplify the SQlite database creation2016 · github.com · ▲7
- DSDistributed SQLite on FoundationDB2022 · github.com · ▲150
Hello HN! I'm building mvsqlite, a distributed variant of SQLite with MVCC transactions, that runs on FoundationDB. It is a drop-in replacement that just needs an `LD_PRELOAD` for existing applications using SQLite. I made this because Blueboat (https://github.com/losfair/blueboat) needs a native SQL interface to persistent data. Apparently, just providing a transactional key-value store isn’t enough - it is more easy and efficient to build complex business logic on an SQL database, and it seems necessary to bring a self-hostable distributed SQL DB onto the platform.…
- DCDatasette – Create and publish an API for SQLite databases2017 · simonwillison.net · ▲269
More dev tools this month
the category →
The first open-source price index for GPU compute
Dev tools · 10d ago · getcomputable.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 2d ago · opentrailpaper.com
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
Launched alongside, April 2026
the whole month →
- AG
Thought the resources for GPU arch were lacking, so here we are
Life & fun · Apr 2026 · jaso1024.com
- IB
Built a ~9M param LLM from scratch to understand how they actually work. Vanilla transformer, 60K synthetic conversations, ~130 lines of PyTorch. Trains in 5 min on a free Colab T4. The fish thinks the meaning of life is food. Fork it and swap the personality for your own character.
AI · Apr 2026 · github.com
- BC
Life & fun · Apr 2026 · sam-burns.com
- IB
With social media and now AI, its important to keep the indie web alive. There are many people who write frequently. Blogosphere tries to highlight them by fetching the recent posts from personal blogs across many categories. There are two versions: Minimal (HN-inspired, fast, static): https://text.blogosphere.app/ Non-minimal: https://blogosphere.app/ If you don't find your blog (or your favorite ones), please add them. I will review and approve it.
AI · Apr 2026 · text.blogosphere.app