SQLite Forum

Timeline
Login

3 forum posts by user ambercrittenden

2021-10-29
06:49 Reply: Assistance with using SQLite in PAMGuard (artifact: 71610f2a90 user: ambercrittenden)

Hi Barry, thank you for taking the time to respond my post.

Yes, to my understanding an “SQLite database module” is the same as an “SQLite database”, a ‘module’ is the terminology used in the PAMGuard user manual to describe an element added to the PAMGuard interface.

Yes, by “database” I am referring to a database intended to be accessed within PAMGuard. I added the database by following the instructions described in the PAMGuard help manual which directed that I designate SQLite as the chosen database system in the database selection menu. I then created an SQLite database file (.sqlite3). I need the database to store count data generated by PAMGuard when it analyses .wav audio files.

Yes, the expected tables are present, but they do not display the count data expected. I apologise for my lack of convention terminology; I am still attempting to learn the appropriate terminology as I familiarise myself with these programs for the first time. Yes, by ‘field’ I am referring to tuples in the table rows.

The detector module in PAMGuard is counting the number of whistles present in an audio file, and I am attempting to have the sum of that count data displayed in the SQLite database file. When the whistle is present in the audio file, I can visually see PAMGuard is detecting it with the real-time spectrogram, but that count data is not shown anywhere in the SQLite database file.

I believe your first assumption is correct, the effect of the PAMGuard run on the database is not as expected; the tables are generated but the count data is absent.

I’m confident “the output” is not an empty set as I can visually see that PAMGuard is detecting the whistles in the audio file correctly, and therefore I believe count data should be displayed in the SQLite database file.

Another piece of information that may help is that when I open the SQLite database file in SQLite Studio is receive the following error messages:

Could not restore window 'Whistle_and_Moan_Detector (TowST)', because database TowST could not be resolved. Could not restore window 'Whistle_and_Moan_Detector_Localised_Contours (TowST)', because database TowST could not be resolved. Could not restore window 'PamguardModules (TowST)', because database TowST could not be resolved. Could not restore window 'Sound_Acquisition (TowST)', because database TowST could not be resolved.

Does this shed any light on what my issue could be? That is, that the count data from the PAMGuard processing is absent from the SQLite database file despite visual confirmation that there should be count data present?

Thank you again for your time.

06:15 Edit: Assistance with using SQLite in PAMGuard (artifact: 56294638a7 user: ambercrittenden)

Hi, I'm a PhD student and have been attempting to use SQLite as a database in PAMGuard.

I have loaded an SQLite database module into PAMGuard, but when the analysis is finished, opeing the database in SQLite Studio shows no data (all fields are empty) even when I can see the detector modules are making detections. I have also attempted opening the SQLite database in PAMGuard Viewer after PAMGuard has finished running, but all of these fields are also empty.

Do any PAMGuard users have suggestions as to why I am not able to view the output in my SQLite database? Any and all insight would be greatly appreciated!

2021-10-07
02:00 Post: Assistance with using SQLite in PAMGuard (artifact: f22f296af4 user: ambercrittenden)

Hi, I'm a PhD student from Melbourne, Australia, and have been attempting to use SQLite as a database in PAMGuard.

I have loaded an SQLite database module into PAMGuard, but when the analysis is finished, opeing the database in SQLite Studio shows no data (all fields are empty) even when I can see the detector modules are making detections. I have also attempted opening the SQLite database in PAMGuard Viewer after PAMGuard has finished running, but all of these fields are also empty.

Do any PAMGuard users have suggestions as to why I am not able to view the output in my SQLite database? Any and all insight would be greatly appreciated!