Wednesday, November 18th, 2009

There are a lot of tutorial out there describing how to use PHP's classic MySQL extension to store and retrieve blobs. There are also many tutorials how to use PHP's MySQLi extension to use prepared statements to fight SQL injections in your web application. But there are no tutorials about using MySQLi with any blob […]

Monday, September 21st, 2009

Your MySQL server is under heavy load or refuses any new connections because MySQL runs out of available threads. Ever wondered why? For me the easiest way to get a first and very helpful real-time insight in what is happening in your database server is to use the show processlist statement: mysql> show processlist; +--------+---------+-----------+-------------+----------------+------+--------------------+------------------------------------------------------------------+ […]

Wednesday, September 9th, 2009

If you're leaving the secure world of ASCII characters you're usually enter a dangerous land of confusion. It's actually a very complex topic and from a technical point of view there is no one to blame. But if you don't care about the basics, don't care why or how, and just want a reliable and […]

Tuesday, September 8th, 2009

I don't know why or who was the first who introduced this legend, but if you review source code from time to time, you see one weird MYSQL SQL statement showing up regularly: SELECT LAST_INSERT_ID() FROM some table. If you google for »SELECT LAST_INSERT_ID() FROM« you'll get 98,100 hits. And if you use Google Code […]

Monday, August 31st, 2009

You don't know anything about databases and want to get rid of this social stigma? But you don't want to read a 500 pages book about theoretical aspects of relational database management system written by an aged computer science professor who thinks "real life" must be the name of a theater next to the campus? […]

This blog copyright 2010-2012 by Kai 'Oswald' Seidler