How to Efficiently Choose the Right Database for Your Applications

Re:How to Efficiently Choose the Right Database for Your App... by pjmlp on Sunday February 28, 2021 @03:01AM (#26291556)

Depends, on the projects I work on, it usually goes with either Oracle or SQL Server.

Occasionally PostgreSQL gets used, as kind of staging database for small teams on a department level, with a db link for the big boy database used at corporate level.

[ Parent | on HN ]

Re:How to Efficiently Choose the Right Database for Your App... by pg_bot on Sunday February 28, 2021 @04:06AM (#26291844)

I mean no disrespect, but I've never met another developer/organization that was happy using Oracle. I'm genuinely curious as to why someone would prefer it over PostgreSQL if they were familiar with both had the option to not use it.

[ Parent | on HN ]

Re:How to Efficiently Choose the Right Database for Your App... by pjmlp on Sunday February 28, 2021 @05:11AM (#26292195)

IDE development tooling straight out of Oracle without going to hunt for third parties, including proper debugging of stored procedures with everything that I expect from a modern language.

Ada flavoured PL/SQL.

The Java and .NET drivers, with support for advanced stuff like distributed clustered transactions and direct mappings of UDTs into source language types.

Support for nice stuff like OLAP cubes, bare metal databases and APEX provides a nice way to quickly build database frontends.

As mentioned I am familiar with PostgreSQL, and honestly other than a couple of SQL extensions that are easier to use, I don't see much value when I compare everything that is on the box, and usually at the project scale I work on (just yet another cog on the enterprise wheel), license costs aren't the biggest hurdle to care about, there are other pain points where money matters more.

[ Parent | on HN ]

Re:How to Efficiently Choose the Right Database for Your App... by mrweasel on Sunday February 28, 2021 @05:00AM (#26292135)

We use it and sell Oracle DB consulting services. Support from Oracle is pretty good. Postgresql also cannot compete with Oracle in HA setups.

Don’t get me wrong, we love Postgresql, and MariaDB, but Oracle is still a great database, with all the features and stability you could possibly want, just at a hefty price.

[ Parent | on HN ]

Re:How to Efficiently Choose the Right Database for Your App... by smarx007 on Sunday February 28, 2021 @05:43AM (#26292355)

I am pretty sure at least some of this is not 100% true. Otherwise "Russian Gmail" would not migrate 300TB from Oracle to Postresql https://news.ycombinator.com/item?id=12489055

[ Parent | on HN ]

Re:How to Efficiently Choose the Right Database for Your App... by mrweasel on Sunday February 28, 2021 @06:27AM (#26292587)

I think that’s an edge case, most businesses don’t have the scale where the investment in building a Postgresql setup like that is cheaper than just paying Oracle.

[ Parent | on HN ]

Re:How to Efficiently Choose the Right Database for Your App... by pjmlp on Sunday February 28, 2021 @07:25AM (#26292897)

I am quite certain that Oracle being an high profile US company, and possibility of export restrictions, also played a role.

[ Parent | on HN ]

Re:How to Efficiently Choose the Right Database for Your App... by emrah on Sunday February 28, 2021 @01:52PM (#26295952)

I don't know for sure but my guess is that Oracle gets sold to managers in large orgs where such decisions are not necessarily made by engineers.

[ Parent | on HN ]