Show HN: A Database Written in Golang

Re:Show HN: A Database Written in Golang by bob1029 on Wednesday February 26, 2025 @11:58AM (#43185527)

If you are wanting proper SQL command support, you could copy the SQLite parser approach. Properly parsing all valid command texts is not a problem that I would find compelling unless I was being compensated for it.

https://www.sqlite.org/lemon.html

You could probably use something like participle, but you'd have to translate the grammar.

https://github.com/alecthomas/participle

[ Parent | on HN ]

Re:Show HN: A Database Written in Golang by Sahil121 on Wednesday February 26, 2025 @12:16PM (#43185728)

yes man have to work on adding the sql cmd support thanks for the links

[ Parent | on HN ]

Re:Show HN: A Database Written in Golang by qaq on Wednesday February 26, 2025 @01:16PM (#43186374)

You can use https://github.com/cockroachdb/cockroachdb-parser which is basically PGSQL compatible parser implemented in golang

[ Parent | on HN ]

Re:Show HN: A Database Written in Golang by mingodad on Thursday February 27, 2025 @04:36AM (#43192728)

I do have a big collection of LALR(1) grammars to test/study/develop/document here https://mingodad.github.io/parsertl-playground/playground/ including sqlite, tidb, vites, postgresql, mysql, ...

[ Parent | on HN ]