Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality. Learn more →
Top 23 Python Sqlite Projects
-
Scout Monitoring
Free Django app performance insights with Scout Monitoring. Get Scout setup in minutes, and let us sweat the small stuff. A couple lines in settings.py is all you need to start monitoring your apps. Sign up for our free tier today.
-
-
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
-
-
-
prisma-client-py
Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of use
-
-
-
-
-
-
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.
-
django-dbbackup
Management commands to help backup and restore your project database and media files
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Project mention: Ask HN: High quality Python scripts or small libraries to learn from | news.ycombinator.com | 2024-04-19Simon Willison's github would be a great place to get started imo -
https://github.com/simonw/datasette
Project mention: Data Science at the Command Line, 2nd Edition (2021) | news.ycombinator.com | 2024-05-06I'd like to call out one of my favorite pieces of software from the past 10 years: VisiData [1] has completely changed the way I do ad-hoc data processing, and is now my go-to for pretty much all use cases that I previously used spreadsheets for, and about half of those I previously used databases for.
It's a TUI application, not strictly CLI, but scriptable, and I figure anyone building pipelines using tools like jq, q, awk, grep, etc. to process tabular data will find it extremely useful.
----
[1]: https://visidata.org
Project mention: The Future of MySQL is PostgreSQL: an extension for the MySQL wire protocol | news.ycombinator.com | 2024-04-26This is probably referring to "zero changes to your driver code" and not "zero changes to the SQL you send over this driver".
Translating between SQL dialects is notoriously hard and attempts to translate [1] are working in 95% of cases. But the last 5% would require 5x amount of work. That's because "SQL dialect" also includes weird edge cases of type inference of things like COALESCE(5, FALSE) and emulation of system catalogs (pg_catalog, information_schema).
[1] https://github.com/tobymao/sqlglot
Project mention: Show HN: SQLFrame – I ran PySpark without Spark on a SQL database | news.ycombinator.com | 2024-05-20
Project mention: Building a full Django project, starting with a single file | news.ycombinator.com | 2024-04-23
sqlite-web – Web-based SQLite database browser written in Python
GitHub: https://github.com/dbcli/litecli
- for important files, a separate box where I have borgmatic [1] in deduplication mode installed; this is updated once in a while
Just curious: Do you have any reason to believe that such a data corruption bug is likely in ZFS? It seems like saying that ext4 could have a bug and you should also store stuff on NTFS, just in case (which I think does not make sense..).
[1]: https://github.com/borgmatic-collective/borgmatic
Project mention: Ask HN: High quality Python scripts or small libraries to learn from | news.ycombinator.com | 2024-04-19https://github.com/simonw/sqlite-utils
So, his code might not be a good place to find best patterns (for ex, I don't think they are fully typed), but his repos are very pragmatic, and his development process is super insightful (well documented PRs for personal repos!). Best part, he blogs about every non-trivial update, so you get all the context!
Project mention: Challenges with semantic search on transcribed audio files | news.ycombinator.com | 2023-12-27I've been trying to solve a problem with implementing semantic search on my YouTube search engine yt-fts (https://github.com/NotJoeMartinez/yt-fts). I've managed to substantially speed up search results by storing subtitle embeddings in Chroma. But a bigger problem has been with how to properly segment the text in a way that accounts for the duration and context of word embeddings while returning precise time stamps. This a blog post exploring what I've tried so far.
Project mention: Piccolo, a Lightweight and Async Pydantic V2 Python ORM | news.ycombinator.com | 2023-11-07
How are you syncing/storing the data?
I've been a Garmin user for nearly a decade and would really like to get the data off their platform so I can do more with it.
There are a few self-hosted options (https://github.com/tcgoetz/GarminDB seems like the best) but I keep kicking that can down the road.
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
-
Show HN: Merge Folders from the CLI
-
Show HN: Find similar folders based on folder name, folder size, and count
-
Ask HN: High quality Python scripts or small libraries to learn from
-
This Week In Python
-
Sqlelf – Explore ELF objects through the power of SQL
-
Sqlelf: Explore ELF Objects with SQL
-
How to Enhance Content with Semantify
-
A note from our sponsor - InfluxDB
www.influxdata.com | 16 Jun 2024
Index
What are some of the best open-source Sqlite projects in Python? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Peewee | 10,905 |
| 2 | q | 10,139 |
| 3 | datasette | 9,026 |
| 4 | visidata | 7,502 |
| 5 | sqlglot | 5,882 |
| 6 | ibis | 4,412 |
| 7 | tortoise-orm | 4,335 |
| 8 | databases | 3,727 |
| 9 | PonyORM | 3,561 |
| 10 | sqlite-web | 3,125 |
| 11 | litecli | 2,040 |
| 12 | prisma-client-py | 1,736 |
| 13 | borgmatic | 1,662 |
| 14 | sqlite-utils | 1,546 |
| 15 | yt-fts | 1,368 |
| 16 | piccolo | 1,301 |
| 17 | requests-cache | 1,269 |
| 18 | python-diskcache | 1,132 |
| 19 | aiosqlite | 1,097 |
| 20 | GarminDB | 982 |
| 21 | django-dbbackup | 925 |
| 22 | csvs-to-sqlite | 863 |
| 23 | invest-alchemy | 684 |
Sponsored
Free Django app performance insights with Scout Monitoring
Get Scout setup in minutes, and let us sweat the small stuff. A couple lines in settings.py is all you need to start monitoring your apps. Sign up for our free tier today.
www.scoutapm.com