Hacker News Clone new | comments | show | ask | jobs | submit | github repologin
SQLite: Outlandish Recursive Query Examples (www.sqlite.org)
45 points by Rendello 3 hours ago | hide | past | web | 2 comments | favorite





Just curios: can CTE's be used to make time series range queries easier / more performant?

Sqlite is the default option on Android and it's pretty common to have time series sensor data that needs to be captured, stored, and analyzed...

But sqlite isn't really meant for a time series workload.

There is also duckdb but I'm not sure about the status of the Android bindings.


nothing really helps with potato slow Android device / storage media. CTE is not magic sauce that will make sqlite go faster.

Firefox bookmarks have nested folders in an arbitrary depth tree, so a recursive CTE might be faster; https://www.google.com/search?q=Firefox+bookmarks+%22CTE%22

(Edit) "Bug 1452376 - Replace GetDescendantFolders with a recursive subquery" https://hg.mozilla.org/integration/autoland/rev/827cc04dacce

"Recursive Queries Using Common Table Expressions" https://gist.github.com/jbrown123/b65004fd4e8327748b650c7738...




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: