I have used and been a DBA for a large database application. We first used Sybase ASE on Linux for our platform. The application worked great, but the DB was a bit difficult to administer (mostly because of the dump format/devices and the lame isql client. Sybase ASE was good. The support people did not know Linux and suggested we move to Windows NT/2000. UGH.
We ported the application and greatly expanded it using PostgreSQL and found that PostgreSQL was easy to code in and easy to maintain. About the only thing we missed was nested transactions (Available in the 8.0 beta. PostgreSQL has performed extremely well in our large database application (86 tables, 90 stored procedures, 22 million records on average) The ASCII dump format is great and porting between platforms is a breeze. I have used Oracle, currently use MySQL but PostgreSQL is my fave.
Slashdot Mirror
I have used and been a DBA for a large database application. We first used Sybase ASE on Linux for our platform. The application worked great, but the DB was a bit difficult to administer (mostly because of the dump format/devices and the lame isql client. Sybase ASE was good. The support people did not know Linux and suggested we move to Windows NT/2000. UGH. We ported the application and greatly expanded it using PostgreSQL and found that PostgreSQL was easy to code in and easy to maintain. About the only thing we missed was nested transactions (Available in the 8.0 beta. PostgreSQL has performed extremely well in our large database application (86 tables, 90 stored procedures, 22 million records on average) The ASCII dump format is great and porting between platforms is a breeze. I have used Oracle, currently use MySQL but PostgreSQL is my fave.