How to upgrade SQLite?

[swhite]

Hi

I am using PB 5.7 on Linux and it is using SQLite ver 3.21 and I need at least 3.24 so is there a way to upgrade the version of sqlite the Purebasic uses?

Simon

[Marc56us]

I am using PB 5.7 on Linux and it is using SQLite ver 3.21 and I need at least 3.24 so is there a way to upgrade the version of sqlite the Purebasic uses?

Yes, this feature is in 5.70 B1

viewtopic.php?f=14&t=72650

[swhite]

What I did was rename the purebasic/purelibraries/linux/libraries/libpbsqlite3.a and then got the 5.71 beta and copied the libpbsqlite3.a file into the purebasic/purelibraries/linux/libraries folder and now I have version 3.27.

Simon

[Marc56us]

If the application is intended to run on a workstation other than the one on which it was programmed, I advise you to put the new lib in the application's own directory rather than in the system tree. Always think that a client workstation uses several applications before changing common libs.

Remember to put the full path to the UseSQLiteDatabase lib.
UseSQLiteDatabase(./xxx) if in le actual dir.
or
UseSQLiteDatabase(ProgramFilename()/xxx) if in same dir as program.

[Fred]

Don't patch the static lib, better use the shared object version (.so) with the enw 5.71 feature

[swhite]

Hi

I did not know that you can specify a path in the UseSQLiteDatabase() is this a new addition as it is not mentioned in the 5.7 documentation?

Simon

If the application is intended to run on a workstation other than the one on which it was programmed, I advise you to put the new lib in the application's own directory rather than in the system tree. Always think that a client workstation uses several applications before changing common libs.

Remember to put the full path to the UseSQLiteDatabase lib.
UseSQLiteDatabase(./xxx) if in le actual dir.
or
UseSQLiteDatabase(ProgramFilename()/xxx) if in same dir as program.

[swhite]

Thanks Fred I will look into this.

Simon

Don't patch the static lib, better use the shared object version (.so) with the enw 5.71 feature

[Marc56us]

I did not know that you can specify a path in the UseSQLiteDatabase() is this a new addition as it is not mentioned in the 5.7 documentation?

5.71 B1
Beta, so documentation not set.
See Fred reply in topic 'PureBasic 5.71 beta 1 is out'
'The flag is just the DLL pathname, similar to UseMySQLDatabase().'
viewtopic.php?p=535284#p535284

[swhite]

Don't patch the static lib, better use the shared object version (.so) with the enw 5.71 feature

Just for my own knowledge of PB what are the possible negative aspects of patching the static libraries?

Thanks,
Simon

[infratec]

That you don't know with wich compilerflags the original lib was compiled.
So you don't know if everything what's needed by PB is inside your 'new' lib.