I'm a newbie with absolutely no experience of databases. I need to find a solution to help me catalogue and manage the use of my 35mm slide collection, and Cardbox has been suggested as a way forward. The full details of what I'm trying to do can be found at http://screencast.com/t/jJCw2JMcSJ
Martin Kochanski has been kind enough to have a look at this and says that he thinks Cardbox could do all that I want except perhaps for the last of my requirements. He suggested that I post this message to see if any experienced Cardbox user had thoughts on this point, so it's over to you!
In another application for my job I also store images. Into the record is also the jpg file stored. So the image is showed ++ it works as file container.
For a beginner there is a way to go to develop this. However, I cannot find an alternative for such a thing then Cardbox.
First try to know what you want. If that is clear, you will find a way to make it with Cardbox.
Entirely agree with Bert. I also use Cardbox for both books and image files. I am also not very experienced and even reading what Bert said I can see I could improve my database, if I understood it. But with my limited knowledge I find Cardbox ideal. I have two separate databases of 134GB and 9 GB respectively. Highly recommended.
I can assure you that Cardbox is perfect for the job. I read what you want to do and I don't believe this will be a problem. Your collection is now ordered by subject or category, and you already noticed yourself that this method has its limitations.
The core of your database can be very straightforward: a field containing the master number (the slide's ID), the pocket number and a field containing keywords that identify what the slide is about. That's enough to find any slides on a particular subject, to know where they are and to see that you have the right ones by checking the master number.
My advice is to start with such a simple database and keep it small (100 records or so) to get the feel of Cardbox. You can always change anything you like, or better: anything you don't like.
The next step might be to add an image field. There's no need to reorganise the existing small database: just add the image field. Add some pictures. At this stage they need not be the actual scans of your slides. For experimental purposes you could use any picture. Keep the images smallish: 700 to 800 pixels is a good average.
When your satisfied that your database meets your needs, you can take it a step further.
Create another database. Give the records (at least) three fields: date, name of the audience and master number of the slide. Let's call the slide database SLIDES and this database TALKS.
Now suppose you have all your slides in SLIDES and 100 talks in TALKS. You can now use the relational search capabilities of Cardbox. I will not discuss them at length here; that's too heavy for a newbie :-)
You can open both databases.
You can also make a selection of slides in SLIDES for a certain audience, select the same audience in TALKS and exclude all previously used slides from your selection in SLIDES.
Yes, Cardbox is perfect for the job.
|© 2010 Cardbox Software Limited|