[Babase] Merging JPSAMPS with FPSAMPS (and JPNEIGHBORS with
FPNEIGHBORS)
Stephanie Combes
babase@www.eco.princeton.edu
Mon, 11 Oct 2004 17:11:05 -0400
Just for reference: I've never used the old id's in a query. I don't
think we need to worry about them since we have the snames in place.
-steph
--On Saturday, October 09, 2004 5:12 PM +0300 Susan Alberts
<alberts@duke.edu> wrote:
>>
>>
>> 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)
> _______________________________________________
> Babase mailing list
> Babase@www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase