simonw/datasette on Hacker News

…I have similar charts across my three main open source projects: https://github.com/simonw/datasette/graphs/code-frequency https://github.com/simonw/llm/graphs/code-frequency https://github.com/simonw/sqlite-utils/graphs/co

comment by simonw · 2026-08-05 · in Eight Myths on Software Engineering and GenAI

…on https://github.com/simonw/tools/commits and https://github.com/simonw/sqlite-utils/commits and https://github.com/simonw/datasette/commits and you'll see that commits that were AI-assisted almost all link to a transcript or include a…

comment by simonw · 2026-07-12 · in Prefer strict tables in SQLite

…to ingest and query lots of logs locally, and present/filter in realtime with simonw's excellent https://github.com/simonw/datasette . I don't think it's every "sqlite for everything" as much as it is "sqlite in lots of places you probably…

comment by rpdillon · 2026-05-29 · in SQLite is all you need for durable workflows

…progress on my core projects (here's a substantial, reviewed PR I landed just yesterday https://github.com/simonw/datasette/pull/2741 ) and helping me create plenty of projects that otherwise would not have existed.

comment by simonw · 2026-05-27 · in I think Anthropic and OpenAI have found product-market fit

Hi, thanks for your project! Do you accept pull requests? https://github.com/simonw/datasette/pull/2616 https://github.com/simonw/datasette/pull/2617

comment by philkrylov · 2026-04-08 · in SQLite in Production: Lessons from Running a Store on a Single File

I've shipped some features in my largest open source project (Datasette) recently using Claude Code: https://github.com/simonw/datasette/pull/2636

comment by simonw · 2026-02-21 · in Claws are now a new layer on top of LLM agents

…and I find the coding agents pick it up pretty fast. One trick I use that might work for you as well: Clone GitHub.com/simonw/datasette to /tmp then look at /tmp/docs/datasette for documentation and search the code if you need to Try that…

comment by simonw · 2026-01-07 · in Opus 4.5 is not the normal AI agent experience that I have had thus far

…would have taken me weeks. I got it done in two days. Here's a diff that captures most of the work: https://github.com/simonw/datasette/compare/e951f7e81f038e43...

comment by simonw · 2025-10-28 · in AI can code, but it can't build software

I've been using LLM-assistance for my larger open source projects - https://github.com/simonw/datasette https://github.com/simonw/llm and https://github.com/simonw/sqlite-utils - for a couple of years now. Also literally hundreds of…

comment by simonw · 2025-08-10 · in The current state of LLM-driven development

It does seem like a job well suited to simonw's https://github.com/simonw/datasette

comment by phrotoma · 2025-03-06 · in Exploring the Paramilitary Leaks

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…

comment by simonw · 2024-07-18 · in Show HN: SQLite Transaction Benchmarking Tool

Simon Willison's github would be a great place to get started imo - https://github.com/simonw/datasette https://github.com/simonw/sqlite-utils So, his code might not be a good place to find best patterns (for ex, I don't think they are…

comment by thelastbender12 · 2024-04-19 · in Ask HN: High quality Python scripts or small libraries to learn from

Have you tried Datasette? (Not terminal) https://github.com/simonw/datasette

comment by mutant · 2024-04-03 · in Show HN: TextQuery – Query and Visualize Your CSV Data in Minutes

Seems similar to Datasette: https://datasette.io https://github.com/simonw/datasette/

comment by rmorey · 2024-02-08 · in SQLite-Web: Web-based SQLite database browser written in Python

…a dozen new tests takes only very slightly longer than adding one. Here's the kind of thing I mean: https://github.com/simonw/datasette/blob/45b88f2056e0a4da204... - pytest displays that as 5 passing tests.

comment by simonw · 2024-01-03 · in Waiting on Tests

…WebAssembly build of datasette which can be served as static HTML, JS, and WASM SQlite. datasette: https://github.com/simonw/datasette : > Datasette is a tool for exploring and publishing data. It helps people take data of any shape or…

comment by westurner · 2023-09-11 · in Code-gov: A collection point for all Code.gov repositories

…behind Cloudflare (or run it on a vendor like Vercel who might have a partnership with Cloudflare). https://github.com/simonw/datasette/issues/1534

comment by simonw · 2023-08-16 · in Htmx is part of the GitHub Accelerator

…could you have a look at this pull request I opened three years ago on a repo of yours : https://github.com/simonw/datasette/pull/1159 ?

comment by lovasoa · 2023-07-31 · in Repeating yourself thrice doesn’t turn you into a 3x developer

…: A dev-tool for web developers that aid in faster responsive web page development. - https://github.com/simonw/datasette : An open source multi-tool for exploring and publishing data - https://github.com/spyder-ide/spyder : The scientific…

comment by 255kb · 2023-04-13 · in GitHub Accelerator: our first cohort and what’s next

Opensource: https://github.com/simonw/datasette

comment by gardenfelder · 2023-01-15 · in Implement Q&A against your documentation with GPT3

Not yet, but I hope to ship that in the next alpha in a few days time: https://github.com/simonw/datasette/issues/1878

comment by simonw · 2022-12-03 · in Datasette’s new JSON write API: The first alpha of Datasette 1.0

…ability to create tokens that have a subset of permissions - eg can only write to specific tables: https://github.com/simonw/datasette/issues/1855 But maybe a mechanism for easily specifying that for anonymous localhost users would be…

comment by simonw · 2022-12-03 · in Datasette’s new JSON write API: The first alpha of Datasette 1.0

…work better for this. I think this issue might help - the ability to turn off row counts entirely: https://github.com/simonw/datasette/issues/1818 (I noticed that trying to access the table directly seems to suck in a LOT of data,…

comment by simonw · 2022-10-28 · in SQLite in the browser with WASM/JS

…off already. I had a feature idea relating to this a while back which I should bump up the list: https://github.com/simonw/datasette/issues/1160 I opened a new issue based on this conversation here: https://github.com/simonw/datasette/issue…

comment by simonw · 2022-10-15 · in Shot-scraper: Automating screenshots for documentation

I would recommend SQLite + a nice usable interface tool like datasette https://github.com/simonw/datasette Or SQLitebrowser https://sqlitebrowser.org/ (There are other generalized tools, search around to see if there are more suitable.)…

comment by inphovore · 2022-08-10 · in Ask HN: What's the best way to create a database for legal document clauses?

It appears so: https://github.com/simonw/datasette/issues/657

comment by infogulch · 2022-06-25 · in Show HN: Easily Convert WARC (Web Archive) into Parquet, Then Query with DuckDB

…content to pages to be able to collaborate with each other. I have an open issue for that here: https://github.com/simonw/datasette/issues/1191 I'm not too worried about extra template vars overrides though - that will only be a problem if…

comment by simonw · 2022-05-28 · in Architecture Notes: Datasette

Interesting - I hadn't thought about putting that right on the homepage. The GitHub README has that: https://github.com/simonw/datasette I worry that my target audience for the homepage won't necessarily have access to a working Python and…

comment by simonw · 2022-04-27 · in The Datasette Ecosystem

Here's one from this morning: https://github.com/simonw/datasette/issues/1718 This one is a bit more involved: https://github.com/simonw/shot-scraper/issues/18 There are a few good examples linked to at the very bottom of…

comment by simonw · 2022-04-24 · in Software Mise En Place

…data (SQLite, CSV, JSON, etc) and generate a REST/GraphQL API with visualization tools from it: https://github.com/simonw/datasette From the same author, "sqlite-utils" generate SQLite table definitions and rows from similar:…

comment by gavinray · 2022-04-15 · in The fastest tool for querying large JSON files is written in Python (benchmark)

…format, in a way that affects future traffic. I'm really annoyed about this. Notes on that here: https://github.com/simonw/datasette/issues/1534

comment by simonw · 2022-03-06 · in I invented a “dash encoding”, a new encoding scheme for URL paths

…there's so much troubleshooting full of relevant links and solutions. Same with his TIL blog. [0]: https://github.com/simonw/datasette/issues/1576

comment by abdusco · 2022-01-05 · in Problems once solved by a metaclass can be solved by __init_subclass__

…a dumb question but I skimmed the docs and sample and it looks similar + didn't see any mention: https://github.com/simonw/datasette

comment by gavinray · 2021-10-08 · in Roapi: An API Server for Static Datasets

…focused, is Simon Willison's Datasette [1]. [0] https://github.com/multiprocessio/datastation [1] https://github.com/simonw/datasette

comment by eatonphil · 2021-09-22 · in JupyterLab Desktop App now available

…means I can see at a glance if all of the dependent issues have been completed. Here's an example: https://github.com/simonw/datasette/issues/1105 It's not nearly as sophisticated as what you're looking for in terms of date estimates and…

comment by simonw · 2021-08-21 · in GitHub Issues-only project management

…started. I considered using Link headers for pagination in Datasette and got some useful pushback: https://github.com/simonw/datasette/issues/782#issuecomment-... > It has a lot of strikes against it: poor discoverability, new developers…

comment by simonw · 2021-07-01 · in PAGNIs: Probably Are Gonna Need Its

…the streaming CSV response - I already have a table with 1001 items in it setup for another test: https://github.com/simonw/datasette/blob/0.57.1/tests/test_c...

comment by simonw · 2021-06-25 · in Notes on streaming large API responses

…Sphinx) and I like that a lot. Some examples: - https://docs.datasette.io serves documentation from https://github.com/simonw/datasette/tree/main/docs - which has documentation unit tests here: https://github.com/simonw/datasette/blob/main/…

comment by simonw · 2021-06-06 · in The case for continuous documentation

…Datasette is one application for views of read-only SQLite dbs with out-of-band replication. https://github.com/simonw/datasette There are a bunch of *-to-sqlite utilities in corresponding dogsheep project. Arrow JS for 'paged' browser…

comment by westurner · 2021-05-02 · in Hosting SQLite databases on GitHub Pages or any static file hoster

…but depending on how complex your operations are this can become hard to read and/or review. [1] https://github.com/simonw/datasette - datasette doesnt replace a standard DB IDE, but is a very good lightweight alternative to one if don't…

comment by abhgh · 2021-03-25 · in SQLite is not a toy database

…https://github.com/aergoio/aergolite - AergoLite is replicated SQLite but secured by a blockchain. https://github.com/simonw/datasette - Datasette (mentioned at the very end of the OP article) is a tool for offering up an SQLite database…

comment by petercooper · 2021-03-25 · in SQLite is not a toy database

…latest.datasette.io/fixtures/compound_three_primary_... The code is pretty complicated - mostly here: https://github.com/simonw/datasette/blob/0.53/datasette/view...

comment by simonw · 2020-12-27 · in API pagination design

…could make a small contribution to this project, I think that would help a lot of people ! [1] https://github.com/simonw/datasette/pull/1159

comment by lovasoa · 2020-12-24 · in Datasette.io, an official project website for Datasette

…up in the interface without having to restart the server. You can follow this issue for updates: https://github.com/simonw/datasette/issues/417

comment by simonw · 2020-12-24 · in Datasette.io, an official project website for Datasette

…old now but I launched this website yesterday. Up until now there's just been the GitHub repo at https://github.com/simonw/datasette and the project documentation at https://docs.datasette.io/ The https://datasette.io/ site is running on…

comment by simonw · 2020-12-12 · in Datasette: An open source multi-tool for exploring and publishing data

It's accepting issues and PRs: https://github.com/simonw/datasette

comment by tosser123 · 2020-12-12 · in Datasette: An open source multi-tool for exploring and publishing data

…to old issue threads to remind myself how I debugged something. Here's an example from yesterday: https://github.com/simonw/datasette/issues/1124

comment by simonw · 2020-12-04 · in Why I keep a personal log of bugs

…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