I read a lot of books and as such own a lot of books. I thought it would be fun as a hobby to build a MySQL database to track all the books I have with quotes, topics, etc that I can search in the future. I would like to make a gui front end for this. My question is would Apple Studio be good for a project like this? I am new to MACs and Applescript as well. If Apple Studio wouldn’t be good for this then can anyone recommend an good program/code to use to do this?
I’m not sure how easy it is to connect to MySQL servers via Applescript. I do know that it is pretty easy in PHP if you know how to code fairly well. You can grab both the latest MySQL build and PHP build for MacOS X from here.
Since OS X comes with a built in Apache webserver, you could run your whole DB out of a browser. You could also have it be cross platform and access it from any browser enabled machine (assuming you have a network connection or a LAN)
All of that said…
I would be very interested in seeing how to Applescript MySQL