simonw/sqlite-utils on Hacker News

…github.com/simonw/datasette/graphs/code-frequency https://github.com/simonw/llm/graphs/code-frequency https://github.com/simonw/sqlite-utils/graphs/code-frequency

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

Right, the transcript is linked from the issue: https://github.com/simonw/sqlite-utils/issues/787#issuecomme... As far as I can tell I've shared more prompt transcripts than anyone else . Happy to be proven wrong about that. Look through…

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

…after opening the database file, prior to doing anything else that requires knowing the schema." https://github.com/simonw/sqlite-utils/issues/344#issuecomme... I guess for ID reuse a rationalization could be that theres only so many…

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

Thanks for the nudge, I just added a new test explicitly covering this: https://github.com/simonw/sqlite-utils/commit/d71420065903ff...

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

…defer_foreign_keys= ON" before running the transformation, then resets those settings afterwards: https://github.com/simonw/sqlite-utils/blob/3f0471701b5f8c7d... That's the pattern recommended by SQLite here:…

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

…has 9,973 lines of implementation code and 14,860 of test code. Here's the delete_where() test: https://github.com/simonw/sqlite-utils/blob/7a52214624ae0e2c... The problem with the test was that it asserted that the records were deleted…

comment by simonw · 2026-07-10 · in sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)

…does SQLite FTS full text search config. There are additional tables for FTS indexes. sqlite-utils: https://github.com/simonw/sqlite-utils sqlite-utils > Configuring full-text search: https://sqlite-utils.datasette.io/en/stable/cli.html#con…

comment by westurner · 2026-02-23 · in Show HN: Saga – A Jira-like project tracker MCP server for AI agents (SQLite)

…run. We picked it at my last company -- and it was a mistake, when a simple DB would have sufficed. https://github.com/simonw/sqlite-utils https://litestream.io/

comment by randito · 2026-01-24 · in Small Kafka: Tansu and SQLite on a free t3.micro

…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 smaller plugins and libraries and CLI tools,…

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

Here's what I got against one of my larger open source projects: cd /tmp git clone https://github.com/simonw/sqlite-utils cd sqlite-utils uvx ty check Here's the output: https://gist.github.com/simonw/a13e1720b03e23783ae668eca7f6f...…

comment by simonw · 2025-05-07 · in Ty: A fast Python type checker and language server

…it's a risky way of working compared to stateful migrations. Here are the tests for that option: https://github.com/simonw/sqlite-utils/blob/577078fe01da6d87... - and the accompanying issue: https://github.com/simonw/sqlite-utils/issues/467

comment by simonw · 2024-06-17 · in Dbmate: A lightweight, framework-agnostic database migration tool

…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 fully…

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

…8000 That started a https://datasette.io/ server running on port 8000. Git works too: ./git clone https://github.com/simonw/sqlite-utils That git binary is 6.3MB, and I believe that same exact file can be copied to a Linux or Windows…

comment by simonw · 2023-11-01 · in Cosmopolitan Third Edition

…useful for working with data in simple shell scripts. [1] https://github.com/johnkerl/miller [2] https://github.com/simonw/sqlite-utils

comment by leonim · 2023-06-28 · in Using command line to process CSV files (2022)

…my package as a Python library rather than a CLI tool may not want the extra installed components: https://github.com/simonw/sqlite-utils/commit/ec12b780d5dcd6... There's an animated GIF demo of the result here:…

comment by simonw · 2023-05-21 · in Show HN: Trogon – An automatic TUI for command line apps

…my head. Just has the exact set of features I want. Here's one example of one of my Justfiles: https://github.com/simonw/sqlite-utils/blob/fc221f9b62ed8624... - documented here: https://sqlite-utils.datasette.io/en/stable/contributing.htm..…

comment by simonw · 2023-01-09 · in Just: A Command Runner

…time, but it is possible to search PRs by commit. For example, say git blame led me to this commit: https://github.com/simonw/sqlite-utils/commit/129141572f249e... I could have found PR #373 via this search:…

comment by thunky · 2022-10-30 · in The Perfect Commit

Is this example too large or about the right size for you? https://github.com/simonw/sqlite-utils/commit/ab8d4aad0c42f9...

comment by simonw · 2022-10-29 · in The Perfect Commit

…them is to run my test suite against multiple Python versions using GitHub Actions, e.g. here: https://github.com/simonw/sqlite-utils/blob/main/.github/wor...

comment by simonw · 2022-09-01 · in The Rise of SQL

…each column: https://sqlite-utils.datasette.io/en/latest/python-api.html#... Implementation here: https://github.com/simonw/sqlite-utils/blob/3fbe8a784cc2f3fa...

comment by simonw · 2022-06-21 · in One-liner for running queries against CSV files with SQLite

…fine in practice. Here's where I implement that in my sqlite-utils Python library and CLI tool: https://github.com/simonw/sqlite-utils/blob/2d84577202e22767...

comment by simonw · 2022-06-18 · in The Design of SQLite4

…From the same author, "sqlite-utils" generate SQLite table definitions and rows from similar: https://github.com/simonw/sqlite-utils I find this useful outside of SQLite because the syntax is similar across SQL databases. Great way to…

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

…the other tools that will create a sqlite database for you.) - https://github.com/saulpw/visidata - https://github.com/simonw/sqlite-utils

comment by leonim · 2022-03-22 · in Ask HN: Local Tools for Viewing JSON

Sqlite-utils has this: https://github.com/simonw/sqlite-utils

comment by globular-toast · 2022-02-27 · in New JSON query operators in SQLite 3.38.0

…and then exploring with Visidata or SQL queries. Q: https://github.com/harelba/q sqlite-utils: https://github.com/simonw/sqlite-utils

comment by leonim · 2021-12-30 · in A fast SQLite PWA notebook for CSV files

…or for things that I want to explore that are relevant to the project in some way. Recent example: https://github.com/simonw/sqlite-utils/issues/344 - researching STRICT mode that was just added to SQLite, and seeing if it would make sense…

comment by simonw · 2021-12-04 · in Keep a Log

…for my sqlite-utils tool - I'm seeing a big speed up in comparison to parsing the CSV in Python: https://github.com/simonw/sqlite-utils/issues/297

comment by simonw · 2021-07-18 · in Show HN: Work with CSV files using SQL. For data scientists and engineers

…property, which grew extra features (like order_by) over time as they were requested by users, eg https://github.com/simonw/sqlite-utils/issues/76 The vast majority of the library is aimed at making getting data IN to SQLite as easy as…

comment by simonw · 2021-06-20 · in Joining CSV and JSON data with an in-memory SQLite database

…to add a --schema option which does the dump without also including the inserted rows. Issue here: https://github.com/simonw/sqlite-utils/issues/288

comment by simonw · 2021-06-20 · in Joining CSV and JSON data with an in-memory SQLite database

…hub.com/simonw/datasette/blob/main/tests/test_doc... - https://sqlite-utils.datasette.io/ serves from https://github.com/simonw/sqlite-utils/tree/main/docs - unit tests here: https://github.com/simonw/sqlite-utils/blob/main/tests/test_...…

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

…Excel, Sqlite3, etc in the terminal. I find the Datasette author's related tools sqlite-utils ( https://github.com/simonw/sqlite-utils ) and the Dogsheep tools ( https://github.com/dogsheep ) and VisiData are nicely complementary. I prefer…

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

Yes, ijson. I figured out how to use that a few days ago: https://github.com/simonw/sqlite-utils/issues/173

comment by simonw · 2020-10-24 · in XMHell: Handling 38GB of UTF-16 XML with Rust

…and (inspired by simonw) we've incorporated a black check into the test suite. It's simple: https://github.com/simonw/sqlite-utils/blob/master/tests/tes...

comment by genmon · 2019-05-17 · in Black – Uncompromising Python code formatter