Getting Started with the Oracle Berkeley DB SQL APIs
Legal Notice
This documentation is distributed under an open source license. You may review the terms of this license at: http://www.oracle.com/technetwork/database/berkeleydb/downloads/oslicense-093458.html
Oracle, Berkeley DB, and Sleepycat are trademarks or registered trademarks of Oracle. All rights to these marks are reserved. No third-party use is permitted without the express prior written consent of Oracle.
Other names may be trademarks of their respective owners.
To obtain a copy of this document's original source code, please submit a request to the Oracle Technology Network forum at: http://forums.oracle.com/forums/forum.jspa?forumID=271
9/9/2013
Table of Contents
1. Berkeley DB SQL: The Absolute Basics
BDB SQL Is Nearly Identical to SQLite
Getting and Installing BDB SQL
PRAGMA bdbsql_shared_resources
PRAGMA bdbsql_vacuum_fillpercent
Differences for Users of other SQL Engines
Lock Usage with the BDB SQL Interface
Using Multiversion Concurrency Control
4. Using Replication with the SQL API
PRAGMA replication_initial_master
PRAGMA replication_remote_site
PRAGMA replication_remove_site
PRAGMA replication_verbose_output
PRAGMA replication_verbose_file
Displaying Replication Statistics
Example 1: Distributed Read at 3 Sites
5. Administrating Berkeley DB SQL Databases
Backing Up Berkeley DB SQL Databases
Backing Up Replicated Berkeley DB SQL Databases
Syncing on Windows Mobile Platforms
Supported Platforms and Languages
BFILE SQL Objects and Functions