Creating My DVD Movie Database

Stephen stephen-d-bJEeYj9oJeDQT0dZR+AlfA at public.gmane.org
Sun Jul 4 03:39:13 UTC 2010


I know nothing about sqlite other than that it exists.

I already have MySQL installed, use it, and know it as well as I need 
to. I use it as the database for my web sites, and for Mediatomb.

Stephen

On 10-07-03 11:35 PM, ted leslie wrote:
> 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
>>
>>      
>
>    

--
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





More information about the Legacy mailing list