Top 23 datasette Open-Source Projects
-
Project mention: Does anyone here use sqlite just to do quick queries, because it is easier than loading to another rdb? | reddit.com/r/Python | 2022-08-05
https://datasette.io is my larger open source project around building tools for analyzing and publishing data with SQLite
-
Project mention: Does anyone here use sqlite just to do quick queries, because it is easier than loading to another rdb? | reddit.com/r/Python | 2022-08-05
https://sqlite-utils.datasette.io is the Python CLI tool and library I wrote to speed up this kind of work. Here's a recent tutorial I wrote about it: https://datasette.io/tutorials/clean-data
-
Scout APM
Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.
-
Project mention: Turning database into a searchable dashboard? | reddit.com/r/datascience | 2021-10-21
Oh what's that you say, your data is in CSV and you don't want to write code to load them up into a database, well try this https://github.com/simonw/csvs-to-sqlite
-
-
Keep in mind that all of this is automatically generated from a sqlite table (which itself was automatically generated by running twitter-to-sqlite), greatly reducing the bar for GUI-based, SQL-based EDA.
-
Project mention: I created Scrumdog – a program to download Jira Issues to a local database | news.ycombinator.com | 2022-07-15
Thanks for letting me know - fixed that here: https://github.com/dogsheep/github-to-sqlite/issues/74
-
dogsheep-beta
Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Project mention: Zinc Search engine. A lightweight alternative to Elasticsearch written in Go | news.ycombinator.com | 2021-12-03 -
SonarQube
Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
-
Project mention: sqlite-utils - my Python library and CLI tool for manipulating SQLite databases | reddit.com/r/Python | 2021-08-24
I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.
-
Download Link to source code:https://github.com/sweetlilmre/tapuino/releases/tag/v.2.8.0
-
Project mention: A SQLite extension for reading large files line-by-line | news.ycombinator.com | 2022-07-30
Oh wow! I wonder how hard it would be to load that module into https://github.com/simonw/datasette-lite
-
https://github.com/rclement/datasette-dashboards
It is still very alpha but usable if you know Vega syntax.
Looking for some contributors to bring Datasette to the level of Metabase!
-
Project mention: sqlite-utils - my Python library and CLI tool for manipulating SQLite databases | reddit.com/r/Python | 2021-08-24
I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.
-
-
covid-19-datasette
Deploys a Datasette instance of COVID-19 data from Johns Hopkins CSSE and the New York Times
Project mention: Automating a Software Company with GitHub Actions | news.ycombinator.com | 2021-08-19I don't have any at the moment where a commit to one triggers a build in another, but I have a bunch that run on a schedule, pull code from other repos and do stuff with it.
Best example of that is here: https://github.com/simonw/covid-19-datasette/blob/main/.gith...
-
Project mention: sqlite-utils - my Python library and CLI tool for manipulating SQLite databases | reddit.com/r/Python | 2021-08-24
I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.
-
Project mention: sqlite-utils - my Python library and CLI tool for manipulating SQLite databases | reddit.com/r/Python | 2021-08-24
I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.
-
Opened an issue exploring alternatives here: https://github.com/simonw/datasette.io/issues/109
I decided to just drop "any size" but keep "any shape".
-
-
Project mention: “Obtaining My Personal Data from Amazon Was a Nightmare” | news.ycombinator.com | 2022-03-27
-
-
-
This is a CLI written in Rust to download your Stripe account to a local SQLite database.
It is intended to enable using SQL queries over your data.
There is also a template for fly.io and Datasette to give you a Sigma like web UI:
-
datasette related posts
- Does anyone here use sqlite just to do quick queries, because it is easier than loading to another rdb?
- Awesome SQLite
- Need a database that can hold 16 million records and export any 2000 non-sequential records to Excel within 10 seconds.
- Simon Willison's cool categorised TIL page
- The Design of SQLite4
- Ask HN: How to remember technical topics which you don’t use/refer everyday?
- Architecture Notes: Datasette
Index
What are some of the best open-source datasette projects? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | datasette | 6,314 |
| 2 | sqlite-utils | 945 |
| 3 | csvs-to-sqlite | 703 |
| 4 | til | 514 |
| 5 | twitter-to-sqlite | 344 |
| 6 | github-to-sqlite | 223 |
| 7 | dogsheep-beta | 149 |
| 8 | healthkit-to-sqlite | 131 |
| 9 | tapuino | 116 |
| 10 | datasette-lite | 102 |
| 11 | datasette-dashboards | 70 |
| 12 | google-takeout-to-sqlite | 66 |
| 13 | datasette-graphql | 63 |
| 14 | covid-19-datasette | 61 |
| 15 | pocket-to-sqlite | 58 |
| 16 | swarm-to-sqlite | 48 |
| 17 | datasette.io | 43 |
| 18 | datasette-auth-github | 38 |
| 19 | hacker-news-to-sqlite | 36 |
| 20 | museums | 25 |
| 21 | timezones-api | 24 |
| 22 | datasette-stripe | 20 |
| 23 | datasette-dateutil | 7 |
Are you hiring? Post a new remote job listing for free.
