Hacker News Reader

Comment by bnchrch | Hacker News Reader

Im slowly sliding into the opinion that Postgres should go down as the most impactful technology of the 2000s.

Whatever they've done internally to encourage and enable the high quality plugins deserves some seriously high praise.

Dude, seriously. I have been a developer since 2014 but I always stayed away from Postgres because it did not seem cool to me. Recently I started a company which provides Postgres deployments(ironically, just to seem cool) and that's when I unearthed a ton of incredibly powerful features in Postgres. I even wrote a small script that auto inserts user_id from users table into messages table whenever a new message is inserted into the db using Postgres triggers. I mean how cool is that.

Check it out here: https://gist.github.com/kaushik94/5257f0ff5520598e6327d14805...

Everyday I am finding more and more amazing stuff about Postgres and I'm literally obsessed.

If you want to know more about my work, connect with me here: https://twitter.com/RGraphql

You’ve been a developer since and 2014 and hear about database triggers just now? I guess you stayed away not just from Postgres but relational databases in general.

That's true. Been into frontend mostly.

I started webdev (or webapp dev or what ever it was called) quite "late" into my career about 13 years ago. At the time ruby+MySQL were the biggest rage. For some reason I was reading that while MySQL was blazing fast, postgres was standards compliant and focusing on being "correct" and thought ful about it's evolution. I even (may be naively) reasoned that, this deliberate focus + lending itself to better control plane development (I didn't know about control planes at that time but coming from embedded systems had a gut feel about it) were going to be powerful features. Again pure gut feel as I had no web or service dev experience (came from a c++ background).

I am so glad I picked postgres as my db for life when it was not such a cool thing. It has been vindicated time and time again!

Step 1: be free

Lol but true. I was so stuck with mongoDB that I avoided Postgres for far too long and I regret it. It's only now I realise how awesome it is.

Reply on news.ycombinator.com