I have a qsuestion: Why is sqlite(sucks) standard in amarok in ubuntu instead of mysql(rocks)? And why is it so damn hard to configure mysql?

And what's the advantage of progresql?

What an odd question. If mysql is "so damn hard" how does it "rock"????

sqlite is a simple library for emulating sql interfaces for trivial data storage. It is not an sql server. Running an entire RDBMS like mysql for a package manager is just stupid. consuming vast resources for scant and lightweight queries makes no sense at all.

postgresql vs mysql - http://www.google.co.uk/search?q=mysql+postgresql

Sorry I didn't clarify. I use mysql as library for amarok on my ubuntu. Before that I had sqlite but it was very very slow. But configuring mysql was really dificult.

sqlite is just that, a light weight sql application.
Think Firefox also uses sqlite for some stuff.

mysql is a "full" rdbms, same as pgsql.

make a query on a large mysql db and then on a large pgsql db, and you'll see
the advantage of pgsql
mysql locks up the whole bloody DB and causes performance probs then,
whereas pgsql has less problems with that, mostly due to table indexes

well exactly. di dyou have to configure sqlite? no. simple. easy. works.

I thinks sqlite is actually quite neat and works well for providing the possibility to implement complex custom file formats during programming. It's not a server per se, but it wouldn't be a big deal to program some wrapper code to make it a server. It is simply targeted to a different audience. Not every tiny application wants a full SQL server installation.

MySQL is also quite neat, but it is obviously targeted to another audience. Large amounts of data simply have different requirements than small stand-alone applications. I'm not sure what you mean by MySQL being hard to configure. I haven't found it to be difficult so far. I rather guess that configuring it to work along with amarok is maybe tricky, but I don't think that Sun/MySQL see their main priority in Amarok support.

progresql is a DBMS called Progress (http://www.progress.com) and appears to be a set of commercial products. I think the product suite is not even pre-dominantly about SQL at all.

Sometimes it is mixed with PostgreSQL (www.postgresql.com), which is OpenSource and uses the BSD license. MySQL in contrast uses the GPL (actually it uses two licenses to choose from: GPL and it's own). Both are quite mature SQL servers, te API differs, but for the larger part people seem to make their choice based on license preference.

linux

As far as I'm concerned the advantage(s) of PostgreSQL are many :}

• BSD license
• no commercial interests directing the flow
• planned and implemented around ACID from the ground up
• has sane defaults (e.g. won't accept dates (dd/mm/yyy) like 31/02/2009
  or 00/00/0000, both of which are undefined in the SQL standard, and won't
  accept data too big for a column only writing out a warning to a log)
• ...

Cheers,
Tink