I have way too many books in my house.
One of the challenges of having too many books, is that sometimes (and with increasingly alarming frequency) I end up buying the same book twice!
So I decided to create a simple database using Access 2007.
Creating the schema was fairly trivial. It consisted of three tables:
Book (BookID, Title)
Authors (AuthorID, FirstName, LastName)
AuthorBookMap (AMID, BookID, AuthorID)
Once I got my tables, I wanted to create, what I thought was a fairly simple data-entry mechanism:Imagine a button: AddNewBook
Which would take me to a wizard:
ask for book title
ask for author (s)
Which would then conclude with the action of
update book and author table and add authorbookmap entry.
Turns out that this simple activity is non trivial, and is turning into an illuminating, and informative experience into the very nature of how MS Apps are put together.
Because, for whatever reason, the company that popularized or pioneered wizards did not think that having wizard creation tools in the most popular database on the planet was a necessity.
I am now struggling to understand how you use VB 6.5 (Visual Basic 6.5) to create a wizard. And I believe it is possible, but the complexity is staggering!
Databases are awesome. I think I have spent a couple of years in my professional and non professional life building apps with them.
I you are interested in projects that catalog your books out there I cannot help but recommend these three:
http://www.librarything.com/ – For the web
http://www.delicious-monster.com/ – For the Mac
http://www.imediaman.com/products/mediaman/product-overview.html – For windows
Mediaman is a complete ripoff of Delicious but what is cool is that it runs on windows which I know you are a big fan of.
In any case if you buy a cheap bar code reader you can enter in all your books with blinding speed!
Try Filemaker or a slimdown “Bento”.
I believe that it even comes with template that will let you manage
your library without any programming.
Pingback: Day to Day Nonesense » Who owns my data?