I’m working on my app to replace my SQLite database with Couchbase Lite, which will bring a much needed feature such as real-time synchronization.
However, I’m wondering what kind of queries I’ll be able to do on Couchbase Lite. Will I be able to run “complex” N1QL queries using features like UNNEST, JOIN and aggregation operators (AVG, SUM, COUNT, etc.)?
Also, is there a way to run raw N1QL queries?
February 15, 2018, 11:21pm
We support joins and aggregation, but not UNNEST. Check the documentation for more details.
There is no N1QL parser in CBL. Queries are constructed programmatically.
Additional info : The
announcement includes links to several query related blogs. And of course the documentation…
Which platform are on you ? If you are on swift, there is query playground available
here for trying things out
@priya.rajagopal I’m on Android and Objective-C, no Swift for the moment, but thank you very much for the links.
Should be quite straightforward to map between the languages - hopefully. That’s been the goal of the Query spec and the Query Builder should assist you with that.
@priya.rajagopal I checked the documentation and, if I’m not mistaken, Query Builder is available on Couchbase Lite 2 only, apparently it’s not available on 1.4 or 1.5, right?
I plan to deploy Couchbase Mobile in 4-5 months, by then I suppose there will be a stable release of Couchbase Lite 2.
I checked the documentation and, if I’m not mistaken, Query Builder is available on Couchbase Lite 2 only, apparently it’s not available on 1.4 or 1.5, right?
Correct . 2.0 only.
Yes. Thats the plan. We should go GA by then. We are feature complete now so its code hardening between now and GA.
Hi, I know this is closed! But what should be the alternative for UNNEST?