[Babase] Merging JPSAMPS with FPSAMPS (and JPNEIGHBORS with
FPNEIGHBORS)
Susan Alberts
babase@www.eco.princeton.edu
Sat, 9 Oct 2004 17:12:26 +0300
>
>
>We've less than 100,000 JPSAMPS, so I've added 100,000 to the FPSAMPS
>and FPNEIGHBORS Fpid so the ids don't conflict when they're all
>put into one table. Does anybody care about the old ids at all?
>I could add 1,000,000 to the FPSAMPS ids just to make the new id
>the old id with a 1 on the left.
I don't think anyone has used the old IDs in queries yet, so perhaps
this is not an issue but again, others should comment. I think that
even if they have been used in a query, it would be relatively easy
to change it. My opinion is that we should not worry about it, but
someone closer to the database (especially Daphne) should comment.
>
>>
>>I think we should have a "type" field as you describe below.
>
>I think so too.
>
>>
>>Do you still have plans to come to Duke again soon? What are your
>>thoughts on this?
>
>I feel like one of those boom and bust dieters. When I go to duke
>I get lots of babase done but nothing else, and then after the
>binge have to do all the paperwork and other undone tasks here.
>The plan is to go for 2 weeks on Oct 11th, but I'd like not to
>go. I think progress on babase is going ok. I'm also scheduled
>to go to Princeton Nov 8 through 18th and I think by then
>I will need to go because they'll be enough done that I'll need
>feedback from people using the programs.
i certainly understand why you'd rather not come this month, I can
appreciate how hard it must be to change location all the time. As
you know my main concern is that we maintain momentum on the
database. My new demography postdoc is arriving this week, and i had
always envisioned that the conversion would be complete and the new
postgresql database up and running before he arrived. This obviously
isn't the case and I guess I haven't yet sorted out the implications
of this in terms of his work. I guess my feeling is that we should
just keep tabs on progress.
Perhaps it would be helpful if you sort of summarized where we are
right now -- i for one have lost track a bit of exactly where we are
versus where we wanted to be. What do we have left to do before we
have a fully functional postgresql database?
Susan
>
>At this point I'm kinda sorta done with the conversion, except
>that I need to speed it up (again) so it will run in less
>than a week.
>
>Karl <kop@meme.com>
>Free Software: "You don't pay back, you pay forward."
> -- Robert A. Heinlein
>_______________________________________________
>Babase mailing list
>Babase@www.eco.princeton.edu
>http://www.eco.princeton.edu/mailman/listinfo/babase
--
--------------------------------------------------------------------------------------------------------------------------------------
Susan Alberts, Department of Biology, Duke University, Box 90338,
Durham NC 27708
919-660-7272 (phone), 919-660-7293 (FAX)