postgres-language-server
postgres-language-server copied to clipboard
supabase-community
A Language Server for Postgres
I saw that a fix for `WITH` was made in https://github.com/supabase-community/postgres-language-server/pull/263, but I have an example that is not a CTE but still crashes: ```sh # echo "CREATE ROLE foo...
EDIT: putting this into draft again. there are other issues that I need to figure out before we should continue in this direction. - [ ] get pg_query (or libpg_query?...
we want to make the platform as accessible as possible, and a wasm integration would allow us to run the workspace api within a service worker. this would allow tools...
a tsserver plugin *should* allow us to add sql language features to template literals within a typescript / javascript file.
this is *very early*, but we can use [`pretty`](https://crates.io/crates/pretty) to implement pretty printing for the ast nodes returned by [`pg_query.rs`](https://github.com/pganalyze/pg_query.rs).
since we have a db connection, we should be able to integrate [`plpgsql_check`](https://github.com/okbob/plpgsql_check). I would propose two layers: 1. inline lints on the source code itself: actively query the extension...
we need to add - generic dev docs and an ARCHITECTURE.md - more documentation for each crate
once we have #178, we can start looking into this too. pg_query.rs already exposes a basic binding for parsing plpgsql. we should first improve that binding upstream and then start...
we should be able to extract the body of a `language sql` function as yet another statement and provide language intelligence features on it as usual.
using `oxc`, we should be able to extract sql code from template literals and provide language intelligence features for it. note that this is only for the CLI entry point....