I submitted the guide selection form for doing my DOEACC A Level projects yesterday. I had to choose a ‘Software platform’ to code on. My primary choice was of course Python, but unfortunately there’s no guide available at the Institute with any expertise in Python. Hence, I had to choose PHP/MySql as my language!
The trouble is, I don’t know PHP at all! I’ve begun to learn it from some ebooks and w3schhols, and so far, my take on the language is pretty good.
The syntax is not as lucid and natural as Python (obviously!), but I’m really enjoying the way it can be used to manipulate HTML stuff! Since I’ve never done any web programming at all, this entire concept is like a new toy for me. Currently, I’m playing with connecting to a mysql database server (I’m fairly comfortable with SQL stuf) and viewing the result of my queries on the browser. The only time I need to stop is to check on with HTML syntax, because I am not at all well versed with HTML at all. Perhaps a bit of Javascript knowledge would also come in handy.

The idea of the project I have in mind is to develop some kind of a Ebook Library Manager. For long, I myself have felt the need of such an application to manage my reasonably large collection (nearly 2 gigs) of ebooks I have on my hard disk. None of the existing collection managers (like GCstar, Alexandria,etc) catered to my needs, so I needed to write an application of my own. Originally, my plan was to do it in Python with an Sqlite3 database backend and WxPython for the GUI. Now, Php would replace Python, MySql would replace Sqlite, and of course, there would be no need for a GUI toolkit as the frontend will be handled on the web browser itself by using HTML/JS. This is a rather good thing because I won’t have to worry about the WxPython codes, which is quite difficult & time consuming to perfect(esp. the layouts & alignments) in absence of a proper RAD tool. Also, the program will now be web-based & hence platform independent with no need for a specific GUI toolkit to be installed. On the downside, using PHP and MySql makes running a webserver like Apache mandatory, which sounds a bit overkill & out-of-context since the purpose of the program is to manage local ebooks. And I have to learn PHP, HTML and Javascript fairly well before starting the project.

I hope that this idea qualifies as a valid A Level Project, esp. with the aprox. 350 man hours involvement requirement posed my DOEACC. Formal allocation of guide and commencement of projects will begin from 3rd week of February. I intend to have a working draft of the project by then to show. Till then, onwards to w3schhols and the PHP Manual!