SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Python datasette Projects
-
Seems like a perfect job for Datasette: SQLite plus web api and UI
“Datasette is a tool for exploring and publishing data. It helps people take data of any shape, analyze and explore it, and publish it as an interactive website and accompanying API.”
https://datasette.io/
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
sqlite-utils – Python CLI utility and library for manipulating SQLite databases
-
-
-
-
Project mention: db-to-sqlite: exporting tables or queries from any SQL database to SQLite | news.ycombinator.com | 2024-09-19
-
I wrote a tool a few years ago that could convert your Apple Health data export into a SQLite database. I haven't run it in a while though so there's a chance it doesn't work with the latest file format: https://github.com/dogsheep/healthkit-to-sqlite
-
-
dogsheep-beta
Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
-
Project mention: Observable 2.0, a static site generator for data apps | news.ycombinator.com | 2024-02-15
Me too, and that lead to developing the « datasette-dashboards » plugin[0]. I use this for my company where all the data is gathered by connectors scheduled in CI, storing data in Git, and triggering a SQLite db build and Datasette deployment. « BI as Code » if you will
[0] https://github.com/rclement/datasette-dashboards
-
-
-
-
Project mention: Why Ruby's Timeout is dangerous (and Thread.raise is terrifying) (2015) | news.ycombinator.com | 2024-06-03
I'm fascinated by this general problem - I see it as a close relative of the "sandbox" problem, where I want to be able to safely run user-defined untrusted operations.
For timeouts, I want to be able to build web application features which are guaranteed to terminate early after eg 2s in a way that resets all resources related to the operation.
The best way I've found of doing this so far involves proceses: run the time-bound operation in an entirely separate process and terminate it early if necessary.
I do that with "rg" here: https://github.com/simonw/datasette-ripgrep/blob/a40161f6273...
-
-
-
-
covid-19-datasette
Deploys a Datasette instance of COVID-19 data from Johns Hopkins CSSE and the New York Times
-
-
-
Oddly enough I built an API. A few years ago that does exactly that, using timezone polygons derived from OpenStreetMap: https://timezones.datasette.io/timezones/by_point?longitude=...
-
-
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 datasette discussion
Python datasette related posts
-
Storing Times for Human Events
-
db-to-sqlite: exporting tables or queries from any SQL database to SQLite
-
Show HN: What's in My Location History?
-
Dbmate: A lightweight, framework-agnostic database migration tool
-
Ask HN: High quality Python scripts or small libraries to learn from
-
Getting things done (in small increments)
-
GitHub – GSA/code-gov: An informative repo for all Code.gov repos
-
A note from our sponsor - SaaSHub
www.saashub.com | 21 Jan 2025
Index
What are some of the best open-source datasette projects in Python? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | datasette | 9,726 |
| 2 | sqlite-utils | 1,735 |
| 3 | csvs-to-sqlite | 882 |
| 4 | github-to-sqlite | 418 |
| 5 | twitter-to-sqlite | 402 |
| 6 | db-to-sqlite | 371 |
| 7 | healthkit-to-sqlite | 207 |
| 8 | apple-notes-to-sqlite | 193 |
| 9 | dogsheep-beta | 188 |
| 10 | datasette-dashboards | 139 |
| 11 | google-takeout-to-sqlite | 105 |
| 12 | pocket-to-sqlite | 102 |
| 13 | datasette-graphql | 100 |
| 14 | datasette-ripgrep | 73 |
| 15 | datasette-chatgpt-plugin | 67 |
| 16 | swarm-to-sqlite | 62 |
| 17 | datasette-scraper | 61 |
| 18 | covid-19-datasette | 61 |
| 19 | hacker-news-to-sqlite | 48 |
| 20 | datasette-auth-github | 41 |
| 21 | timezones-api | 29 |
| 22 | datasette-auth-passwords | 22 |
| 23 | datasette-plugin | 20 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com