Dev tools · alternatives · 2026
24 alternatives to I wrote a RDBMS (SQLite clone) from scratch in pure Python
I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
This is a relational database management system written entirely in Python that functions similarly to SQLite. It is designed for developers who need a lightweight database solution built from scratch without external… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. I wrote a RDBMS (SQLite clone) from scratch in pure Python launched in 2023; newer entries below may have overtaken it.
- 1
A pure ORM for writing native SQL queries yielding pure business objects - craigmichaelmartin/pure-orm
2021 · github.com · its alternatives →
- 2HA
Hi all, we recently open sourced the first version of Hashquery, a Python library which lets you model analytics, DRY up common logic, and execute it against a database or warehouse. We were originally rendering SQL directly for all our queries, but that spiraled out of control with more complex analysis; the SQL needed to be changed sporadically for each new database dialect (BigQuery, Redshift, Aethena, Postgres, etc etc) and the SQL fragments were very challenging to reuse (and so fragments were copy-pasted all over). ~~~ Advantages we think it has over writing SQL by hand: - Queries are…
2024 · hashquery.dev · its alternatives →
- 31R
2016 · magic.io · its alternatives →
- 4
Recently created a minimal persistent relational database in Go. Main focus was on implementing & understanding working the of database, storage management & transaction handling. Use of B+ Tree for storage engine(support for indexing), managing a Free List (for reusing nodes), Support for transactions, Concurrent Reads. Still have many things to add & fix like query processing being one of the main & fixing some bugs Repo link - https://github.com/Sahilb315/AtomixDB Would love to hear your thoughts
2025 · github.com · its alternatives →
- 5
Hello HN! I built stanchion to scratch my own itch. I have personal applications running on SQLite where I want to store log and metric data (basically forever) but don't want to add complexity by bringing in a new database or whole separate server. Some of these applications are running on a Raspberry Pi, where storage and compute are limited, but I still want data warehouse like capabilities. I envision stanchion being used in similar scenarios: on phones and resource-limited devices in applications that are already using SQLite. I know that there are alternatives like DuckDB (which is…
2024 · github.com · its alternatives →
- 6
Recently there seem to be a surge in SQLite related projects. TeaTime is riding that wave... A couple of years ago I was intrigued by phiresky's post[0] about querying SQLite over HTTP. It made me think that if anyone can publish a database using GitHub Pages, I could probably build a frontend in which users can decide which database to query. TeaTime is like that - when you first visit it, you'll need to choose your database. Everyone can create additional databases[1]. TeaTime then queries it, and fetches files using an IPFS gateway (I'm looking into using Helia so that users are also…
2024 · github.com · its alternatives →
- 7
PugSQL is a Python library for interacting with your database the way the gods intended.
2019 · pugsql.org · its alternatives →
- 8
Hi HN - DBOS CEO here with the co-founders of DBOS, Peter (KraftyOne) and Qian (qianli_cs). The company started as a research project of Stanford and MIT, and Peter and Qian were advised by Mike Stonebreaker, the creator of Postgres, and Matei Zaharia, the creator of Spark. They believe so strongly in reliable, serverless compute that they started a company (with Mike) to bring it to the world! Today we want to share our brand new Python library providing ultra-lightweight durable execution. https://github.com/dbos-inc/dbos-transact-py Durable execution means your program…
2024 · github.com · its alternatives →
- 9
A truly Open Source MongoDB alternative. Contribute to FerretDB/FerretDB development by creating an account on GitHub.
2023 · github.com · its alternatives →
- 10
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…
2024 · github.com · its alternatives →
- 11
SimpleSQLite is a Python library to simplify SQLite database operations: table creation, data insertion and get data as other data formats. Simple ORM functionality for SQLite. - thombashi/SimpleSQLite
2016 · github.com · its alternatives →
- 12
I built a SQLite VFS in Rust that serves cold queries directly from S3 with sub-second performance, and often much faster. It’s called turbolite. It is experimental, buggy, and may corrupt data. I would not trust it with anything important yet. I wanted to explore whether object storage has gotten fast enough to support embedded databases over cloud storage. Filesystems reward tiny random reads and in-place mutation. S3 rewards fewer requests, bigger transfers, immutable objects, and aggressively parallel operations where bandwidth is often the real constraint. This was explicitly inspired…
Mar 2026 · github.com · its alternatives →
- 13AT
A bunch of developers and myself have created RepliByte - an open-source tool to seed a development database from a production database. Features: - Support data backup and restore for PostgreSQL, MySQL and MongoDB - Replace sensitive data with fake data - Works on large database (> 10GB) (read Design) - Database Subsetting: Scale down a production database to a more reasonable size - Start a local database with the prod data in a single command - On-the-fly data (de)compression (Zlib) - On-the-fly data de/encryption (AES-256) - Fully stateless (no server, no daemon) and lightweight…
2022 · its alternatives →
- 14
Manipulate your SQLite database like a giant Javascript object. Built with o1.
2024 · gist.github.com · its alternatives →
- 15
A lightweight database with Python syntax queries, using ZeroMQ - asrp/pyzdb
2017 · github.com · its alternatives →
- 16
SPyQL (https://github.com/dcmoura/spyql) is SQL with Python in the middle, an open-source project fully written in Python for making command-line data processing more intuitive, readable and powerful. Try mixing in the same pot: a SQL SELECT for providing the structure, Python expressions for defining transformations and conditions, the essence of awk as a data-processing language, and the JSON handling capabilities of jq. How does a SPyQL query looks like? $ spyql “ IMPORT pendulum AS p SELECT (p.now() - p.from_timestamp(purchase_ts)).in_days() AS days_ago, sum_agg(price…
2022 · github.com · its alternatives →
- 17
Lightweight text-based SQL parameter binds. Contribute to baverman/sqlbind development by creating an account on GitHub.
2024 · github.com · its alternatives →
- 18
Contribute to akdor1154/python-csql development by creating an account on GitHub.
2020 · github.com · its alternatives →
- 19
LBADD: An experimental, distributed SQL database. Contribute to tomarrell/lbadd development by creating an account on GitHub.
2019 · github.com · its alternatives →
- 20
Distributed NoSQL Database. Contribute to stephenmcd/curiodb development by creating an account on GitHub.
2015 · github.com · its alternatives →
- 21
🪄 Inline SQL in any Python program. Contribute to ekzhang/inline-sql development by creating an account on GitHub.
2022 · github.com · its alternatives →
- 22AS
Hi HN, we're Eric and Dean, creators of SchemafreeSQL. Its roots go back to an on-line Web App Development Environment we developed back in 1999. It was comprised of an IDE, Web Server, Object Store, Virtual File System, Template System, and polyglot (Java, JavaScript, and Python). Of course, we named it “.OS”. Then we ended up dropping it. But that's a story for another time. It was the ease of use of the Object Store from .OS that we really missed, which brings us back to SchemafreeSQL. It provides an enhanced API to your SQL Database which allows it to function as a Schemaless…
2022 · schemafreesql.com · its alternatives →
- 23
Write python locally, execute SQL in your data warehouse - rasgointelligence/RasgoQL
2022 · github.com · its alternatives →
- 24SS
2020 · app.swaggerhub.com · its alternatives →
Also compare
- Write universally accessible SQL, not library-specific ORM wrapper APIs alternatives
- Hashquery, a Python library for defining reusable analysis alternatives
- 1M rows/s from Postgres to Python alternatives
- A Database Written in Golang alternatives
- Stanchion – Column-oriented tables in SQLite alternatives
- TeaTime – distributed book library powered by SQLite, IPFS and GitHub alternatives
Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →