Sqlite Version - is it really from 2005??

LiveCode is the premier environment for creating multi-platform solutions for all major operating systems - Windows, Mac OS X, Linux, the Web, Server environments and Mobile platforms. Brand new to LiveCode? Welcome!

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
Lagi Pittas
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 365
Joined: Mon Jun 10, 2013 1:32 pm

Sqlite Version - is it really from 2005??

Post by Lagi Pittas » Thu Oct 25, 2018 1:04 pm

I needed to check what version of Sqlite was being used on livecode 9.1
I put this in a button.

Code: Select all

on MouseUp
   local lnVer, lcSql, lnDbId
   
   -- Open In Memory database
   put revOpenDatabase("sqlite",,,,,,,) into lnDbId
   
   put "select Sqlite_Version()" into lcSql
   put revDataFromQuery(comma,return,lnDbId,lcSql) into lnVer
  
 answer  "Version: " & lnVer

   revCloseDatabase lnDbId
end MouseUp
The answer I get is version is 3.15.0.
Sqlite is Upto version 3.9.2 as of now and there have been many critical bug fixes (and speed improvements) since 2005. Is this an error on the return string or are we that far behind?

Now the output says 3.15.0

The closest to that numbering system I can find is 2007-04-09 - Version 3.3.15 which is 2007 if we assume the .3 is a given.

The next closest is 2005-03-11 - Version 3.1.5 from 2005 - either way it's 10 years old and we had a crowdfunding in 2016 to bring it upto date.

Can anybody confirm this? And Panos I know you are reading this - what is the state of play.

Regards Lagi

LiveCode_Panos
Livecode Staff Member
Livecode Staff Member
Posts: 818
Joined: Fri Feb 06, 2015 4:03 pm

Re: Sqlite Version - is it really from 2005??

Post by LiveCode_Panos » Thu Oct 25, 2018 1:57 pm

Hello Lagi,
And Panos I know you are reading this
:) :) :)

The SQLite version we use in LC 9 is indeed v3.15.0. The latest version is currently 3.25.2, released at the end of September 2018: https://sqlite.org/index.html

For anyone interested, you can find which version of each thirdparty library we use by browsing our "thirdparty" GitHub repo:

https://github.com/livecode/livecode-th ... evelop-9.0

Regards,
Panos
--

Lagi Pittas
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 365
Joined: Mon Jun 10, 2013 1:32 pm

Re: Sqlite Version - is it really from 2005??

Post by Lagi Pittas » Thu Oct 25, 2018 2:17 pm

Thanks Panos,

Good to know we are only a couple of years out.

They must have changed their numbering system https://www.sqlite.org/oldnews.html and I thought the latest was 2015.

Oh and by state of play I was asking about the Sqlite Library that was funded in Mat 2016 - and would be ready 3 months after a successful funding. Sorry to put the Onus on you but you are closer to the big Cheese(s) (did I mention Cheese?? - sorry Heather) - but there is still stuff outstanding from the Kickstarter and we are getting shiny new toys.

Open language was the main reason I donated to the Kickstarter and came on board the good ship Runrev.

Edit.
------

Now I'm really confused - on Github for the file sqlite3.c
[[ libsqlite ]] Update libsqlite to version 3.15.0
and in the code itself we have we have

Code: Select all

#define SQLITE_VERSION        "3.15.0"
:? :?

Kindest Regards Lagi

Post Reply

Return to “Getting Started with LiveCode - Experienced Developers”