| - This page is a collection of some of the Advanced queries from the [[Datalog]] channel on the [[Logseq/Discord]] server. #datalog | |
| id:: 61db13f4-75e8-4f87-ad60-3ac3479c5fc8 | |
| - ### Resources | |
| - [link: The first message on the datalog channel](https://discord.com/channels/725182569297215569/743139225746145311/743139795865174119) | |
| - [link: Logseq docs - Advanced queries](https://docs.logseq.com/#/page/advanced%20queries) | |
| - [link: Logseq datascript schema](https://gist.github.com/tiensonqin/9a40575827f8f63eec54432443ecb929) | |
| - [link: Logseq frontend db model](https://github.com/logseq/logseq/blob/master/src/main/frontend/db/model.cljs) | |
| - [link: How to Graph Your Data - talk by Paula Gearon](https://youtu.be/tbVwmFBnfo4) | |
| - [link: Domain modelling with datalog - talk by Norbert Wojtowicz](https://youtu.be/oo-7mN9WXTw) | |
| - [link: Athens Research ClojureFam](https://github.com/athensresearch/ClojureFam) |
I liked the way Grokking the coding interview organized problems into learnable patterns. However, the course is expensive and the majority of the time the problems are copy-pasted from leetcode. As the explanations on leetcode are usually just as good, the course really boils down to being a glorified curated list of leetcode problems.
So below I made a list of leetcode problems that are as close to grokking problems as possible.
| -- convert all .xel files in a given folder to a single-column table | |
| -- (alternatively specify an individual file explicitly) | |
| select event_data = convert(xml, event_data) | |
| into #eeTable | |
| from sys.fn_xe_file_target_read_file(N'd:\killme\extended events\*.xel', null, null, null); | |
| -- select from the table | |
| select * from #eeTable | |
| -- and click on a hyperlink value to see the structure of the xml |