(David E. Wheeler) A common pattern when managing the relationship between object-oriented applications and databases is the many-to-many relationship. Object-relational mappers usually manage these relationships as collections of objects, wherein one class has an accessor that returns a collection

(Serdar Yegulalp) If you use either MySQL or Microsoft SQL Server, odds are you’re at least curious about trying out the competing product. Most of the time, SQL Server users are the ones interested in moving to MySQL to take advantage of a free, open source system — but the reverse does happen. In

(Paul Dubois) By default, MySQL uses the ISO-8859-1 (Latin1) character set with sorting according to Swedish/Finnish rules. These defaults are suitable for the United States and most of western Europe.

(Edacio) This article is my personal attempt to create a MySql provider based on the Membership and Role Provider in another article.

(Matthew Aslett) Microsoft Corp has officially unveiled CodePlex, its new collaborative development portal for community-based development for open- and shared-source projects, while signing a new partnership with open-source database vendor MySQL AB.

(Graham) In a database such as MySQL, data is divided into a series of tables (the “why” is beyond what I’m writing today) which are then connected together in SELECT commands to generate the output required. I find when I’m running MySQL training, people often get confused between all the join flav

(Alejandro Gervasio) For anyone who has spent a few weeks working with PHP 5, the plethora of cool improvements and new features added to this incarnation of the language has brought a new, more powerful level for developing and deploying Web applications. These include the implementation of excepti

(Ian Gilfillan) Last year I wrote a two-part series entitled the Database Journal Guide to MySQL certification. Part one covered the core certification, and part two the professional certification. Those two articles covered the MySQL 4 certification. Although it is still possible to achieve MySQL 4

(Mike Hillyer) One of MySQL’s strengths is it’s use of Binary Large Object (BLOB) columns. These columns store unprocessed binary data, typically files, that can be retrieved and manipulated like the other common datatypes. One sample use would be the storage of images into the database to be retrie

(Ed Burnette) In my last installment I introduced a simple decision tree that could help you decide which (if any) of the many open source licenses you should use for your project. Each decision point generally asked a yes or no question about what is important to you. For example, if you want some