|
|
procy New user 87 Posts |
Hi,
I am looking for a database to store information on effects in my books and DVD's. Before I try and make one in Access, I wondered if there was any commercial ones available and if so are they any good? Thanks Simon |
Jamie Ferguson Inner circle Alba Gu Brà th 3640 Posts |
Good question, I'd like to know too.
I keep a list in excel but would be good to have something a little more flexible.
When the chips are down, the duvet is uncomfortable.
|
John C Eternal Order I THINK therefore I wrote 12938 Posts |
If you have a tablet ipad I can recommended a great database otherwise there's a nice easy to work database for PC called brilliant database that can create such an app fairly easy.
|
Jamie Ferguson Inner circle Alba Gu Brà th 3640 Posts |
Hi John
I have an ipad. Please would you let me know what database you would recommend. Many thanks Jamie.
When the chips are down, the duvet is uncomfortable.
|
muse Special user Scotland 925 Posts |
I use Filemaker Pro, as I have it for other uses anyway. Expensive but very flexible
|
btedeski Veteran user Pittsburgh PA 322 Posts |
It's not the database, it's the front end access to the database that is important.
I have used both Access and Filemaker Pro and both are great tools to build a database with, filemaker has the edge when it comes to building a front end to access it. but for the fun of it I looked out on Source Forge to find out what is available They have a second on Knowledge Management, with free document management systems http://sourceforge.net/directory/busines......updated/ Take a look,, |
John C Eternal Order I THINK therefore I wrote 12938 Posts |
Quote:
On 2012-11-07 05:33, Jamie Ferguson wrote: I use this for android, I don't think it runs on ipad: http://mementodatabase.com/ There's also this: Listmaster and Sailforms + All three of these can do what you want. On PC it's Brilliant Database. John PS: I use front end and database interchangebly. You have to have a datainput screen and a place to hold data. Databases usually do all this. |
pabloinus Inner circle 1683 Posts |
I use Handbase for IPAD, and it is very good
|
atkinsod Regular user VA 196 Posts |
I had always wanted to place the contents of my magic book table of contents listings on magicref.tripod.com into a database, rather than just plain HTML format. The idea would have been to have a database back end, and a Web-based front-end to pull the info into a nice, readable page. However, when I first started the project around 10 years ago, the free webhost I used didn't support anything like this, and I knew very little about implementing databases on a web-site (and still don't). Dennis Behr has done a nice job on his website (http://archive.denisbehr.de/) and I believe it is a custom database he put together.
Today it would take so much effort for me to port the over 1000 book contents to a database format, that it is far down the to-do list! Doug A. |
Chris Inner circle lybrary.com 1177 Posts |
While I am not yet really ready to make a public announcement I am going to give you guys an early look at a new tool I am working on which I think will solve a couple of problems with this database for magic situation.
The biggest problem with all of the existing solutions, be it dedicated database programs or simple spreadsheets or Word documents, is the fact that they start out empty. One has to type in the meta-data which is a major pain in the neck unless you have only a handful of items. But then you probably would not need a database program to begin with. Isn't it really stupid that we all are typing in essentially the same information over and over again? To fix this problem my database for magic books/ebooks/DVDs/posters (and potentially tricks and effects) comes already pre-loaded with meta-data so that for the most part you will have to simply click a check box indicating that you have a particular edition. On top of that I allow users to edit and add additional information. Through the power of crowd sourcing the database will get better and more complete as we go on. Another cool feature of this tool is a built in pricing tool and marketplace to sell and buy magic books. Once you indicated that you own a particular title or edition you can enter the price you paid and the date you bought this book. If enough people do that my software can then process this price information and spit out estimated values or min/max ranges for books. It even calculates a value of your entire collection and you can print out a PDF report of your titles, something quite useful if you want to insure your collection. You can also offer any of your books for sale with an asking price. Others can indicate that they are looking for a particular book. My tool then allows to have seller and buyer connect via email to negotiate on the final price and enter a deal. Even cooler is the fact that this will be completely free. No software to purchase no subscription to pay. All you need is to register a Lybrary.com customer account and subscribe to my magic newsletter. Then you have access to the 'My Magic Library' feature which is already accessible through the Tools section in your Lybrary account. Check it out and let me know what you think. I am very happy to get suggestions of how to further improve it. The tool is for the most part functional. The PDF reporting feature is rudimentary. There will be a lot more available further down the line. Also the amount of data in the database right now is small. But it is a start and more will be added. If you think this is a good idea and want to help populate the database please feel free to add new titles/editions. When you add a new title or edition you can edit it for 2 days. You can even delete it if you are not happy with it. After the 2 day period you can still edit it but any edit will go through a review process and is therefore not immediately reflected in the database. This is simply to prevent vandalism of the data already in the database. Well, give it a try and email me, PM me or post here on this thread what you think about it.
Lybrary.com preserving magic one book at a time.
|
Uli Weigel Inner circle Berlin, Germany 1478 Posts |
The problem is, that the information we want to access and manage is so diverse. And we all have different needs. I use a personal information manager, that I'm very happy with (unfortunately only available in german). But there are many similar tools available. Two good ones, which I have tried and tested myself are Treepad (http://www.treepad.com) and especially TreeDBNotes (http://www.mytreedb.com). This type of software has three main advantages: ease of use, capacity and utmost flexibility.
|
Chris Inner circle lybrary.com 1177 Posts |
I would think that we can come up with a generally accepted and useful database structure that works for most magicians. Catch all fields can be added for anything special some might need.
I am happy to make changes to the database I created if I get feedback and suggestions. Of course, I will not be able to satisfy any wild need, but if it is something that looks useful for more than one I will try to add it.
Lybrary.com preserving magic one book at a time.
|
Danny Kazam Inner circle 1516 Posts |
This might be what you are looking for.
http://magiciansoftware.com/ COPIED FROM THE WEBSITE INFO: The Magic DataBaseâ„¢ was created when its author wanted to find the book that described a trick he had done years previously. Unfortunately, he couldn't remember which of his books contained the description. At that moment, the idea of a computerized system that would allow the search for information by keywords, or props, etc. was born. Along the way, The Magic DataBaseâ„¢ became a way for organizing more than just tricks. A magician's props and books were added to the database's features. Additionally, users of The Magic DataBaseâ„¢ are given the ability to share data among themselves. This will allow users to find interesting material in books they were planning to purchase. Perhaps some day, publishers of magic books will post their own export files on the internet, to allow readers to easily find material that meets their explicit needs.
Keep your dreams alive. Understand to achieve anything requires faith and belief in yourself, vision, hard work, determination, and dedication. Remember all things are possible for those who believe.
|
DonB! Regular user Minnesota 170 Posts |
For a MAC, I have been using Librarian Pro, and it is designed for books, Movies, and other forms of media.
I used it to catalog the 2500 magic books that I am selling for the library owner, and it really works great, and offers a lot of information. DonB |
Dr. Van Van Mojo Special user 570 Posts |
|
The Magic Cafe Forum Index » » Ebooks, PDF's or Downloads » » Database to store tricks, books and DVD contents (0 Likes) |
[ Top of Page ] |
All content & postings Copyright © 2001-2024 Steve Brooks. All Rights Reserved. This page was created in 0.04 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 < |