SliTaz SliTaz Forum

You are not logged in.

#1 2012-12-19 12:50:57

emgi
Member
Registered: 2012-12-17
Posts: 127

SQLite

My work on slitaz involves scripting (both Perl & shell) and some database work.

I am quite experienced on MySQL.

Because Slitaz comes with SQLite I have been looking into that now and it seems to be an alternative worth investigating further. The only drawback I noticed is that the distro comes with a fairly ancient version, 3.7.9 whereas the SQLite website recommends to switch to the latest, 3.7.15.

As there is no package for that version yet, I took the shortcut of downloading the precompiled binary. I simply swapped the sqlite3 executable in /usr/bin for the downloaded version. This worked with no issues thus far so there seem to be no dependencies for this.

The analyzer package didn't work; failed on not finding libtcl8.6.so but sqlite3_anayzer  is not in the slitaz distro so that makes sense.

It would be nice though if an updated package could be made available for these two files. I would do it myself if I could but unfortunately this is not yet a skill which I posess.

/emgi

Offline

#2 2012-12-19 14:18:59

bellard
Administrator
Registered: 2011-03-28
Posts: 657

Re: SQLite

SliTaz 4.0 stable branch will stay with version 3.7.9

Version 3.7.15 is available in cooking branch.

http://cook.slitaz.org/cooker.cgi?pkg=sqlite

Offline

#3 2012-12-19 15:46:35

emgi
Member
Registered: 2012-12-17
Posts: 127

Re: SQLite

OK, I get your point and I hadn't even checked the "Cooking" packages.

Probably this version will be in Slitaz5.0?

Another question: Is it then useful to check frequently for upgrades?

Direct after installation from the Live CD I installed some 15 updated packages.

These are probably relating to urgent bugs found after release of 4.0?

The whole setup is rock-stable now and everything works, at least for what I can see of it. Unless I install something from the "Cooking" section the set of packages will probably be pretty static then?

/emgi

Offline

#4 2012-12-19 16:14:34

emgi
Member
Registered: 2012-12-17
Posts: 127

Re: SQLite

Seems that you have instantly built the package I requested?

Thanks, I really appreciate that.

There was a problem though when installing this.

From cli I did tazpkg -i sqlite-3.7.15.0.tazpkg

Installation was successfull but when starting the program, I got a message about inconsistent headers. Then I removed the previous version and installed sqlite-3.7.15.0.tazpkg but the result stays the same. The issue was fixed by re-installing v3.7.9 and then replace the file in /usr/bin with the downloaded one from sqlite.org. Did I make a mistake or is there a problem wit the package?

/emgi

Offline

#5 2012-12-19 16:29:53

Trixar_za
Administrator
Registered: 2011-03-29
Posts: 1,506

Re: SQLite

Mostly static except with critical or bug fix related issues. We may sneak in an update or two for more stand-alone packages, but rarely for system critical or compatibility breaking packages. And I also wouldn't call something 'ancient' if a commit to was made to the branch (3.7.9) a few days ago. Thing to remember is that developers always believe the next version is better - even if it isn't all that compatible. That's why websites like oldversion.com exists.

Offline

Registered users online in this topic: 0, guests: 1
[Bot] ClaudeBot

Board footer

Powered by FluxBB
Modified by Visman

[ Generated in 0.017 seconds, 7 queries executed - Memory usage: 1.53 MiB (Peak: 1.77 MiB) ]