[Netarchivesuite-devel] Database Guidelines

[Søren Vejrup Carlsen]

Hi Colin.
It would be preferable to have only one database for the harvester module.
However it may not be worth the effort to make our unittests work, as you need to then re-enter entries necesary for the unittests to work.

Anyway, our database migration infrastructure makes it unnecessary to actually migrate to a new format,as migration is done on the fly during initialization.
Each DAO-initializer should check in its constructor the versions of the tables required for it to function properly.

Look in the JobDBDAO contructor for how it should be done.

regards
Søren
-----Oprindelig meddelelse-----
Fra: netarchivesuite-devel-bounces at lists.gforge.statsbiblioteket.dk [mailto:netarchivesuite-devel-bounces at lists.gforge.statsbiblioteket.dk] På vegne af Colin Rosenthal
Sendt: 27. november 2009 11:01
Til: netarchivesuite-devel at lists.gforge.statsbiblioteket.dk
Emne: Re: [Netarchivesuite-devel] Database Guidelines

I notice also that the various sub-packages in the harvester module have 
their own copies of fullhddb.jar in their data. Should
these all be identical. If not, why not? If so, why have them at all? 
Shouldn't we have, or do we have, an ant task to keep the
multiple copies of fullhddb.jar synchronised with the schema in 
createfullhddb.sql?

Colin

Colin Rosenthal wrote:
> Hi all,
>
> Creating a model for global crawler traps requires some new tables in 
> the database. Do we have any guidelines for this?
> For example, I note that our derby db schema has no foreign key 
> constraints even when they would appear to be
> indicated. Is this a general policy?
>
>
> --
> Colin
>
> _______________________________________________
> Netarchivesuite-devel mailing list
> Netarchivesuite-devel at lists.gforge.statsbiblioteket.dk
> https://lists.gforge.statsbiblioteket.dk/mailman/listinfo/netarchivesuite-devel
>   

_______________________________________________
Netarchivesuite-devel mailing list
Netarchivesuite-devel at lists.gforge.statsbiblioteket.dk
https://lists.gforge.statsbiblioteket.dk/mailman/listinfo/netarchivesuite-devel