SQLite triggers to track table changes

I am just starting to explore SQLite in the context of personal projects and, more recently, Publii. So this is interesting. Didn&#x27;t know about triggers.<p>I found one statement confusing in this post: &quot;I can&#x27;t add a primary key after the fact to my inputs table; it&#x27;s not supported&quot;.<p>I have added PKs to existing tables before, what does the author mean by that?

This is me learning sqlite basics to start a more ambitious project tracking changes in grafana.

DuckDB is another embedded db worth taking a look. It has some unique features, such as, you can fetch data from an api, extract data from the json response and insert into database via sql

Cool solution. I might use it on a small multi tenant web app to generate audit logs.<p>It has one SQLite database per tenant.