(Rex Baldazo) I rant against Oracle products a lot in this blog, but I have to admit there’s a few of their products I do actually like. One of them is SQL Developer. Strangely though, the feature I kinda like best is that SQL Developer can connect to non-Oracle databases like MySQL. Which makes it

(Ronald) I came across a problem on site yesterday. In moving the development environment to a new server and creating more appropriate permissions for users (they were using ALL on *.*) I found that the Java application would crash with a NullPointerException. The permissions were standard, and cal

(CrazyToon) There have been numerous occasions where I needed to make backups of individual tables from selected database.

(Jonathan) So I have been talking to a lot of people about my idea for a business rules engine in the database and many of my friends have given really good feedback. Not all of it was good feedback, but it allowed me to re-evaluate and focus my idea on what exactly I want to achieve using this idea

(Mark Schoonover) In September, the Developer Zone featured Chapter 6 of Paul DuBois’ MySQL, 3rd edition on Writing C Programs with the MySQL C API. This month, we continue in this series on developing MySQL applications in C with a tutorial from Mark Schoonover about using the Eclipse CDT (C Develo

(Jeremy Cole) Geo-referencing IPs is, in a nutshell, converting an IP address, perhaps from an incoming web visitor, a log file, a data file, or some other place, into the name of some entity owning that IP address. There are a lot of reasons you may want to geo-reference IP addresses to country, ci

(Parvesh Garg) Again I have a well neglected and documented feature of MySQL. As we all often need and use locks in MySQL, we tend to forget (or not bother about) MySQL internals and how they cause trouble. For example, try something like LOCK TABLE … WRITE on an InnoDB table in a transaction and

(Corra) Today I answered to a problem regarding fulltext indexes on an italian newsgroup. The guy was in trouble in building a multicolumn fulltext index. MySQL always said that a column cannot be part of the index. Why?

(Giuseppe Maxia) MySQL Proxy is being beefed up, to make it ready for prime time. New features are being added, and old ones are improved and tested. Testing the Proxy is an adventure in its own right. It’s a tool that was designed to get in the middle of the scene and change things. Testing its fe

(Vincent Danen) The PostgreSQL database server is arguably one of the best SQL servers available, but it’s not as easy for beginners to get a handle on it as other SQL databases, such as MySQL. Where MySQL stores all of its credential information within the SQL database itself, PostgreSQL takes a tw