News for hackers. Stuff that matters.

A comment on PostgreSQL 14. Parent comment

Re:PostgreSQL 14 by bfelbo on Thursday September 30, 2021 @07:53PM (#28712710)
There’s plenty of GUI tools, but what about tools for writing SQL inside VS Code?

We usually write our DB migrations in VS Code along with any other code changes, but the PG support in VS Code seems to be lacking. Just some naïve validation of PostgreSQL code inside VS Code would be awesome!

[ Parent | on HN ]
Re:PostgreSQL 14 by mixmastamyk on Thursday September 30, 2021 @08:36PM (#28713008)
I used pgsanity at the CLI for a while when I unfortunately had coding and testing split between two machines. Can be used with any editor. https://github.com/markdrago/pgsanity
[ Parent | on HN ]
Re:PostgreSQL 14 by bfelbo on Friday October 01, 2021 @01:32AM (#28714957)
Interesting, thanks! I wonder how easy it would be to write a VS Code plug-in using that.
[ Parent | on HN ]
Re:PostgreSQL 14 by mixmastamyk on Friday October 01, 2021 @01:17PM (#28721118)
If you can run a linter, you can run it as well.
[ Parent | on HN ]
Re:PostgreSQL 14 by bfelbo on Saturday October 02, 2021 @02:31PM (#28730854)
Ah, good point! I might try to create an eslint rule that incorporates it.
[ Parent | on HN ]