On 2018-04-08 19:39:43 -0400, Stephen Frost wrote: > * Alvaro Aguayo Garcia-Rada (aagu...@opensysperu.com) wrote: > > 1. Portability. Being tied to a single database engine is not always > > a good idea. When you write business logic in database, you have to > > write and maintain your store procedures for every database engine > > you want to support. That can be really complicated, and will surely > > take pretty much time, as programming languages for different > > databases are very different from each other. And it's permanent: > > Every time you make a change to a store procedure, you must make > > that change for every supported database. > > The portability claim tends to be both a false one and often, when > realized, results in a solution where you aren't using the database for > anything complicated and you'd be better off with a much simpler data > store. You also don't actually offer any justification for the claim > that being tied to a single database engine is not always a good idea- > why is that? With commercial databases it tends to be because you are > at the behest of some very large commercial company- but that isn't an > issue with PostgreSQL.
Many companies don't like to support multiple database engines. There is the license issue, true, but having DBAs is even more important. If you are an Oracle shop you have your Oracle DBAs, and they know how to make backups (and how to restore them), how to monitor the database, how to track down performance issues, etc. If some application needs MS-SQL or PostgreSQL or MySQL, they won't have that expertise, so they will have to be trained, or you need additional DBAs (maybe on a part-time or support contract basis). So all other things being equal, companies will prefer applications which work with databases they already use. So if you are an application developer, it makes sense to develop your application to work with several databases. It vastly expands your potential clientele. At least that was the situation 10 years ago. These days much software is offered as a service. If the customer sees only a REST API and doesn't have to host the database on their own servers, they won't care about the RDBMS underneath. hp -- _ | Peter J. Holzer | we build much bigger, better disasters now |_|_) | | because we have much more sophisticated | | | h...@hjp.at | management tools. __/ | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>
Description: PGP signature