TicTacToe in SQL (Postgres) (opens in new tab)

original link: https://technology.amis.nl/2009/10/13/oracle-rdbms-11gr2-sol...

Why are you linking it to a third party site.

The special purpose language, TicTacToe-inator, where an input of zero length compiles to TicTacToe.

The "higher" the language and more declarative. "Higher" because all the lower level work of data structures/etc are taken care of or even embedded into the language itself. "Declarative" because in declarative languages you just express what you want, not how to get it ( which imperative languages have to do ).

Compare "SELECT * FROM TBL1" with what you would need to do in an imperative language.

You would have to open data connection, set up data structures and have to specify step by step what you want. Even if you had libraries doing most of the work, you would still need to specify step by step what you want to be done. Whereas with SQL, you specify what you want and let the language/interpreter/optimizer/engine figure out the rest.

That's only considering "number of characters". Now if you measured "executable size" or memory size or any other impact, it might be different.

There are code golfs for at least checking the game states:

- https://codegolf.stackexchange.com/questions/32383/determine...

- https://stackoverflow.com/questions/2245801/code-golf-tic-ta...

You could probably add an extension to HQ9+[0] that'll get the job done pretty quick

[0]: https://esolangs.org/wiki/HQ9%2B

APL/J

k