5 ms·
There's also a pretty nice built-in sqlite extension for transitive closures that helps in searching hierarchical/tree structures in sqlite: https://web.archive
by faizshah 6y ago
There's also a pretty nice built-in sqlite extension for transitive closures that helps in searching hierarchical/tree structures in sqlite: https://web.archive.org/web/20141127001741/https://charlesleifer.com/blog/querying-tree-structures-in-sqlite-using-python-and-the-transitive-closure-extension/ https://web.archive.org/web/20141127001741/https://charlesle...
- napsterbr 6y agoClicking the above link takes me to https://imgur.com/32R3qLv https://imgur.com/32R3qLv. I fail to understand why have a blog at all if its author don't like people linking to it.
- setr 6y agowell, he doesn't like one particular group of people linking to it :-)
- fiddlerwoaroof 6y agoI believe jwz did this first
- faizshah 6y agoHow strange, sorry, I didn't know that it did that. Just updated it to an archive link. This is the only source I know of that gives an overview of closures.c so it's worth the read.
- napsterbr 6y agoDefinitely not your fault :)