Page 1 of 6

PureBasic 5.71 LTS is out !

Posted: Mon Apr 15, 2019 8:47 pm
by Fred
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: Select all

- 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

Re: PureBasic 5.71 beta 1 is out !

Posted: Mon Apr 15, 2019 8:53 pm
by skywalk
Wow! That sounds tremendous. 8)

Re: PureBasic 5.71 beta 1 is out !

Posted: Mon Apr 15, 2019 10:20 pm
by DeanH
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?

Re: PureBasic 5.71 beta 1 is out !

Posted: Tue Apr 16, 2019 3:51 am
by useful
Great news,
but it is frustrating that

README
INSTALL
checkinstall.sh

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

Re: PureBasic 5.71 beta 1 is out !

Posted: Tue Apr 16, 2019 6:16 am
by Marc56us
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:

Re: PureBasic 5.71 beta 1 is out !

Posted: Tue Apr 16, 2019 8:02 am
by RSBasic
Thank you very much :)

Re: PureBasic 5.71 beta 1 is out !

Posted: Tue Apr 16, 2019 8:19 am
by Fred
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

Re: PureBasic 5.71 beta 1 is out !

Posted: Tue Apr 16, 2019 8:20 am
by Fred
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

Re: PureBasic 5.71 LTS beta 1 is out !

Posted: Tue Apr 16, 2019 8:20 am
by Joris
Thanks Fred.

Re: PureBasic 5.71 LTS beta 1 is out !

Posted: Tue Apr 16, 2019 1:00 pm
by RSBasic
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.

Re: PureBasic 5.71 LTS beta 1 is out !

Posted: Tue Apr 16, 2019 1:15 pm
by Dude
Thanks Fred, and thanks RSBasic for the bug-fix list! 8)

Re: PureBasic 5.71 LTS beta 1 is out !

Posted: Tue Apr 16, 2019 1:57 pm
by Fred
Now that's cool RSBasic ! If you can share this, I will run it when writing the announcement :)

Re: PureBasic 5.71 LTS beta 1 is out !

Posted: Tue Apr 16, 2019 3:50 pm
by pwd
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.

Re: PureBasic 5.71 LTS beta 1 is out !

Posted: Tue Apr 16, 2019 3:57 pm
by Fred
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

Re: PureBasic 5.71 LTS beta 1 is out !

Posted: Tue Apr 16, 2019 4:37 pm
by skywalk
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?