SQLite 3.45

[Tremorian]

Please integrate SQLite 3.45 in PB 6.10, because it has several improvements:

https://sqlite.org/releaselog/3_45_0.html

[infratec]

Read the help for UseSQLiteDatabase()

You can always use the latest version if you really want.

[skywalk]

+1
Many json improvements, small speed ups and bug fixes.
PB static load is at 3.38.2 from 2022.

Code: Select all

SQLite3.dll       = 
SQLite Version    = 3.38.2
SQLite Lib        = 2022-03-26 13:51:10 d33c709cc0af66bc5b6dc6216eba9f1f0b40960b9ae83694c986fbf4c1d6f08f

It would be better if we could statically load the latest sqlite32.lib with PB's C compile option.

[Fred]

you should now be able to replace the sqlite.lib file in PureBasic\PureLibraries\Windows\Libraries if the lib is compiled with VC2022

[Quin]

you should now be able to replace the sqlite.lib file in PureBasic\PureLibraries\Windows\Libraries if the lib is compiled with VC2022

this is incredible, thanks a ton!
Agreed with OP though, not having to do that ourselves and getting the latest would be nice.

[skywalk]

That is awesome!
I'll try today after upgrading VS.

[skywalk]

Hi Fred,
Can you list the built-in compile settings Purebasic uses for the static sqlite3.lib?

Can you add -DSQLITE_ENABLE_MATH_FUNCTIONS to the list?

The math functions shown below are a subgroup of scalar functions that are built into the SQLite amalgamation source file but are only active if the amalgamation is compiled using the
-DSQLITE_ENABLE_MATH_FUNCTIONS compile-time option.