Stop vibe-debugging. Every exception, every backtrace, grouped so you see patterns, not noise. Learn more →
Top 23 Python Sqlite Projects
-
-
AppSignal
AppSignal knows why the f*#k it crashed. Stop vibe-debugging. Every exception, every backtrace, grouped so you see patterns, not noise.
-
Project mention: How to Build a Minimal SIEM with Python, SQLite and Telegram Alerts | dev.to | 2026-08-14
Reasonable next steps: rules for failed sudo attempts, unexpected cron jobs, and outbound connections via auditd; a read-only UI with Datasette; AbuseIPDB enrichment on flagged IPs. For a structured checklist of what to monitor and in what priority order, our free security hardening checklists map detection goals to MITRE ATT&CK tactics.
-
-
We should also declare an interest. Interlace's entire intermediate representation is sqlglot — the parser that came with the Tobiko acquisition. Every model we compile is parsed, canonicalised and transpiled by a library Fivetran now stewards. We are not neutral observers of this consolidation; we are downstream of it.
-
Project mention: We used an AI agent to fix an open-source bug. Someone asked to ban us | news.ycombinator.com | 2026-09-23
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
sqlit
A user friendly TUI for SQL databases. Written in python. Supports SQL server, Mysql, PostreSQL, SQLite, Turso and more.
- Themes (Rose Pine, Tokyo Night, Nord, Gruvbox).
Install: `pipx install sqlit-tui` (also works with `uv tool install` and `pip`).
Built with Python and Textual. First shared here in December (https://news.ycombinator.com/item?id=46276002) - a lot has shipped since.
Repo: https://github.com/Maxteabag/sqlit
Feedback welcome, especially on what's still missing for daily-driver use.
My goal is to make an aesthetic tool that makes it easy and enjoyable to connect and query data, and do that one thing only, really well.
-
-
-
-
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: Volkswagen blocks Home Assistant by requiring client assertion | news.ycombinator.com | 2026-05-28Same here. I've been scraping the data from my Garmin watch for years with very little problems (first with https://github.com/tcgoetz/GarminDB, then https://github.com/sealbro/dotnet.garmin.connect).
The only annoyance is that Garmin requires 2FA if you enable the ECG feature on your smart watch/fitness tracker, but I have a small program that reads the 2FA codes from my Gmail inbox and supplies them to the scraper without too much trouble.
-
-
Project mention: How to Add a Sentiment Confirmation Layer to OpenAlgo with Python | dev.to | 2026-03-17
-
borgmatic
Mirror of borgmatic: Simple, configuration-driven backup software for servers and workstations
Project mention: Borgmatic: The Simple, Configuration-Driven Guardian for Your Server Backups | dev.to | 2025-10-29View the Project on GitHub
-
As far as I can tell I've shared more prompt transcripts than anyone else. Happy to be proven wrong about that.
Look through my commit history on https://github.com/simonw/tools/commits and https://github.com/simonw/sqlite-utils/commits and https://github.com/simonw/datasette/commits and you'll see that commits that were AI-assisted almost all link to a transcript or include a prompt or both.
-
RSS-to-Telegram-Bot
A Telegram RSS bot that cares about your reading experience (calling for new maintainers: https://github.com/Rongronggg9/RSS-to-Telegram-Bot/issues/747)
-
-
getsploit
Search and download public exploits from the Vulners database — online, or fully offline from a local SQLite FTS5 index.
-
-
Automatic crash detection for your process is built-in our Conductor offering. The library has a default recovery mode when used standalone.
What do you find strange with workflow versioning? Would love to consider improving the semantics. In fact, we started doing it: https://github.com/dbos-inc/dbos-transact-py/pull/598
-
-
-
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
-
Ask HN: Who wants to be hired? (September 2026)
-
How to Build a Minimal SIEM with Python, SQLite and Telegram Alerts
-
LightRAG VS Mnemos - a user suggested alternative
2 projects | 26 Jul 2026 -
Prefer Strict Tables in SQLite
-
Qlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)
-
Datasette Apps: Host custom HTML applications inside Datasette
-
I built an AI-personalized news bot that runs on a single SQLite file — architecture and everything that broke
-
A note from our sponsor - AppSignal
www.appsignal.com | 9 Oct 2026
Index
What are some of the best open-source Sqlite projects in Python? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | Peewee | 11,995 |
| 2 | datasette | 11,503 |
| 3 | q | 10,365 |
| 4 | sqlglot | 9,665 |
| 5 | visidata | 9,324 |
| 6 | ibis | 6,674 |
| 7 | tortoise-orm | 5,633 |
| 8 | sqlit | 4,883 |
| 9 | sqlite-web | 4,170 |
| 10 | PonyORM | 3,819 |
| 11 | Yamtrack | 3,680 |
| 12 | GarminDB | 3,329 |
| 13 | litecli | 3,311 |
| 14 | openalgo | 2,772 |
| 15 | borgmatic | 2,349 |
| 16 | sqlite-utils | 2,178 |
| 17 | RSS-to-Telegram-Bot | 2,161 |
| 18 | piccolo | 1,949 |
| 19 | getsploit | 1,824 |
| 20 | yt-fts | 1,811 |
| 21 | dbos-transact-py | 1,604 |
| 22 | aiosqlite | 1,581 |
| 23 | requests-cache | 1,506 |
Sponsored
AppSignal knows why the f*#k it crashed.
Stop vibe-debugging. Every exception, every backtrace, grouped so you see patterns, not noise.
www.appsignal.com