0.11.0

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

0.11.0

This release brings basic hover support, support for named parameters such as @name, and a plpgsql_check integration for better PL/pgSQL support. make sure to enable the extension in your development database!

🚀 Features

• Plpgsql check (#469)
• Basic hover (#463)

🐛 Bug Fixes

• Splitter crash (#464)
• files.ignore setting should work (#462)
• Add support for named param type $name (#475)
• Positional params (#473)

🚜 Refactor

• Extract completions context into pgt_treesitter crate (#466)

📚 Documentation

• Fix links to rules (#467)

⚙️ Miscellaneous Tasks

• Add custom libpg_query binding (#465)
• Add extensions to schema cache (#468)
• Pglpgsql docs (#478)
• Run tests on macos in ci (#479)

Contributors

• @psteinroe
• @juleswritescode

0.10.0

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

0.10.0

This release fixes a deadlock that w as introduced earlier and adds support for named parameters in the lexer.

🚀 Features

• Add support for named params (#458)

🐛 Bug Fixes

• Revoke split (#459)
• Deadlock (#460)
• Syntax error regression (#461)

⚙️ Miscellaneous Tasks

• Expose schema_cache & file_context in lint rules (#449)

Contributors

@juleswritescode
@psteinroe

0.9.0

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

This release comes with a few very important under-the-hood refactors that remove the reason why the server crashed sometimes entirely, and unblocks us to work on more advanced features!

Please open an issue if the server still crashes on you.

we also shipped a few features:

• linter suppression

-- pgt-ignore lint/safety/banDropTable
drop table users;

• plpgsql syntax errors

0.9.0

🚀 Features

• Customise severity per rule (#430)
• Linter suppressions (#440)
• Show plpgsql syntax errors (#452)

🐛 Bug Fixes

• (splitter) Do update in INSERT INTO (#436)
• (analyser) Recognize disabled rules (#438)

🚜 Refactor

• Custom lexer (#437)
• Drop change.rs (#447)
• Simplify caches (#448)

📚 Documentation

• Rule suppressions (#443)

⚙️ Miscellaneous Tasks

• (docs) Fix schema links (#451)
• Add Nix development environment (#441)
• Fix doc command (#450)
• Update git cliff version

Contributors

@juleswritescode
@psteinroe

0.8.1

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

0.8.1

🐛 Bug Fixes

• Batched changes (#428)

Contributors

• @psteinroe

0.8.0

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

0.8.0

🚀 Features

• Workspace support (#408)
• Versioned docs (#414)
• (schema-cache) Include procedures & aggregates, fix query (#424)
• (completions) Complete (materialized) views (#409)
• (completions) Alter/drop/rename column statements (#421)
• (completions) Complete in (simple) function bodies (#426)
• (completions) Complete roles (#410)
• (completions) Complete in WITH CHECK and USING clauses (#422)

🐛 Bug Fixes

• (docs) Make latest default after next release (#420)
• (completions) Convert SQL to lowercase (#416)
• (splitter) Split grant stmts (#425)
• Broken text after receiving batched changes (#413)
• Release pipeline points at correct schema.json (#427)

🚜 Refactor

• (test_db) Use sqlx::test instead (#411)

Contributors

• @juleswritescode
• @psteinroe

0.7.0

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

0.7.0

🚀 Features

• (completions) Respect table aliases, complete in JOINs (#388)
• (completions) Fill in alias for columns in join clauses (#392)
• Allow configuration through workspace/didChangeConfiguration (#316)
• (completions) Lower priority of already mentioned columns in SELECT (#399)
• (completions) Complete policies (#397)
• (completions) Nicer function completions (#401)
• (completions) Show data type for columns (#402)
• (completions) Complete insert, drop/alter table, ignore many situations, improve WHERE (#400)

🐛 Bug Fixes

• (splitter) Allow newlines after commas (#380)
• Properly parse trigger with instead of (#383)
• (completions) Complete right columns right after JOIN ON (#390)
• Properly handle multiple changes at once (#389)
• (completions) Use fuzzy matching for user input (#393)
• Do not complete right after asterisk (#394)
• Sql fn params (#366)
• Nullabe column query (#406)

📚 Documentation

• Mention Emacs client (#378)

⚙️ Miscellaneous Tasks

• (schema_cache) Query policies (#379)
• (completions) Add tree sitter query for table aliases
• Add contributors to changelog (#387)
• (schema_cache) Add query for triggers (#398)
• (schema_cache) Add query for roles (#404)

Contributors

• @willruggiano made their first contribution in #316 🎉
• @jcs090218 made their first contribution in #378 🎉
• @juleswritescode
• @psteinroe

0.6.1

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

0.6.1

🐛 Bug Fixes

• Does not split statements at a WITH TIMEZONE anymore
• Does not try to connect to postgresql://postgres:postgres@127.0.0.1:5432/postgres if no db section is configured in postgrestools.jsonc anymore

0.6.0

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

0.6.0

🚀 Features

• (completions) Filter out irrelevant completion items: For example, it does not make sense to suggest columns in a FROM clause.

• (completions) Insert schema name when selecting non-public tables: If you accept a suggestion from another schema then public, the schema name will be added into the editor.

🐛 Bug Fixes

• (completions): , does not trigger suggestions anymore (' ' still does)
• (completions): Fixed a bug where '.' led to invalid completions.
• (completions): Completion items are now correctly sorted in the editor.

0.5.0

Postgres Language Server

A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.

Note

We accidentally deleted release 0.4.0 while trying to release 0.5.0. Sorry!

0.5.0

🚀 Features

• Autocomplete schemas (#340)

🐛 Bug Fixes

• Comments only (#337)
• Release changelog (#338)
• Dont point to 404 in config schema (#339)
• Plpglsql cmds (#336)
• Typing comments (#347)
• Report db connection errors (#348)
• Split grant stmt properly (#350)
• Extract sql fn body properly (#346)

⚙️ Miscellaneous Tasks

• Add double newline comment (#341)
• Ensure auto fixes are applied (#349)
• Test fn body content (#351)

0.3.1

postgrestools 0.3.1

This release fixes a few minor bugs and enables building without an active db connection - a prerequisite for homebrew.

🐛 Bug Fixes

• Enable sqlx offline mode (#297)
• Support non timestamp but numeric migrations (#301)
• Nested () and with check (#307)
• Log more (#309)