Morioh
Login
Shannon Atkinson

Shannon Atkinson

4 years ago

Previously in database basics:
1. SELECT, INSERT, CREATE and a REPL
Next in database basics:
3. indexes
4. a database/sql driver

In this post, we’ll extend gosql to support binary expressions and very simple filtering on SELECT results via WHERE. We’ll introduce a general mechanism for interpreting an expression on a row in a table. The expression may be an identifier (where the result is the value of the cell corresponding to that column in the row), a numeric literal, a combination via a binary expression, etc.

#sql #database #go

Writing a SQL database from scratch in Go: Binary Expressions and WHERE Filters

notes.eatonphil.com

Writing a SQL database from scratch in Go: Binary Expressions and WHERE Filters

Writing a SQL database from scratch in Go, we'll extend gosql to support binary expressions and very simple filtering on SELECT results via WHERE. We'll introduce a general mechanism for interpreting an expression on a row in a table. The expression may be an identifier (where the result is the value of the cell corresponding to that column in the row), a numeric literal, a combination via a binary expression, etc.

2.00 GEEK