Categoría: SQL++ / N1QL Query
-
Processing GraphQL Queries with Java, Spring Boot, and NoSQL
Over the span of the past few months I’ve been learning about GraphQL and how to use it as an alternative to RESTful API development. The focus thus far had been around GraphQL and…
-
How to Join JSON: Couchbase N1QL vs. MongoDB Query
As NoSQL databases evolved, each added higher level APIs or languages to help programmers to complex things easily. SQL, having done that for relational data, showed the way. In SQL, developers say WHAT needs…
-
Michigan User Groups this month
Michigan user groups: watch out! I’ll be spending a solid week at in your state! I’ll be talking about the tech I’m most enthusiastic about, including: Couchbase Server, .NET, C#. If you’re anywhere in…
-
Divide and Conquer: Couchbase GSI Index partitioning.
In Couchbase, data is always partitioned using the consistent hash value of the document key into vbukets which are stored on the data nodes. Couchbase Global Secondary Index (GSI) abstracts the indexing operations and…
-
Understanding Index Grouping And Aggregation in Couchbase N1QL Query
Couchbase N1QL is a modern query processing engine designed to provide aggregate SQL for JSON by index on distributed data with a flexible data model. Modern databases are deployed on massive clusters. Using JSON…
-
Using Couchbase Analytics with Node.js and JavaScript
Note: This post uses the the Couchbase Analytics Data Definition Language as of the version 5.5 preview release. For updates and information on breaking changes in newer versions, please refer to Changes to the Couchbase…
-
New Features in Index Service in Couchbase Server 5.5
In the last major release, Couchbase Server 5.0, we introduced Plasma – New Storage Engine and also the support for Index Replicas in the Index Service. We have continued to build on these new features…
-
Configuring Analytics in Couchbase Server 5.5
Couchbase Analytics Developer Preview 4 brought the ability to manage Analytics nodes from the Couchbase Server administration console. With the release of Couchbase Server 5.5, we’ve unified the installation experience as well. To illustrate…
-
ANSI JOIN Support in N1QL
Overview ANSI JOIN support is added in N1QL to Couchbase version 5.5. In previous versions of Couchbase, join support was limited to lookup join and index join, which works great when the document key…
-
Database Pagination: Using OFFSET and Keyset in N1QL
Read the pagination background in my previous article: https://www.couchbase.com/blog/optimizing-database-pagination-using-couchbase-n1ql/ Pagination is the task of dividing the potential result into pages and retrieving the required pages, one by one on demand. Using OFFSET and LIMIT…
-
Couchbase Analytics Developer Preview 4 – Bringing NoETL to NoSQL
I am very excited to announce the release of Couchbase Analytics Developer Preview 4 (DP4). The focus of the previous release was unified administration, and we have continued to build on that theme in…
-
Oracle Date Format: N1QL and Support for Date-Time Functions
Date and Time functions and formats can vary for different databases. In this article, we shall compare Couchbase ISO-based Date-Time functions with Oracle Date format. Date formats vary between relational and NoSQL database due…