News : The level of daily SPAM has reached insane proportions, all registrations are now manual. I ask you to send me an e-mail (john (at) murga (dot) org), to confirm that you want me to create an account for you.


Post Reply  Post Thread 
New SQLite version in 0.7?
Author Message
jpjacobs
Member
***


Posts: 113
Group: Registered
Joined: Jul 2007
Status: Offline
Reputation: 0
Post: #1
New SQLite version in 0.7?

Hi,
I was wondering, will there be a new version of sqlite in the upcoming 0.7 release?
Their site says:

Quote:
Version 3.6.23.1 of SQLite is recommended for all new development. Upgrading from version 3.6.12, 3.6.13, 3.6.22, and 3.6.23 is optional. Upgrading from all other SQLite versions is recommended.


And judging by http://sqlite.org/changes.html it seems there have been a lot of changes since the 2005 December 19 3.2.8 release included in murgaLua 0.6.9.

Greetings,

Jan-Pieter

This post was last modified: 05-06-2010 01:42 AM by jpjacobs.

05-06-2010 01:38 AM
Find all posts by this user Quote this message in a reply
JohnMurga
Administrator
*******


Posts: 381
Group: Administrators
Joined: Apr 2007
Status: Offline
Reputation: 2
Post: #2
RE: New SQLite version in 0.7?

jpjacobs Wrote:
I was wondering, will there be a new version of sqlite in the upcoming 0.7 release?
Their site says:

Quote:
Version 3.6.23.1 of SQLite is recommended for all new development. Upgrading from version 3.6.12, 3.6.13, 3.6.22, and 3.6.23 is optional. Upgrading from all other SQLite versions is recommended.


And judging by http://sqlite.org/changes.html it seems there have been a lot of changes since the 2005 December 19 3.2.8 release included in murgaLua 0.6.9.

To be honest I don't see any compelling reasons to upgrade, compatibility wise it is still OK, and newer versions of sqLite have been getting bloatier (to the point I like it less and less).
If you read though the list you'll find that 3.2.8 was a nice and solid release, after that they like to tinker and tinker with the internals.

The other issue is that I'd have to port the DB encryption stuff (which I use myself) ...

I am willing to do this if there is enough demand, but currently don't see any good reasons to do so.

Cheers
John de Murga

05-11-2010 01:22 AM
Visit this user's website Find all posts by this user Quote this message in a reply
jpjacobs
Member
***


Posts: 113
Group: Registered
Joined: Jul 2007
Status: Offline
Reputation: 0
Post: #3
RE: New SQLite version in 0.7?

Ok, it was just something I noticed when searching why foreign keys wouldn't work in murgaLua, while they do in the sqlite standalone. Guess I can live without them.

Greets,
JP

05-11-2010 02:11 AM
Find all posts by this user Quote this message in a reply
JohnMurga
Administrator
*******


Posts: 381
Group: Administrators
Joined: Apr 2007
Status: Offline
Reputation: 2
Post: #4
RE: New SQLite version in 0.7?

I have a look at the later versions ...

Does the syntax pass in 3.2.8 but not work ?
Do you have an example, or is it any foreign key ?

Cheers
John de Murga

05-13-2010 12:52 AM
Visit this user's website Find all posts by this user Quote this message in a reply
jpjacobs
Member
***


Posts: 113
Group: Registered
Joined: Jul 2007
Status: Offline
Reputation: 0
Post: #5
RE: New SQLite version in 0.7?

Yeah, I was trying to use foreign keys. It does not give a syntax error, which is already fine, but it just does not work. Example SQL:

Code:
PRAGMA foreign_keys=ON;
CREATE TABLE artist(
  artistid    INTEGER PRIMARY KEY,
  artistname  TEXT
);
INSERT INTO "artist" VALUES(NULL,'Dean Martin');
INSERT INTO "artist" VALUES(NULL,'Frank Sinatra');

CREATE TABLE track(
  trackid     INTEGER,
  trackname   TEXT,
  trackartist INTEGER,
  FOREIGN KEY(trackartist) REFERENCES artist(artistid)
);
INSERT INTO "track" VALUES(NULL,'That''s Amore',1);
INSERT INTO "track" VALUES(NULL,'Christmas Blues',1);
INSERT INTO "track" VALUES(NULL,'My Way',2);
INSERT INTO "track" VALUES(NULL,'Mr. Bojangles',3);


This should not work, as there is no artist with artistID = 3.

greetz,
JP

This post was last modified: 05-14-2010 02:38 AM by jpjacobs.

05-14-2010 02:31 AM
Find all posts by this user Quote this message in a reply
JohnMurga
Administrator
*******


Posts: 381
Group: Administrators
Joined: Apr 2007
Status: Offline
Reputation: 2
Post: #6
RE: New SQLite version in 0.7?

Umm ...

Yeah, it is a problem.

Maybe I'll have to upgrade, however, there seems to be a better encryption lib than the one I am using.

http://www.zetetic.net/software/sqlcipher/

This would allow me to get up-to-date quite quickly.

Cheers
John de Murga

05-20-2010 08:01 PM
Visit this user's website Find all posts by this user Quote this message in a reply
JohnMurga
Administrator
*******


Posts: 381
Group: Administrators
Joined: Apr 2007
Status: Offline
Reputation: 2
Post: #7
RE: New SQLite version in 0.7?

Hi,

The new drop uses sqlcipher/sqlite3.6.23.1 ... A Git snapshot of sqcipher.

However, sqcipher has been updated to sqLite 3.7.2, and will be used in the next drop.

Either way, your issue should be fixed.

Cheers
John de Murga

10-13-2010 05:10 AM
Visit this user's website Find all posts by this user Quote this message in a reply
jpjacobs
Member
***


Posts: 113
Group: Registered
Joined: Jul 2007
Status: Offline
Reputation: 0
Post: #8
RE: New SQLite version in 0.7?

thanks again!

10-13-2010 06:23 PM
Find all posts by this user Quote this message in a reply
Post Reply  Post Thread 

View a Printable Version
Send this Thread to a Friend
Subscribe to this Thread | Add Thread to Favorites

Forum Jump: