SQL powered operating system instrumentation, monitoring, and analyticsgithub.com58 ポイント·投稿者 gzel·2 年前·7 コメント
gzel·2 年前·議論I really like the way of how feldera implemented recursion in SQL: https://docs.feldera.com/sql/recursionAll you have to do is to add a forward declaration of the view and then you can reference it in a recursive query. Makes the syntax part much easier.
gzel·2 年前·議論This is somewhat common when high performance is needed it seems: e.g., https://github.com/feldera/feldera comes to mind which uses the same approach to compile SQL to type-safe incremental query plans in rust.
All you have to do is to add a forward declaration of the view and then you can reference it in a recursive query. Makes the syntax part much easier.