Page 1 of 1
4.60 and SQLite
Posted: Sat Jun 11, 2011 2:09 am
by USCode
SQLite is up to 3.7.6.3, can someone who has the 4.60 Beta 3 installed tell us what version SQLite the beta is using?
This code will return the SQLite version:
Code: Select all
ImportC "sqlite3.lib"
sqlite3_libversion()
sqlite3_version.s{20}
EndImport
Debug PeekS(sqlite3_libversion(), #PB_Any, #PB_Ascii)
Debug sqlite3_version
Re: 4.60 and SQLite
Posted: Sat Jun 11, 2011 2:20 am
by netmaestro
Your code reports 3.6.23.1 with 4.60 b3. It's around 1yr old, is there a specific change in the meantime that you're interested in? To me, 1yr old is just like gold unless major bugfixes have come since. Otherwise, you're using much newer code that's far less tested.
Re: 4.60 and SQLite
Posted: Sat Jun 11, 2011 4:34 am
by USCode
If you check out that change history page I linked to, you'll see there's been some new commands added, new bug fixes and performance enhancements.
Re: 4.60 and SQLite
Posted: Sat Jun 11, 2011 4:54 am
by netmaestro
If you check out that change history page I linked to, you'll see there's been some new commands added, new bug fixes and performance enhancements.
Of course, that's always the case. But unless there's a specific weakness in the existing version that the later one claims to fix, and you need that fix, it's better to stick with something you know is solid. In the world of code, brand-new is not something to yearn for. Let the team decide if the latest sqlite is worth the upgrade or not, you can trust them. I do, and I've yet to be disappointed.
Re: 4.60 and SQLite
Posted: Sat Jun 11, 2011 5:29 am
by skywalk
http://sqlite.org/changes.html wrote:2010 August 04 (3.7.0.1)
Fix a potential database corruption bug that can occur if version 3.7.0 and version 3.6.23.1 alternately write to the same database file. Ticket [51ae9cad317a1]
This is 1 gotcha to worry about, if sharing SQLite DB's between PB static and external later versions.
Re: 4.60 and SQLite
Posted: Sat Jun 11, 2011 6:13 am
by USCode
skywalk wrote:http://sqlite.org/changes.html wrote:2010 August 04 (3.7.0.1)
Fix a potential database corruption bug that can occur if version 3.7.0 and version 3.6.23.1 alternately write to the same database file. Ticket [51ae9cad317a1]
This is 1 gotcha to worry about, if sharing SQLite DB's between PB static and external later versions.
Yes! Thank you for reminding me, I pointed that out as well in another post for the last version of PB:
http://www.purebasic.fr/english/viewtop ... lit=SQLite
In that thread, Fred promised to update SQLite in the next version ... 4.60 IS the next version!
Fred wrote:4.51 is in final state so it will be for the next version.
Re: 4.60 and SQLite
Posted: Fri Aug 12, 2011 5:33 pm
by skywalk
Hi,
Given 4.6 is imminent, can the SQLite dB format > 3.7 be included to eliminate the possible data corruptions mentioned above and on their website?
Re: 4.60 and SQLite
Posted: Sat Aug 13, 2011 7:05 pm
by Zach
This is important for me too. My WIP engine will heavily rely on SQLite DB's for storage.
I don't want to end up locked into one PB version because of this issue.
Re: 4.60 and SQLite
Posted: Sun Sep 11, 2011 10:36 pm
by USCode
Since we won't be getting the latest version of SQLite in 4.60, is it possible to get it into 4.61? Or will we have to wait for 4.70?
Re: 4.60 and SQLite
Posted: Sat Nov 12, 2011 10:03 pm
by Zach
Can we please have an update on what the current plans for an SQLite update are?
Fred, I know you said that you have to modify some code to integrate with PB, so we understand that has to be done slow and careful.
But it would be nice if you could roadmap it for us, and if not let us know how long, but which version of PB (4.6x?, 4.7? 4.8??) an update will be planned for.
The whole idea of even a marginal risk of data corruption is unsettling. Especially if someone were to forget or have no idea it is an issue, and end up in a situation where they are doing R/W operations across different SQL versions.