Running the latest SQLite in Datasette using Homebrew

I made a pleasant discovery today: Homebrew are very quick to update to the latest SQLite release (here's their formula), and since Datasette when installed via Homebrew uses that version, this means you can use brew update sqlite to ensure you are running the most recent SQLite version within Datasette.

If you've installed Datasette using Homebrew:

brew install datasette

You can see the version of SQLite it uses either by running datasette and navigating to https://127.0.0.1:8001/-/versions - or you can see it from the command-line using:

% datasette --get /-/versions.json | jq .sqlite.version
"3.37.2"

To upgrade SQLite, run the following:

brew upgrade sqlite

After doing that I ran the above command again and confirmed I had been upgraded to SQLite 3.38.0:

% datasette --get /-/versions.json | jq .sqlite.version
"3.38.0"

Related

• sqlite Loading SQLite extensions in Python on macOS - 2023-01-07
• sqlite Running Steampipe extensions in sqlite-utils and Datasette - 2023-12-20
• homebrew Upgrading Python Homebrew packages using pip - 2020-10-14
• sqlite Using LD_PRELOAD to run any version of SQLite with Python - 2020-06-17
• sqlite Using pysqlite3 on macOS - 2021-07-10
• homebrew Packaging a Python CLI tool for Homebrew - 2020-08-11
• sqlite Compiling the SQLite spellfix.c module on macOS - 2020-09-19
• python Running PyPy on macOS using Homebrew - 2022-09-14
• sqlite Compile and run a new SQLite version with the existing sqlite3 Python library on macOS - 2023-08-22
• sqlite Finding the SQLite version used by Web SQL in Chrome - 2022-10-28

Created 2022-02-28T12:09:11-08:00, updated 2022-02-28T12:41:50-08:00 · History · Edit