Postgres Language Server: Initial Release

This page summarizes the projects mentioned and recommended in the original post on dev.to

InfluxDB – Built for High-Performance Time Series Workloads
InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  1. nvim-lspconfig

    Quickstart configs for Nvim LSP

    Neovim (via nvim-lspconfig + mason)

  2. InfluxDB

    InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

    InfluxDB logo
  3. squawk

    🐘 Linter for Postgres migrations & SQL

    Our linter is heavily inspired by Squawk. It takes the AST emitted by libpg_query and runs all configured rules on them. We spent some time optimizing the infrastructure of the linter in order to lower the barrier of contributing new rules and ask that the community can support us there.

  4. mason-registry

    Core registry for mason.nvim.

    Neovim (via nvim-lspconfig + mason)

  5. postgres-language-server

    A Language Server for Postgres

    GitHub Releases (precompiled binaries)

  6. libpg_query

    C library for accessing the PostgreSQL parser outside of the server environment

    This is why we decided not to create a custom parser. Instead, we leverage the existing libpg_query library to parse SQL code reliably. The pganalyze team has published a great blog post on why this approach is preferred.

  7. postgres_lsp

    Discontinued A Language Server for Postgres [Moved to: https://github.com/supabase-community/postgres-language-server]

    Our linter is heavily inspired by Squawk. It takes the AST emitted by libpg_query and runs all configured rules on them. We spent some time optimizing the infrastructure of the linter in order to lower the barrier of contributing new rules and ask that the community can support us there.

  8. biome

    A toolchain for web projects, aimed to provide functionalities to maintain them. Biome offers formatter and linter, usable via CLI and LSP.

    This approach is heavily inspired by (and borrows a lot from) Biome. Without their sophisticated and well-structured codebase, we wouldn’t have been able to implement an entire toolchain infrastructure this quickly over the past months. Cheers to Open Source!

  9. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
  10. pglite

    Embeddable Postgres with real-time, reactive bindings.

    If you want, you can already help us by installing the Language Server and reporting any issues we might have overlooked, or you could suggest features that we should implement later on (we're currently planning PL/pgSQL support, a Wasm build for pglite, and parsing SQL function bodies).

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Squawk: A linter for PostgreSQL, focused on migrations

    1 project | news.ycombinator.com | 17 Dec 2024
  • Squawk – A Linter for Postgres Migrations

    1 project | news.ycombinator.com | 30 Apr 2024
  • Postgres Language Server: Implementing the Parser

    5 projects | news.ycombinator.com | 8 Dec 2023
  • Bluesky migrates from pg to single-tenant SQLite

    2 projects | news.ycombinator.com | 6 Nov 2023
  • compile-time SQL validations and type generation in TypeScript & Node

    4 projects | /r/typescript | 27 Aug 2023

Did you know that Rust is
the 5th most popular programming language
based on number of references?