The Call for Participation for the 2007 MySQL Conference & Expo has just opened: an invitation for database experts and enthusiasts to share their knowledge of MySQL with the global open source community. The theme for the 2007 conference is “Scale to New Heights with MySQL.” This annual event bring

(Edacio) I did not write the profile provider from scratch. I used a sample MS Access profile provider from the Microsoft SDK, and modified it to work with MySQL and the membership provider from the article mentioned below.

(Beat Vontobel) With MySQL 5.1 you can store the general query log in a table. But what if you don’t want to log every single statement but only the users logging in and the hosts they’re coming from? There exists in fact a very simple solution that even works with MySQL 5.0 and (with some changes)

(mustapha) Beginning with MySQL 5.1.5, two functions providing basic XPath (XML Path Language) capabilities are available: ExtractValue and UpdateXML.

(Kevin Burton) MySQL 5.0 is now gold!. Great job guys! MySQL is really moving forward towards an Enterprise (I hate that word) -quality database.

(Peter Zaitsev) One little known fact about MySQL Indexing, however very important for successfull MySQL Performance Optimization is understanding when exactly MySQL is going to use index and how it is going to do them.

(David E. Wheeler) The previous article in this series, Practical PL/pgSQL: Managing Ordered Sets, created four functions to simplify the management of ordered collections as many-to-many relationships. The two more complex functions, entry_coll_tag_set() and entry_coll_tag_add(), take an iterative

(Shekhar Govindarajan) Most enterprise grade databases support stored procedures, which have two essential advantages. First, stored procedures reside in the database (such as tables and indexes) and the database queries in the stored procedures are executed at the database side. It yields faster re

(Ben Lorica) Tableau Software is a provider of visual analysis and reporting tools. Although there are several tools available to help users efficiently and easily create pivot tables or cross-tabulations, Tableau allows you to take it one step further: visualize the cross-tabulations in real time.

IBM announced new software and resources to help customers leverage their investments in open source development tools and resources. The new offerings will help software development teams build Eclipse-based open integrated development environments that are technologically diverse and vendor neutra