51–58 of 58 posts
Is there a way to make this work inside a browser, via monaco-editor? If so, do you have any examples, or recommendations?
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.
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?
The crazy part is it can do this for a SQL string in your code.
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.
If it’s just a nice GUI for interacting with postgres, Postico (for mac) is fantastic. Autocomplete is good, and the UI is very intuitive if you’re familiar with mac. It’s also a native app so it’s wicked fast. None of that web app pretending to be an app nonsense lol.
If you’re looking for a better experience interacting with a postgres server in a static typed language, like java, i’d check out Jooq. It’s been a while since i’ve used it but it basically lets you query a postgres database with proper types in your java code.
The best I've seen is jetbrains. Not only does it parse the query but it matches against actual tables if you give it a source. The crazy part is it can do this for a SQL string in your code.
# just as an example, I'm pretty sure that
# IJ already knows this is SQL
spring:
datasource:
hikari:
# language=sql
connection-test-query:
SELECT count(1) FROM my_table
#!/usr/bin/env python
# language=sql
MY_AWESOME_QUERY = """
WITH awesome AS (
-- ...
) SELECT * FROM awesome
"""Earlier quoted context omitted.
I suggest it would be helpful if the README's intro expanded a little more on the project's scope. "for postgres" is a bit vague, and "focusing on developer experience and reliable SQL tooling." doesn't tell me much about what it actually does. If I was coming to this project for the first time I think the questions I'd immediately like the answers to are: - What language is this language server for? Is it just for S…
Thanks for the feedback. Good points, we'll improve the README. Regarding your questions: 1. It's currently only for SQL statements, but we'll work on function bodies and PL/pgSQL soon. 2. Exactly, we follow the the PostgreSQL dialect (we use Postgres's parser) 3. You can give it a database connection and it will query some pg_catalog tables. If you don't provide connection details, we'll bypass features requiring th…
It'd be nice if users could manually obtain and provided that information.
Any plans on supporting such workflows?
Earlier quoted context omitted.
Thanks for the feedback. Good points, we'll improve the README. Regarding your questions: 1. It's currently only for SQL statements, but we'll work on function bodies and PL/pgSQL soon. 2. Exactly, we follow the the PostgreSQL dialect (we use Postgres's parser) 3. You can give it a database connection and it will query some pg_catalog tables. If you don't provide connection details, we'll bypass features requiring th…
> You can give it a database connection and it will query some pg_catalog tables. If you don't provide connection details, we'll bypass features requiring that. It'd be nice if users could manually obtain and provided that information.