nuno-faria/tetris-sql
Using SQL's Turing Completeness to Build Tetris observed · 2026-08-28
Health v2 · maintenance only
45/100
- Activity 49
- Release rhythm 35
- Longevity 52
Flags: no_releases
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-02. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 728
- days_rel: n/a
- days_push: 311
- n_releases_24m: 0
Adoption not part of the score
1032 stars · 43 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
A complete implementation of Tetris running inside a single PostgreSQL SQL query, exploiting the Turing completeness of recursive CTEs. A small Python helper script converts keyboard input into SQL commands, while the game logic, rendering, and state all live in SQL.
Use cases
- play tetris in a postgres database
- demonstrate sql turing completeness
- learn recursive cte techniques
- novel demo for database conference talks
- explore what can be built in pure sql
When to choose
- you want a fun, educational showcase of recursive CTEs in PostgreSQL
- you need a striking demo of SQL's computational power
- you already run PostgreSQL and want a novelty game
When to avoid
- you need a practical or performant Tetris game
- you don't have a PostgreSQL server available
- you want maintainable game code in a general-purpose language
Facets
application · maturity active
game interpreter developer-tools databases gaming-tools programming-languages windows cli sql postgresql cte recursive-cte turing-complete novelty-project plpgsql linux macos docker
1 source
- readme: https://github.com/nuno-faria/tetris-sql · fetched 2026-08-28 · 4bf15237af31
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| nuno-faria/tetris-sql | main | 45 |
For agents
markdown · JSON · MCP: product_card(name="nuno-faria/tetris-sql")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem