Creating My DVD Movie Database

[CLIFFORD ILKAY]

On 07/03/2010 10:36 PM, Stephen 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.

You could do that if you want to create more work for yourself, I suppose.

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

This would make a very good first project in Django 
<http://djangoproject.com>. It sounds like you already know what your 
models are supposed to be. You just have to express them in Python and 
Django will take care of creating all the necessary database objects and 
provide an auto-generated admin interface that will enable you to do 
CRUD (Create, Read, Update, Delete) operations without having to write a 
single form. You're not stuck with just using MySQL either. By doing 
nothing more than changing the database connection strings, you can swap 
out SQLite, PostgreSQL, Oracle, DB/2, or MS SQL Server for MySQL. Django 
will take care of the rest.

Download Django and go through the tutorial. You should be able to build 
this little app simultaneously with the tutorial. If you get stuck, just 
ask for help on IRC and/or the mailing list. The community is friendly, 
knowledgeable, and helpful.
-- 
Regards,

Clifford Ilkay
Dinamis
1419-3266 Yonge St.
Toronto, ON
Canada  M4N 3P6

<http://dinamis.com>
+1 416-410-3326
--
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