Skip to content

Instantly share code, notes, and snippets.

@Kidinnu
Kidinnu / game_life.sql
Last active May 11, 2020 03:26
"Game of Life" in SQL
CREATE TABLE cells (
x BIGINT,
y BIGINT,
gen BIGINT,
CONSTRAINT UQ_xy UNIQUE (x, y, gen)
);
CREATE TABLE dxdy (x BIGINT, y BIGINT, CONSTRAINT UQ_xy UNIQUE (x, y));
INSERT INTO dxdy (x,y) VALUES