[Systems] DBMS on sunjammer

[Bernie Innocenti]

El Fri, 04-12-2009 a las 11:53 +0100, Sascha Silbe escribió:
> Out of curiousity, is there a reason we're running mysql instead of 
> postgresql? Is it better suited to some of the applications we are 
> running?

It's the same old story: almost none of the web applications we
use support PostgreSQL. Some of them do, but only with patches
or at least not officially. Trac the only popular application
I know of with  better support for PostgreSQL than MySQL.

Besides, I have a lot more hands-on experience on MySQL, but
I'd be willing to learn more about PostgreSQL it if there
were tangible advantages in switching.

What I really dislike is having to run both on the same
machine. At this time PostgreSQL is not even being backed up!


> In my (limited) experience, PostgreSQL is easier to administrate and 
> works much better for large data sets (e.g. OSM [1] data).
> 
> [1] http://www.openstreetmap.org/

We still have a ridiculously small dataset :-)

-- 
   // Bernie Innocenti - http://codewiz.org/
 \X/  Sugar Labs       - http://sugarlabs.org/