Back to the Basics - Turning on the LAMP.
Why handicapped? In the days of django, Rails, numerious MVC frameworks and ORMS that take much of the lower level database and routing out of building websites, why would someone go back to plain old PHP and SQL?
My reasoning is going back to plain PHP and SQL would make me better appreciate and understand MVC design and working with raw SQL queries – not fleeing from them. Moreover, due to the more OOP oritened nature of PHP5 that is avilable on most webservers –pritcularly hared servers - A.K.A. the classic LAMP stack (Linux, Apache, MySQL, and PHP) for web development would make deployment and installation much easier than a custom install requiring a virtual or dedicated server and worrying about scability, etc. I took up a challange to write fairly good code in PHP while keeping the good design, code seperation and clear organization.
Coming back to PHP was nice at first due to an easy install and no need to reload the code on the development server after making a change. However, the nice parts of the switch pretty much ended there. In an attempt to keep everything lean, I chose limonade as a simple PHP router and sinatra-like framework to clean up the admin routing and rendering MVC code while writing my own database model (using __call and PDO). Now, it’s nice to know more about .htaccess files and regex that I had not known starting out.
Overall, the journey has continued as expected, but the total control of the database schema and queries and how the queres get passed to the final page have bene interesting – things I’ve taken for granted with MVC frameworks and ORMs. I’m trying to keep the project lightweight and organized. I hope I’m succeeding – and if so – keep it that way.
(comments on hacker news)