Fwd: [Berkeley DB Announce] Berkeley DB 11gR2 (11.2.5.0.21) - New Release, Major Revision

[Howard Chu <hyc@symas.com>]

Looks like the major addition is the SQLite work-alike API. Not much of 
interest to us here, possibly some of the lock bugs they fixed may be relevant.

-------- Original Message --------
Subject: [Berkeley DB Announce] Berkeley DB 11gR2 (11.2.5.0.21) - New	Release, 
Major Revision
Date: Wed, 31 Mar 2010 14:17:56 -0700 (PDT)
From: Announcements related to the Berkeley DB product family.	<bdb@oracle.com>
Reply-To: bdb@oss.oracle.com
To: bdb@oss.oracle.com

Berkeley DB 11gR2 (11.2.5.0.21)

http://www.oracle.com/database/berkeley-db/
http://www.oracle.com/technology/products/berkeley-db/
http://www.oracle.com/technology/products/berkeley-db/sql.html

Berkeley DB 11gR2 (11.2.5.0.21) is a major new release.  Berkeley DB now 
includes a SQL API for relational data storage based on SQLite.  This release 
uses the Oracle standard marketing naming (11gR2), however the revision 
number's last three components map to the historic versioning pattern (5.0.21) 
to help maintain consistency.


NEW IN THIS RELEASE:

* SQL
  * SQL/Relational access via integration with SQLite
  * Support for SQL92, ODBC and JDBC
  * Drop-in replacement for any SQLite-based solution
  * New Documentation covering the SQL API

* SQL Performance
  * 10s of thousands of INSERTS/UPDATES/DELETES per-second
  * 100s of thousands of SELECTs per-second
  * Approximately as fast as SQLite for reads (within 10%)
  * About 3X faster than SQLite for updates/writes
  * Has fine grained locking which leads to better read/write concurrency
  * 6-8x more transactions/second compared to SQLite when using multiple threads

* Other Features
  * Support for DTrace/SystemTap performance monitoring
  * Automatic resource management: close open database and cursor handles on 
environment close
  * Transaction priorities
  * Compact to reclaim unused spaces in hash databases to match similar 
existing feature for btrees
  * Log file portability across different endian machines

* High Availability
  * Client-to-client synchronization
  * Read-after-write consistency on replicas

* Integration with other Oracle Products
  * Synchronization with Oracle Database Server using Oracle Mobile Sync Server

The complete list of changes can also be found in the change log page.

http://www.oracle.com/technology/documentation/berkeley-db/db/installation/changelog_5_0.html


QUOTES:

"Oracle Berkeley DB 11gR2 combines seamlessly the benefits of SQLite's 
ubiquitous API with Berkeley DB's concurrency and performance into an 
easy-to-use product. SQLite users can now benefit from enhanced concurrency 
and performance, and Oracle Berkeley DB users can now benefit from an 
easy-to-use SQL API."
- Dr. Richard Hipp, architect, SQLite

"Berkeley DB's new SQLite-compatible SQL API offers powerful features not only 
for its users but to the SQLite community at large. Berkeley DB developers now 
have a proven embedded SQL engine to make application development even easier. 
SQLite users now have the option of a powerful, industry-supported storage 
engine that is built from the ground up for high-concurrency, and which 
includes powerful features like built-in replication and hot backups. The 
combination of the two technologies provides all developers with tremendous 
flexibility in that a single SQL/API can now be used across a broad spectrum 
of applications ranging from the embedded space all the way up to large-scale 
transaction processing. Oracle has done a fantastic job of not only 
integrating the technologies, but also being an exemplary participant in the 
open source community by contributing time, expertise and resources to the 
SQLite project."
- Mike Owens, author of "The Definitive Guide to SQLite"

"Berkeley DB 11gR2 is a very interesting product mainly because it combines 
the familiar SQLite sqlite3() API with the powerful, proven Berkeley DB data 
storage technology. I was able to re-compile my SQLiteManager product against 
the Berkeley DB library without any major issues in very little time. I have 
now a product that is fully able to manage Berkeley DB databases without 
changing a single line of my code. So far performance and concurrency are 
excellent and I am thrilled to think about the future improvements of this 
great product."
- Marco Bambini, CEO of SQLabs

"Berkley DB 11gR2 is, in my experience, a fully drop-in replacement for 
SQLite3. I was hugely surprised at just how easy it was; I'd had zero 
experience in using Berkeley DB in products before, but within a couple hours 
I had my application powered by Berkeley DB. From there onwards, you can enjoy 
all the benefits of Berkeley DB including concurrency and long term stability 
compared to SQLite3 from an API you're already familiar with. It's quite 
simply amazing."
- Liam McLoughlin, Chromium OS independent developer


DOWNLOAD:

http://www.oracle.com/technology/software/products/berkeley-db
http://www.oracle.com/technology/software/products/berkeley-db/db

Berkeley DB .tar.gz, with AES encryption
   http://download.oracle.com/berkeley-db/db-5.0.21.tar.gz

Berkeley DB .zip, with AES encryption
   http://download.oracle.com/berkeley-db/db-5.0.21.zip

Berkeley DB .msi Windows installer, with AES encryption
   http://download.oracle.com/berkeley-db/db-5.0.21.msi

Berkeley DB NC.tar.gz , without encryption
   http://download.oracle.com/berkeley-db/db-5.0.21.NC.tar.gz

Berkeley DB .NC.zip, without encryption
   http://download.oracle.com/berkeley-db/db-5.0.21.NC.zip


EDUCATION:

Documentation page:
   http://www.oracle.com/technology/documentation/berkeley-db/db

You may find an answer on our product FAQ page:
    http://www.oracle.com/technology/products/berkeley-db/faq/db_faq.html

Join OTN today and participate in the Berkeley DB Support Forum and discussions.

  General Questions
    http://forums.oracle.com/forums/forum.jspa?forumID=271

  Questions on HA/Replication
   http://forums.oracle.com/forums/forum.jspa?forumID=272

For further information, please contact us at:
   mailto:berkeleydb-info_us@oracle.com


Thank you for your support of Berkeley DB.

-greg

Greg Burd | Product Manager | Oracle Berkeley DB

_______________________________________________
BDB mailing list
BDB@oss.oracle.com
http://oss.oracle.com/mailman/listinfo/bdb