SQLite Forum

Assistance with using SQLite in PAMGuard
Please don't use SQLite Studio for debugging.  We don't know how it works and we don't know what its error messages mean.  Instead, please use the SQLite Command Line Shell:


Which you can download as part of the 'Precompiled Binaries' package from


This program was written by the same team which wrote SQLite itself.  If it does anything wrong, they know whether the problem is with that program or with SQLite itself.

Make sure your PAMGuard program – and everything else – doesn't have the SQLite database open.  Then use the command line program to open the database and examine it using commands like <code>.schema</code> and <code>.table</code> and by just typing SQL commands.  Does that program report that the database file contains what you expected ?