I've used Oracle, PostgreSQL and SQL Server. I push as much as possible into stored procedures on all of these platforms. It saves a lot of data moving back and forth between the program and the database. Oracle and PostgreSQL have very powerful procedural languages that can be used to write stored procedures (PostgreSQL stored procedures can even be written in perl). SQL Server seems a little weaker in this regard but seems to be getting better in newer versions.
|90% of every Perl application is already written. ⇒|