SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Python datasette-io Projects
-
I wrote an async wrapper around SQLite in Python - I'm using a thread pool: https://github.com/simonw/datasette/blob/main/datasette/data...
I have multiple threads for reads and a single dedicated thread for writes, which I send operations to via a queue. That way I avoid ever having two writes against the same connection at the same time.
-
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
-
-
-
Yeah, I worry about that too. I have SO much of my stuff dependent on my GitHub account now.
I'm slightly reassured by how useful their APIs are. I have automated exports of a lot of my GitHub issues, though I really should shore those up and make sure I'm capturing everything.
That's one of the reasons I built https://github.com/dogsheep/github-to-sqlite
-
-
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 SQLite Is Taking over with Brian Holt and Marco Bambini | news.ycombinator.com | 2024-06-12
I haven't tried it with git pluggable diff tools yet, but I wrote a tool that lets me convert a SQLite database into a bunch of plain text files so I can manage them in git: https://github.com/simonw/sqlite-diffable
-
-
-
-
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...
-
-
Project mention: Ask HN: Is there a Hacker News takeout to export my comments / upvotes, etc.? | news.ycombinator.com | 2023-12-10
Partially. https://github.com/dogsheep/hacker-news-to-sqlite
-
-
-
-
-
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-io discussion
Python datasette-io related posts
-
db-to-sqlite: exporting tables or queries from any SQL database to SQLite
-
Show HN: What's in My Location History?
-
Ask HN: High quality Python scripts or small libraries to learn from
-
Getting things done (in small increments)
-
Ask HN: Is there a Hacker News takeout to export my comments / upvotes, etc.?
-
Welcome to Datasette Cloud
-
SQLite Functions for Working with JSON
-
A note from our sponsor - SaaSHub
www.saashub.com | 6 Oct 2024
Index
What are some of the best open-source datasette-io projects in Python? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | datasette | 9,447 |
| 2 | sqlite-utils | 1,644 |
| 3 | csvs-to-sqlite | 875 |
| 4 | django-sql-dashboard | 437 |
| 5 | github-to-sqlite | 408 |
| 6 | twitter-to-sqlite | 403 |
| 7 | db-to-sqlite | 358 |
| 8 | csv-diff | 292 |
| 9 | healthkit-to-sqlite | 199 |
| 10 | dogsheep-beta | 183 |
| 11 | datasette-dashboards | 137 |
| 12 | sqlite-diffable | 109 |
| 13 | pocket-to-sqlite | 102 |
| 14 | google-takeout-to-sqlite | 102 |
| 15 | datasette-graphql | 100 |
| 16 | datasette-ripgrep | 72 |
| 17 | swarm-to-sqlite | 60 |
| 18 | hacker-news-to-sqlite | 47 |
| 19 | datasette-auth-github | 41 |
| 20 | evernote-to-sqlite | 36 |
| 21 | datasette-auth-passwords | 22 |
| 22 | ibis-datasette | 10 |
| 23 | inaturalist-to-sqlite | 7 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com