A Language Server for Postgres
31 points by fanf
31 points by fanf
It would be cool if these things had integration with webapp development servers and/or executing databases.
I know you can use Docker Compose, but now that there are good PostgreSQL servers packaged that you can download and run, we should start using them more. My webapp should use a database URL like local-pg17:, and the development web server should (indirectly through libraries) download a PostgreSQL 17 binary, start the database, and apply migrations.
The LSP should hook into that, and create a temporary database for code completion, with the migrations applied.
The config does require database connectivity. You must run the way you are describing.
Of course, you cannot get completion of tables if you don’t create the tables.
However, I want to edit my database definition and have the LSP reload. For that, it would be nice to have some automation.
Supabase has done lots of good for postgres. I am using their graphql integration and it is reasonable good. This LSP will be certainly useful. It is interesting that SQL existed for this long but you can only know if your SQL query will work until you execute it.