How to create an index under CBL Android 2.0 DB018

Marten · November 2, 2017, 2:18pm

Please provide a basic example which shows the usage of createIndex(String name, Index index) from Database.java in DB018. Especially how to use Index.java.

jens · November 3, 2017, 12:21am

The TravelSample sample code provides such an example.

priya.rajagopal · November 3, 2017, 2:36pm

Here is an example of creating a FTS index from Travel Sample App -

github.com

couchbaselabs/mobile-travel-sample/blob/connect_sv/android/app/src/main/java/com/couchbase/travelsample/util/DatabaseManager.java#L76


        InputStream inputStream = assetManager.open(filename);
        File outFile = new File(context.getFilesDir(), filename);
        FileOutputStream out = new FileOutputStream(outFile);
        copyFile(inputStream, out);
        unpackZip(context.getFilesDir().getPath() + "/", filename);
    } catch (IOException e) {
        e.printStackTrace();
    }
}


private void createFTSQueryIndex() {
    try {
        database.createIndex("descFTSIndex", Index.ftsIndex().on(FTSIndexItem.expression(Expression.property("description"))));
    } catch (CouchbaseLiteException e) {
        e.printStackTrace();
    }
}


private static boolean unpackZip(String path, String zipname)
{
    InputStream is;

Marten · November 3, 2017, 2:47pm

Thank you!

And how can I achieve something different than an FTS index?
For example a huge list of dates.

priya.rajagopal · November 3, 2017, 3:17pm

It’s very similar. You create a value index

For example, this creates an index on “type” property

    database.createIndex("typeIndex",Index.valueIndex().on(ValueIndexItem.expression(Expression.property("type"))));

jay · November 7, 2017, 2:59pm

Is it possible to create an index on two fields?

jay · November 7, 2017, 4:03pm

Actually I found it. Thanks

Topic		Replies	Views
CBL 2.1 indexing best practice and crash probelm Couchbase Lite java	6	1043	April 18, 2019
How to query index created in CBL 2.0 DB20? Couchbase Lite	4	1114	June 2, 2020
Couchbase lite index with expression Couchbase Lite query , java , mobile , index	5	2693	December 23, 2019
How to create like query over Index in CBL 2.0 Android Mobile java	1	605	May 21, 2018
CBL2 Index. How to have Query use a specific index Couchbase Lite	13	1786	January 31, 2019

How to create an index under CBL Android 2.0 DB018

Related topics