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.
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.
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!
I will just show you how big of a mess it is to setup pgAudit on production deployments. TLDR: You can get it soon with Rocketgraph.io.
But I am very obsessed with building loggers using Postgres. There are some sneak peaks of my work on Twitter you can find in the above comment. But it's a lot of work to just setup pgAudit on AWS RDS. Like literally takes days. Basically you have to enable pgAudit, for that you need to edit the DBParameterGroup. Then enable cloudwatchlogs and query from cloudwatch console what logs you want to see. It's a mess. But here is a sneak peek of what's cooking at rocketgraph: https://twitter.com/RGraphql/status/1689631592321544192
It's so beautiful that I'm gonna name it "the sexy release".
9 comments
[ 3.4 ms ] story [ 29.6 ms ] threadWhatever they've done internally to encourage and enable the high quality plugins deserves some seriously high praise.
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
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!
But I am very obsessed with building loggers using Postgres. There are some sneak peaks of my work on Twitter you can find in the above comment. But it's a lot of work to just setup pgAudit on AWS RDS. Like literally takes days. Basically you have to enable pgAudit, for that you need to edit the DBParameterGroup. Then enable cloudwatchlogs and query from cloudwatch console what logs you want to see. It's a mess. But here is a sneak peek of what's cooking at rocketgraph: https://twitter.com/RGraphql/status/1689631592321544192
It's so beautiful that I'm gonna name it "the sexy release".