Databases Archive

MySQL 5.0: To Plug Or Not To Plug?

The newest version of MySQL AB's flagship open source database product includes new pluggable storage engines -- swappable components that offer the ability to add or remove storage engines from a live MySQL server. In this interview, MySQL expert Mike Hillyer gives a deeper explanation of this new feature and explains how it can benefit DBAs.

MySQL CEO: Partnerships Will Propel OSS Into Mainstream

In the business IT shop of the near future, open source software will gain equality with proprietary software, but it won't get there on its own power, said Marten Mickos, CEO of MySQL AB. "From the beginning, we have never been religious about open source. We think it's the most effective way to produce software, but we've always realized that there are vendors that will stay with closed source products. Our users live in the real world where both open source and closed source software have to work together."

DBAs vs. Developers: How to Collaborate

Is your IT team conducting an internal feud, with team members struggling against each other instead of fighting the real problems of limited time, money, and manpower to support your organization's technology needs? Buck Woody argues that you can't afford to become the Hatfields and McCoys. Also, both developers and DBAs have merit in the IT team. Although different, both jobs are crucial for a successful enterprise. However, conflicting responsibilities sometimes trigger members of the two related professions to face off. Baya Pavliashvili points out a few common situations that can cause tension between the two groups and provides some advice for working your way out of an argument before it leads to a war.

Preview of the Firebird Conference 2005

In about six weeks time developers from all over the world will convene in Prague for the 2005 edition of the Firebird Conference. This year's conference has an even greater abundance of speakers and topics than the previous editions of the event. The various tracks on the conference will cover Firebird itself, development languages and solution stacks, development tools and issues and applications. And, of course, it is a great opportunity to meet the community.

HSQLDB 1.8.0 Released

HSQLDB is the leading SQL relational database engine written in Java. It has a JDBC driver and supports a rich subset of ANSI-92 SQL (BNF tree format) plus SQL 99 and 2003 enhancements. It offers a small (less than 100k in one version for applets), fast database engine which offers both in-memory and disk-based tables and supports embedded and server modes.

There is more to data access than SQL

The number and variety of computing devices in the environment are increasing rapidly. Real computers are no longer tethered to desktops or locked in server rooms. PDAs, highly mobile tablet and laptop devices, palmtop computers, and mobile telephony handsets now offer powerful platforms for the delivery of new applications and services. These devices are, however, only the tip of the iceberg. Hidden from sight are the many computing and network elements required to support the infrastructure that makes ubiquitous computing possible.

Sleepycat CEO Talks About Everything recently caught up with Sleepycat Software Inc. CEO Mike Olson to find out what's new with open source Berkeley DB. In these excerpts from that conversation, Olsen talks about where Berkeley DB is positioned in the marketplace, and where it's going in terms of features and functionality. Also, Olson discusses why he thinks ever-evolving attitudes toward open source will make hybrid offerings lucrative. He then runs through an interesting "thought experimentation" to show what would happen if Microsoft ever decided to embrace open source.

Firebird SQL Server 2.0 Alpha-01 Release

This alpha release contains a large number of new features, including derived tables, support for Execute Block, increased table sizes, new improved index code (the 252-byte index length limit is no longer applicable), expression indices, numerous optimiser improvements, enhanced security features, support for on-line incremental backups along with many other improvements & bug fixes.

Interview with Josh Berkus of PostgreSQL

The PostgreSQL database project has recently released Version 8.0, which was received with quite some fanfare, mostly due to its first-ever Windows port. Mad Penguin talked with Josh Berkus, one of the core team members, to find out how 8.0 has fared since its official release on January 17, 2005.