SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Python Sqlite Projects
-
Project mention: FastAPI, Pydantic, Psycopg3: the holy trinity for Python web APIs | dev.to | 2024-10-24
Alternative ORMs: there are many such as peewee, PonyORM, etc.
-
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.
-
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/
-
A couple of reasons which pop to mind:
- Searching a plain text data file is O(n). Searching a SQLite database that has been properly indexed, which is very easy to do nowadays with FTS5, is O(log n) worst case scenario and O(1) in the best case. This doesn't explain why SQLite over a dataframe or anything, but it definitely justifies it over plain text for large email collections.
- SQLite is really easy to write custom views and programs around. Virtually every major programming language can work with it without issue. See also: simonw's wonderful https://datasette.io/ .
- SQLite is an accepted archival format by the Library of Congress, if you ever want to go down the rabbit hole of digital preservation.
-
-
Project mention: Show HN: SQL-tString a t-string SQL builder in Python | news.ycombinator.com | 2025-05-16
https://github.com/tobymao/sqlglot :
> SQLGlot is a no-dependency SQL parser, transpiler, optimizer, and engine [written in Python] . It can be used to format SQL or translate between 24 different dialects like DuckDB, Presto / Trino, Spark / Databricks, Snowflake, and BigQuery. It aims to read a wide variety of SQL inputs and output syntactically and semantically correct SQL in the targeted dialects.
-
Project mention: Why Pandas feels clunky when coming from R (2024) | news.ycombinator.com | 2025-06-07
pandas* per the style guide (nobody follows it)
also I recommend trying Ibis. created by the creator of pandas originally and solves so many of the issues
https://ibis-project.org
-
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.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
AwaitableModel is a model base class in UtilMeta to provide fully async query in Django using encode/databases, which will unleash the async performance for Django ORM
-
Project mention: FastAPI, Pydantic, Psycopg3: the holy trinity for Python web APIs | dev.to | 2024-10-24
Alternative ORMs: there are many such as peewee, PonyORM, etc.
-
-
Project mention: Litecli: CLI for SQLite Databases with auto-completion and syntax highlighting | news.ycombinator.com | 2024-09-08
-
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: Syncthing – A decentralized continuous file synchronization program | news.ycombinator.com | 2024-08-18
You could use Syncthing just to empty the incoming files from your phone (ingest) and then move the photos via cron to a second folder (also Syncthing) which is just shared with the replicas.
Another approach would be to push the files from Syncthing to borg (borgmatic can do replicas) https://torsion.org/borgmatic/
-
Project mention: Ty: An fast Python type checker and language server, written in Rust | news.ycombinator.com | 2025-05-07
-
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
-
Project mention: YouTube Full Text Search – Search All of a YouTube Channel from the CLI | news.ycombinator.com | 2024-08-31
-
-
-
-
-
django-dbbackup
Management commands to help backup and restore your project database and media files
-
raglite
🥤 RAGLite is a Python toolkit for Retrieval-Augmented Generation (RAG) with DuckDB or PostgreSQL
Project mention: Show HN: RAGLite – A Python package for the unhobbling of RAG | news.ycombinator.com | 2024-12-19 -
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Python Sqlite discussion
Python Sqlite related posts
-
Show HN: SQL-tString a t-string SQL builder in Python
-
Why Developers Are Choosing Tortoise ORM as Python’s Modern ORM
-
datasette alternatives - csvbase, portaljs, and DataTables
4 projects | 21 Apr 2025 -
Show HN: Crowdfunding app built using just Flask and SQLite
-
Show HN: Advanced-Alchemy – A framework agnostic library for SQLAlchemy
-
Sell Yourself Sell Your Work
-
Exploring the Paramilitary Leaks
-
A note from our sponsor - SaaSHub
www.saashub.com | 21 Jun 2025
Index
What are some of the best open-source Sqlite projects in Python? This list will help you:
# | Project | Stars |
---|---|---|
1 | Peewee | 11,580 |
2 | q | 10,288 |
3 | datasette | 10,132 |
4 | visidata | 8,269 |
5 | sqlglot | 7,859 |
6 | ibis | 5,861 |
7 | tortoise-orm | 5,136 |
8 | databases | 3,914 |
9 | PonyORM | 3,737 |
10 | sqlite-web | 3,730 |
11 | litecli | 3,026 |
12 | GarminDB | 2,493 |
13 | borgmatic | 1,995 |
14 | sqlite-utils | 1,851 |
15 | RSS-to-Telegram-Bot | 1,770 |
16 | yt-fts | 1,702 |
17 | piccolo | 1,618 |
18 | requests-cache | 1,426 |
19 | aiosqlite | 1,362 |
20 | python-diskcache | 1,214 |
21 | django-dbbackup | 1,049 |
22 | raglite | 1,012 |
23 | bitcoin-abe | 978 |