So I’ve been dragged somewhat reluctantly back into the software development world, working on a PHP interface that lets users search our content database stored in MySQL. Basically there’s nobody else available to work on this, so I’m jumping in to help out even though I kinda suck as a programmer.
This is my first experience in the LAMP world (Linux, Apache, MySQL, PHP). My last official job as a software engineer involved JSP and Java connecting to Sybase. For that we used primarily Eclipse, plus a little Sybase command-line shell that I’d access thru my Linux shell account.
For this LAMP work I’m using a weird mix of open source, free, and commercial software. For the PHP code I’m editing in Dreamweaver, mostly because I use it for a few other projects so rather than fire up both Dreamweaver and Eclipse I just edit the PHP code in Dreamweaver.
Unfortunately I can’t get WebDAV working right so I’m editing the PHP file locally, then I use WinSCP to copy the file up to the Apache docroot. And when I have to run test queries in the MySQL database I’ve been using SQLyog.
Are there better options to replace some of the tools I already am using? And what other tools have you found useful when working in this LAMP world?
