[Novalug] Database advice
tom at tomgoldsmith.com
Sun Mar 14 14:46:05 EDT 2010
I've about worn my copy to shreds. This has been really useful to me,
both from the standpoint of understanding MySQL and of understanding
On Sun, 2010-03-14 at 14:08 -0400, Bonnie Dalzell wrote:
> I finally found a front end for creating databases in Linux. It is called
> Razor SQL and it is pretty reasonably priced, as in roughly $70 and with a
> 30 day trial and a pretty decent manual.
> However the dog pedigree record set has 55,000 records in it - and
> around 25
> fields. I will want to do indices on almost all of the fields.
> I had thought to try SQLite as the DB base. Are 55,000+ records too many
> for SQLite? Do I need to do MySQL instead?
> Also does anyone have the time to explain to me the strategy for linking a
> field in a record to another record line within MySQL or SQLite? For a
> given record the mother and father will have record numbers and will be in
> the main record set. What is the term for picking up a link to another
> record in the database to put as a reference in a record? I am sure if I
> know the term I can find a tutorial on doing it.
> My Perl program knows how to look up the parent record, it just goes back
> to the main record number based index and then finds the parent record
> by record number because the parent id is stored in the offspring's
> record as a record number.
> This DB stuff is confusing to get started with.
> Bonnie Dalzell, MA
> mail:5100 Hydes Rd PO Box 60, Hydes,MD,USA 21082-0060|EMAIL:bdalzell at qis.net
> Freelance anatomist, vertebrate paleontologist, writer, illustrator, dog
> breeder, computer nerd & iconoclast... Borzoi info at www.borzois.com.
> HOME www.batw.net ART bdalzellart.batw.net BUSINESS www.boardingatwedge.com
> Novalug mailing list
> Novalug at calypso.tux.org
More information about the Novalug