PureBasic 5.71 LTS is out !

Fred · **Posted:** Mon Apr 15, 2019 8:47 pm

Hello,

Final version is out, thank you a lot for testing !

Beta 3 is available ! Bug fixes:

Bugfixes for this version:

This list was created automatically. All updated bug threads from the date of the last final version have been determined.

The beta 2 is out with some more bug fixes ! You can get it on your online account

The new bug fix version of PureBasic is available on your online account. Change list:

Code:

- SQLite added DLL support (new parameter in UseSQLiteDatabase())
- Updated SQLite to 3.27.0
- Bug fixes

About the new flag in UseSQLiteDatabase(): if you don't use the flag, it will link the static lib as usual. If you use the flag, it won't link the static lib at all (ie: much smaller exe, but requiers a DLL). When using the DLL it's easier to use the latest available version of SQLite without waiting for a PB update.

Bugfixes for this version:

This list was created automatically. All updated bug threads from the date of the last final version have been determined.

Have fun !

The Fantaisie Software team

skywalk · **Posted:** Mon Apr 15, 2019 8:53 pm

Wow! That sounds tremendous.

DeanH · **Posted:** Mon Apr 15, 2019 10:20 pm

Apologies for being a bit thick, but what is the flag please? I cannot seem to locate any information.
To access the database commands, are the normal PureBasic database functions used or DLL library functions?
Also, are there any plans to implement fts5 in the static lib?

useful · **Posted:** Tue Apr 16, 2019 3:51 am

Great news,
but it is frustrating that

README
INSTALL
checkinstall.sh

in the Linux version still does not correspond to the current state.

Marc56us · **Joined:** Sat Feb 08, 2014 3:26 pm **Posts:** 718

Thank you Fred,

Excellent choice (as usual) to have kept the possibility to use SQLite internally or as DLL.

̶P̶S̶.̶ ̶M̶i̶s̶s̶i̶n̶g̶ ̶L̶T̶S̶ ̶i̶n̶ ̶t̶o̶p̶i̶c̶ ̶t̶i̶t̶l̶e̶.̶
(Fixed)

:wink:

RSBasic · **Posted:** Tue Apr 16, 2019 8:02 am

Thank you very much

Fred · **Posted:** Tue Apr 16, 2019 8:19 am

useful wrote:

Great news,
but it is frustrating that

README
INSTALL
checkinstall.sh

in the Linux version still does not correspond to the current state.

True, I will update it

Fred · **Posted:** Tue Apr 16, 2019 8:20 am

DeanH wrote:

Apologies for being a bit thick, but what is the flag please? I cannot seem to locate any information.
To access the database commands, are the normal PureBasic database functions used or DLL library functions?
Also, are there any plans to implement fts5 in the static lib?

The flag is just the DLL pathname, similar to UseMySQLDatabase(). About FTS5 and other option, that's also why the DLL is an option too, because SQlite can be built with a lot of flags and we can't support them all in a single static lib

Joris · **Posted:** Tue Apr 16, 2019 8:20 am

Thanks Fred.

RSBasic · **Posted:** Tue Apr 16, 2019 1:00 pm

Fred wrote:

- Bug fixes

So that everyone doesn't have to check for themselves which bug was fixed in this version, I have developed a tool to determine all bug fixes since the last final version.

Bugfixes for this version:

This list was created automatically. All updated bug threads from the date of the last final version have been determined.

Dude · **Joined:** Mon Feb 16, 2015 2:49 pm **Posts:** 1904

Thanks Fred, and thanks RSBasic for the bug-fix list!

Fred · **Posted:** Tue Apr 16, 2019 1:57 pm

Now that's cool RSBasic ! If you can share this, I will run it when writing the announcement

pwd · **Joined:** Thu Sep 06, 2012 9:39 am **Posts:** 60

Even though we were given a "new parameter in UseSQLiteDatabase()" to use whatever SQLite version we like (thx!), I would still ask:
Why not to ship 5.71 LTS with the latest SQLite version available at the moment of the release (at least the first beta, not the final release date for obvious reasons)?
And that is 3.27.2 (2019-02-25), which has 4 bug fixes (in total with 3.27.1) over 3.27.0

By the way, thank you for the bug fixes too.

Fred · **Posted:** Tue Apr 16, 2019 3:57 pm

Because it takes time to do the patch, and I did it a few week ago. It doesn't matter it will be outdated anyway

skywalk · **Posted:** Tue Apr 16, 2019 4:37 pm

Hi Fred, can you explain the Pros/Cons of the static vs dynamic use of SQLite?
All things equal, I'm curious of the speed of insertions and queries.
Maybe after establishing a DB connection, there is no big difference?

PureBasic Forum

PureBasic 5.71 LTS is out !

Who is online