Category: Application Design
How to use N1QL to migrate Oracle data into Couchbase
Getting the Couchbase server to run on your PC or Mac involves a few simple steps to download the software and spin up a cluster with all the Couchbase services that you need (https://docs.couchbase.com/server/6.0/getting-started/start-here.html). Sample buckets are available with the...
Build a Diary Web Application with Couchbase as the Back-end
Michael Aboagye is a backend software/security engineer based in Ghana. He is interested in building secure backend services with Python. In this tutorial, we will look at how we can build a diary web application based on the flask framework...
The Unreasonable Effectiveness of SQL in NoSQL Databases: A Comparative Study.
The business applications have requirements: take customer orders, deliver customer orders, track shipping, generate inventory report, end of the day/month/quarter business report, generate business dashboards and more. These requirements evolve slowly. They remain even when you choose a NoSQL database....
N1QL Index Advisor: Improve Query Performance and Productivity
As application developers, your main focus is to design the most efficient queries for your application. You want to ensure the integrity of the data that your application pushes to the database, and construct the most efficient queries to retrieve...
Search and Rescue: 7 Reasons for N1QL (SQL) developers to use Search
People don’t want a four key index. They need a four-ms response. Ted Levitt Application development is demanding. Each application is trying to progress on behalf of the customer — searching for the right product or the right form, ordering,...
Couchbase’s N1QL Query Shatters the Limits of MongoDB™
As NoSQL adoption grows, developers and enterprises alike require a general purpose database to replatform their mission-critical applications and services. These databases are no longer used only by backend services that need sub-second access to the data, but also by...
Get a Bigger Picture with N1QL Window Functions and CTE
Whether it is a personal need to understand your spending pattern from looking at the bank transactions, or seeking to improve the sales performance in your organization by looking at the sales activities, the real insights are only visible with...
Couchbase beats MongoDB™ with greater flexibility and stronger availability for geo-distributed applications
Today’s businesses compete in a digital economy where downtime can be deadly. But keeping data highly available is never as simple as backing up one database to be an up-to-the-second copy of another. Instead, modern databases have to function in...
N1QL query with Self Referencing Hierarchy
A data construct that often appears in business application is the hierarchical data structure. Hierarchy captures the parent-child relationship often between the same object. For instance a company structure captures the reporting line between employees. Business organization captures the relationship...
Searching JSON: compare text search in Couchbase and MongoDB.
“Apps without search is like Google homepage without the search bar.” It’s hard to design an app without a good search. These days, it’s also hard to find a database without a built-in search. MySQL to NoSQL, Sybase to Couchbase,...