Creating My DVD Movie Database

[ted leslie]

why not use sqlite?
that way you can drop it down and run it anywhere and not have to worry about setup/admin of a db-server.
this is the type of thing sqlite is perfect for.


you also don't have to worry about table design for purpose of speed, as with that few records
(even if you expanded on it greatly), all your queries will be instant, as it will all cache in ram.



tl

On Sat, 03 Jul 2010 22:36:25 -0400
Stephen <stephen-d-bJEeYj9oJeDQT0dZR+AlfA at public.gmane.org> wrote:

> I have about 300 DVD movies.
> 
> I would like to create a database to support queries.
> 
> Movie Title
> Director
> Actors
> Themes
> 
> I will use MySQL.
> 
> Probably PHP and a web interface.
> 
> The work I am looking to simplify is the data entry. Specifically the 
> One->Many relationship between movie title and actors.
> 
> All tables will be normalized, and there will be a relationship table 
> for the movie_id>actor_id.
> 
> Any all suggestions appreciated.
> 
> Stephen
> --
> The Toronto Linux Users Group.      Meetings: http://gtalug.org/
> TLUG requests: Linux topics, No HTML, wrap text below 80 columns
> How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists
> 


-- 
ted leslie <tleslie-RBVUpeUoHUc at public.gmane.org>
--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists