Postgres Language Server (github.com)

Article summary

The Postgres Language Server is a toolchain for Postgres development, built on Postgres' own parser libpg_query, providing features such as autocompletion, syntax diagnostics, and formatting. It is designed to work standalone, without connecting to a database, but will have optional features that require a database connection. The project aims to make Postgres tooling more accessible and to build missing features. It supports various editors, including VSCode, Neovim, and Sublime Text.

Main themes

• Postgres tooling
• Language Server Protocol
• Database schema management
• Pricing models
• Developer experience
• Open-source contributions
• Subscription vs perpetual licenses
• Database extensions

What commenters say

• Some commenters are interested in the project's potential to support extensions, such as PostGIS, and to provide features like autocompletion and code actions.
• Others are concerned about the pricing model of similar tools, preferring one-time payments or perpetual licenses over subscriptions.
• There is a discussion about the ideal approach to database schema management, with some advocating for a state-based, declarative approach.
• Some commenters appreciate the project's focus on improving the developer experience for Postgres, while others are skeptical about the need for another tool.
• The project's maintainers are open to contributions and are planning to add features that require a database connection.
• Some commenters are frustrated with the pricing model of certain tools, feeling that it is not transparent or fair.
• There is a debate about the value of paying for tooling, with some arguing that it is worth the cost and others preferring free or open-source alternatives.