Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

PostgreSQL is the worlds’ best database

2ndquadrant.com

Post reply on HN
Print view View original

41–50 of 365 posts

Re: PostgreSQL is the worlds’ best database

#41

Post by mulmen »

forinti wrote: post #33

I manage Oracle and Postgresql instances and I agree with this, except for one small thing: Postgresql doesn't have packages. Otherwise, it is much simpler to manage than Oracle (which really is a system turned inside out). The documentation is really good and straight to the point (Oracle can't help but turn everything into an ad - nvl uses the best null handling technology on the market and such).

I spent many years on Oracle. I do not miss smug Tom Kyte blog posts about the pointlessness of BOOLEANs. Nor do I miss endless hours Googling around Burleson Consulting pages because we couldn’t afford support.

I do kinda miss how easy it was to do partitioning but I’m on Redshift now so it doesn’t matter.

Re: PostgreSQL is the worlds’ best database

#43

Post by ilogik »

redis_mlc wrote: post #36

Ironically, the blog post shoots itself in the foot by starting with Postgres security. Postgres has very poor security compared to MySQL, and in fact, I tell companies implementing compliance policies to shift to MySQL. https://www.cvedetails.com/metasploit-modules/vendor-336/Pos... The reasons are: - Postgres' grant model is overly complex. I haven't seen anybody maintain the grants correctly in production for non-…

does running Postgres on AWS RDS mitigate some of these problems?

Re: PostgreSQL is the worlds’ best database

#44

Post by mulmen »

redis_mlc wrote: post #22
m0skit0 wrote: post #11

Earlier quoted context omitted.

Yahoo uses PostgreSQL. I think that's pretty high-end requirements an debunks the myth of "commercial software is better for high end requirements".

First of all, Yahoo historically used Oracle Enterprise and MySQL for RDBMS, roughly 50% each. Large companies use some of everything, but I never saw PG in use there.

https://www.computerworld.com/article/2535825/size-matters--...

Yahoo’s use of Postgres was legendary.

Re: PostgreSQL is the worlds’ best database

#45

Post by [deleted] »

Jonnax wrote: post #2

This is advertising of course. But if I had to select an SQL DB postgres is my only choice. Perhaps I don't know enough about databases and their differences. Anyone have some pros and cons of others? Like why would I pick MySQL, Microsoft, Oracle, Maria etc over Postgres? Apart from support that you gotta pay for.

[deleted]

Re: PostgreSQL is the worlds’ best database

#46

Post by DeathArrow »

redis_mlc wrote: post #36

Ironically, the blog post shoots itself in the foot by starting with Postgres security. Postgres has very poor security compared to MySQL, and in fact, I tell companies implementing compliance policies to shift to MySQL. https://www.cvedetails.com/metasploit-modules/vendor-336/Pos... The reasons are: - Postgres' grant model is overly complex. I haven't seen anybody maintain the grants correctly in production for non-…

Wouldn't a competent DBA take care of those issues? It is a honest question since I don't know much about database administration.

Re: PostgreSQL is the worlds’ best database

#47

Post by sgt »

irjustin wrote: post #17

While I disagree that it's the world's best, it is my default for all projects and general RMDBS. I used to be MySQL but it felt like over time it was becoming hack on top of hack for each subsequent version while PG lacked a number of features in the early 2010's it has clearly caught up with great care to its codebase. There are scenarios that PG does not win and should not be used, but if we're talking about the m…

Out of curiosity, what RDBM do you feel is the best?

Re: PostgreSQL is the worlds’ best database

#48

Post by DeathArrow »

ilogik wrote: post #43
redis_mlc wrote: post #36

Ironically, the blog post shoots itself in the foot by starting with Postgres security. Postgres has very poor security compared to MySQL, and in fact, I tell companies implementing compliance policies to shift to MySQL. https://www.cvedetails.com/metasploit-modules/vendor-336/Pos... The reasons are: - Postgres' grant model is overly complex. I haven't seen anybody maintain the grants correctly in production for non-…

does running Postgres on AWS RDS mitigate some of these problems?

I don't know about AWS but our Postgres instances are accessible only through internal network connections. I think we are safe.

Re: PostgreSQL is the worlds’ best database

#49

Post by BozeWolf »

jwr wrote: post #25

PostgreSQL is great if you: a) are OK with using SQL (this is not obvious) b) do not need a distributed database I've spent a lot of time on looking at database solutions recently, reading through Jepsen reports and thinking about software architectures. The problem with PostgreSQL is that it is essentially a single-point-of-failure solution (yes, I do know about various replication scenarios and solutions, in fact I…

So what do you suggest then?

Do you really care that much about the language? Shouldn't you care more about your data? If you are not OK with SQL there are abstractions available.

Re: PostgreSQL is the worlds’ best database

#50

Post by danmaz74 »

redis_mlc wrote: post #36

Ironically, the blog post shoots itself in the foot by starting with Postgres security. Postgres has very poor security compared to MySQL, and in fact, I tell companies implementing compliance policies to shift to MySQL. https://www.cvedetails.com/metasploit-modules/vendor-336/Pos... The reasons are: - Postgres' grant model is overly complex. I haven't seen anybody maintain the grants correctly in production for non-…

Using inflammatory language like "The simple fact is, if you use Postgres, you almost certainly have a security compliance problem" or "If you're thinking, "How is it possible that everybody else is wrong about Postgres being the best?", just remember the decade of Mongo fanboism on HN. I cringed during that era, too" really doesn't help getting the message through.
Post reply on HN