[UPDATED] SQLite 3.6.7 (toolchain build)

[edgecrush3r]

*UPDATE*
I've rebuilded version SQLite 3.6.7 last nite, and uploaded it for those who are interested.

http://files.codeware-consultancy.com/in...me&srt=yes

You find the pre-compiled lean-and-mean binairies.

*Installation*

untar/unzip the file contents of the package and copy the folder contents to your nmt.

on the nmt box (using telnet)
go to the directory where you copied the files.
mkdir /usr/local/bin (if not already created)
cp usr/bin/sqlite3 /usr/local/bin/
cp lib/* /usr/local/lib

then just add the /usr/local/bin to your path directory:
PATH=$PATH:/usr/local/bin [enter]

just to be on the safe side, i always run ldconfig after installing fresh libraries:
ldconfig [enter]

*testing*
You can test out sqlite by running the following commands.
type the following using telnet:
sqlite3 testdb [enter]
>>SQLite: create table test (id int(3));
>>SQLite: .tables
>>SQLite: .exit

Thats it... you created a database called testdb, containing a table named test.

Happy new YEAR everyone

[garp99]

Very nice job.... I'm sure it will become handy for some people here.

It's still rumoured that Syabas will also include an SQLite to handle some future features... time will tell!

[werner]

yes we will i hope to see it soon anyway nice work

[stuart]

I'm unfamiliar w/SQL data bases. "Lite" implies this application does not implement all the features of MySQL. I am also unfamiliar with how I want to use the SQL data base. Let me explain: I want to port SqueezeCenter to the NMT. In order to port SqueezeCenter I believe I need both PERL and MySQL. I am not interested in making a custom version of SqueezeCenter. Using the stock version of SqueezeCenter is the objective. By what means -or- who could I talk to in order to determine if SQLite will work w/SqueezeCenter w/o modifications.

...thanks

[Niels Leenheer]

You can't simply take the MySQL based version of SqueezeCenter and use it with SQLlite without modifications.

MySQL and SQLlite are two different SQL engines with different use cases. They are not compatible with each other and while it is possible to port an application build for MySQL to SQLlite, it can be quite a bit of work.

[stuart]

(12-18-2008 04:37 PM)Niels Leenheer Wrote:  You can't simply take the MySQL based version of SqueezeCenter and use it with SQLlite without modifications.

MySQL and SQLlite are two different SQL engines with different use cases. They are not compatible with each other and while it is possible to port an application build for MySQL to SQLlite, it can be quite a bit of work.

Thanks, I was afraid of that. Porting is not out of the question, but (w.r.t. SqueezeCenter) now that SlimDevices is own by Logitech the matter of supporting a ported product (even an open source project) supported by a commercial entity appears to be "grey". (i.e. Before downloading SqueezeCenter there is an agreement you have to "agree to". Yes, I know there are legitimate ways around it, but still.)

It look like I have 2 porting mountains to climb here. One of which is: What are the chances / difficulties associated w/porting MySQL to the NMT?

[edgecrush3r]

(12-18-2008 03:31 PM)stuart Wrote:  I'm unfamiliar w/SQL data bases. "Lite" implies this application does not implement all the features of MySQL.

SQLite isnt MySQL, but an DB implementation much more suitable for lighter machines such as embedded devices. The main reason why i've uploaded this, is because quiete some packages (UPNP servers) depend on it.

I think recompiling MySQL should be quiete easy... but with cross compiling you'll never know until it runs Anyway.. I will post it, if i get to it.

[hooijschuur]

(12-16-2008 09:06 AM)edgecrush3r Wrote:  For those interested i compiled the latest SQLite last night from the repository, using the mipsel-linux-uclibc toolchain

You find the pre-compiled lean-and-mean binairies, so
you just extract and enjoy.

http://files.codeware-consultancy.com/in...me&srt=yes

I am new on installing a database engine on a nmt

could you tell how i can test if it is working and if there are settings i have to change

Thanks in Advance

[edgecrush3r]

I just added a complete short installation/test guides.

Hope this helps

Cheers,
Tony