(Leo Hsu and Regina Obe) One of the features of PostGIS (pain to some however you look at it), is that PostGIS library file is versioned by minor version. The library will have for example a postgis-2.0 or postgis-1.5.dll / .so to denote the version. Each version of PostGIS can be compiled to run on

(Tom Van Goethem) In some languages, using arithmetic operators on elements that aren’t numeric, give some weird results. In JavaScript for example, [ ] + { } is an Object, while { } + [ ] appears to be NaN.

(Mark Grennan) It’s about time for this year’s MySQL (Percona) conference in San Francisco. I haven’t written anything in some time. So, I thought I’d write something we can talk about should you meet me.

(Todd Farmer) In case you missed it, MySQL Utilities 1.3.0 (alpha) was released last week. MySQL Utilities is a component of MySQL Workbench, but it’s been broken out into a separate download allowing command-line users access unencumbered by a pretty GUI interface.

(Maciej Dobrzanski) MySQL lets database administrators define access rights on many levels – from the ability to run global commands down to access to individual columns.

(Serge Frezefond) Auditing of a MySQL server activity is a request raised more and more often as compliance rules are more strict for companies. MySQL is used in more and more critical areas.

(Michael McLaughlin) While I tried to deflect how you perform SQL Injection attacks against a MySQL procedure, my students requested that I post examples of what to do to avoid SQL injection, and what not to do to invite attacks.

(Chris Calender) I mentioned in a recent post (and another recent, related post) I was going to try Visual Studio 2012 Express (as opposed to VS 2010 Express) for building MySQL 5.6 and MariaDB 10.0. on Windows.

(Simon Mudd) One of the typical problems you have when restarting mysqld is that the InnoDB buffer pool (buffer pool from now on) is empty and consequently access to the database requires reading directly from disk. Performance suffers dramatically as a consequence.

(Mat Keep) The new MySQL 5.6 GA release delivers a host of new capabilities to support developers releasing new services faster, with more agility, performance and security .