Are Open-Source Databases Ready for Production Applications?
Open source in the enterprise is growing steadily, but for what applications? eWEEK IT expert Kevin Closson, chief software architect for PolyServe-HP, answers the question.Q: Are open-source databases like PostgreSQL, Ingres and MySQL becoming serious alternatives to Oracle for enterprise applications?
A: Yes, more and more, depending on the application. Oracle became the leading database in the 1990s because it ran better on high-end SMP Unix servers. But in those days most applications were still just dumb terminals talking to the big Unix box. So the database software had to be very sophisticated to perform well.
But in modern multi-tier applications you have a lot of intelligence in the application server tier and even in the browser on the users desktop. If the database server goes down, all is not lost, because you have persistence in the front-end and the middle tier. After a certain delay you will be able to reconnect and finish your transaction.