Open source is hot these days, and Oracle knows it. The company is facing challenges from open source competitors by embracing open source technology in its own right - acquiring and developing key companies and products in this area - as well as fighting to show its merits over other open source choices. How does Oracle stack up against PostgreSQL? How do Oracle and Linux work together? What's next for Oracle on the open source front?
To view parent comment, click here.
To read all comments associated with this story, please click here.
Member since:2005-07-09
Hmm...might be off topic but I have never really worked a lot with PostgreSQL but mainly because for quick stuff MySQL is just unbeatable with its graphical tools and so on for quick creation of tables and so on. I wonder if PostgreSQL has that. Also does anyone know of any tools that will migrate my sample tables over to PostgreSQL with minimal hassle?
Member since:2005-07-06
I wonder if PostgreSQL has that. Also does anyone know of any tools that will migrate my sample tables over to PostgreSQL with minimal hassle?
There are free GUI admin/development tools for postgresql e.g. pgAdminIII, there are also many commersial closed source tools for postgresql development. Personally I like the web based phpPgAdmin tool best. It is far more advanced than the similarly named phpMyAdmin tool for MySQL.
For porting MySQL stuff to postgres there is compatibility library available that could be helpful when porting MySQL applications to Postgresql you find it at: http://pgfoundry.org/projects/mysqlcompat/
There are also plenty commersial tools that might help you migrate MySQL to Postgresql. Even though you should be able to migrate quite easily with the compatibility lib mentioned above as both MySQL and Postgresql can dump their contents into sql form.
Unfortunately MySQL dumps in a nonstandard insert statement format with multiple value fields for each insert line, but with a little tweaking with standard unix text editing tools that is quite easily fixed.
Member since:
2005-07-18
I'd say PostgreSQL and MySQL barely belong in the same sentence together. MySQL has never been a realistic competitor to Oracle, except in the limited case of simple, read-mainly databases.
It's not just about performance, and it never has been. It is about serious manageability of your data. It is about knowing for sure that the database does what you say--and that what you say is what you mean--with your data. MySQL has a terrible track record in that area (they are addressing it somewhat in versions 5+ with ANSI-standard switches, so we'll see where things go)
On the other hand, when it comes to logical data manageability, PostgreSQL correlates quite nicely to Oracle. The only areas where PostgreSQL might really be considered behind Oracle are in the "extended" implementation areas, such as stored procedures, clustering and sophistication of server management (on-disk layout, table partitioning, tablespaces, etc...). And really, PostgreSQL is making strides in each of these areas.