Hacker News Reader

kvaranasi_on Show HN: I built this Postgres logger

Of course I could be wrong. Please share with me your thoughts.

kvaranasi_on Show HN: I built this Postgres logger

I am assuming that the developer has necessary permissions. If he/she accidentally deletes the table, then that's a problem.

kvaranasi_on Show HN: I built this Postgres logger

Interesting idea to use Triggers.

kvaranasi_on Show HN: I built this Postgres logger

1 week free trail. And for HN users I can give more time for the free trail. It'll be $50/mo. But it is worth a lot more.

But hey, you can sign up and create a project without your credit card. Once free trail ends, you can pay with stripe. Let me know how you like it.

kvaranasi_on Show HN: I built this Postgres logger

Hahahah. I literally Googled who Triboulet was.

kvaranasi_on Show HN: I built this Postgres logger

Yes, I have been reading the conversation. That was so much to learn. I did not know that `SELECT ... FOR UPDATE` is "sort of" a write. I googled and found out this SO link: https://stackoverflow.com/questions/18879584/postgres-select...

that corroborates what you have said.

kvaranasi_on Show HN: I built this Postgres logger

Ok, looking into it.

kvaranasi_on Show HN: I built this Postgres logger

This is a nice idea to check if any dependencies are there on the table.

kvaranasi_on Show HN: I built this Postgres logger

Hey wait, you have a point though. We can put our custom locks onto tables that doesn't let anyone delete a particular table. Let me think over it. Saving this comment for later. Thanks for the idea man.

kvaranasi_on Show HN: I built this Postgres logger

Haha, we need Neuralink chips then.

kvaranasi_on Show HN: I built this Postgres logger

Interesting. I did not know that. I have to dig into the source code then. Do you know any alternate logging tools that don't have this issue?

kvaranasi_on PgAudit: Open-Source PostgreSQL Audit Logging

That's true. Been into frontend mostly.

kvaranasi_on PgAudit: Open-Source PostgreSQL Audit Logging

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.

kvaranasi_on PgAudit: Open-Source PostgreSQL Audit Logging

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".

kvaranasi_on PgAudit: Open-Source PostgreSQL Audit Logging

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