Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Postgres Language Server: Initial Release

github.com

Post reply on HN
Print view View original

31–40 of 58 posts

Re: Postgres Language Server: Initial Release

#31

Post by steinroe »

tmountain wrote: post #30

For anyone struggling to manage their PL/pgSQL codebase via migration files. This is a game changer. https://github.com/t1mmen/srtd

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.

Re: Postgres Language Server: Initial Release

#32

Post by [deleted] »

homebrewer wrote: post #16
steinroe wrote: post #2

Hey HN! We have released the initial version of the Postgres Language Server we started working on almost two years ago[0]. You can try it out by downloading the binary from the repo[1]. It is also available on npm, as a vscode extension and via nvim-lspconfig and mason.[2] We fell into plenty of rabbit holes along the way, but dug our way out of each. We're now using mostly pragmatic, almost naive solutions for our…

> we started working on almost two years ago Jesus, this really puts it into perspective how much effort JetBrains have put into their IDEs, which have had superb support for all popular SQL dialects for as long as I can remember. Thank you for providing the community with a FOSS alternative, because IIRC there wasn't anything remotely comparable to JetBrains up until now.

[deleted]

Re: Postgres Language Server: Initial Release

#33

Post by perrygeo »

tmountain wrote: post #30

For anyone struggling to manage their PL/pgSQL codebase via migration files. This is a game changer. https://github.com/t1mmen/srtd

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

Re: Postgres Language Server: Initial Release

#36

Post by pphysch »

Pedro_Ribeiro wrote: post #13

This is awesome. Does anyone know if it'll possible to integrate it with tools like SQLX (Rust's pseudo-ORM) to get type hinting when writing in-like SQL code within Rust, or just have it work when I'm writing SQL within a simple Python script? That would truly be next-gen.

Python 3.14 will likely add PEP-750 t-strings which will make LSP integrations like this much more tangible.

https://discuss.python.org/t/pep750-template-strings-new-upd...

Re: Postgres Language Server: Initial Release

#37

Post by vendiddy »

I'm very happy that something like this exists!

I'm wondering why have there have been no good IDE experiences so far for Postgres? Or put another way, what has been the most challenging part of building this?

Nothing I have tried so far comes close to what I'm used to with statically typed languages. One would think something as strict as Postgres would have good autocomplete by now but I've yet to find something.

Re: Postgres Language Server: Initial Release

#38

Post by doctorpangloss »

vendiddy wrote: post #37

I'm very happy that something like this exists! I'm wondering why have there have been no good IDE experiences so far for Postgres? Or put another way, what has been the most challenging part of building this? Nothing I have tried so far comes close to what I'm used to with statically typed languages. One would think something as strict as Postgres would have good autocomplete by now but I've yet to find something.

IntelliJ works great. Nothing you’ve tried in VS Code “comes close.”

Re: Postgres Language Server: Initial Release

#40

Post by crooked-v »

steinroe wrote: post #2

Hey HN! We have released the initial version of the Postgres Language Server we started working on almost two years ago[0]. You can try it out by downloading the binary from the repo[1]. It is also available on npm, as a vscode extension and via nvim-lspconfig and mason.[2] We fell into plenty of rabbit holes along the way, but dug our way out of each. We're now using mostly pragmatic, almost naive solutions for our…

Any chance this will include formatting in the future?
Post reply on HN