WAL Autocheckpoint has been set to check every two pages.
Max journal size is 32 MB.
Updated the delete product record trigger to now delete the tags associated with it in the tags table.
Added a few more (and removed 1) indexes for performance for sorting.
Updated tags table to be of Integer type instead of String for performance reasons.
When the app is closed, the database will be checkpointed and the WAL file will be truncated. It also attempts to delete the extra "wal" and "shm" files but currently it fails to do so.
DPDatabase
DPDatabase now has functions to delete tags (for updating tags) and GetExtractionRecord in preparation for improving the Product Record Dialog.
DPDatabase now has RecordQueryCompleted and Failed event.
DoLibraryQuery now takes current page into account when returning results from database.
Library / LibraryPanel / Button Control
Updated Library and LibraryPanel to appropriately update view when changing pages between search or regular mode.
Search results are no longer of type LibrarySearchItem.
Fixed an issue where the library button controls would throw an exception and would be rendered useless for the lifetime of the application.
Product Record Form
Product Record Form is now fully functional.
Other
LibrarySearchItem has been removed.
Added license headers.
Fixed a small issue where files with no extension (such as 'LICENSE') would throw an unexpected exception.
Import File Records Project has been added to the solution (this is mainly for me) to import file records (erec and prec) into the database.
Database
DPDatabase
Library / LibraryPanel / Button Control
Product Record Form
Other