Live data from Hacker News

What’s so exciting about Postgres?

changelog.com

131–137 of 137 posts

Re: What’s so exciting about Postgres?

#131

Earlier quoted context omitted.

You're the one that doesn't understand. It's what makes you so edgy. Keep doing it.

I understand perfectly the difference between a system and a format. You either don’t or you’re trolling (and dishing out ad hominems to boot.). Reddit would be more suitable to your posting style, we come here with a higher expectation of them being actual discourse and intellectual honesty.

What does the JS in JSON stand for?

Re: What’s so exciting about Postgres?

#132

PostgreSQL isn't exciting. It's boring, with roots in the Berkeley Ingress project from the mid 80s. Which is why 10 years ago, so many HNers went with trendy NoSQL data stores instead, even though they lost data. Data loss is very exciting, and PostgreSQL is very boring. This preference for what's exciting and trendy over what's old and proven is a large reason why so much software today sucks.

Boring until it’s not: https://about.gitlab.com/blog/2017/02/10/postmortem-of-datab...

Re: What’s so exciting about Postgres?

#133
post #12

I started using PostgreSQL because, at the time, MySQL wouldn't do subqueries. The fact it silently truncated VARCHAR data to the size of the column and didn't give out an error didn't help much. Overall, my impression is that the project's philosophy is to do the Correct Thing, even if it's slow.

Years back, the conventional wisdom seemed to be that MySQL used to be faster, and PostgreSQL more correct. Over time, according to that same conventional wisdom, MySQL got more correct than it used to be and PostgreSQL got faster than it used to be.

Re: What’s so exciting about Postgres?

#134

Earlier quoted context omitted.

can you elaborate?

> can you elaborate? On what exactly? The freeze map bit I referenced above is the following commit: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit... Commit a892234f830e832110f63fc0a2afce2fb21d1584 gave us enough infrastructure to avoid vacuuming pages where every tuple on the page is already frozen. So, replace the notion of a scan_all or whole-table vacuum with the less onerous notion of an "aggressi…

awesome, that's an above and beyond answer! i really appreciate the detail!

Re: What’s so exciting about Postgres?

#135
post #11

Databases shouldn't be exciting. They should just work . The main reason webcrap works is because the databases underneath work. If the Javascript crowd had to manage data storage, nothing persistent would work reliably.

> Databases shouldn't be exciting. They should just work . With enough experience with the alternative, things that just work are exciting.

And it's wonderful to work with someone whose stuff just works

Re: What’s so exciting about Postgres?

#136

Earlier quoted context omitted.

Good luck running serverless code in a lightbulb.

https://azure.microsoft.com/en-us/services/iot-edge

Last time I looked at Azure IoT Hub for anything I was baffled by the way their system used MQTT but didn't provide general-purpose MQTT access. Frankly they're not a great example of a company understanding how these devices are supposed to work.

Re: What’s so exciting about Postgres?

#137

Earlier quoted context omitted.

Typical frontend developer spew. Works with JavaScript or Emscripten, hasn't dealt with data integrity, scale, or security challenges. Threatened by people who build things from scratch. Stuck writing handlers, never to see the whole architecture. Soon to be replaced by GPT-3. Thank you, this has been entertaining.

This is one of the funniest rebuttals on HN.

I was thinking about the exchange, and it dawned on me that GPT-3 has really demonstrated frontend generation capability. I'd absolutely love to see it build my app's data layer from description (don't call it an ORM!) but I don't even know where to start looking for that.
Post reply on HN