13 ms·

PgAudit: Open-Source PostgreSQL Audit Logging

32 points by kvaranasi_ 3y ago

bnchrch 3y ago
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.
- tmpz22 3y ago
  Step 1: be free
  - kvaranasi_ 3y ago
    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_ 3y ago
  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/5257f0ff5520598e6327d148056ff3bb 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 https://twitter.com/RGraphql
  - nesarkvechnep 3y ago
    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.
    - kvaranasi_ 3y ago
      That's true. Been into frontend mostly.
- flashgordon 3y ago
  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!
thunderbong 3y ago
Is there some tutorial on how to set up pg_audit? Maybe also something with an interface where the logs can be queried?
- kvaranasi_ 3y ago
  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 https://twitter.com/RGraphql/status/1689631592321544192 It's so beautiful that I'm gonna name it "the sexy release".

32 points by kvaranasi_ 3y ago

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.

tmpz22 3y ago
Step 1: be free
- kvaranasi_ 3y ago
  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_ 3y ago
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/5257f0ff5520598e6327d148056ff3bb 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 https://twitter.com/RGraphql
- nesarkvechnep 3y ago
  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.
  - kvaranasi_ 3y ago
    That's true. Been into frontend mostly.
flashgordon 3y ago
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!

thunderbong 3y ago

Is there some tutorial on how to set up pg_audit? Maybe also something with an interface where the logs can be queried?

kvaranasi_ 3y ago
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 https://twitter.com/RGraphql/status/1689631592321544192 It's so beautiful that I'm gonna name it "the sexy release".