/plushcap/analysis/supabase/supabase-postgres-language-server-implementing-parser

Postgres Language Server: implementing the Parser

What's this blog post about?

The Postgres Language Server is being developed to improve the tooling around Postgres programming, making it easier for developers to write SQL in editors like VSCode. The parser is the core of every language server and converts written code into a form that tools can work with. Implementing a parser for Postgres is challenging due to its complex syntax. To overcome this, libpg_query is leveraged to parse SQL code reliably. The lexer breaks the input into individual SQL statements and parses them one by one, allowing errors within each statement to be handled independently.

Company
Supabase

Date published
Dec. 8, 2023

Author(s)
Philipp Steinrötter

Word count
2865

Language
English

Hacker News points
162


By Matt Makai. 2021-2024.