PureBasic 5.71 LTS is out !

Developed or developing a new product in PureBasic? Tell the world about it.
Fred
Administrator
Administrator
Posts: 16619
Joined: Fri May 17, 2002 4:39 pm
Location: France
Contact:

PureBasic 5.71 LTS is out !

Post 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
User avatar
skywalk
Addict
Addict
Posts: 3972
Joined: Wed Dec 23, 2009 10:14 pm
Location: Boston, MA

Re: PureBasic 5.71 beta 1 is out !

Post by skywalk »

Wow! That sounds tremendous. 8)
The nice thing about standards is there are so many to choose from. ~ Andrew Tanenbaum
User avatar
DeanH
Enthusiast
Enthusiast
Posts: 223
Joined: Wed May 07, 2008 4:57 am
Location: Adelaide, South Australia
Contact:

Re: PureBasic 5.71 beta 1 is out !

Post 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?
User avatar
useful
Enthusiast
Enthusiast
Posts: 367
Joined: Fri Jul 19, 2013 7:36 am

Re: PureBasic 5.71 beta 1 is out !

Post 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.
Dawn will come inevitably.
Marc56us
Addict
Addict
Posts: 1477
Joined: Sat Feb 08, 2014 3:26 pm

Re: PureBasic 5.71 beta 1 is out !

Post 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:
Last edited by Marc56us on Tue Apr 16, 2019 8:29 am, edited 1 time in total.
User avatar
RSBasic
Moderator
Moderator
Posts: 1218
Joined: Thu Dec 31, 2009 11:05 pm
Location: Gernsbach (Germany)
Contact:

Re: PureBasic 5.71 beta 1 is out !

Post by RSBasic »

Thank you very much :)
Image
Image
Fred
Administrator
Administrator
Posts: 16619
Joined: Fri May 17, 2002 4:39 pm
Location: France
Contact:

Re: PureBasic 5.71 beta 1 is out !

Post 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
Fred
Administrator
Administrator
Posts: 16619
Joined: Fri May 17, 2002 4:39 pm
Location: France
Contact:

Re: PureBasic 5.71 beta 1 is out !

Post 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
Joris
Addict
Addict
Posts: 885
Joined: Fri Oct 16, 2009 10:12 am
Location: BE

Re: PureBasic 5.71 LTS beta 1 is out !

Post by Joris »

Thanks Fred.
Yeah I know, but keep in mind ... Leonardo da Vinci was also an autodidact.
User avatar
RSBasic
Moderator
Moderator
Posts: 1218
Joined: Thu Dec 31, 2009 11:05 pm
Location: Gernsbach (Germany)
Contact:

Re: PureBasic 5.71 LTS beta 1 is out !

Post 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.
Image
Image
Dude
Addict
Addict
Posts: 1907
Joined: Mon Feb 16, 2015 2:49 pm

Re: PureBasic 5.71 LTS beta 1 is out !

Post by Dude »

Thanks Fred, and thanks RSBasic for the bug-fix list! 8)
Fred
Administrator
Administrator
Posts: 16619
Joined: Fri May 17, 2002 4:39 pm
Location: France
Contact:

Re: PureBasic 5.71 LTS beta 1 is out !

Post by Fred »

Now that's cool RSBasic ! If you can share this, I will run it when writing the announcement :)
pwd
User
User
Posts: 60
Joined: Thu Sep 06, 2012 9:39 am

Re: PureBasic 5.71 LTS beta 1 is out !

Post 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.
Fred
Administrator
Administrator
Posts: 16619
Joined: Fri May 17, 2002 4:39 pm
Location: France
Contact:

Re: PureBasic 5.71 LTS beta 1 is out !

Post 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
User avatar
skywalk
Addict
Addict
Posts: 3972
Joined: Wed Dec 23, 2009 10:14 pm
Location: Boston, MA

Re: PureBasic 5.71 LTS beta 1 is out !

Post 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?
The nice thing about standards is there are so many to choose from. ~ Andrew Tanenbaum
Post Reply