Simon Willison's blog offers a mix of technical tutorials, data analysis projects, and reflections on technology and society. With a focus on Python, SQL, and web development, Simon shares insights into building web applications, working with data, and exploring emerging technologies. Developers can learn about data visualization, API design, and software engineering best practices, gaining inspiration and practical knowledge to advance their careers.

Simon Willison

Learn how to track the history of a table in SQLite using a JSON audit log. Explore the audit table design and the construction of JSON objects using SQLite triggers.

Tracking SQLite table history using a JSON audit log

Building a JSON object representing the changes