maemo.org - Talk - How do I use mySQL?

maemo.org - Talk (https://talk.maemo.org/index.php)

- Applications (https://talk.maemo.org/forumdisplay.php?f=41)

- - How do I use mySQL? (https://talk.maemo.org/showthread.php?t=18174)

Re: How do I use mySQL?

Quote:

Originally Posted by rickyb (Post 158414)

Incidentally Pamadio, I am a newbie to Linux and X-Term but could you show me how to extract the tarball in X-Term? I think I previously downloaded a decompression utility...I think it was bzip2 or something. Am I even close?

Hmmm, i did not realise there are no package made for this application.

you can type the following to get the content of the archive:

tar xvzf sqlite3sg-2.0.1.tar.gz

It seems this is not fully polished yet, so i'm not sure it will fit your need.
There is a README file that gives some information on how to use it, but as it is not packaged you will most probably have to install several dependencies manually (sqlite3 of course, but python2.5 and glade too).

sqlite3 is like mysql but is smaller and so more adapted for small devices.

Reading a bit about sql (mysql,postgresql or sqlite) is definitively a good starting point :-)

Good luck.

Re: How do I use mySQL?

Quote:

Originally Posted by rickyb (Post 158410)

I guess I am looking for a simple database without having to pay for an account.

You don't have to pay for an account.

Quote:

I have set up a few of my own databases in Windows XP MS Acess and I am a computer desktop technician by trade but I was just curious about mySQL to see if it may be right for me. I think it would work for me but I am still a little unclear of the details. Does mySQL cost to get an account?

No. MySql is a database engine that runs on your machine, like mssql or oracle.
As such, as a user you cant actually *do* anything with it like you can with access or those sort of programs. You need another application to use it (or a website etc). mysql is often used as the back of a shopping website.

I think from what you have said so far that it is really not the sort of program you are looking for.

However, if I am wrong, and you have it installed on your IT, the only way to access it unless you have some GUI is to access it in a terminal.
Here is something I found which might help.

Re: How do I use mySQL?

Quote:

Originally Posted by tabletrat (Post 158499)

You don't have to pay for an account.

No. MySql is a database engine that runs on your machine, like mssql or oracle.
As such, as a user you cant actually *do* anything with it like you can with access or those sort of programs. You need another application to use it (or a website etc). mysql is often used as the back of a shopping website.

I think from what you have said so far that it is really not the sort of program you are looking for.

However, if I am wrong, and you have it installed on your IT, the only way to access it unless you have some GUI is to access it in a terminal.
Here is something I found which might help.

Thank you and everyone that has helped me decide what app to go with. I now have a good idea how mysql works. I think I am better off going with a local database such as glom just because it was made very similar to MS Acess which is what I am used to. Now if I could only get it installed. lol:D