Issue #19 - 2/10/2023

Got something for the newsletter? Please share it!

---

openai-to-sqlite - "This tool provides utilities for interacting with OpenAI APIs and storing the results in a SQLite database." Simon Willison

Making SQLite extensions pip install-able - An article that describes how to distribute an SQLite extension as a Python package. Alex Garcia

Building a Pivot Table in SQLite - A tutorial on three ways to build a pivot table in SQLite. Anton Zhiyanov

Writing a Custom SQLite Function (in C) - "In this short series, we're going to add a user defined function to SQLite in C. We'll go through the process slowly and in a way which, I hope, a C novice can follow." Karl Seguin

SQLite Clustered Index & the WITHOUT ROWID Optimization - A short video that describes how to use a clustered index to speed up queries in SQLite. Mycelial

Sponsored by Mycelial, maker of local-first software tools.
Sponsor