Simon Willison on sqlite-utils

223 posts tagged “sqlite-utils”

sqlite-utils is a Python library and command-line utility for creating and manipulating SQLite databases.

2020

Release sqlite-utils 2.14.1 — Python CLI utility and library for manipulating SQLite databases

6th Aug 2020, 6:31 am · sqlite-utils, sqlite

sqlite-utils 2.14 (via) I finally figured out porter stemming with SQLite full-text search today—it turns out it’s as easy as adding tokenize=’porter’ to the CREATE VIRTUAL TABLE statement. So I just shipped sqlite-utils 2.14 with a tokenize= option (plus the ability to insert binary file data from stdin).

# 1st August 2020, 9:19 pm / full-text-search, projects, search, sqlite, sqlite-utils

Release sqlite-utils 2.14 — Python CLI utility and library for manipulating SQLite databases

1st Aug 2020, 9 pm · sqlite, sqlite-utils

Fun with binary data and SQLite

This week I’ve been mainly experimenting with binary data storage in SQLite. sqlite-utils can now insert data from binary files, and datasette-media can serve content over HTTP that originated as binary BLOBs in a database file.

[... 957 words]

11:22 pm / 30th July 2020 / projects, sqlite, paul-ford, plugins, datasette, weeknotes, sqlite-utils

Release sqlite-utils 2.13 — Python CLI utility and library for manipulating SQLite databases

30th Jul 2020, 1:15 am · sqlite-utils, sqlite

sqlite-utils 2.12 (via) I’ve been experimenting with ways of improving BLOB support in Datasette and sqlite-utils. This new version of sqlite-utils includes a “sqlite-utils insert-files” command, which can recursively crawl directories for files and add their contents to SQLite with configurable columns containing their metadata.

I was inspired by Paul Ford who has been creating multi-GB SQLite databases of images and PDFs. It turns out that when disk space is cheap this is a pretty effective way of working with interesting corpuses of documents and images.

# 27th July 2020, 7:36 am / projects, sqlite, sqlite-utils

Release sqlite-utils 2.12 — Python CLI utility and library for manipulating SQLite databases

27th Jul 2020, 7:24 am · sqlite-utils, sqlite

Weeknotes: datasette-copyable, datasette-insert-api

Two new Datasette plugins this week: datasette-copyable, helping users copy-and-paste data from Datasette into other places, and datasette-insert-api, providing a JSON API for inserting and updating data and creating tables.

[... 953 words]

11:37 pm / 23rd July 2020 / my-talks, weeknotes, datasette, plugins, projects, sqlite-utils

Weeknotes: SBA Covid-19 PPP loans, Datasette talks, Datasette plugin upgrades

This week I’ve mainly been exploring Small Business Administration Covid-19 loans data, pitching some talks and upgrading some plugins for compatibility with Datasette 0.44+.

[... 524 words]

10:44 pm / 9th July 2020 / projects, covid19, datasette, weeknotes, sqlite-utils

Release sqlite-utils 2.11 — Python CLI utility and library for manipulating SQLite databases

8th Jul 2020, 5:36 pm · sqlite, sqlite-utils

Release sqlite-utils 2.10.1 — Python CLI utility and library for manipulating SQLite databases

23rd Jun 2020, 9:04 pm · sqlite, sqlite-utils

Release sqlite-utils 2.10 — Python CLI utility and library for manipulating SQLite databases

12th Jun 2020, 5:44 pm · sqlite-utils, sqlite

Release sqlite-utils 2.9.1 — Python CLI utility and library for manipulating SQLite databases

11th May 2020, 7:21 pm · sqlite, sqlite-utils

Release sqlite-utils 2.9 — Python CLI utility and library for manipulating SQLite databases

11th May 2020, 1:57 am · sqlite, sqlite-utils

Release sqlite-utils 2.8 — Python CLI utility and library for manipulating SQLite databases

3rd May 2020, 3:41 pm · sqlite-utils, sqlite

Release sqlite-utils 2.7.2 — Python CLI utility and library for manipulating SQLite databases

2nd May 2020, 4:10 pm · sqlite, sqlite-utils

Release sqlite-utils 2.7.1 — Python CLI utility and library for manipulating SQLite databases

1st May 2020, 10:11 pm · sqlite-utils, sqlite

Release sqlite-utils 2.7 — Python CLI utility and library for manipulating SQLite databases

30th Apr 2020, 6:33 pm · sqlite-utils, sqlite

Weeknotes: Datasette 0.40, various projects, Dogsheep photos

A new release of Datasette, two new projects and progress towards a Dogsheep photos solution.

[... 826 words]

11:09 pm / 22nd April 2020 / twitter, datasette, github, projects, jsk, dogsheep, weeknotes, sqlite-utils

Release sqlite-utils 2.6 — Python CLI utility and library for manipulating SQLite databases

16th Apr 2020, 3:14 am · sqlite-utils, sqlite

Release sqlite-utils 2.5 — Python CLI utility and library for manipulating SQLite databases

13th Apr 2020, 3:54 am · sqlite-utils, sqlite

Release sqlite-utils 2.4.4 — Python CLI utility and library for manipulating SQLite databases

23rd Mar 2020, 8:34 pm · sqlite-utils, sqlite

Release sqlite-utils 2.4.3 — Python CLI utility and library for manipulating SQLite databases

23rd Mar 2020, 8 pm · sqlite-utils, sqlite

Weeknotes: this week was absurd

As of this morning, San Francisco is in a legally mandated shelter-in-place. I can hardly remember what life was like seven days ago. It’s been a very long, very crazy week. This was not a great week for getting stuff done.

[... 246 words]

2:52 am / 18th March 2020 / projects, weeknotes, sqlite-utils

Release sqlite-utils 2.4.2 — Python CLI utility and library for manipulating SQLite databases

14th Mar 2020, 8:13 pm · sqlite-utils, sqlite

Release sqlite-utils 2.4.1 — Python CLI utility and library for manipulating SQLite databases

14th Mar 2020, 8:06 pm · sqlite-utils, sqlite

Release sqlite-utils 2.4 — Python CLI utility and library for manipulating SQLite databases

27th Feb 2020, 4:58 am · sqlite, sqlite-utils

Release sqlite-utils 2.3.1 — Python CLI utility and library for manipulating SQLite databases

11th Feb 2020, 5:59 am · sqlite, sqlite-utils

Release sqlite-utils 2.3 — Python CLI utility and library for manipulating SQLite databases

8th Feb 2020, 11:59 pm · sqlite, sqlite-utils