s
Oct. 3, 2023, 6:57 p.m. |

Simon Willison's Weblog simonwillison.net

New sqlite3 CLI tool in Python 3.12


The newly released Python 3.12 includes a SQLite shell, which you can open using "python -m sqlite3" - handy for when you're using a machine that has Python installed but no sqlite3 binary.

I installed Python 3.12 for macOS using the official installer from Python.org and now "/usr/local/bin/python3 -m sqlite3" gives me a SQLite 3.41.1 shell - a pleasantly recent version from March 2023 (the latest SQLite is 3.43.1, released in September).

binary cli machine macos python python 3 shell sqlite tool

AI Research Scientist

@ Vara | Berlin, Germany and Remote

Data Architect

@ University of Texas at Austin | Austin, TX

Data ETL Engineer

@ University of Texas at Austin | Austin, TX

Lead GNSS Data Scientist

@ Lurra Systems | Melbourne

Senior Machine Learning Engineer (MLOps)

@ Promaton | Remote, Europe

Senior Software Engineer, Generative AI (C++)

@ SoundHound Inc. | Toronto, Canada