The new and shiny oe1.orf.at is finally online!
As you might expect it's crafted using the finest ingredients of Modern Perl: Catalyst, DBIx::Class, Moose, HTML::FormHandler, KinoSearch. Relaunching the site was a nice project, even though there were some setbacks:
I was forced to switch from Postgres to MySQL (using - the horrors - MyISAM), so I couldn't use any real database features like transactions and referential integrity; the launch date was postponed a few times, so I couldn't help organising the QA Hackathon as much as I wanted (in fact I can also not attend all days, because I want to spend some time with my family before leaving for Berlin / Icleand).
Anyway, after fixing some last post-deployment glitches everything seems to work now. Yay!
What forced the switch from Postgres? Even worse, why MyISAM? I assume there's a compelling story in there somewhere
Re:Shiny!
Aristotle on 2010-04-09T08:27:06
It seems to me if one were to have good reason to pick MySQL, then it would necessarily be for MyISAM. That engine is at least compelling insofar as it is essentially a NoSQL database with an SQL frontend. For mostly-read workloads it’s an interesting option.
In contrast, InnoDB is just a crippled wannabe regular transactional RDBMS. There are far better choices if you need one of those. InnoDB only ever makes sense to use when you are stuck with MySQL as an a priori constraint.
Re:Shiny!
domm on 2010-04-09T11:34:41
Because they didn't want to support another database. They are using Oracle and MySQL, and that's it. I was lobbying for Postgres, but in the end the corporate policy won. I can see their point, but it was still painful...
