A 2.5x faster Postgres parser with Claude Code

multigres.com

9 pointskiwicopple7 comments

Hey HN, I'm the author. Happy to answer questions or discuss further.

I'm curious because I have a similar use case for a querying frontend. Did you consider using https://github.com/tobymao/sqlglot? If so, what was missing to justify writing your own parser?

Good question! The main reason is that sqlglot is written in Python, so it wouldn't integrate natively with our Go codebase. We actually faced a similar decision with pg_query_go (https://github.com/pganalyze/pg_query_go) and passed on that too, anything that requires bridging another language means translating the AST back into Go, which adds a performance cost we wanted to avoid.

Ok that makes sense! On my side I can get away with using it through WASM. But your performance needs won't allow that.

Right exactly!

Neat build for sure, but did you write the actual article here by hand? Getting some AI sniffs in the copy..

I wrote it, but of course I used AI to polish it :smile: It would actually be ironic if I didn't use Claude to write about how Claude accelerated my engineering!

Reply on news.ycombinator.com