|
|
mikejorden Loyal user 222 Posts |
Because I can never remember what is on my collection of Videos & DVD's I decided to make a computer database of all items.
Has anyone else done this? If so I would be interested how they classify each item. So far my database classifies each video/dvd by Title, Author, and each effect (together with description of the effect) The effects are subdivided by: * what it uses (cards, coins etc etc) * Close-Up, Stand-Up, Stage, "other" or Sleight/Move * Comedy, Mentalism. I would be interested in your input |
MacGyver Inner circle St. Louis, MO 1419 Posts |
I have made a MySQL database for all my tricks, but haven't done books/video's yet.
A good idea would be to make different tables, one for tricks, and one for video's, then give each video a video_id and have each trick point to what video is on it, so that way you can look at tricks seprate of video's. My trick table looks something like this: ENUM column of Card, Coin, Money, Other ENUM column of Magic, Funny, Child, Gambler, Mentalist, Other A Title Description A 1-10 rating column where I rate my effects A "need" column, that includes whatever you need to perform said effect. And now I'll probably add a vid_id column as well... |
RiffClown Inner circle Yorktown, Virginia (Previously Germany) 1579 Posts |
I use an Excel Spreadheet.
Rob "Riff, the Magical Clown" Eubank aka RiffClown
<BR>http://www.riffclown.com <BR>Magic is not the method, but the presentation. |
RayBanks Special user Nassau Bay, TX 533 Posts |
One of the regular contributors (Tony) to the Magic and Illusion forum has developed a database in Access 2000.
He is currently on Version 3 and it should be available pretty soon. I've looked at the earlier versions and it definitely has possibilities. Try this link: http://forums.about.com/ab-magic/messages?msg=4585.36 For info on Version 3 and this one: http://forums.about.com/ab-magic/messages?msg=4585.1 for the whole thread.
-------------
Pick a card, any card...No. not THAT one...THIS one Ray Banks |
mikejorden Loyal user 222 Posts |
Thanks for the input. For those interested I am writing mine in Clarion which is a WYSIWYG
language. It's "stand alone" program on which I can put icons & pictures. I didn't include effects because I basically know them but DVD & Videos are a problem. So far I've cataloged 48 DVD/Videos and have 470 entries. It's a labor of love |
thimblerig Loyal user Bellevue, WA 273 Posts |
OK,
Glad somebody brought this up. What I really want is a user friendly desktop database that is compatible with a "little brother" on my Palm OS Sony Clie. I'd like to keep the database current on the PC and download to the Palm for travel, so when I'm out of town I can check my Clie for what I have/don't have. Anybody got a line on anything like that? Thanks! Cordially, tr |
mikejorden Loyal user 222 Posts |
A nice thought, thimblerig. As I only perform about 30 effects I don't really need a sophisticated DB for them - but the list is downloaded onto my Palm.
I originally started this topic as a DB for Videos & DVD´s. There is so much information on these that it is impossible to remember everything and I like to keep referring to it in order that I can research different methods and presentations for the effects I do. |
hokeypokey New user Chicago 71 Posts |
FYI, there is a similar thread here in which a Café user is considering developing a similar database.
|
wcb39 Regular user 172 Posts |
I am very pedestrian when it comes to computers so I just use Word and set up files just like you would if they were in a filing cabinet.
|
The Magic Cafe Forum Index » » Where to put it all... » » Databases (0 Likes) |
[ Top of Page ] |
All content & postings Copyright © 2001-2024 Steve Brooks. All Rights Reserved. This page was created in 0.02 seconds requiring 5 database queries. |
The views and comments expressed on The Magic Café are not necessarily those of The Magic Café, Steve Brooks, or Steve Brooks Magic. > Privacy Statement < |