I’ve been using AppleWorks to catalog my videotapes and DVDs. I made a really detailed database and some nice layouts to go with it; I even had an image field for the covers and screenshots. I catalogued about 85 tapes full of stuff, and then suddenly the database got corrupted or something, so it keeps crashing on me! There were about 500 records in the db, and there’s a certain record in there that can’t be viewed, it causes a crash every time. I’ve tried everything, the only apparent option is to rebuild the database without using the pictures, I guess. I can only assume it’s the pictures that are choking it up. Ugh.
I really want to find a good relational database to use instead of AppleWorks. I need one that’ll let me link separate databases to each other… i.e. to pull from a db of actors or directors, or names of movies and TV shows etc. That way it would be a lot more efficient; I wouldn’t have to repeat so much info from record to record.
The only database I have that works that way is HanDbase, which is only for the PalmPilot, which I don’t use anymore. I had exported all my HanDbase data into CSV text files, but I have nowhere to import them without losing the relational aspect… they’re all connected to each other, see.
Now that Apple’s come out with X11 so we can more easily run Unix programs, maybe there’s something out there that I can use. I don’t know jack about databases, so if anybody knows a good one that might work on OS X (natively or via X11), please let me know!