PDA

View Full Version : Connecting to sqlite or mysql



brettnak
May 31st, 2008, 08:34 PM
Is there a mysql or sqlite service running on ubuntu by default?

Majorix
May 31st, 2008, 08:42 PM
As far as I know, there is no database software installed on Ubuntu. However doing a search in your Synaptic would reveal the packages you can install.

LaRoza
May 31st, 2008, 09:06 PM
Is there a mysql or sqlite service running on ubuntu by default?

sqlite isn't a service, it is a C library.

MySQL isn't installed on the desktop version by default.

SQLite is used by many apps, including Firefox.

pmasiar
May 31st, 2008, 09:10 PM
sqlite isn't a service, it is a C library.

It means SQLite does not have server running, administration (and does not allow multiple users). This is why SQLite is excellent choice for embedded databases, and for SQL development: database is just a file with special structure, you can copy it, make backup, run another SQL query against it, etc.

LaRoza
May 31st, 2008, 09:22 PM
It means SQLite does not have server running, administration (and does not allow multiple users). This is why SQLite is excellent choice for embedded databases, and for SQL development: database is just a file with special structure, you can copy it, make backup, run another SQL query against it, etc.

Yes, it is a very handy library especially the way it is so easy to use.