Best SQLite wrappers

[Chris Holbrook]

Any views on what is the most reliable-v-most up-to-date? I'm using a fairly elderly one of Stan Durham's at the moment - dated 12-1-2005 (Thanks, Stan!). It has been trouble-free in my experience but do not want to get too far behind, or too far out on a limb!

[Paul Squires]

Hi Chris,

I was also using Stan's wrappers. I have since switched from using Stan's to my own because Stan used the Get_Table approach rather than Prepare/Step/Finalize. He also used a strange setup to hold the Get_Table array result rather than simply allocating a block of memory via HeapAlloc and freeing when the recordset was no longer needed.

If you are interested, you can download the source code for the SQLite3 Client/Server that I am working on. It contains a fair amount of code to handle SQLite3 databases both directly or over a network. The code is located in my PlanetSquires forums. http://planetsquires.com/support/index.php

[Chris Holbrook]

Thanks Paul, I'll give them a spin!