On Tue, Dec 27, 2011 at 10:15 AM, Terry Brown <[email protected]> wrote: > On Tue, 27 Dec 2011 00:53:06 -0500 > Seth Johnson <[email protected]> wrote: > >> I read a bit of SQLAlchemy tonight, and it does seem promising. Makes >> working with data as objects easy, and seems to promise to do the >> versioning. > > Ville's schema is worth looking at. Also the Django ORM is neat, > although SQLAlchemy might make a regular python classes based framework > easier, not sure.
I will, somewhat soon . . . > I think there are many places where Leo does something similar to > > for n in c.unique_nodes(): > blah blah > > which might be an issue for DB based outlines if the goal was to have > massive outlines - Leo doesn't do much lazy evaluation. > > Even for outlines only as large as the Leo code base for example I > and even with a DB on the local machine I'd expect some performance > hit, although RAM disk buffering can help a lot of course. My approach would scale globally very easily, but yes, traversal might get intensive in some contexts. I think optimizing that could be done locally and/or in the interface rather than the backend -- no reason why you couldn't just do the massive query, then build a list of child nodes pointer structure locally on that "cursor set." In the ancient world, the good designs supported bottomless sized structures, by just moving a window through it, swapping pieces into memory and on the display. Plus, shockingly enough: my system actually allows the return of record-oriented db approaches -- it solves the problem of how to work with arbitrarily complex relational structure across networks (the basic technical issue that really killed dBASE and settled us on SQL) -- you can navigate through "tables" and "relations" record-by-record with all the facility with which one used to do it using dBASE on the old 8 bit office desktop. The horror!: database development for the masses again, with a BASIC-like language, now all over the net! :-) Seth > Cheers -Terry > > -- > 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. > -- 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.
