4 ms·

A 2.5x faster Postgres parser with Claude Code

• guptamanan100 8mo ago
  Hey HN, I'm the author. Happy to answer questions or discuss further.
  • Lemaxoxo 8mo ago
    I'm curious because I have a similar use case for a querying frontend. Did you consider using https://github.com/tobymao/sqlglot https://github.com/tobymao/sqlglot? If so, what was missing to justify writing your own parser?
    • guptamanan100 8mo ago
      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 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.
      • Lemaxoxo 8mo ago
        Ok that makes sense! On my side I can get away with using it through WASM. But your performance needs won't allow that.
        • guptamanan100 8mo ago
          Right exactly!
  • jonsully 8mo ago
    Neat build for sure, but did you write the actual article here by hand? Getting some AI sniffs in the copy..
    • guptamanan100 8mo ago
      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!