[Babase] Males data -- somewhat urgent update

Karl O. Pinc kop at meme.com
Sat Mar 8 11:57:05 EST 2008


On 03/08/2008 04:04:03 PM, Susan Alberts wrote:

> Yes, Lacey I think this is a really good idea. You sent me a word  
> document - that could be posted to the mailing list with just a  
> little more explanation and perhaps something like "members self  
> joins" in subject line or "extracting durations from members" or  
> something.

I think either attach the word document to a wiki page or cut
and paste it into the wiki.  That way it will be on the web
for everybody.  (I think this is what got me looking at
the Babase SQL tutorial on the wiki.  Self joins are pretty much
a must to get intervals between 2 events stored in the same table.
Because it seems like this sort of question is often asked
it seems like it'd be good to have some sort of self-join
something in the tutorial.  Maybe have an "advanced" section.)

> 
> I also think that, when we are back in the mode of enhancing babase  
> (with luck, next year some time) we need to make this a view.

A view might or might not run fast enough.  There are other choices.
We'll wait and see.

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list