simonw

sqlite-utils

Python2019–2026

simonw / sqlite-utils

sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Explore on GitHub Read Hacker News discussions

12Distinct people

35Mentions

1Explicit recommenders

2.2KGitHub stars

REPOSITORY AT A GLANCE

What to know before exploring

What it is

Python CLI utility and library for manipulating SQLite databases

GitHub

Where it is used

No documented product use was verified in the last source check.

What people are saying

I love black: formatting isn't a _big_ thing to think about, but it's always there. Until black. For [current project] it's hooked into VS Code as the default formatter, and…

genmon used a recommendation phrase. One indexed comment matches. This is a phrase match, not a verdict.

No classified warning is attached to this page. Read the discussions before treating silence as approval.

Also in these discussions

simonw/datasette · linked in 6 of the same discussions
simonw/llm · linked in 2 of the same discussions

Mentioned in the same Hacker News threads. That is not proof they are substitutes.

This week on Hacker News

Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 6:01:08 PM UTC.

No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.

Mentions over time

HN mentions by year35 dated mentions

Observed mentions: 2019-05-17 16:36:50 UTC to 2026-08-05 02:35:12 UTC.

* An incomplete calendar period is marked with an outlined bar. Its count is not directly comparable with a full period.

Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.

View mention counts and date ranges

UTC ranges include their start and exclude their end. Select a period to filter the source evidence.
Period	Start (UTC)	End (exclusive, UTC)	Mentions	Submissions	Comments
2019	2019-01-01 00:00:00 UTC	2020-01-01 00:00:00 UTC	1	0	1
2020	2020-01-01 00:00:00 UTC	2021-01-01 00:00:00 UTC	3	1	2
2021	2021-01-01 00:00:00 UTC	2022-01-01 00:00:00 UTC	6	0	6
2022	2022-01-01 00:00:00 UTC	2023-01-01 00:00:00 UTC	9	1	8
2023	2023-01-01 00:00:00 UTC	2024-01-01 00:00:00 UTC	4	0	4
2024	2024-01-01 00:00:00 UTC	2025-01-01 00:00:00 UTC	2	0	2
2025	2025-01-01 00:00:00 UTC	2026-01-01 00:00:00 UTC	2	0	2
2026 (partial)	2026-01-01 00:00:00 UTC	2027-01-01 00:00:00 UTC	8	0	8

What Hacker News says

4 sources

simonw·Nov 1, 2023

There's so much cool stuff in this post. https://github.com/jart/cosmopolitan/releases/download/3.0.1... is 213MB file which contains "fat binaries" (single binaries that execute on a bewildering array of hardware platforms and operating systems) for dozens of programs, including zip, curl, git, wget, python, ctags and even my own Datasette Python application! It's absolutely wild that this works. I just tried it out (on macOS). I downloaded and extracted that zip and did this: cd ~/Downloads/cosmos-3.0.1/bin ./python -c 'print(4 + 5)' It refused the first time because of macOS security settings. I had to open the security panel and click "allow"... and then it worked! Likewise, this worked: ./datasette -m datasette -p 8000 That started a https://datasette.io/ server running on port 8000. Git works too: ./git clone https

Read the rest

://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 machine and will work the same way.

In Cosmopolitan Third Edition

leonim·Jun 28, 2023

Also, there is the VisiData Tutorial by Jeremy Singer-Vine. This is a very helpful introduction to VisiData. https://jsvine.github.io/intro-to-visidata/index.html I am a big fan of VisiData for working with data in the terminal. I also like John Kerl's miller[1] and Simon Willison's sqlite-utils [2] when I want to do queries. These are useful for working with data in simple shell scripts. [1] https://github.com/johnkerl/miller [2] https://github.com/simonw/sqlite-utils

In Using command line to process CSV files (2022)

simonw·May 21, 2023

This is really fun. I have an experimental branch of my sqlite-utils CLI tool (which has dozens of sub-commands) running with this now and it really did only take 6 lines of code - I'm treating Trogon as an optional dependency because people using 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: https://github.com/simonw/sqlite-utils/issues/545#issuecomme...

In Show HN: Trogon – An automatic TUI for command line apps

simonw·Jan 9, 2023

I've been using this for about six months now and I absolutely love it. Make never stuck for me - I couldn't quite get it to fit inside 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... I also wrote about using Just with Django in this TIL: https://til.simonwillison.net/django/just-with-django

In Just: A Command Runner