Online PHP MySQL CRUD Scaffold generator

Monday, July 6th, 2009

I needed some simple PHP MySQL CRUD and found www.phpscaffold.com. Perfect!

MySQL, the new Cinderella

Tuesday, April 21st, 2009

Oracle tried to buy MySQL. Sun bought MySQL. Oracle buys Sun. MySQL will become Cinderella with the ugly stepmother Oracle mistreating her.

The power of greylisting is aided by whitelisting

Saturday, August 23rd, 2008

I've been running gld for more than two months now and it is truly efficient. The current statistics say: # of entries in the database         : 16077 # of one hit entries in the database : 15100 Oldest entry in database             : 65 days ago This means that almost 94% of the attempts to ...

WordPress crack attempt this morning!

Wednesday, April 16th, 2008

When I got to work and viewed this blog I noticed that Sidebar Widgets was disabled. I thought "That's weird!" When I tried to login to the administration interface I was told that my WordPress database needed upgrading. I thought "That's weird!" Some further investigation revealed that someone managed to upload a ...

Sun buys MySQL AB!

Wednesday, January 16th, 2008

Read more at MySQL.com and Sun.com. Good it's not Oracle. Oracle, on the other hand, managed to buy BEA.

MySQL support for UTF-8 in Ruby on Rails

Tuesday, December 11th, 2007

As a follow-up to my post about MySQL support for UTF-8 in PHP, here is the very same information for Ruby on Rails. In Rails it is a simple configuration entry in config/database.yml. I use the development configuration as an example: development: adapter: mysql database: dev username: dev ...

MySQL support for UTF-8 in PHP

Monday, December 10th, 2007

Originally published in Swedish in my Folkmun.se Blog, a handy tip to make sure that you are reading and writing UTF-8 when connecting to a MySQL database: mysql_query("SET NAMES utf8"); mysql_query("SET CHARACTER SET utf8")