PostgreSQL 8.3 Features To Be Available After Labor Day - InformationWeek
IoT
IoT
Software // Enterprise Applications
News
8/30/2007
10:12 PM
Connect Directly
Twitter
RSS
E-Mail
50%
50%

PostgreSQL 8.3 Features To Be Available After Labor Day

Full text search and other features will become available for free download in beta code after Labor Day, with the final release to follow by eight to 10 weeks.

Lead integrator Bruce Momjian of the PostgreSQL database project says the 8.3 release of PostgreSQL will add full text searching as a regular feature, as well as a debugger for Oracle's version of SQL data access language with Oracle extensions, PL/SQL.

Full text search and other features will become available for free download in beta code after Labor Day, with the final release to follow by eight to 10 weeks.

The PostgreSQL project is one of the better-kept secrets of the database world. The mature relational system is an outgrowth of the Postgres database project run by computer science graduate students at the University of California at Berkeley in the early 1990s.

The school's Postgres code had both object handling and relational data handling capabilities and served as the core of Michael Stonebraker's Illustra startup, acquired in 1996 by Informix (which was later acquired by IBM). Postgres became the PostgreSQL open source project under the BSD license in 1996.

The PostgreSQL system appeared to gain strength during the dot-com boom, then stuttered as some of its sources of technical support disappeared during the bust. GreatBridge, started in 2000 with a focus on PostgreSQL consulting and technical support, closed in August 2001.

At that time, key PostgreSQL developers went back to the drawing board to improve the database system's performance and SQL compliance, says Momjian.

After nine months of work, the new features in 8.3 will be available at www.postgreSQL.org. They will include:

  • A finished PL/pgSQL debugger, a tool for editing PostgreSQL's version of the standard SQL data access language in database applications.

  • Full text search made more accessible by becoming a feature included in the system code instead of being an add-on option.

  • Clustering code from Skype for load balancing and spreading queries to a large database across several PostgreSQL systems.

Josh Berkus, a PostgreSQL developer who recently conducted a benchmark of PostgreSQL vs. Oracle for Sun Microsystems, said bit-mapped indexes intended for this release will be in a future release. Bit-mapped indexes provide fine-grained references to varied content in the database.

Berkus' benchmark found that PostgreSQL trails Oracle in performance.

Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
Annual IT Salary Report 
Base pay for IT professionals has remained flat this year with a median annual salary of $88,000 for staff and $112,000 for management. However, 58% of staff and 62% of managers who responded to our survey say they're satisfied with their compensation. Download this report to find out which positions earn the highest compensation.
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on InformationWeek.com for the week of November 6, 2016. We'll be talking with the InformationWeek.com editors and correspondents who brought you the top stories of the week to get the "story behind the story."
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll