Archive for the “SQL” category
PHP ActiveRecord Available for Beta Testing
by Kien La on May 19, 2009
We’ve been working hard to get this ready for people to start poking around in and we’re happy to announce that it’s now ready for public beta testing! You can grab it from http://github.com/kla/php-activerecord/. Play with it… break it… and (…)
PHP GIS Functions
by Clay vanSchalkwijk on April 14, 2009
I have been working a lot of with PHP and GIS consulting for CitySquares and the History Engine. I found searching for everything I needed to do basic processing & Google Integration tedious and painful. So here is a collection (…)
SQL script to grab the worst performing indexes
by Clay vanSchalkwijk on February 11, 2009
I have been doing a lot of auditing and clean up of database performance the last few days. We are currently in the middle of a migration and with hardware infrastructure in place it is time to go back and (…)
MySQL Proxy Quick Start
by Clay vanSchalkwijk on February 10, 2009
There isn’t too much out there for easy reliable mysql load balancing. I recently built a master/master mysqld setup and needed automatic roll over on the software side. After going through the options I ended up going with MySQL Proxy (…)
There and Back Again, an EC2 MySQL Cluster
by Clay vanSchalkwijk on January 26, 2009
Limitations of EC2 as a web platform: Price- An m1.xlarge instance will run you ~$600 with data transfer costs. Managed hosting solutions run cheaper especially if you plan on purchasing in bulk. The grid is designed for on-demand computation and (…)