(Robin Bloor) The recent announcement that Pervasive was throwing its weight behind PostgreSQL, as an open source offering, was interesting for two reasons. First of all, Pervasive already had a successful database product – Pervasive SQL – which has strong traction among ISVs. Pervasive regards its

(Paul Dubois) This chapter covers the following exam topics: –General database and table properties –Storage engines and table types –Limits on number and size of database components –Identifier syntax –The CREATE DATABASE and DROP DATABASE statements –The CREATE TABLE, ALTER TABLE, an

(Darryl K. Taft) The biggest question facing open-source developers is, after Linux, what can be done to spur efforts toward complete open-source software stacks?

(Sean Michael Kerner) A new report out this week from Evans Data shows that FirebirdSQL and MySQL are the most popular open source databases currently in use.

(Blane Warrene) There are all manner of whitepapers and architecture documents on the features and benefits of migrating from MySQL 3 to MySQL 4. Sometimes, the best case is to see it done on the front lines of a real Web business.

(Ingrid Marson) The recent release of PostgreSQL 8.0 means that Microsoft users will now be able to run the open source database PostgreSQL natively on Windows. Previous versions required the Cygwin Unix emulation toolkit to run on Windows servers.

(Ian Gilfillan) Last month we looked at MySQL Administrator, this month I try out another of the MySQL tools: MySQL Query Browser. One nice thing about writing a regular monthly column (or a book!) is that it is an incentive to try out new tools I may not use in the work environment. I can avoid

(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

(Vance McCarthy) Open Source start-up firm TechWhale Inc. is offering for download the first Open Source CRM solution optimized for Microsoft’s .NET Framework.

The MySQL Users Conference 2005 is the largest gathering of MySQL developers and users. The 2005 Conference hosts leading industry keynote speakers, the latest MySQL Open Source technologies, in-depth sessions and tutorials, and an exhibit hall showcasing the latest open source technologies.