Databases Archive

PostgreSQL v7.3 Released

The PostgreSQL Global Development Group announced yesterday the release of PostgreSQL v7.3, now available for download. Numerous changes include: support for the SQL 92 Schema spec, enhanced dependency tracking for complex databases, prepared queries for maximized performance on common requests, expanded logging options, supports data in many international characters sets, dozens of performance enhancements. Update: A report at eWeek about mySQL & PostgreSQL's progress.

Aqua Data Studio 1.0 Released

Aqua Data Studio is a SQL editor and developer tool that allows developers to easily create, edit, and execute SQL scripts, as well as browse database structures. Aqua Data Studio provides an integrated database environment with a single consistent inferface to all major relational databases. This allows the DBA or developer to tackle multiple tasks simultaneously from one application. The application is multi-platform as it is written in Java. Screenshots here.

Multidimensional Clustering for Linux, Unix, and Windows

This is an interview with IBM's expert Matt Huras on DB2. He shares a sneak preview of the new release of DB2 version 8 and its technical highlights, including it's high-availability features, improved administration tools, performance advice, and multidimensional clustering, which allows data to be clustered according to several different "dimensions" simultaneously. There's a free download of DB2 v8.

Open-Source Databases Hike Enterprise Appeal

"The creators of the open-source databases MySQL and PostgreSQL are trying to push them further into the enterprise with new features aimed at better support for transactions, database recovery and replication." Read the news at eWeek. On the other hand, VA-Software said that they had to switch SourceForge to IBM's DB2, because their database grows very fast (70 new projects and 700 new users daily) and while they did a move from mySQL to PostgreSQL a year ago (mySQL is faster for smaller dbs, while PostgreSQL scales better), now they have to move again to an even more powerful database, which happens to be proprierty.

IBM Released DB2 v8.1

IBM has released DB2 v8.1 for Linux, HP, AIX, Solaris, os390 and Windows today. New features include multi-dimensional clustering (queries and analytics nearly 100% faster), self-configuring, self-healing, self-optimizing, self-protecting, and the ability to consolidate Web Services queries through a single SQL statement.

Oracle: IBM DB2 is Behind the Times

"IBM DB2 is only popular on mainframes...which is only used by your father!" That was Oracle Chairman and CEO Larry Ellison's response to a report that Big Blue's database-management software is gaining market share over Oracle. A recent Gartner Dataquest study ranked IBM ahead of Oracle in the highly competitive DBMS market. The report, which Oracle has since disputed, found that the Redwood Shores, Calif.-based company had slipped to second place in the overall database market in 2001, with a market share of about 32 percent, versus IBM's 34.6 percent.

Firebird 1.0 Released

Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names since 1981. Firebird is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (once known as Borland Software Corp) under the InterBase Public License v.1.0 on 25 July, 2000. Version 1.0 of Firebird was released just yesterday for many platforms including MacOSX and Linux.

Server Databases Clash – eWeek Benchmarks

"Finding solid performance data to help choose among competing technologies is as tough as creating the data in the first place. This is particularly true in the database space, where database vendors routinely use no-benchmarking clauses in their license agreements to block publication of benchmarks of which they do not approve. We tested IBM's DB2 7.2 with FixPack 5, Microsoft Corp.'s SQL Server 2000 Enterprise Edition with Service Pack 2, MySQL AB's MySQL 4.0.1 Max, Oracle Corp.'s Oracle9i Enterprise Edition and Sybase Inc.'s ASE (Adative Server Enterprise)" Read the rest of the benchmark article at eWeek. Our Take: Hey, where are my PostgreSQL benchmarks?

Sleepycat Announces the Release of Berkeley DB 4.0

From the press release: "Sleepycat Software, Inc. today announced the release of version 4.0 of the award-winning data management system, Berkeley DB. Version 4.0 delivers new services and significant performance enhancements for high-end mission critical applications. Berkeley DB 4.0 provides a new feature required by developers building mission-critical applications: High Availability. Designed for applications that must run around the clock, High Availability uses a technique called "replication" to keep multiple copies of a database, stored in different places, up to date. In the event of a hardware or application crash that causes one of the copies to fail, applications can use the remaining copies to continue operating without interruption. Application developers can also use the copies to answer queries during normal operation. As a result, applications can support more users more reliably than ever before."

Borland & SleepyCat Deliver New DB Versions

Borland released a new Interbase version. New features include VLDB Support (Very Large Database: 64 bit I/O), enables the creation of large files without creating a multi-file database and XML Data-generation, allows InterBase developers to generate XML documents directly from InterBase. In the meantime, Sleepycat Software released version 4.0 of the Berkeley DB just a few days ago. This version adds support for replication, so apps can survive single- or multi-node hardware or software failures without interruption in service.

Oracle to Introduce Beefed Up 9i Database

"Looking to jump-start sales in the face of stiff competition and a nasty economy, Oracle is set to disclose plans for new software and a revamped version of its flagship database-management application at a customer conference in San Francisco next week. The new release of Oracle 9i database, which will be available early next year, will better handle XML (Extensible Markup Language) data, a Web standard for data exchange that lets companies construct e-commerce and new Web services applications, said Oracle executives." In related news, Microsoft released Service Pack 2 for SQL Server 2000. Because SQL Server Service Packs are cumulative, SP2 includes all fixes from previously released Service Pack 1 (SP1), and can be applied to an original installation or to one where Service Pack 1 (SP1) was previously applied.

FileMaker Pro 5.5 Unlimited Now Available

FileMaker Pro 5.5 Unlimited is now certified for Apache Web Servers running Red Hat Linux 7.1 and the powerful new Mac OS X Server. FileMaker Pro 5.5 Unlimited offers the same powerful database features found in FileMaker Pro 5.5, including two-way ODBC capabilities, record-level access privileges and more. However, in contrast to FileMaker Pro 5.5, it sets no limits to the number of Web Browsers that can access a FileMaker Pro database published on the Web.

MySQL 4.0 is Released

Patrik Wallström writes "The long awaited version 4.0 of MySQL has been released. It is in its alpha stage, and among the new features are SSL-connections, increased speed, more compatibility with other DBMS's and the SQL standard, transactions with the InnoDB table type and more. Download here, and read all the news in the 4.00 version here."

Open Source Databases Bloom

"Databases were once the forgotten stepchild of the open-source family. Companies like Red Hat Inc. included database software with their Linux distribution disks, but the main focus was on the operating system, the kernel and the graphical interface. A database was just another add-on, like a Minesweeper clone. But now, companies and users are scrambling to realize the value locked up in quality, open-source database software," ComputerWorld writes. Following the discussion we had recently on mySQL and PostgreSQL, the article seems to agree that professional closed-source database systems still have the lead on the open source counterparts.

PostgreSQL vs MySQL, a Year Later

"To many people, PostgreSQL and MySQL seem like similar, alternative databases. Both are quickly gaining popularity. Based on the track records of older versions, there's a lot of debate over the speed of PostgreSQL and the durability of MySQL. But times have changed and each database has progressed. On both counts, the two packages are the closest they've ever been, so when deciding which to use in a Web application, a developer doesn't always have a clear winner. If you're looking for a database to prop up a Weblog or portal, you'll find that many such packages rely on MySQL. It should be possible to port them to PostgreSQL, but if you're looking for a turnkey package, chances are you're not interested in doing too much porting work. If you're migrating from Oracle, Sybase, or Microsoft SQL Server, I suggest PostgreSQL. Like those databases, PostgreSQL has triggers, stored procedures, and a rich set of built-in functions (including many functions for date manipulation). Also, PostgreSQL procedural language is easy to learn if you're familiar with Oracle's PL/SQL and SQL Server's Transact-SQL." Read the whole shootout article over at WebTechniques.