Ionic Couchbase Lite

Ionic Couchbase Lite is a cross-platform data storage system that works on iOS and Android, and Electron on desktop. Powered by Couchbase Lite, a NoSQL database engine that provides simple yet powerful query, replication, and sync APIs.

This solution makes it easy to add Secure Storage to Ionic apps that are secure (encrypted on device), highly performant, and provide advanced data querying. Learn more.

Installation

If you have not already setup Ionic Enterprise in your app, follow the one-time setup steps.

Next, install the plugin:

Capacitor
Cordova

npm install @ionic-enterprise/couchbase-lite
npx cap sync

ionic cordova plugin add @ionic-enterprise/couchbase-lite

Project Requirements

Couchbase Lite requires a min SDK target for Android of at least 19. Make sure you have this in your config.xml at a minimum:

<preference name="android-minSdkVersion" value="19" />

To use additional features such as cloud data sync, data replication, conflict resolution, and delta sync, a subscription to Couchbase Server is required. To learn more, please get in touch.

Getting Started

After installing the plugin, import @ionic-enterprise/couchbase-lite into the desired class (A dedicated service class that encapsulates Couchbase Lite logic is recommended).

import {
    BasicAuthenticator,
    CordovaEngine,
    Database,
    Function,
    Meta,
    MutableDocument,
    QueryBuilder,
    SelectResult,
    DataSource,
    Expression,
    Ordering,
    Query,
    ResultSet,
    Result,
    Replicator,
    ReplicatorConfiguration,
    ReplicatorChange,
    URLEndpoint,
    ArrayFunction,
    PropertyExpression,
    Join,
    DocumentReplication
} from '@ionic-enterprise/couchbase-lite';

Next, initialize the database:

/*  
    Note about encryption: In a real-world app, the encryption key 
    should not be hardcoded like it is here. One strategy is to 
    auto generate a unique encryption key per user on initial app 
    load, then store it securely in the device's keychain for later
    retrieval. Ionic's Identity Vault plugin is an option. Using 
    IV’s storage API, you can ensure that the key cannot be read
    or accessed without the user being authenticated first.
*/
private async initializeDatabase(): Promise<void> {
    return new Promise(resolve => {
        IonicCBL.onReady(async () => {
            const config = new DatabaseConfiguration();
            config.setEncryptionKey('8e31f8f6-60bd-482a-9c70-69855dd02c38');
            this.database = new Database('DATABASE_NAME', config);
            this.database.setEngine(
            new CordovaEngine({
                allResultsChunkSize: 9999
            }));
            await this.database.open();

            resolve();
        });
    });
}

Create a new document and save it to the database:

// Create a new document (i.e. a record) in the database.
let mutableDoc = new MutableDocument()
    .setFloat("version", 2.0)
    .setString("type", "SDK")
    .setString("company", "Ionic");

// Save it to the database.
await this.database.save(mutableDoc);

Run a simple Query:

// Create a query to fetch documents of type SDK.
let query = QueryBuilder.select(SelectResult.property("version"),
        SelectResult.property("type"),
        SelectResult.property("company"))
    .from(DataSource.database(database))
    .where(Expression.property("type").equalTo(Expression.string("SDK")));
const result = await (await query.execute()).allResults();
console.log("Number of rows:  " + result.size());

Build and run. You should see a row count of one printed to the console, as the document was successfully persisted to the database.

Bi-directional replications with Sync Gateway:

// Create replicators to push and pull changes to and from the cloud.
let targetEndpoint = new URLEndpoint(new URI("ws://localhost:4984/example_sg_db"));
let replConfig = new ReplicatorConfiguration(database, targetEndpoint);
replConfig.setReplicatorType(ReplicatorConfiguration.ReplicatorType.PUSH_AND_PULL);

// Add authentication.
replConfig.setAuthenticator(new BasicAuthenticator("john", "pass"));

// Create replicator.
let replicator = new Replicator(replConfig);

// Listen to replicator change events.
replicator.addChangeListener((status) => {
});

// Listen to document replication events.
replicator.addDocumentListener((doc) => {
});

// Start replication.
replicator.start();

Beyond these docs, reference Couchbase Lite's documentation for more functionality details and examples.

Database

New Database

As the top-level entity in the API, new databases can be created using the Database class by passing in a name, configuration, or both. The following example creates a database using the Database(name: string) constructor:

let config = new DatabaseConfiguration();
let database = new Database("my-database", config);

The database will be created on the device. Alternatively, the Database(name: string, config: DatabaseConfiguration) initializer can be used to provide specific options in the DatabaseConfiguration object such as the database directory.

Loading a pre-built Database

If your app needs to sync a lot of data initially, but that data is fairly static and won’t change much, it can be a lot more efficient to bundle a database in your application and install it on the first launch. Even if some of the content changes on the server after you create the app, the app’s first pull replication will bring the database up to date.

To use a prebuilt database, you need to set up the database, build the database into your app bundle as a resource, and install the database during the initial launch. After your app launches, it needs to check whether the database exists. If the database does not exist, the app should copy it from the app bundle using the Database.copy(File path, String name, DatabaseConfiguration config) method as shown below.

let config = new DatabaseConfiguration(getApplicationContext());
ZipUtils.unzip(getAsset("replacedb/android200-sqlite.cblite2.zip"), getApplicationContext().getFilesDir());
let path = new File(getApplicationContext().getFilesDir(), "android-sqlite");
try {
    Database.copy(path, "travel-sample", config);
} catch (e) {
    console.log("Could not load pre-built database");
}

Document

In Couchbase Lite, a document’s body takes the form of a JSON object — a collection of key/value pairs where the values can be different types of data such as numbers, strings, arrays or even nested objects. Every document is identified by a document ID, which can be automatically generated (as a UUID) or specified programmatically; the only constraints are that it must be unique within the database, and it can’t be changed.

Initializers

The following methods/initializers can be used:

The MutableDocument() initializer can be used to create a new document where the document ID is randomly generated by the database.

The MutableDocument(withID: string) initializer can be used to create a new document with a specific ID.

The database.getDocument(id: string) method can be used to get a document. If it doesn’t exist in the database, it will return null. This method can be used to check if a document with a given ID already exists in the database.

The following code example creates a document and persists it to the database:

let newTask = new MutableDocument();
newTask.setString("type", "task");
newTask.setString("owner", "todo");
newTask.setDate("createdAt", new Date());
try {
    database.save(newTask);
} catch (e) {
    console.log(e.toString());
}

Changes to the document are persisted to the database when the save method is called.

Typed Accessors

The Document class offers a set of property accessors for various scalar types, including boolean, integers, floating-point and strings. These accessors take care of converting to/from JSON encoding, and make sure you get the type you’re expecting.

In addition, as a convenience we offer Date accessors. Dates are a common data type, but JSON doesn’t natively support them, so the convention is to store them as strings in ISO-8601 format. The following example sets the date on the createdAt property and reads it back using the document.getDate(String key) accessor method.

newTask.setValue("createdAt", new Date());
let date = newTask.getDate("createdAt");

If the property doesn’t exist in the document it will return the default value for that getter method (0 for getInt, 0.0 for getFloat etc.).

Batch Operations

If you need to make multiple changes to a database at once, it’s faster to group them together.

The following example persists a few documents in batch:

await this.database.inBatch(() => {
  for (let sdk of sdkDataToLoad) {
    let doc = new MutableDocument()
      .setNumber('version', sdk.version)
      .setString('type', sdk.type)
      .setString('company', sdk.company);

    this.database.save(doc);
 }
});

At the local level this operation is still transactional: no other Database instances, including ones managed by the replicator can make changes during the execution of the block, and other instances will not see partial changes. But Couchbase Mobile is a distributed system, and due to the way replication works, there’s no guarantee that Sync Gateway or other devices will receive your changes all at once.

Blobs

Used to store large data, such as images.

The following code example adds a blob to the document under the avatar property.

public async saveImageBlob() {
    // Get a reference to a file - various ways to do so
    let filepath = getAsset("avatar.jpg");
    try {
        // Ionic Native File plugin
        let fileEntry = await this.file.resolveLocalFilesystemUrl(filepath) as any;
        fileEntry.file((file) => {
            const fileReader = new FileReader();
            fileReader.onloadend = () => {
                let blob = new Blob("image/jpeg", fileReader.result as ArrayBuffer);
                newTask.setBlob("avatar", blob);
                database.save(newTask);
                }
            fileReader.readAsArrayBuffer(file);
            }
        } catch (e) {
        console.log(e.toString());
    }
}

// Retrieve image blob then convert to base64 format
public getImageAsBase64() {
    return new Promise((resolve, reject) => {
      this.savedDoc.getBlobContent("avatar", this.database).then((docBlob) => {
        var bytes = new Uint8Array(docBlob);
        var blob = new window.Blob([bytes.buffer], { type: "image/jpeg"});

        var reader = new FileReader();
        reader.onloadend = () => {
          resolve(reader.result);
        };
        reader.readAsDataURL(blob);
      });
    });
}

// Alternatively, retrieve blog image then convert to objectURL
public async getImageUsingObjectUrl() {
    let docBlob = await this.savedDoc.getBlobContent("test", this.database);
    let arrayBufferView = new Uint8Array(docBlob);
    let blob = new window.Blob([ arrayBufferView.buffer ], { type: "image/jpeg"});
    let objectUrl = window.URL.createObjectURL(blob);
    return this.sanitizer.bypassSecurityTrustUrl(objectUrl);
}

The Blob API lets you access the contents as in-memory data (a Data object) or as a InputStream. It also supports an optional type property that by convention stores the MIME type of the contents.

In the example above, "image/jpeg" is the MIME type and "avatar" is the key which references that Blob. That key can be used to retrieve the Blob object at a later time.

When a document is synchronized, the Couchbase Lite replicator will add an _attachments dictionary to the document’s properties if it contains a blob. A random access name will be generated for each Blob which is different to the "avatar" key that was used in the example above.

A blob also has properties such as "digest" (a SHA-1 digest of the data), "length" (the length in bytes), and optionally "content_type" (the MIME type). The data is not stored in the document, but in a separate content-addressable store, indexed by the digest.

Query

Database queries are based on expressions, of the form "return from documents where , ordered by __", with semantics based on Couchbase’s N1QL query language.

There are several parts to specifying a query:

SELECT: specifies the projection, which is the part of the document that is to be returned.
FROM: specifies the database to query the documents from.
JOIN: specifies the matching criteria in which to join multiple documents.
WHERE: specifies the query criteria that the result must satisfy.
GROUP BY: specifies the query criteria to group rows by.
ORDER BY: specifies the query criteria to sort the rows in the result.

SELECT statement

With the SELECT statement, you can query and manipulate JSON data. With projections, you retrieve just the fields that you need and not the entire document.

A SelectResult represents a single return value of the query statement. You can specify a comma separated list of SelectResult expressions in the select statement of your query. For instance, the following select statement queries for the document _id as well as the type and name properties of all documents in the database. In the query result, we print the _id and name properties of each row using the property name getter method.

{
    "_id": "hotel123",
    "type": "hotel",
    "name": "Apple Droid"
}

let query = QueryBuilder
    .select(SelectResult.expression(Meta.id),
        SelectResult.property("name"),
        SelectResult.property("type"))
    .from(DataSource.database(database))
    .where(Expression.property("type").equalTo(Expression.string("hotel")))
    .orderBy(Ordering.expression(Meta.id));

try {
    const resultSet = await (await query.execute()).allResults();
    for (let result of resultSet) {
        console.log("Sample", String.format("hotel id -> %s", result.getString("id")));
        console.log("Sample", String.format("hotel name -> %s", result.getString("name")));
    }
} catch (e) {
    Log.e("Sample", e.getLocalizedMessage());
}

The SelectResult.all() method can be used to query all the properties of a document. In this case, the document in the result is embedded in a dictionary where the key is the database name. The following snippet shows the same query using SelectResult.all() and the result in JSON.

let query = QueryBuilder
    .select(SelectResult.all())
    .from(DataSource.database(database))
    .where(Expression.property("type").equalTo(Expression.string("airline")));

const results = await (await query.execute()).allResults();

for (var key in results) {
    // SelectResult.all() returns all properties, but puts them into this JSON format:
    // [ { "*": { version: "2.0", type: "SDK", company: "Ionic" } } ]
    // Couchbase can query multiple databases at once, so "*" represents just this single database.
    let singleResult = results[key]["*"];

    // do something with the data
}

[
    {
        "*": {
            "callsign": "MILE-AIR",
            "country": "United States",
            "iata": "Q5",
            "icao": "MLA",
            "id": 10,
            "name": "40-Mile Air",
            "type": "airline"
        }
    },
    {
        "*": {
            "callsign": "TXW",
            "country": "United States",
            "iata": "TQ",
            "icao": "TXW",
            "id": 10123,
            "name": "Texas Wings",
            "type": "airline"
        }
    }
]

Retrieve nested document objects

{
    "_id": "airport123",
    "type": "airport",
    "country": "United States",
    "geo": { "altitude": 456 },
    "tz": "America/Anchorage"
}

In the above example, access nested objects like altitude using periods (geo.altitude):

let query = QueryBuilder
    .select(SelectResult.property("geo.altitude"))
    .from(DataSource.database(database));

Retrieve All Unique Values for One Column

Retrieve all unique values in the database for one specific column of data. Useful for populating dropdown controls as part of a search interface, for example.

// Find all unique Hotel names, for example
// documentPropertyName = "hotel"
public async getAllUniqueValues(documentPropertyName: string) {
    const query = QueryBuilder.selectDistinct(
        SelectResult.property(documentPropertyName))
      .from(DataSource.database(this.database))
      .orderBy(Ordering.property(documentPropertyName).ascending());
    
    const results = await (await query.execute()).allResults();
    return results.map(x => x[documentPropertyName]);
}

WHERE Statement

Similar to SQL, you can use the where clause to filter the documents to be returned as part of the query. The select statement takes in an Expression. You can chain any number of Expressions in order to implement sophisticated filtering capabilities.

Comparison

The comparison operators can be used in the WHERE statement to specify on which property to match documents. In the example below, we use the equalTo operator to query documents where the type property equals "hotel".

{
    "_id": "hotel123",
    "type": "hotel",
    "name": "Apple Droid"
}

let query = QueryBuilder
    .select(SelectResult.all())
    .from(DataSource.database(database))
    .where(Expression.property("type").equalTo(Expression.string("hotel")))
    .limit(Expression.intValue(10));
let rs = await (await query.execute()).allResults();
for (let result of rs) {
    let all = result.getDictionary(DATABASE_NAME);
    console.log("Sample", String.format("name -> %s", all.getString("name")));
    console.log("Sample", String.format("type -> %s", all.getString("type")));
}

Collection Operators

Collection operators are useful to check if a given value is present in an array.

CONTAINS Operator

The following example uses the Function.arrayContains to find documents whose public_likes array property contain a value equal to "Armani Langworth".

{
    "_id": "hotel123",
    "name": "Apple Droid",
    "public_likes": ["Armani Langworth", "Elfrieda Gutkowski", "Maureen Ruecker"]
}

let query = QueryBuilder
    .select(SelectResult.expression(Meta.id),
        SelectResult.property("name"),
        SelectResult.property("public_likes"))
    .from(DataSource.database(database))
    .where(Expression.property("type").equalTo(Expression.string("hotel"))
        .and(ArrayFunction.contains(Expression.property("public_likes"), Expression.string("Armani Langworth"))));
let rs = await (await query.execute()).allResults();
for (let result of rs)
    console.log("Sample", String.format("public_likes -> %s", result.getArray("public_likes").toList()));

IN Operator

The IN operator is useful when you need to explicitly list out the values to test against. The following example looks for documents whose first, last or username property value equals "Armani".

let values = new Expression[] {
    Expression.property("first"),
    Expression.property("last"),
    Expression.property("username")
};

let query = QueryBuilder.select(SelectResult.all())
    .from(DataSource.database(database))
    .where(Expression.string("Armani").in(values));

Like Operator

The like operator can be used for string matching. It is recommended to use the like operator for case insensitive matches and the regex operator (see below) for case sensitive matches.

In the example below, we are looking for documents of type landmark where the name property exactly matches the string "Royal engineers museum". Note that since like does a case insensitive match, the following query will return "landmark" type documents with name matching "Royal Engineers Museum", "royal engineers museum", "ROYAL ENGINEERS MUSEUM" and so on.

let query = QueryBuilder
    .select(SelectResult.expression(Meta.id),
        SelectResult.property("country"),
        SelectResult.property("name"))
    .from(DataSource.database(database))
    .where(Expression.property("type").equalTo(Expression.string("landmark"))
        .and(Expression.property("name").like(Expression.string("Royal Engineers Museum"))));
let rs = await (await query.execute()).allResults();
for (let result of rs) {
    console.log("Sample", `name -> ${result.getString("name")}`);
}

Wildcard Match

We can use % sign within a like expression to do a wildcard match against zero or more characters. Using wildcards allows you to have some fuzziness in your search string.

In the example below, we are looking for documents of type "landmark" where the name property matches any string that begins with "eng" followed by zero or more characters, the letter "e", followed by zero or more characters. The following query will return "landmark" type documents with name matching "Engineers", "engine", "english egg" , "England Eagle" and so on. Notice that the matches may span word boundaries.

let query = QueryBuilder
    .select(SelectResult.expression(Meta.id),
        SelectResult.property("country"),
        SelectResult.property("name"))
    .from(DataSource.database(database))
    .where(Expression.property("type").equalTo(Expression.string("landmark"))
        .and(Expression.property("name").like(Expression.string("Eng%e%"))));
let rs = await (await query.execute()).allResults();
for (let result of rs)
    console.log("Sample", `name -> ${result.getString("name")}`);

A reusable function can easily be created that formats an expression, usable in a Where clause, for fuzzy searching:

// Specify a reserved word
private EMPTY_PLACEHOLDER = "Any";

private formatWildcardExpression(propValue) {
    return Expression.string(
        `%${propValue === this.EMPTY_PLACEHOLDER ? "" : propValue}%`);
}

// snippet:
.where(Expression.property("office").like(
    this.formatWildcardExpression(office))

Wildcard Character Match

We can use _ sign within a like expression to do a wildcard match against a single character.

In the example below, we are looking for documents of type "landmark" where the name property matches any string that begins with "eng" followed by exactly 4 wildcard characters and ending in the letter "r". The following query will return "landmark" type documents with the name matching "Engineer", "engineer" and so on.

let query = QueryBuilder
    .select(SelectResult.expression(Meta.id),
        SelectResult.property("country"),
        SelectResult.property("name"))
    .from(DataSource.database(database))
    .where(Expression.property("type").equalTo(Expression.string("landmark"))
        .and(Expression.property("name").like(Expression.string("Eng____r"))));
let rs = await (await query.execute()).allResults();
for (let result of rs)
    console.log("Sample", `name -> ${result.getString("name")}`);

Regex Operator

The regex expression can be used for case sensitive matches. Similar to wildcard like expressions, regex expressions based pattern matching allow you to have some fuzziness in your search string.

In the example below, we are looking for documents of type "landmark" where the name property matches any string (on word boundaries) that begins with "eng" followed by exactly 4 wildcard characters and ending in the letter "r". The following query will return "landmark" type documents with name matching "Engine", "engine" and so on. Note that the \b specifies that the match must occur on word boundaries.

let query = QueryBuilder
    .select(SelectResult.expression(Meta.id),
        SelectResult.property("country"),
        SelectResult.property("name"))
    .from(DataSource.database(database))
    .where(Expression.property("type").equalTo(Expression.string("landmark"))
        .and(Expression.property("name").regex(Expression.string("\\bEng.*r\\b"))));
let rs = await (await query.execute()).allResults();
for (let result of rs)
    console.log("Sample", `name -> ${result.getString("name")}`);

JOIN Statement

The JOIN clause enables you to create new input objects by combining two or more source objects.

The following example uses a JOIN clause to find the airline details which have routes that start from RIX. This example JOINS the document of type "route" with documents of type "airline" using the document ID (_id) on the "airline" document and airlineid on the "route" document.

let query = QueryBuilder.select(
    SelectResult.expression(Expression.property("name").from("airline")),
    SelectResult.expression(Expression.property("callsign").from("airline")),
    SelectResult.expression(Expression.property("destinationairport").from("route")),
    SelectResult.expression(Expression.property("stops").from("route")),
    SelectResult.expression(Expression.property("airline").from("route")))
    .from(DataSource.database(database).as("airline"))
    .join(Join.join(DataSource.database(database).as("route"))
        .on(Meta.id.from("airline").equalTo(Expression.property("airlineid").from("route"))))
    .where(Expression.property("type").from("route").equalTo(Expression.string("route"))
        .and(Expression.property("type").from("airline").equalTo(Expression.string("airline")))
        .and(Expression.property("sourceairport").from("route").equalTo(Expression.string("RIX"))));
let rs = await (await query.execute()).allResults();
for (let result of rs)
    console.log("Sample", String.format("%s", result.toMap().toString()));

GROUP BY statement

You can perform further processing on the data in your result set before the final projection is generated. The following example looks for the number of airports at an altitude of 300 ft or higher and groups the results by country and timezone.

{
    "_id": "airport123",
    "type": "airport",
    "country": "United States",
    "geo": { "alt": 456 },
    "tz": "America/Anchorage"
}

let query = QueryBuilder.select(
    SelectResult.expression(Function.count(Expression.string("*"))),
    SelectResult.property("country"),
    SelectResult.property("tz"))
    .from(DataSource.database(database))
    .where(Expression.property("type").equalTo(Expression.string("airport"))
        .and(Expression.property("geo.alt").greaterThanOrEqualTo(Expression.intValue(300))))
    .groupBy(Expression.property("country"),
        Expression.property("tz"))
    .orderBy(Ordering.expression(Function.count(Expression.string("*"))).descending());
let rs = await (await query.execute()).allResults();
for (let result of rs)
    console.log("Sample",
        String.format("There are %d airports on the %s timezone located in %s and above 300ft",
            result.getInt("$1"),
            result.getString("tz"),
            result.getString("country")));

There are 138 airports on the Europe/Paris timezone located in France and above 300 ft
There are 29 airports on the Europe/London timezone located in United Kingdom and above 300 ft
There are 50 airports on the America/Anchorage timezone located in United States and above 300 ft
There are 279 airports on the America/Chicago timezone located in United States and above 300 ft
There are 123 airports on the America/Denver timezone located in United States and above 300 ft

ORDER BY statement

It is possible to sort the results of a query based on a given expression result. The example below returns documents of type equal to "hotel" sorted in ascending order by the value of the title property.

let query = QueryBuilder
    .select(SelectResult.expression(Meta.id),
        SelectResult.property("name"))
    .from(DataSource.database(database))
    .where(Expression.property("type").equalTo(Expression.string("hotel")))
    .orderBy(Ordering.property("name").ascending())
    .limit(Expression.intValue(10));
let rs = await (await query.execute()).allResults();
for (let result of rs)
    console.log("Sample", result.toMap());

Aberdyfi
Achiltibuie
Altrincham
Ambleside
Annan
Ardèche
Armagh
Avignon

Indexing

Creating indexes can speed up the performance of queries. While indexes make queries faster, they also make writes slightly slower, and the Couchbase Lite database file slightly larger. As such, it is best to only create indexes when you need to optimize a specific case for better query performance.

The following example creates a new index for the type and name properties.

{
  "_id": "hotel123",
  "type": "hotel",
  "name": "Apple Droid"
}

database.createIndex("TypeNameIndex",
    IndexBuilder.valueIndex(ValueIndexItem.property("type"),
        ValueIndexItem.property("name")));

If there are multiple expressions, the first one will be the primary key, the second the secondary key, etc.

Note: Every index has to be updated whenever a document is updated, so too many indexes can hurt performance. Thus, good performance depends on designing and creating the right indexes to go along with your queries.

Full-Text Search

To run a full-text search (FTS) query, you must have created a full-text index on the expression being matched. Unlike regular queries, the index is not optional. The following example inserts documents and creates an FTS index on the name property.

database.createIndex("nameFTSIndex", IndexBuilder.fullTextIndex(FullTextIndexItem.property("name")).ignoreAccents(false));

Multiple properties to index can be specified in the index creation method.

With the index created, an FTS query on the property that is being indexed can be constructed and ran. The full-text search criteria is defined as a FullTextExpression. The left-hand side is the full-text index to use and the right-hand side is the pattern to match.

let whereClause = FullTextExpression.index("nameFTSIndex").match("buy");
let ftsQuery = QueryBuilder.select(SelectResult.expression(Meta.id))
    .from(DataSource.database(database))
    .where(whereClause);
let ftsQueryResult = await (await ftsQuery.execute()).allResults();
for (let result of ftsQueryResult)
    console.log(String.format("document properties %s", result.getString(0)));

In the example above, the pattern to match is a word, the full-text search query matches all documents that contain the word "buy" in the value of the doc.name property.

Full-text search is supported in the following languages: danish, dutch, english, finnish, french, german, hungarian, italian, norwegian, portuguese, romanian, russian, spanish, swedish and turkish.

The pattern to match can also be in the following forms:

prefix queries: the query expression used to search for a term prefix is the prefix itself with a "*" character appended to it. For example:

"'lin*'"
-- Query for all documents containing a term with the prefix "lin". This will match
-- all documents that contain "linux", but also those that contain terms "linear",
--"linker", "linguistic" and so on.

overriding the property name that is being indexed: Normally, a token or token prefix query is matched against the document property specified as the left-hand side of the match operator. This may be overridden by specifying a property name followed by a ":" character before a basic term query. There may be space between the ":" and the term to query for, but not between the property name and the ":" character. For example:

'title:linux problems'
-- Query the database for documents for which the term "linux" appears in
-- the document title, and the term "problems" appears in either the title
-- or body of the document.</pre>

phrase queries: a phrase query is a query that retrieves all documents that contain a nominated set of terms or term prefixes in a specified order with no intervening tokens. Phrase queries are specified by enclosing a space separated sequence of terms or term prefixes in double quotes ("). For example:

"'"linux applications"'"
-- Query for all documents that contain the phrase "linux applications".</pre>

NEAR queries: A NEAR query is a query that returns documents that contain a two or more nominated terms or phrases within a specified proximity of each other (by default with 10 or less intervening terms). A NEAR query is specified by putting the keyword "NEAR" between two phrase, token or token prefix queries. To specify a proximity other than the default, an operator of the form "NEAR/" may be used, where is the maximum number of intervening terms allowed. For example:

"'database NEAR/2 "replication"'"
-- Search for a document that contains the phrase "replication" and the term
-- "database" with not more than 2 terms separating the two.</pre>

AND, OR & NOT query operators: The enhanced query syntax supports the AND, OR and NOT binary set operators. Each of the two operands to an operator may be a basic FTS query, or the result of another AND, OR or NOT set operation. Operators must be entered using capital letters. Otherwise, they are interpreted as basic term queries instead of set operators. For example:

'couchbase AND database'
-- Return the set of documents that contain the term "couchbase", and the
-- term "database". This query will return the document with docid 3 only.</pre>

When using the enhanced query syntax, parenthesis may be used to specify the precedence of the various operators. For example:

'("couchbase database" OR "sqlite library") AND linux'
-- Query for the set of documents that contains the term "linux", and at least
-- one of the phrases "couchbase database" and "sqlite library".</pre>

Ordering results

It’s very common to sort full-text results in descending order of relevance. This can be a very difficult heuristic to define, but Couchbase Lite comes with a ranking function you can use. In the OrderBy array, use a string of the form Rank(X), where X is the property or expression being searched, to represent the ranking of the result.

Replication

Couchbase Mobile 2.0 uses a new replication protocol based on WebSockets.

Compatibility

The new protocol is incompatible with CouchDB-based databases. And since Couchbase Lite 2 only supports the new protocol, you will need to run a version of Sync Gateway that supports it.

To use this protocol with Couchbase Lite 2.0, the replication URL should specify WebSockets as the URL scheme (see the "Starting a Replication" section below). Mobile clients using Couchbase Lite 1.x can continue to use http as the URL scheme. Sync Gateway 2.0 will automatically use the 1.x replication protocol when a Couchbase Lite 1.x client connects through http://localhost:4984/db and the 2.0 replication protocol when a Couchbase Lite 2.0 client connects through ws://localhost:4984/db.

Starting Sync Gateway

Download Sync Gateway and start it from the command line with the configuration file created above.

~/Downloads/couchbase-sync-gateway/bin/sync_gateway

For platform specific installation instructions, refer to the Sync Gateway installation guide.

Starting a Replication

Replication can be bidirectional, this means you can start a push/pull replication with a single instance. The replication’s parameters can be specified through the ReplicatorConfiguration object; for example, if you wish to start a push only or pull only replication.

The following example creates a pull replication with Sync Gateway.

class MyClass {
  database: Database;
  replicator: Replicator;

  startReplication() {
    let endpoint = new URLEndpoint('ws://10.0.2.2:4984/db');
    let config = new ReplicatorConfiguration(this.database, endpoint);
    config.setReplicatorType(ReplicatorConfiguration.ReplicatorType.PULL);
    this.replicator = new Replicator(config);
    return this.replicator.start();
  }
}

A replication is an asynchronous operation. To keep a reference to the replicator object, you can set it as an instance property.

To verify that documents have been replicated, you can:

Monitor the Sync Gateway sequence number returned by the database endpoint (GET /{db}/). The sequence number increments for every change that happens on the Sync Gateway database.
Query a document by ID on the Sync Gateway REST API (GET /{db}/{id}).
Query a document from the Query Workbench on the Couchbase Server Console.

Couchbase Lite 2.0 uses WebSockets as the communication protocol to transmit data. Some load balancers are not configured for WebSocket connections by default (NGINX for example); so it might be necessary to explicitly enable them in the load balancer’s configuration (see Load Balancers).

By default, the WebSocket protocol uses compression to optimize for speed and bandwidth utilization. The level of compression is set on Sync Gateway and can be tuned in the configuration file (replicator_compression).

Replication Ordering

To optimize for speed, the replication protocol doesn’t guarantee that documents will be received in a particular order. So we don’t recommend to rely on that when using the replication or database change listeners for example.

Troubleshooting

As always, when there is a problem with replication, logging is your friend. The following example increases the log output for activity related to replication with Sync Gateway.

Database.setLogLevel(LogDomain.REPLICATOR, LogLevel.VERBOSE);

Replication Status

The replication.Status.Activity property can be used to check the status of a replication. For example, when the replication is actively transferring data and when it has stopped.

replication.addChangeListener((change) => {
  if (change.activityLevel == Replicator.ActivityLevel.STOPPED)
      console.log("Replication stopped");
});

The following table lists the different activity levels in the API and the meaning of each one.

State Meaning

State	Meaning
`STOPPED`	The replication is finished or hit a fatal error.
`OFFLINE`	The replicator is offline as the remote host is unreachable.
`CONNECTING`	The replicator is connecting to the remote host.
`IDLE`	The replication caught up with all the changes available from the server. The `IDLE` state is only used in continuous replications.
`BUSY`	The replication is actively transferring data.

STOPPED

The replication is finished or hit a fatal error.

OFFLINE

The replicator is offline as the remote host is unreachable.

CONNECTING

The replicator is connecting to the remote host.

IDLE

The replication caught up with all the changes available from the server. The IDLE state is only used in continuous replications.

BUSY

The replication is actively transferring data.

Handling Network Errors

If an error occurs, the replication status will be updated with an Error which follows the standard HTTP error codes. The following example monitors the replication for errors and logs the error code to the console.

replication.addChangeListener((change) => {
  let error = change.error;
  if (error != null)
      console.log("Error code::", error.getCode());
});
replication.start();

When a permanent error occurs (i.e., 404: not found, 401: unauthorized), the replicator (continuous or one-shot) will stop permanently. If the error is temporary (i.e., waiting for the network to recover), a continuous replication will retry to connect indefinitely and if the replication is one-shot it will retry for a limited number of times. The following error codes are considered temporary by the Couchbase Lite replicator and thus will trigger a connection retry.

408: Request Timeout
429: Too Many Requests
500: Internal Server Error
502: Bad Gateway
503: Service Unavailable
504: Gateway Timeout
1001: DNS resolution error

Custom Headers

Custom headers can be set on the configuration object. And the replicator will send those header(s) in every request. As an example, this feature can be useful to pass additional credentials when there is an authentication or authorization step being done by a proxy server (between Couchbase Lite and Sync Gateway).

let config = new ReplicatorConfiguration(database, endpoint);
config.setHeaders({
  "CustomHeaderName": "Value"
});

Handling Conflicts

In Couchbase Lite 2.0, document conflicts are automatically resolved. This functionality aims to simplify the default behavior of conflict handling and save disk space (conflicting revisions will no longer be stored in the database). There are 2 different save method signatures to specify how to handle a possible conflict:

save(document: MutableDocument): when concurrent writes to an individual record occur, the conflict is automatically resolved and only one non-conflicting document update is stored in the database. The Last-Write-Win (LWW) algorithm is used to pick the winning revision.
save(document: MutableDocument, concurrencyControl: ConcurrencyControl): attempts to save the document with a concurrency control. The concurrency control parameter has two possible values: - lastWriteWins: The last operation wins if there is a conflict. - failOnConflict: The operation will fail if there is a conflict.

Similarly to the save operation, the delete operation also has two method signatures to specify how to handle a possible conflict:

delete(document: Document): The last write will win if there is a conflict.
delete(document: Document, concurrencyControl: ConcurrencyControl): attemps to delete the document with a concurrency control. The concurrency control parameter has two possible values: - lastWriteWins: The last operation wins if there is a conflict. - failOnConflict: The operation will fail if there is a conflict.

Database Replicas

Database replicas is available in the Ionic Native only (https://www.couchbase.com/downloads). Starting in Couchbase Lite 2.0, replication between two local databases is now supported. It allows a Couchbase Lite replicator to store data on secondary storage. It would be especially useful in scenarios where a user’s device is damaged and the data needs to be moved to a different device. Note that the code below won’t compile if you’re running the Community Plugin of Couchbase Lite.

Changelog

[1.2.0] (2020-07-24)

Features

adding replication listening API

Bug Fixes

android: removed deleted files from cordova plugin xml

1.1.0 (2020-01-08)

Features

add hook to remove unused archs from CouchbaseLite.framework

1.0.6 (2019-12-17)

Bug Fixes

field mapping on all results for Android 818b4da
convert * to database name in . result

Installation​

Project Requirements​

Getting Started​

Database​

New Database​

Loading a pre-built Database​

Document​

Initializers​

Typed Accessors​

Batch Operations​

Blobs​

Query​

SELECT statement​

Retrieve nested document objects​

Retrieve All Unique Values for One Column​

WHERE Statement​

Comparison​

Collection Operators​

CONTAINS Operator​

IN Operator​

Like Operator​

Wildcard Match​

Wildcard Character Match​

Regex Operator​

JOIN Statement​

GROUP BY statement​

ORDER BY statement​

Indexing​

Full-Text Search​

Ordering results​

Replication​

Compatibility​

Starting Sync Gateway​

Starting a Replication​

Replication Ordering​

Troubleshooting​

Replication Status​

Handling Network Errors​

Custom Headers​

Handling Conflicts​

Database Replicas​

[1.2.0] (2020-07-24)​

Features​

Bug Fixes​

1.1.0 (2020-01-08)​

Features​

1.0.6 (2019-12-17)​

Bug Fixes​

Installation

Project Requirements

Getting Started

Database

New Database

Loading a pre-built Database

Document

Initializers

Typed Accessors

Batch Operations

Blobs

Query

SELECT statement

Retrieve nested document objects

Retrieve All Unique Values for One Column

WHERE Statement

Comparison

Collection Operators

CONTAINS Operator

IN Operator

Like Operator

Wildcard Match

Wildcard Character Match

Regex Operator

JOIN Statement

GROUP BY statement

ORDER BY statement

Indexing

Full-Text Search

Ordering results

Replication

Compatibility

Starting Sync Gateway

Starting a Replication

Replication Ordering

Troubleshooting

Replication Status

Handling Network Errors

Custom Headers

Handling Conflicts

Database Replicas

[1.2.0] (2020-07-24)

Features

Bug Fixes

1.1.0 (2020-01-08)

Features

1.0.6 (2019-12-17)

Bug Fixes