DynSQLite Library - SQLite support library

Started by Michele, November 09, 2026, 12:12:02 AM

Previous topic - Next topic

John Z

Hi Michele,

Started to look more into your masterpiece - Two minor things at the start.
When opening a DB there is very little notification that it has been opened successfully. I did eventually notice the Title bar text change, but perhaps something more affirmative could be done.

Secondly if 'mistakenly'  ;)  opening a .pdf, or .txt, or non-database file the program crashes.  Might want to validate, as a minimum, that the selected file has an extension which is one of the three you allow.

Then check the header to be sure it is a valid SQLite db before trying to load it - valid SQLite 3 database begins with a 16-byte magic header string that spells out SQLite format 3 followed by a null terminator.

Cheers,
John Z

John Z

#31
Hi Michele,

A display issue with column 2.  I mistakenly have it as blob and will fix it.
Nevertheless as the attached image shows SQLite DB browser shows the value while the Studio is just showing (i guess the format) <BLOB 1 bytes>

John Z

Update:   
I miss having a MRU/Recent files list.

Needing to hit save for every entry is burdensome

Like to write all changes at once so a 'Write Changes' menu item

Missing 'Save As' so I tried Backup
Tools - Backup does not seem to work , took filename but I never found the file. then I entered the same backup name twice didn't ask to overwrite so more indication  nothing was backed up.

SQL queries worked fine.

After testing/using for a while not a fan of the static splash window just housing the menu, using screen space, maybe it should be retractable to just the menu after a while.

I see </> on the splash window so I want to click < or > to cycle thru 'something' usually means forward backward but its just an image ....

Done for today - but more testing later

Still very impressive!
John Z