simonw/datasette on Hacker News

…big SQLite files on disk without reading it all to memory), building something like Datasette ( https://github.com/simonw/datasette ) that can run queries on data hosted as static files, or for (as you suggested) using SQLite in a browser…

comment by antimatter15 · 2020-11-07 · in SQL.js: SQLite Compiled to JavaScript

For a quick web interface, I’ve used this on top of sqlite and it’s fantastic: https://github.com/simonw/datasette

comment by discordance · 2020-10-27 · in Ask HN: Good tool to build a web interface on top of SQL Data

…started looking at it today because someone was asking about it on the Datasette discussions board: https://github.com/simonw/datasette/discussions/968

comment by simonw · 2020-09-20 · in DuckDB – An embeddable SQL database like SQLite, but supports Postgres features

…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

▲ 2

Datasette

story by tosh · 2020-07-23 · 0 comments

…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

▲ 1

A tool for exploring and publishing data

story by mooreds · 2019-07-10 · 0 comments

…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