(shodan) mysql_connect() function in PHP’s MySQL interface (which for reference maps to mysql_real_connect() function in MySQL C API) has a $client_flags parameter since PHP 4.3.0. This parameter is barely known and almost always overlooked but in some cases it could provide a nice boost to your app

(W. Jason Gilmore) I’m a programmer, not a database administrator; I prefer to live in a world of code rather than table schemas and confusing SQL queries. This mindset is one of the reasons I find the Rails framework such an appealing solution; Rails so effectively implements an approach to databas

(Peter Zaitsev) MySQL Storage Engines implementing Multi Version Concurrency Control have several internal identifiers related to MVCC. I see a lot of people being confused what they are and why they are needed so I decided to take a time to explain it a bit. This is general explanation, it does not

(Giuseppe Maxia) This article explains how to test the performance of a large database with MySQL 5.1, showing the advantages of using partitions.

(Carla Schroder) The Apache HTTP server has a great security record, at least when it runs on Linux or any proper Unix-type operating system. But plain old static read-only Web sites are an endangered species; now we have all this LAMP guff (Linux, Apache/Lighttpd, MySQL/PostgreSQL/SQLite, Python/PH

(shodan) Just had an interesting issue with an encoding mess on a column containing non-ASCII (Russian) text. The solution was not immediately obvious so I decided it’s worth sharing.

(Roland Bouman) I believe I found a new method to calculate the median in MySQL. I would not be surprised if this method has been figured out by somebody else already. However, I can’t seem to find any resources on the internet describing this method, so for now I flatter myself by assuming the meth

(Mikko Puhakka) There is a going trend among companies not just supporting and appreciating open source, but also ‘’going open’’ by releasing their new development efforts as open source or converting their formerly proprietary offerings open source by releasing the source code under some open sourc

(Morgan Tocker) With MySQL 5.0, it’s much easier to do SQL Injection attacks, because you can use UNION against information schema. You couldn’t do this with the old SHOW commands.

(Ted Dziuba) I was working on a database project the other day, and one of the client’s requirements was that the database be “searchable”. Every programmer is familiar with such a vague requirement, and is therefore familiar with the “creative license” it allows him. The database engine for this pr