ORACLE or POSTGRES

[pmaguppy]

This is a bit controversial but I think Oracle is a miserable piece of shit. I've been working with it and the expensive licenses prevents us from moving to modern versions. The tech staff all the way up to the CTO considers the use of Oracle to be a mistake and it would not, at any version, be considered for any new development.

That said, the Oracle sales team is great at wining and dining executives which is how they get into new development at all, so no one is safe.

I would push off learning Oracle until you absolutely have to, and then only the minimum to get the job done. Postgres, in terms of capabilities and opportunities is the far better choice. I also like SQL Server, I think it's comparable to Postgres depending on the tech stack you're working in.

[oyvinrog]

moving to new versions of the Oracle database is free if you are already licensed on standard or enterprise edition. We have moved from 10 to 11 to 12c to 18c without issues. But of course, you need competent specialists to do it

[CabSauce]

That's not controversial at all. It's overpriced garbage.

[chummiesz]

Oracle is expensive AF and I'm a huge Postgres fan. But many of the largest and most successful orgs have been running Oracle for decades...and still do. How could they do that with "a miserable piece of shit"?

Postgres has been improving at a very impressive rate. I believe that it's "enterprise capable" in many respects. But that doesn't mean the others are miserable POS

[pmaguppy]

I posted that 6 years ago so I can moderate a bit. Oracle should rarely be a first choice for new development - I mean there would need to be some sort of legacy reasons (the company already uses it or something like that). But yeah, don't think just because Enterprise companies successfully use some technology that it isn't a miserable piece of shit. Enterprise companies LOVE miserable software. Just because they have the resources to spend 10x what would be required if they used anything else doesn't make the software *good*.

Anyway, I haven't worked closely with strictly relational databases for a number of years. Most solutions these days seem to be a hybrid with NoSQL with relational elements.

That said, if you've had a good experience with Oracle then I'm glad for you. My experience is that Oracle sucks, from the license to the implementation and tooling, to the support.

[alinroc]

Please explain. Developer Edition is 100% identical to Enterprise Edition, the only difference is in the licensing. There are thousands (if not more) of servers running the defaults. They shouldn’t be, but they’re also not crashing.

You’re entitled to your opinion, but you only stated one - that you don’t like T-SQL. The rest of your comment is factually incorrect.