Top
Best
New

Posted by steinroe 3/29/2025

Postgres Language Server: Initial Release(github.com)
362 points | 52 commentspage 2
t1mmen 3/29/2025|
Really excited about trying this, great job so far!

I think formatting/prettier-type functionality was mentioned as a possibility of this project, is that still in the cards?

(I can’t seem to find a formatter that understands stored procedure; does it even exist?)

steinroe 3/29/2025|
its still in the cards! it will be more like a pretty printer instead of a formatter though. Meaning we will prettify valid code only. but its a bigger effort, and we want to focus on a stable basis first.
tmountain 3/29/2025||
For anyone struggling to manage their PL/pgSQL codebase via migration files. This is a game changer.

https://github.com/t1mmen/srtd

perrygeo 3/29/2025||
In a similar vein, Tusker is helpful tool that diffs your declarative schema and auto-generates migrations. It uses live postgres connections so you can connect and diff against a running instance too, allowing you to sync up multiple instances. You still need something to run the migrations, but generating them is fully automated. https://github.com/bikeshedder/tusker
t1mmen 3/29/2025|||
Oh, fun to see my project mentioned on HN! I’m glad to see it’s useful to others :)
steinroe 3/29/2025||
that is really awesome! declarative schema management is also high on my bucket list, and might even become part of this project. thanks for sharing, will check it out.
matus_congrady 3/29/2025||
Is there a way to make this work inside a browser, via monaco-editor?

If so, do you have any examples, or recommendations?

steinroe 3/29/2025|
I do not have experience with monaco, but you should be able to run the language server remotely and connect to it from the editor via the usual language server protocol.

we currently do not provide a wasm build which would enable us to run the server within the browser too, although that's something I am actively poking around with.

0xa2 3/29/2025||
Happy to see this coming along.
thundervelvet 3/29/2025||
[dead]