Update SQLite to version 3.38

[swhite]

Hi

I would like the SQLite library updated to 3.38. As I would like to be able to use the "Returning" feature added in version 3.35.

Simon

[Marc56us]

In the meantime you can specify a different dll
https://www.purebasic.com/documentation ... abase.html
UseSQLiteDatabase([LibraryName$])
"Filename (and path if needed) of the dynamic library to use.
You will be able to use the latest version of the 'dll' file (so, dylib) without waiting for a PB update. [...]"
DLL https://www.sqlite.org/download.html

[swhite]

Yes that is true for newer versions of PB but I need to use version 5.45 for ASCII compilation. So I need to replace the libpbsqlite3.a with a newer version.

Simon

[skywalk]

You may find it surprisingly simple to convert your ascii code to unicode. Then you get the benefits of latest compiler.

[swhite]

Hi

I use the PB 5.73 all the time but for this application I want to use the ASCII compilation mode for the most speed and to avoid Unicode all together.

Simon

[skywalk]

Have you quantified the speed difference?
Native PB strings vs memory?

[swhite]

There is another issue related to SQLite that makes an ASCII implementation easier. I documented this in the following topic.

https://www.purebasic.fr/english/viewto ... 22#p582322

When I tested the Unicode vs ASCII I got about 30% speed increase.

Simon

[swhite]

Thank-you Fred for the update to SQLite 3.38. It works perfectly with PB 5.45.

Simon