PureBasic Forums - English

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

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

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

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

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

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

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

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

Simon