The Magic Café
[ Lost Password ]
  [ Forgot Username ]
The Magic Cafe Forum Index » » Where to put it all... » » Databases (0 Likes) Printer Friendly Version

View Profile
Loyal user
222 Posts

Profile of mikejorden
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
View Profile
Inner circle
St. Louis, MO
1419 Posts

Profile of MacGyver
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
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...
View Profile
Inner circle
Yorktown, Virginia (Previously Germany)
1579 Posts

Profile of RiffClown
I use an Excel Spreadheet.
Rob "Riff, the Magical Clown" Eubank aka RiffClown
<BR>Magic is not the method, but the presentation.
View Profile
Special user
Nassau Bay, TX
533 Posts

Profile of RayBanks
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:

For info on Version 3 and this one:

for the whole thread.
Pick a card, any card...No. not THAT one...THIS one

Ray Banks
View Profile
Loyal user
222 Posts

Profile of mikejorden
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
View Profile
Loyal user
Bellevue, WA
273 Posts

Profile of thimblerig
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?
View Profile
Loyal user
222 Posts

Profile of mikejorden
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.
View Profile
New user
71 Posts

Profile of hokeypokey
FYI, there is a similar thread here in which a Café user is considering developing a similar database.
View Profile
Regular user
171 Posts

Profile of wcb39
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-2021 Steve Brooks. All Rights Reserved.
This page was created in 0.1 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 <

ROTFL Billions and billions served! ROTFL