plpgsql_check
postgres_lsp
| plpgsql_check | postgres_lsp | |
|---|---|---|
| 3 | 6 | |
| 608 | 3,136 | |
| - | 0.7% | |
| 8.2 | 9.2 | |
| about 2 months ago | 11 days ago | |
| C | Rust | |
| GNU General Public License v3.0 or later | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
plpgsql_check
-
Supabase Local Dev: migrations, branching, and observability
Finally, while you wait for us to make progress on the Language Server, we’ve added support for linting through the excellent plpgsql_check extension.
- Postgres Invalid objects
- PostGIS – Spatial and Geographic Objects for PostgreSQL
postgres_lsp
-
We built our customer data warehouse all on Postgres
Thank you for turning me on top Cornucopia, it looks awesome. I've used the very similar aiosql in Python, but I hadn't realized there was a Rust analog.
To tell the truth I've been waiting for postgres_lsp to mature before trying it out, but based on this example [1] I think it does support multiple queries.
Since it uses a parser extracted from Postgres, the nonstandard syntax would probably trip it up, but there's probably a way to fix that.
[1] https://github.com/supabase/postgres_lsp/blob/main/example/f...
-
compile-time SQL validations and type generation in TypeScript & Node
Cool. How does this compare to SafeQL, PgTyped, and Postgres language server ?
-
Supabase Local Dev: migrations, branching, and observability
While code editors have great support for most programming languages, SQL support is underwhelming. We want to make Postgres as simple as Python. Our recently announced Postgres Language Server takes us a step in that direction - eventually it will provide first-class support for Postgres in your favorite code editor including Linting, Syntax Highlighting, Migrations Parsing, SQL Auto-complete, and Intellisense.
-
Hugging Face is now supported in Supabase
Postgres Language Server
- Show HN: Postgres Language Server
What are some alternatives?
pgsentinel - postgresql extension providing Active session history
pspg - Unix pager (with very rich functionality) designed for work with tables. Designed for PostgreSQL, but MySQL is supported too. Works well with pgcli too. Can be used as CSV or TSV viewer too. It supports searching, selecting rows, columns, or block and export selected area to clipboard.
pg_show_plans - Show query plans of all currently running SQL statements
edge-runtime - A server based on Deno runtime, capable of running JavaScript, TypeScript, and WASM services.
orafce - The "orafce" project implements in Postgres some of the functions from the Oracle database that are missing (or behaving differently).Those functions were verified on Oracle 10g, and the module is useful for production work.
vecs - Postgres/pgvector Python Client
docker-postgis - Docker image for PostGIS
basejump - Teams, personal accounts, permissions and billing for your Supabase app
tds_fdw - A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
declarative-schemas
pg_plan_guarantee - Postgres Query Optimizer Extension that guarantees your desired plan will not change
supabase-test-helpers - Test helpers for pgTAP and Supabase