Python Sqlite

Open-source Python projects categorized as Sqlite

Top 23 Python Sqlite Projects

  1. Peewee

    a small, expressive orm -- supports postgresql, mysql, sqlite and cockroachdb

    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.

  2. 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.

    InfluxDB logo
  3. q

    q - Run SQL directly on delimited files and multi-file sqlite databases (by harelba)

    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/

  4. datasette

    An open source multi-tool for exploring and publishing data

    Project mention: Gmail to SQLite | news.ycombinator.com | 2025-05-09

    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.

  5. visidata

    A terminal spreadsheet multitool for discovering and arranging data

  6. sqlglot

    Python SQL Parser and Transpiler

    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.

  7. ibis

    the portable Python dataframe library

    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

  8. tortoise-orm

    Familiar asyncio ORM for python, built with relations in mind

    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.

  9. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
  10. databases

    Async database support for Python. 🗄

    Project mention: Building a Realworld blog backend in 600 lines of Python | dev.to | 2025-02-12

    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

  11. PonyORM

    Pony Object Relational Mapper

    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.

  12. sqlite-web

    Web-based SQLite database browser written in Python

  13. litecli

    CLI for SQLite Databases with auto-completion and syntax highlighting

    Project mention: Litecli: CLI for SQLite Databases with auto-completion and syntax highlighting | news.ycombinator.com | 2024-09-08
  14. 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: GarminDB | news.ycombinator.com | 2025-02-02
  15. borgmatic

    Simple, configuration-driven backup software for servers and workstations

    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/

  16. sqlite-utils

    Python CLI utility and library for manipulating SQLite databases

    Project mention: Ty: An fast Python type checker and language server, written in Rust | news.ycombinator.com | 2025-05-07
  17. RSS-to-Telegram-Bot

    A Telegram RSS bot that cares about your reading experience

    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

  18. yt-fts

    YouTube Full Text Search - Search all of a YouTube channel from the command line

    Project mention: YouTube Full Text Search – Search All of a YouTube Channel from the CLI | news.ycombinator.com | 2024-08-31
  19. piccolo

    A fast, user friendly ORM and query builder which supports asyncio. (by piccolo-orm)

    Project mention: Piccolo ORM – A powerful async ORM for Python | news.ycombinator.com | 2024-11-20
  20. requests-cache

    Transparent persistent cache for python requests

  21. aiosqlite

    asyncio bridge to the standard sqlite3 module

  22. python-diskcache

    Persistent dict, backed by sqlite3 and pickle, multithread-safe.

  23. django-dbbackup

    Management commands to help backup and restore your project database and media files

  24. 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
  25. bitcoin-abe

    Abe: block browser for Bitcoin and similar currencies

  26. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
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

Log in or Post with

Python Sqlite related posts

  • Show HN: SQL-tString a t-string SQL builder in Python

    6 projects | news.ycombinator.com | 16 May 2025
  • Why Developers Are Choosing Tortoise ORM as Python’s Modern ORM

    1 project | dev.to | 11 May 2025
  • datasette alternatives - csvbase, portaljs, and DataTables

    4 projects | 21 Apr 2025
  • Show HN: Crowdfunding app built using just Flask and SQLite

    1 project | news.ycombinator.com | 29 Apr 2025
  • Show HN: Advanced-Alchemy – A framework agnostic library for SQLAlchemy

    3 projects | news.ycombinator.com | 23 Apr 2025
  • Sell Yourself Sell Your Work

    4 projects | news.ycombinator.com | 25 Mar 2025
  • Exploring the Paramilitary Leaks

    1 project | news.ycombinator.com | 6 Mar 2025
  • A note from our sponsor - SaaSHub
    www.saashub.com | 21 Jun 2025
    SaaSHub helps you find the best software and product alternatives Learn more →

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

Sponsored
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.
www.influxdata.com

Did you know that Python is
the 2nd most popular programming language
based on number of references?