[Novalug] Database advice

[Tom Goldsmith]

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
databases generally.

http://tinyurl.com/ylkvslp

tg


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
> http://calypso.tux.org/mailman/listinfo/novalug