Category: SQL++ / N1QL Query
The Fastest Way to Identify PII Stored in your Database: A Simple Example Using N1QL, Nodejs and Docker
A frequent request from customers is a way to identify PII within their databases. I thought I’d show a brief example how this can be done. User Story: “I want to identify unencrypted credit card numbers and social security numbers...
Todd Greenstein
June 1, 2017
Sample Application with Spring and Angular: GitTalent
One of the first big projects I was involved in after I started at Couchbase last year was helping to create a sample application that would be demonstrated at Couchbase Connect. Sample application It was an enormous team effort to...
Matthew Groves
May 3, 2017
New to Couchbase Server 5.0: GSI replicas and rebalancing
Couchbase Server 4.0 introduced Global Secondary Indexes (GSI) to support the N1QL query engine. Now, with Couchbase Server 5.0 (as of the April developer build), we have added the ability to automatically replicate and rebalance these indexes. At first, GSIs...
Perry Krug
April 30, 2017
Perform Various N1QL Queries without Indexes in Couchbase Server
As you probably already know, you’re able to query Couchbase NoSQL documents using a SQL dialect called N1QL. This is made possible through indexes that you create on documents in your Couchbase Buckets. However, what if I told you that...
Nic Raboy, Developer Advocate, Couchbase
April 11, 2017
Document-Oriented Database and N1QL
Michael K. Aboagye works as an application security engineer and web pentester with good knowledge in Linux, Git, PHP, Java, RDMS and Nosql database development. He likes to dabble in devops also. Document-Oriented Database and N1QL For this article, I will share...
Laura Czajkowski, Developer Community Manager, Couchbase
April 5, 2017
Performance Enhancements to N1QL in the Couchbase 5.0 March Developer Build
N1QL in Couchbase has come a long way since it was first introduced in Couchbase Server 4.0. In Couchbase 5.0, things are taken to the next level in terms of performance. In terms of the March 2017 Developer build of Couchbase...
Nic Raboy, Developer Advocate, Couchbase
March 27, 2017
ANN: Couchbase Lite Developer Build 003 (Obj C, Swift, .NET)
I am very pleased that Couchbase Lite Developer Build 003 is now available for download for Objective C, Swift and “.NET”. Database queries have changed significantly in this release. Couchbase Lite 2.0 uses semantics based on N1QL query language defined...
Sachin Smotra, Director Product Management, Couchbase
March 24, 2017
Working with Arrays in Couchbase with N1QL – Video Tutorial
In a recent article, I wrote about flattening and querying arrays in Couchbase using N1QL. That article was inspired by a popular question in the Couchbase Forums. After publishing the article, I felt a write-up alone couldn’t do it justice...
Nic Raboy, Developer Advocate, Couchbase
March 24, 2017
N1QL: A Practical Guide
N1QL is designed to help developers easily develop applications to solve real-world problems. Technically, N1QL is designed to give developers and enterprises an expressive, powerful, and complete language for querying, transforming, and manipulating JSON data. N1QL takes inspiration from SQL...
Keshav Murthy
March 17, 2017
Feature Enhancements to N1QL in the Couchbase Server 5.0 March Developer Build
With the recent March 2017 Developer build of Couchbase there were many bug fixes, but also feature enhancements to core technologies like N1QL. For example, now indexes can be created on various meta information such as the document cas and...
Nic Raboy, Developer Advocate, Couchbase
March 17, 2017
Profiling and Monitoring in Couchbase Server 5.0 Preview (Update)
In March’s developer build, there are some more updates for N1QL query monitoring and profiling. Go download the March 5.0.0 developer release of Couchbase Server today. Make sure to click the “Developer” tab to get the developer build (DB), and...
Matthew Groves
March 16, 2017
Migrate From MongoDB to Couchbase with N1QL
Customers often tell us they’re preparing to migrate from MongoDB to Couchbase. They come, in part, because they’re tired of the problems they’ve experienced learning how to query MongoDB. Couchbase with N1QL provides a better alternative, especially for scaling up...
Nic Raboy, Developer Advocate, Couchbase
March 7, 2017