logoalt Hacker News

SoKamilyesterday at 10:27 PM2 repliesview on HN

This post is discussing more specialized databases, but why would people choose Oracle/Microsoft DB instead of Postgres? Your own experience is welcome.


Replies

bob1029yesterday at 10:42 PM

I'd pick MSSQL if I was being compensated based upon the accuracy, performance, durability and availability of the system. Also in any cases where the customer can pay and won't complain even once about how much this costs.

I'd never advocate for a new oracle install. But, I'd likely defend an existing one. I've seen how effective pl/sql can be in complex environments. Rewriting all that sql just because "oracle man bad" (or whatever) is a huge fucking ask of any rational business owner.

technionyesterday at 11:21 PM

Easy answer here - nearly every LOB app we have uses MSSQL.

I've had engineers want to talk about syncing it to MySQL using some custom plumbing so that they can build a reporting infra around their MySQL stack, but it's just another layer of complexity over having code just use Microsoft's reporting services.

I'll add, having finance people with Excel really like being able to pull data directly from MSSQL, they do not like hearing about a technican's python app.