On Mon, Apr 11, 2011 at 6:34 PM, Terry Brown <[email protected]> wrote:
>> http://techportal.ibuildings.com/2009/09/07/graphs-in-the-database-sql-meets-social-networks/ > > Cool, I did not know SQL could handle recursion. You realize what this > means... now we can calculate watershed area entirely in SQL :-) Dunno if sqlite could do it. My algorithm is straightforward - first iteration dumps all nodes to the db. Next iteration walks through all nodes and creates an edge from parent to every child + adds "pos" for child index. Unless I'm mistaken this is perfect representation of leo data model. Extra stuff can be added for uA's etc. -- You received this message because you are subscribed to the Google Groups "leo-editor" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/leo-editor?hl=en.
