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:[email protected]: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)

0.3.0

Changelog

This release fixes all bugs reported by early users since the public announcement. And includes a new feature!

You can now execute a statement directly within your IDE using Code Actions. This is very useful if you want to quickly iterate on a function.

To enable the feature, you must first set a db.allowStatementExecutionAgainst property in your postgrestools.jsonc. It should be an array of <hostGlobPattern>/<databaseNameGlobPatterns> strings.
See docs for examples.

🚀 Features

• Execute stmt under cursor (#257)

🐛 Bug Fixes

• Cte (#263)
• Typo on docs/index.md (#283)
• Tree-sitter edit_from_change crash (#273)
• View with options (#288)
• Version (#289)
• Run ci for workflows (#290)
• Use byte indices (#286)
• Execute statement reliable (#291)

🚜 Refactor

• Move lsp converters to lsp crate (#275)
• Move workspace features to own mod (#276)
• Move get_cursor_position to adapters (#278)

⚙️ Miscellaneous Tasks

• Fix bug in codegen (#256)
• Add show-logs justfile cmd (#258)
• Add install docs (#259)
• Add test (#260)
• Add demo media (#264)
• Clean cargo check and cargo clippy (#277)
• Only deploy docs on release (#285)
• Upgrade pg_query and both submodules (#294)
• Update submodules (#295)
• Improve logs (#266)

0.2.1

This patch fixes a few minor and one major issue with the previous release.