SQLite Forum

I Need a tool to support real-time tracking of database actions
Login
SQLite is not a server/client system.  There is no central processor which makes all changes to the database.  So there's no computer or process which can be used to track all changes made by all computers accessing the database.  You can only track what your own connection is doing to the database.

You can use this hook to trace ***what your app*** is doing to the database:

<https://sqlite.org/c3ref/trace_v2.html>

Another way to do it is to use the authorization hook:

<https://sqlite.org/c3ref/set_authorizer.html>

But instead of using it to authorize or deny a statement being executed, just track what's being done and authorize everything.