Re: Small Database Software Recommendation

From: Ryan Thompson (ryan_at_sasknow.com)
Date: 06/22/03

  • Next message: Rob: "Re: FreeBSD vs "The Others" Brochure" 
    Date: Sat, 21 Jun 2003 19:45:36 -0600 (CST)
To: Rod Person <roddierod@hotpop.com>

    Rod Person wrote to freebsd-questions@freebsd.org:

    > Hi Guys,
    >
    > I'm looking for a small database application to create a database of all
    > may dvds and cds. I think mysql my be too much overkill, since it would
    > be running on my laptop. Any suggestions.

    Yes.

    It's raining in Saskatoon. Feels like a rant coming on. :-)

    Fully define the requirements before choosing the technology.

    MySQL *might* be overkill. I could recommend anything from flat files to
    Oracle, though, and be wrong, depending on exactly what it is you want
    to accomplish. For a simple key/value hash that you might encounter in
    the decades old "album catalogue" problem, Berkeley DB, or maybe Perl's
    built-in %hash functions would be the way to go.

    Consider your requirements. What is the system for? Who will be using
    it? What hidden and evident features must it have? What *tasks* (a.k.a.
    "use cases") will the users carry out? What other less tangible goals
    are to be accomplished by the system? Which constraints and standards
    must the system adhere to?

    Once you have the above, you can begin to consider the architecture of
    your system, and, once you've done that, choosing a specific technology
    might be appropriate.

    Requirements specification is *never* overkill.

    As far as defining less tangible goals, though, "I want to learn ${X}"
    is a valid goal.

    Hope this helps,
    - Ryan 

    -- 
  Ryan Thompson <ryan@sasknow.com>
  SaskNow Technologies - http://www.sasknow.com
  901-1st Avenue North - Saskatoon, SK - S7K 1Y4
        Tel: 306-664-3600   Fax: 306-244-7037   Saskatoon
  Toll-Free: 877-727-5669     (877-SASKNOW)     North America
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"
  • Next message: Rob: "Re: FreeBSD vs "The Others" Brochure"

    Relevant Pages

    • Problem solving examples
      ... If you need some examples of problem solving using database ... technology, here are a couple examples I developed in mysql, but could ... Hexagonal puzzle solution: ...
      (comp.databases)
    • Re: You can now verify positively if it is due to statin adverse effects Re: memory loss after CABG
      ... >>Commerical off the shelf data base programs are available and some of them ... The size of a database where "millions of data items will be processed ... computer technology and industrial productivity. ... the publication, page number, the center responsible for the technology, and ...
      (sci.med.cardiology)
    • Re: MySQL Database problem (probably already solved in a message, but this is somewhat urgent)
      ... MySQL server has a database with a table, ... columns, an FSR column, and a password column. ... checked if the supposed arrays that were returned were actually arrays ...
      (comp.lang.php)
    • Re: NanoMark Technologies Website Text - Makes Sense To Me Except For The "Second Amendment" Fal
      ... The technology places an identification mark on each cartridge casing ejected from a properly outfitted firearm at the moment of firing each bullet. ... it is hoped that a computer can compare one physical piece of evidence to a virtual picture of the first ammunition fired by a firearm. ... This has called into question the concept of ballistic fingerprint database technology's readiness by some of the most respected Forensic Firearms Examiners in the world. ... it does not require extensive cross-jurisdictional ballistic image databases or a national ballistic image database containing the files of new guns sold every year. ...
      (talk.politics.guns)
    • RE: FreeBSD 5.3 MySQL Performance
      ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
      (freebsd-questions)