News for hackers. Stuff that matters.
Re:PostgreSQL IDE in VS Code by netghost on Friday May 23, 2025 @12:55PM (#44074456)
That seems like a really pragmatic tool, thanks for sharing it!

I'm curious, do you output triggers, store procedures, and such? Many tools seem to stop after you've defined tables, columns, and indices, but I'd love some better tooling to make use of the rest of the DB's features.

Re:PostgreSQL IDE in VS Code by seveibar on Friday May 23, 2025 @02:30PM (#44075233)
Yep! It basically runs pg_dump and categorizes all of the output into different files so it should be comprehensive. I think there's `functions/function_name.sql`, `misc.sql`, `triggers.sql` etc.
Re:PostgreSQL IDE in VS Code by what on Saturday May 24, 2025 @12:56AM (#44078870)
You built it but you don’t know what it outputs?
Re:PostgreSQL IDE in VS Code by netghost on Wednesday May 28, 2025 @12:48PM (#44117963)
Thanks!

And curses. Now I'm going down another rabbit hole rehashing ways to interface with my database in a side project that is doomed to never get past the "there has to be a better way to…" phase ;)