simonw/datasette
View on GitHub ↗ ★ 11,536 Python
An open source multi-tool for exploring and publishing data
77 mentions on Hacker News by 36 people: 5 stories, 72 comments · first 2017-11-14 · latest 2026-08-05
20082026
-
…of DuckDB compatibility within the context of Datasette and other similar projects. [1]: https://github.com/simonw/datasette
comment by Smerity · 2020-09-20 · in DuckDB – An embeddable SQL database like SQLite, but supports Postgres features -
Reminds me of the venerable Datasette by Simon Willison: https://github.com/simonw/datasette
comment by mitjam · 2020-09-11 · in Show HN: Octo – Generate a serverless API from an SQL query -
My favorite incarnation of this idea is probably Datasette. https://github.com/simonw/datasette
comment by rpdillon · 2020-08-17 · in Show HN: Dropbase 2.0 – Turn offline files into live databases -
…SQLite rather than PostgreSQL. More here: https://simonwillison.net/2018/Oct/4/datasette-ideas/ and https://github.com/simonw/datasette
comment by simonw · 2020-08-11 · in We Can Do Better Than SQL -
Agreed. I have a hunch that any solution to this problem will look similar to https://github.com/simonw/datasette if it develops. Tied together with https://supabase.io/ and you've built a versatile, powerful, open data collaboration…
comment by toomuchtodo · 2020-08-06 · in Social Movements Are Pushing Google Sheets to the Breaking Point -
…cheap to run. The index is a single static file on disk, then you add a Python process (I'm using https://github.com/simonw/datasette ) to run queries against it. Much less resource intensive than running Solr or Elasticsearch. It also…
comment by simonw · 2020-05-02 · in Static Sites with Elasticsearch -
…local governments and anyone else who has data that they wish to share with the world. [0] https://github.com/simonw/datasette [1] http://datasette.readthedocs.io/
comment by pcr910303 · 2020-04-02 · in GitHub uses Datasette to publish an SQL-enabled interface of Covid-19 data -
…data dumps from these kinds of companies into SQLite databases, then query and visualize them using https://github.com/simonw/datasette and https://github.com/simonw/datasette-vega
comment by simonw · 2020-03-02 · in Facebook's Download-Your-Data Tool Is Incomplete -
…choice for it. It might be nice to have a simple GUI for each DB. Perhaps leverage something like https://github.com/simonw/datasette . Also a few sample DBs. Cool stuff!
comment by breck · 2020-02-08 · in Show HN: SimpleSQL, SQLite Database Reachable over HTTP -
…) which converts a YAML file into a SQLite database, which I can then use with Datasette ( https://github.com/simonw/datasette ) My biggest project with it so far has been my site https://www.niche-museums.com/ - a guide to small and niche…
comment by simonw · 2020-01-27 · in GNU Recutils -
…of as suggesting you meant any of that, not at all! Just comparing approaches. I think it was this: https://github.com/simonw/datasette though supports only CSV files. There's also Apache Drill which works with a lot of data sources, which…
comment by cube2222 · 2020-01-17 · in Show HN: ESQLate – Build minimum viable admin panels with just SQL -
…know Datasette[0] either, it's a tool for exploring data. Apparently it's an API above SQLite. [0]: https://github.com/simonw/datasette
comment by Hitton · 2019-12-03 · in Datasette-atom: Define an Atom feed using a custom SQL query -
…Datasette is a great tool for read-only database introspection and queries of SQLite databases. https://github.com/simonw/datasette Sandman2 generates a REST API for an arbitrary database. https://github.com/jeffknupp/sandman2 You can…
comment by westurner · 2019-08-21 · in Ask HN: Is there a CRUD front end for databases (especially SQLite)? -
there's datasette[1] to look forward to (perhaps to get some inspirations or port some ideas) [1]: https://github.com/simonw/datasette
comment by adonese · 2019-07-16 · in Show HN: OctoSQL – Query and join multiple databases and files, written in Go -
…but it is _very_ handy when I do! Semi-related (kind of the inverse) tool is simon w's datasette ( https://github.com/simonw/datasette ) which gives you a readonly view into a sqlite database, conveniently exposed as a website. I've fired…
comment by hprotagonist · 2019-07-10 · in Sqlite to Rest -
For those wishing to see Sqlite used to publish data sets: Datasette ( https://github.com/simonw/datasette ) is a new tool to publish data on the web. It uses SQLite under the hood.
comment by henridf · 2018-12-25 · in SQLite as an Application File Format (2014) -
Related, but with a free web interface https://github.com/simonw/datasette , https://github.com/simonw/csvs-to-sqlite
comment by hprotagonist · 2018-11-14 · in Q: Run SQL Directly on CSV Files -
I wonder if this site is published using: https://github.com/simonw/datasette
comment by softinio · 2018-09-07 · in Tech companies in San Francisco -
Replacing CSV with SQLite is one of my goals for the combination of https://github.com/simonw/datasette and https://github.com/simonw/csvs-to-sqlite
comment by simonw · 2018-05-04 · in We’re happy with SQLite and not urgently interested in a fancier DBMS (2016) -
…tool (written in Python 3) which opens the SQLite database and starts serving up queries from it. https://github.com/simonw/datasette The magic here is that the SQLite database is opened in read-only mode, which means I don't have to worry…
comment by simonw · 2018-01-17 · in Show HN: Datasette Publish – Turn CSVs into a SQLite-Backed JSON API -
This is essentially a web app that helps you deploy new instances of my Datasette application https://github.com/simonw/datasette without having to install anything on your own machine first. I'm using new features of the Zeit API -…
comment by simonw · 2018-01-17 · in Datasette Publish: a web app for publishing CSV files as an online database -
…REST SQL API in literally minutes. Here are a bunch of datasets that I've done that to just today: https://github.com/simonw/datasette/wiki/Datasettes
comment by simonw · 2017-11-14 · in Show HN: Datasette – Create and publish an API for SQLite databases