gosql

I've read a similar series from Phil back in 2020: "Writing a SQL database from scratch in Go" https://notes.eatonphil.com/database-basics.html The code is available on GitHub: https://github.com/eatonphil/gosql (it's specifically a PostgreSQL implementation in Go). It's cool to build a database in 3000 lines, but for a real production-ready database you'll need testing. Would love to see some coverage on correctness and reliability tests. For example, SQLite has about 590 times more test code than the library itself. (https://www.sqlite.org/testing.html)

Flexes, maybe. Delusional? Not at all. Here's a few stuff I've worked on for my own education over the years: - Raft: https://github.com/eatonphil/raft-rs - BTree: https://github.com/eatonphil/btree-rs - A little Lua VM: https://github.com/eatonphil/lust - A little Postgres clone: https://github.com/eatonphil/gosql - A little Elastic clone: https://github.com/eatonphil/docdb - A little amd64 emulator: https://github.com/eatonphil/go-amd64-emulator

In Go you've got: go-mysql-server [0], vitesse's parser [1], and one I wrote [2]. In JavaScript you've got: Alasql's [3] (this is a large file) and here's another SQLite parser [4]. In Java there's JSQLParser [5] and I think you can access Presto's parser too [6]. [0] https://github.com/dolthub/go-mysql-server [1] https://github.com/blastrain/vitess-sqlparser [2] https://github.com/eatonphil/gosql [3] https://github.com/agershun/alasql/blob/develop/src/alasqlpa... [4] https://github.com/codeschool/sqlite-parser [5] https://github.com/JSQLParser/JSqlParser [6] https://github.com/prestodb/presto

Unexpected, but welcome, to see the first part in the series on here right now. I just published the second part [0] today, featuring binary expressions and WHERE filtering. It also updates the REPL to use a prettier table-printing library and a readline implementation. The repo [1] has some additional bare notes on architecture and links to similar, more mature projects (primarily go-mysql-server and ramsql). [0] https://notes.eatonphil.com/database-basics-expressions-and-... [1] https://github.com/eatonphil/gosql