3 ms·
Interesting article! By the way, SQLite also has support for recursive queries (and allows even slightly more advanced stuff than Postgres, e.g. ordering of res
by ThePhysicist 12y ago
Interesting article! By the way, SQLite also has support for recursive queries (and allows even slightly more advanced stuff than Postgres, e.g. ordering of results), which you can use to do many amazing things.
I recently wrote a blog article about this, where I use recursive common table expressions solve the "eight queens" problem in SQL (using both Postgres and SQLite):
http://www.andreas-dewes.de/en/2015/queens-of-the-data-age-abusing-common-table-expressions-to-solve-the-eight-queens-problem-in-sql/ http://www.andreas-dewes.de/en/2015/queens-of-the-data-age-a...