Hacker News Reader

Full thread

j_s

The PostgreSQL parser is available as a C library.

C - https://github.com/lfittl/libpg_query

Ruby - https://github.com/lfittl/pg_query

Go - https://github.com/lfittl/pg_query_go

Node - https://github.com/zhm/pg-query-parser

Python - https://github.com/alculquicondor/psqlparse

View on HN

Thanks for the shout-out - I'm the author of the base library you listed that can be used to work with the Postgres parser (libpg_query).

That said, the tool being discussed here (pev) is used to interpret EXPLAIN plans, which libpg_query doesn't give you, as its only concerned with the parsing stage, not the planning stage.

In order to plan a query you'll need more information from the actual database, including table statistics, config settings and the size of the underlying table :)

The output of explain is not "parse this SQL statement and show me what it means" but "given this SQL statement, how will it be executed on this database (which is affected by the table's stored statistics and takes into account any indexes)". I am thereby not sure how these query parsing libraries are relevant.

Thanks for taking the time to comment (?).

Never-before-on-the-HN-front-page tools for working with PostgreSQL queries seemed relevant to me; this info may help a few others.

Reply on news.ycombinator.com