sqlite-history: tracking changes to SQLite tables using triggers (also weeknotes)

In between blogging about ChatGPT rhetoric, micro-benchmarking with ChatGPT Code Interpreter and Why prompt injection is an even bigger problem now I managed to ship the beginnings of a new project: sqlite-history.

sqlite-history

Recording changes made to a database table is a problem that has popped up consistently throughout my entire career. I've managed to mostly avoid it in Datasette so far because it mainly dealt with read-only data, but with the new JSON write API has made …

api benchmarking bigger blogging career chatgpt chatgpt code code data database databases datasette history json managed people project projects prompt prompt injection recording sqlite table tables tracking weeknotes