Re:Writing Analytics SQL with Common Table Expressions
by groovy2shoes on Saturday August 23, 2014 @01:57PM
(#8216381)
Some RDBMSs support recursive CTEs, which come in handy sometimes. SQLite added support earlier this year, and I've written a handful of recursive CTEs to traverse DAGs in the database. I was blown away by how quickly SQLite can handle queries like that!
Re:Writing Analytics SQL with Common Table Expressions
by Xophmeister on Saturday August 23, 2014 @04:44PM
(#8216820)
Recursive CTEs are part of the SQL:1999 standard and actually make SQL into Turing complete language. I didn't realise SQLite had implemented CTEs, let alone recursive ones...I'll have to play :)