Stream helps developers build engaging apps that scale to millions with performant and flexible Chat, Feeds, Moderation, and Video APIs and SDKs powered by a global edge network and enterprise-grade infrastructure. Learn more →
Top 23 Python Sqlite Projects
-
-
Stream
Stream - Scalable APIs for Chat, Feeds, Moderation, & Video. Stream helps developers build engaging apps that scale to millions with performant and flexible Chat, Feeds, Moderation, and Video APIs and SDKs powered by a global edge network and enterprise-grade infrastructure.
-
I've been using LLM-assistance for my larger open source projects - https://github.com/simonw/datasette https://github.com/simonw/llm and https://github.com/simonw/sqlite-utils - for a couple of years now.
Also literally hundreds of smaller plugins and libraries and CLI tools, see https://github.com/simonw?tab=repositories (now at 880 repos) and https://pypi.org/user/simonw/ (340 published packages).
Unlike my tools.simonwillison.net stuff the vast majority of those products are covered by automated tests and usually have comprehensive documentation too.
- Project mention: XAN: A Modern CSV-Centric Data Manipulation Toolkit for the Terminal | news.ycombinator.com | 2025-03-27
I used to use q for this sort of thing. Not sure if there are better choices now as it have been a few years.
https://harelba.github.io/q/
- Project mention: Pg_ClickHouse: A Postgres extension for querying ClickHouse | news.ycombinator.com | 2025-12-12
If not having to adjust queries is a major driver for your considerations, then I would highly recommend looking at SQLGlot (https://github.com/tobymao/sqlglot), a transpiler that makes you (more) independent of query dialects. They already support 30 dialects (big vendors such as Snowflake, Databricks, BigQuery, but also loads of the specialists such as ClickHouse, SingleStore or Exasol). Repo is maintained extremely well.
Picking the best solution for your concrete workload (and your future demands) should be equally important to the implementation effort, to avoid that you run into walls later on. At least as long as data volume, query complexity or concurrency scalability can be challenges.
-
I use VisiData[0] to view and modify in bulk. For simple error corrections I just edit the text file. For insertions as part of another process I'll write a simple script that appends a block of test to one of the .rec files.
[0] https://visidata.org
-
https://github.com/ibis-project/ibis and
- Project mention: Why Developers Are Choosing Tortoise ORM as Python’s Modern ORM | dev.to | 2025-05-11
For more detailed usage, please refer to the Tortoise ORM Official Documentation.
-
InfluxDB
InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
-
I was looking for a simple, no bloat sqlite explorer that runs in a container and ended up deploying sqlite-web[1] in read-only mode. Very impressed, no external dependencies, works great. A CLI tool is nice, but then still have to ssh into the remote server to access the db file.
[1] https://github.com/coleifer/sqlite-web
-
-
-
GarminDB
Download and parse data from Garmin Connect or a Garmin watch, FitBit CSV, and MS Health CSV files into and analyze data in Sqlite serverless databases with Jupyter notebooks.
Project mention: Garmin Beats Apple to Market with Satellite-Connected Smartwatch | news.ycombinator.com | 2025-09-07If you've got a Garmin device check out GarminDB [0]. Garmin actually exposes an API that you can access with your credentials and get the raw activity, heart rate, etc data.
[0]: https://github.com/tcgoetz/GarminDB
- Project mention: Borgmatic: The Simple, Configuration-Driven Guardian for Your Server Backups | dev.to | 2025-10-29
View the Project on GitHub
- Project mention: I Ditched the Algorithm for RSS–and You Should Too | news.ycombinator.com | 2025-01-16
Same! I'm creating telegram channels for topics using https://github.com/Rongronggg9/RSS-to-Telegram-Bot
That's how I found out about this post https://t.me/best_hn/99
-
I've been using LLM-assistance for my larger open source projects - https://github.com/simonw/datasette https://github.com/simonw/llm and https://github.com/simonw/sqlite-utils - for a couple of years now.
Also literally hundreds of smaller plugins and libraries and CLI tools, see https://github.com/simonw?tab=repositories (now at 880 repos) and https://pypi.org/user/simonw/ (340 published packages).
Unlike my tools.simonwillison.net stuff the vast majority of those products are covered by automated tests and usually have comprehensive documentation too.
- Project mention: Piccolo: Powerful async ORM, query builder, and admin GUI | news.ycombinator.com | 2025-07-15
-
-
-
-
-
sqlit
A user friendly TUI for SQL databases. Written in python. Supports SQL server, Mysql, PostreSQL and SQLite, Turso and more.
Hi,
I've added this now: https://github.com/Maxteabag/sqlit/releases/tag/v1.1
Thank you for the suggestion.
-
-
raglite
🥤 RAGLite is a Python toolkit for Retrieval-Augmented Generation (RAG) with DuckDB or PostgreSQL
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).
Python Sqlite discussion
Python Sqlite related posts
-
CLI to manage your SQL database schemas and migrations
-
Django: One ORM to rule all databases
-
Show HN: An asynchronous database connection manager for Python
-
Garmin Beats Apple to Market with Satellite-Connected Smartwatch
-
The current state of LLM-driven development
-
Show HN: Apple Health MCP Server
-
signal-export: Export your Signal chats to Markdown files with attachments
- A note from our sponsor - Stream getstream.io | 23 Dec 2025
Index
What are some of the best open-source Sqlite projects in Python? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | Peewee | 11,883 |
| 2 | datasette | 10,605 |
| 3 | q | 10,333 |
| 4 | sqlglot | 8,725 |
| 5 | visidata | 8,683 |
| 6 | ibis | 6,289 |
| 7 | tortoise-orm | 5,416 |
| 8 | sqlite-web | 3,959 |
| 9 | PonyORM | 3,824 |
| 10 | litecli | 3,152 |
| 11 | GarminDB | 2,797 |
| 12 | borgmatic | 2,146 |
| 13 | RSS-to-Telegram-Bot | 1,972 |
| 14 | sqlite-utils | 1,952 |
| 15 | piccolo | 1,837 |
| 16 | yt-fts | 1,767 |
| 17 | Yamtrack | 1,697 |
| 18 | aiosqlite | 1,497 |
| 19 | requests-cache | 1,473 |
| 20 | sqlit | 1,334 |
| 21 | python-diskcache | 1,235 |
| 22 | raglite | 1,125 |
| 23 | dbos-transact-py | 1,101 |
Sponsored
Stream - Scalable APIs for Chat, Feeds, Moderation, & Video.
Stream helps developers build engaging apps that scale to millions with performant and flexible Chat, Feeds, Moderation, and Video APIs and SDKs powered by a global edge network and enterprise-grade infrastructure.
getstream.io