Any downsides to using plain SQL++ queries over the Query Builder in Couchbase Lite?

Mobile
, ,
1

I’m working with Couchbase Lite. I know that I can write queries either using the SQL++ or through the query builder.

Are there any downsides (performance, safety, etc) to using SQL++ compared to using the query builder?

Thank you

2

The main downside, which in my opinion is not a very big one, is that the SQL++ statements cannot be compile time checked. That being said, most of our users enjoy using it because largely they are reusing statements that they use on their server nodes and are willing to give up compile time safety for that convenience.

Furthermore, the QueryBuilder is soft deprecated (meaning it won’t be removed until we actually mark it deprecated and then it will remain until the next major release after that), so it is not receiving any new functionality.

With regards to performance SQL++ is likely to be better since QueryBuilder generates an intermediate that is then transformed into something that CBL can use whereas SQL++ is basically used directly.

3

Thank you for the helpful reply!