On 10/20/2010 12:57 AM, Andy Baker wrote:
Hi All,
I'm looking into switching from sqlite to postgreSQL as our backend. I'm
assuming this shouldn't be an issue, but does anyone have any good/bad
experiences to share?
I recently did a similar migration, using Postgres 0.11.6. The core Trac
code went over fine, but our custom queries all needed to be ported
(there were a lot of SQLite-ism's, specifically as related to datetime
type functions). Further, many of our plugins needed to be updated, as
there were subtle variations in the SQL (quotes around arguments being
different, etc.).
In all, I like PostgreSQL less than SQLite. It reminds me of my brief
brush with Oracle - a lot of the meta-syntax is obscure, it's annoyingly
picky about stupid things such as how to quote strings, and it just
feels slightly wrong. That said, it does work, and we noticed a complete
evaporation of our issues relating to people fighting over the database.
SQLite and MySQL are much less annoying to work with... I mean, until
MySQL corrupts its tables because MyISAM is still the default on most
package installs (I'm looking at you, Ubuntu 10.04).
--
Matthew Caron
Build Engineer
Sixnet | www.sixnet.com
O +1 518 877 5173 Ext. 138
F +1 518 602 9209
[email protected]
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en.
