SQLite Databases
SQLite is a single file database and is an excellent replacement for Microsoft Access. Data are stored in a single file which can easily be backed up and copied between computers.
SQLite is cross platform so should work on Mac’s and Linux platforms as well as Windows.
SQLite is open source and free to use. A number of viewers are available to enable you to view data directly within the database file. We have tested and recommend SQLiteStudio which can be downloaded here.
Configuring an SQLite database
PAMGuard will automatically create the necessary .sqlite3 database file on your computer.
You do not need to add tables to the database, PAMGuard will automatically create the tables it needs.
Auto commit
If Auto commit is selected, the database file will be updated every time a new record is written to the database. This can have a serious impact on overall performance, so it not recommended.
If you have NOT selected auto commit, then changes will be written to the database at the following times:
- Every three seconds
- Whenever the number of uncommitted records reaches 10
- Whenever PAMGuard stops
- Whenever PAMGuard exits
- Whenever tables are added to the database, or the database structure changed in any way
- In Viewer Mode, whenever the data about to be reloaded.
You can also commit changes at any time, using the menu command File/Database/Commit Changes.