The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Top 23 Python Sqlite Projects
-
-
-
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.
-
Project mention: Show HN: TextQuery – Query and Visualize Your CSV Data in Minutes | news.ycombinator.com | 2024-04-02
-
[4] "Is it possible to "flatten" structured data (like JSON?)": https://github.com/saulpw/visidata/discussions/1605
-
Recommend checking out https://github.com/tobymao/sqlglot if you are interested in this capability for other SQL dialects
Tools like this are helpful for:
- Rendering SQL in a consistent way, eg for snapshot testing
-
Project mention: How to Connect a FastAPI Server to PostgreSQL and Deploy on GCP Cloud Run | dev.to | 2023-05-26
To do this, we can use the Tortoise-ORM. Begin by installing the package:
-
ibis – portable Python dataframe library
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
-
-
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..).
-
prisma-client-py
Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of use
-
Sounds like your problem is with SQLAlchemy, not with SQLite.
My https://sqlite-utils.datasette.io library might be a better fit for you. It's a much thinner abstraction than SQLAlchemy.
-
Project mention: Piccolo, a Lightweight and Async Pydantic V2 Python ORM | news.ycombinator.com | 2023-11-07
-
-
-
-
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.
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.
-
django-dbbackup
Management commands to help backup and restore your project database and media files
-
-
-
pytablewriter
pytablewriter is a Python library to write a table in various formats: AsciiDoc / CSV / Elasticsearch / HTML / JavaScript / JSON / LaTeX / LDJSON / LTSV / Markdown / MediaWiki / NumPy / Excel / Pandas / Python / reStructuredText / SQLite / TOML / TSV.
-
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).
The latest post mention was on 2024-04-02.
Python Sqlite related posts
- 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
- This Week In Python
- Little Data: How do we query personal data? (2013)
- Show HN: I built an open-source data copy tool called ingestr
-
A note from our sponsor - WorkOS
workos.com | 16 Apr 2024
Index
What are some of the best open-source Sqlite projects in Python? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Peewee | 10,766 |
| 2 | q | 10,106 |
| 3 | datasette | 8,862 |
| 4 | visidata | 7,388 |
| 5 | sqlglot | 5,389 |
| 6 | tortoise-orm | 4,206 |
| 7 | ibis | 4,041 |
| 8 | databases | 3,692 |
| 9 | PonyORM | 3,510 |
| 10 | sqlite-web | 2,867 |
| 11 | litecli | 2,011 |
| 12 | borgmatic | 1,636 |
| 13 | prisma-client-py | 1,590 |
| 14 | sqlite-utils | 1,486 |
| 15 | piccolo | 1,265 |
| 16 | requests-cache | 1,254 |
| 17 | python-diskcache | 1,105 |
| 18 | aiosqlite | 1,062 |
| 19 | GarminDB | 917 |
| 20 | django-dbbackup | 904 |
| 21 | csvs-to-sqlite | 858 |
| 22 | invest-alchemy | 668 |
| 23 | pytablewriter | 593 |
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com