While i’m on the topic of Google Maps, I decided to bookmark Pamela’s other article which is more like an introduction on how to use Google Maps with a MySql database. Related article - Using PHP and MySQL to create KML.

This topic comes up frquently enough to warrant a bookmark to Pamela Fox’s how-to on a Store Locator with PHP, MySQL & Google Maps. Being on the Google Geo APIs Team, i can’t wait to dive into this.

I’ve bumped into PHP scripts like this before, but haven’t bookmarked them until now.

Chyrp appears to be a light weight blogging engine, done in PHP/mySQL (some Ajax) and is “loosely based on the MVC design pattern.”. It’s been recently upgraded. I don’t like the fact you need to give an email for a live demo, but at least you can download the code.

Chyrp is a blogging engine designed to be very lightweight while retaining functionality. It is driven by PHP and MySQL (with some AJAX thrown in), and has a pimpin’ theme and module engine, so you can personalize it however you want.

John Gruber picked up on this (and so did i) that Cameron Hunt switched from Tumblr to Chyrp, an interesting endorsement.

You may think with “125.125.1.1″, you would want a VarChar type of field. That would be my first instinct until this tip made me think. If you are storing an IP Address in MySql (or any database for that matter) it’s better to store it as an Integer. MySQL has two built-in functions: INET_ATON() and INET_NTOA() to convert the IP. This allows for better storage and possible indexing.

Sun Acquires MySQL

Perishable Press presents a simple method for dramatically decreasing the size of your WordPress database by partially emptying old data from the WP-ShortStat. I personally use this plugin, so i’m bookmarking this for me to consider six months down the road.

I work with MySQL more than any other database, so naturally I want to bookmark some interesting reading. I’m currently reading 10 Tips for optimizing mysql queries and 10 Tips for Optimizing MySQL Queries (That don’t suck), both I found referenced here.