WAMP Architecture
Wednesday, February 15. 2006
Setting up Apache, MySQL, and PHP/Perl on your own personal Windows' based machine? Don't really know how to do it? Worried about security? I'm not really much of an enthusiast over pre-made packages that auto-install all 4 (and, actually more) software packages on to your local computer for development purposes, but this one actually seems really, really nice. I can't take the full credit for finding this, as someone else pointed me to it as I was trying to help them install these packages individually, but the features seem really, really nice:
- The security of your server is one of our #1 concerns and with that, we tend to set every single default setting as if your server will be used in production.
- Other security measures we take is that we update our package with every new release of PHP, MySQL, Perl, phpMyAdmin, and the Apache HTTPd Server.
- Supports plugins
- Web-Based administration page (Alpha)
- SSL Support OUT OF THE BOX
Plugins:
- FTP (x2)
- Java servlet engine(s) (Resin and/or Tomcat)
- PHP4 downgrade
- ActivePython (I didn't even know this existed ... time for a new download)
- Stunnel
- Admin Panel and Web-Based Admin
- Zend Optimizer (future plan)
I would suggest this to anyone just starting out now that I've seen it. If it didn't use Apache 2.0, I might even use it myself.
- The security of your server is one of our #1 concerns and with that, we tend to set every single default setting as if your server will be used in production.
- Other security measures we take is that we update our package with every new release of PHP, MySQL, Perl, phpMyAdmin, and the Apache HTTPd Server.
- Supports plugins
- Web-Based administration page (Alpha)
- SSL Support OUT OF THE BOX
Plugins:
- FTP (x2)
- Java servlet engine(s) (Resin and/or Tomcat)
- PHP4 downgrade
- ActivePython (I didn't even know this existed ... time for a new download)
- Stunnel
- Admin Panel and Web-Based Admin
- Zend Optimizer (future plan)
I would suggest this to anyone just starting out now that I've seen it. If it didn't use Apache 2.0, I might even use it myself.
MySQL Development Tools
Tuesday, February 7. 2006
I've been waiting for a tool like Microsoft Visio's diagramming (ERD) that would also create/use the related SQL instructions. One would think that Microsoft would have added something like this in their 2003 version of the software - now one can only hope it's in the 2007 version.
I've been using SQLyog as my SQL management solution tool of choice, and it's definately a great product, one which I really need to pay for the retail version and register (just because it's indisposable, even compared to the MySQL AB Team's tools, in my opinion). Unfortunately for SQLyog, one of their features on the roadmap was to create a diagramming tool, which was a big reason for me sticking with it and continually download the updates and get used to the software. They have yet to incorporate this, but I've found something that does.
I've been using SQLyog as my SQL management solution tool of choice, and it's definately a great product, one which I really need to pay for the retail version and register (just because it's indisposable, even compared to the MySQL AB Team's tools, in my opinion). Unfortunately for SQLyog, one of their features on the roadmap was to create a diagramming tool, which was a big reason for me sticking with it and continually download the updates and get used to the software. They have yet to incorporate this, but I've found something that does.
Continue reading "MySQL Development Tools"
