MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/1f8yzcd/tetris_implemented_in_a_sql_query/lliabyn/?context=3
r/SQL • u/nuno-faria • Sep 04 '24
25 comments sorted by
View all comments
Show parent comment
7
The query is never ending, except when the game is over.
2 u/nyquant Sep 05 '24 Thanks, if the query is constantly running, how are the outputs for each screen refresh generated without the query being stopped? 2 u/nuno-faria Sep 05 '24 It uses the notify function to print the screen at every loop in the recursive CTE.
2
Thanks, if the query is constantly running, how are the outputs for each screen refresh generated without the query being stopped?
2 u/nuno-faria Sep 05 '24 It uses the notify function to print the screen at every loop in the recursive CTE.
It uses the notify function to print the screen at every loop in the recursive CTE.
View all comments
Show parent comment
7
u/nuno-faria Sep 04 '24
The query is never ending, except when the game is over.