A support library to simplify handling of SQLite use in programs

Started by Michele, October 11, 2026, 04:37:50 PM

Previous topic - Next topic

Michele

I'm writing a library, named 'DynSQLite', to simplify the use of SQLite in user programs.
The library carry a table browser that allows CRUD (Create, Read, Update and Delete) actions on each row, and to inspect blob fields as hex or image, even save, or load, a table, supported formats CSV, JSON, XML and SQL script.
The package include also a SQL editor/executor, that comes with syntax highlighter and auto-completion.
I wrote a demo program, SQLite-Browser, that is completely based on DynSQLite, the images attached shows some samples of use.
The software is almost completed in version Beta, I'll publish soon in the hope that could be useful to someone else.


Michele

I forget to say that the help of Gemini speeded up everything.
The program compiles with PellesC, Clang and MSVC.

Vortex

Hi Michele,

Thanks. We will wait for an attachment to test your library.
Code it... That's all...

Michele

Thanks Vortex, I'm completing the DLL version and fixing some minor bugs.
I forget to mention that the browser, a customized listview control, use a working thread to fill the list, this allows an efficient and fast handling of huge databases.

Robert

Hi Michele:

This may not be relevant to your current project but it is something to keep in mind going forward.

Quoted from SQLite Release 3.54.0 On 2026-10-09
at
https://sqlite.org/releaselog/3_54_0.html

Quote10: Drop support for WindowsXP and earlier Windows versions, including WindowsCE. SQLite for Windows now requires Windows Vista (circa 2007) or later.

Michele

Quote from: Robert on Today at 04:36:20 AMHi Michele:

This may not be relevant to your current project but it is something to keep in mind going forward.

Quoted from SQLite Release 3.54.0 On 2026-10-09
at
https://sqlite.org/releaselog/3_54_0.html

Quote10: Drop support for WindowsXP and earlier Windows versions, including WindowsCE. SQLite for Windows now requires Windows Vista (circa 2007) or later.
Thanks Robert, the short answer: my software isn't compatible with windows older than win10.
To allow for such old systems I should have used more complex approaches to obtain the results I got, I don't mean that isn't possible to make it back compatible, but I concluded that it wasn't worth the extra effort and, main reason, would have slowed down everything.
Anyway, because I'll publish the whole source, anybody, in case of need, can refactor it to the appropriate OS, also Linux maybe.