Building Tetris in a SQL Query!
October 21–24
Level: Beginner
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.