Open Query blog

David Axmark is one the MySQL AB Founders who will be at OSCON in Portland next week.
There’s a grand session States of the Databases scheduled for Wednesday 3rd August, 1:45pm, look at a range of Open Source databases and where they’re at. David will present the MySQL “State of the Dolphin” as part of this [...]

Filed under: Uncategorized | by arjen
No Comments »

A commonly asked question… and you could do IFNULL(col,’wazzanull’) or somesuch.
But there’s another standard SQL function with a funny (and therefore difficult to remember) name, and that is COALESCE(). The COALESCE function takes one or more parameters, and will return the first one that is not NULL. GooD huh? Example:
SELECT COALESCE(somecol,anothercol,’no values available) AS colalias
And [...]

Filed under: Uncategorized | by arjen
No Comments »

This looks like a good read: Free Software for Busy People.
BoingBoing.net writes:
“Free Software for Busy People is a new book from Mohammad Al-Ubaydli, a Bahraini MD who is on a mission to help information-civilians understand why they should use free/open source software.
The book tells the story of six people from six walks of life (government [...]

Filed under: Uncategorized | by arjen
No Comments »

A little known but very useful script, which has been part of MySQL distributions for quite some time now, is mysql_secure_installation. It’s a shell script, written by Jeremy Cole. No Perl or anything needed!
When you run it, it will ask you a few questions to secure your basic MySQL server setup. You can set up [...]

Filed under: Uncategorized | by arjen
No Comments »

Found by my colleague João http://www.comics.com/comics/workingdaze/archive/workingdaze-20050721.html
An episode of the cartoon “Working Daze”, about PHP + MySQL.

Filed under: Uncategorized | by arjen
5 Comments »

This is cool: http://news.zdnet.co.uk/business/0,39020645,39210059,00.htm
Florian Mueller, who started NoSoftwarePatents.com and campaigned tirelessly against the adoption of software patents in the European Union, has been recognised as one of the most influential people in the IP (Intellectual Property) world by a magazine for IP lawyers.
Good on ya, Florian!

Filed under: Uncategorized | by arjen
1 Comment »

The Eventum issue tracking system now has its own public Wiki in a mysql.org subdomain (there’ll be more of those!)
For more info about Eventum, see my earlier post and the recent interview with the original and main developer João Prado Maia.
There are also two mailing lists for Eventum:
eventum-users (see http://lists.mysql.com/eventum-users for archive and subcribing)
and http://lists.mysql.com/eventum-devel [...]

Filed under: Uncategorized | by arjen
2 Comments »

I was just browsing SourceForge after clicking from my mMAIM story, and spotted this in the “Server Based DBMS” overview. It’s in alphabetical order:

Firebird/InterBase (55 projects)
HSQL (37 projects)
IBM DB2 (21 projects)
Microsoft SQL Server (181 projects)
MySQL (1560 projects)
Oracle (125 projects)
Other network-based DBMS (38 projects)
PostgreSQL (pgsql) (325 projects)
SQLite (120 projects)
Sybase (20 projects)

It’s excellent that there are so [...]

Filed under: Uncategorized | by arjen
No Comments »

Chris DiBona is a busy guy at Google, organizing Google Code. An excellent initiative I’ve also written about earlier.
One published is Google mMAIM. From the Google Code page:
“mMAIM’s purpose is to make it easy to monitor and analyze MySQL servers and to easily integrate itself into any environment.
It can show Master/Slave sync stats, some efficiency [...]

Filed under: Uncategorized | by arjen
No Comments »

“So how do you make money out of Open Source? This forum brings together some excellent examples of companies using different business methods for Open Source. Each company will outline their strategy, why they use Open Source for their businesses, and how successful the business methodology with Open Source has been.”
When and where: Tue 19 [...]

Filed under: Uncategorized | by arjen
No Comments »