Re^3: Getting id of postgres record inserted via DBI

[marto]

For some people, 2006 tech is futuristic :P

[cavac]

I agree that i'm old, yes. I started with PostgreSQL 7 or something like that (after having to work with Oracle for many years).

[erix]

That's not too bad; I was made to work with Oracle 5.

[Tux]

I have been so lucky to port Oracle 4 from source to MCX Unix. It was not one of my most joyable experiences.

IMHO there is no perfect database, they all have advantages and disadvantages. Unify does not have VARCHAR (or something alike), SQLite has issues with more than single-user usage, MySQL has too many issues to mention with quotation use and non-ANSI standards as worst, Oracle is expensive and a PITA to maintain, PostgreSQL requires old versions installed when restoring backups on different servers, CSV has no type system, NoSQL databases have no SQL, MS-Server allows rediculous table and column names, Firebird has a weird API that often doesn't allow actions in /some/ cases, Sybase has lack of local tools, ODBC requires unavailable drivers, etc etc etc. And for all of that: YMMV. A good system administrator that works together with a good database administrator is a luxury that would probably prevent most of those drawbacks.

My personal choice is PostgreSQL: hands down the easiest to work with and the most predictable and compliant behavior. Additional PostgreSQL has fantastic community support.