Publications
Bulding Tetris in a SQL Query!
PGConf.EU: PostgreSQL Conference Europe, 2025
Authors
- Nuno Faria
Abstract
Recursive CTE queries have been gaining special attention in recent years, as they enable complex computations to occur closer to the data source, rather than loading large amounts of data to an external application. This presentation aims to shed light on recursive CTEs in PostgreSQL, including use cases, key considerations when using them, and current limitations. To exemplify just how powerful CTEs are, a fully working game of Tetris is implemented in a PostgreSQL query.BibTeX
@misc{tetris-sql,
author = {Nuno Faria},
title = {Building Tetris in a SQL Query!},
howpublished = {PostgreSQL Conference Europe},
year = {2025},
month = oct,
url = {https://nuno-faria.github.io/publications/tetris-sql}
}