Category: SQL++ / N1QL Query
Prepared Statements – by the Numbers!
Always be Prepared…. In our last discussion on prepared statements in couchbase we talked about the performance gains that are possible using prepared statements. I thought I’d post a “sequel” with a few real world examples and numbers using the...
Prepare for This!
Get Prepared…. One of the more impressive aspects of using N1QL is the ability to use prepared statements. What are prepared statements? Why use them? What’s the big deal? Consider the following example from the travel-sample bucket and dataset that are bundled...
Locating cbq
cbq is the command-line REPL environment for N1QL and, since version 4.0, it comes along with Couchbase Server. It's a great tool to not only learn N1QL but also to try out and optimise queries before using them in your...
Moving SQL database content to Couchbase
Since the GA release of N1QL, we get a lot of questions about moving content from a SQL database to Couchbase. There are many different ways to do so. Today, I have chosen what is probably the simplest. I will...
Workaround for N1QL* Queries in the .NET SDK
This blog was originally posted on David Ostrovsky's personal blog. To see to original blog post, click here. TL;DR: SELECT myBucket.* FROM myBucket A change in the way N1QL returns results for star queries in Couchbase Server 4.1 seems to have...
N1QL vs TSQL – Aggregations with Couchbase Server vs SQL Server
SQL has been around for a loooooong time. It is very intuitive and efficient way to process structured data and has been the choice for databases for many years. With the world of BIG DATA however, data has velocity, variety...
Couchbasics: How Functional and Performance Needs Determine Data Access in Couchbase
There are multiple ways of getting data in and out of Couchbase. Notice that I did not say querying, I said in and out…on purpose. Not all ways of getting data in and out of Couchbase are querying like in...
Data modelling for N1QL
In my posts on key-value data modelling with Couchbase, the main concerns were: * when to embed data and when to refer * building secondary indexes * key design. In a N1QL world, we’re still thinking about similar things and in this post...
Hands-on with N1QL in London!
We're kicking off the 2016 Couchbase meet-up calendar in London with a hands-on N1QL workshop! Come and join us on January 20th at the Couchbase London office, in Shoreditch, to learn: the fundamentals of N1QL: what you can do and why how N1QL...
Getting Started with Tableau and Couchbase
Getting Started with Couchbase and Tableau With the release of Couchbase 4.0, business intelligence users now have access to document data stored in Couchbase via N1QL and ODBC/JDBC drivers from SIMBA. This is a quick start guide on how to integrate a...
Introducing Linq2Couchbase Developer Preview 1: The Linq provider for Couchbase N1QL!
Learn basic functionality of the Linq provider by checking out sample application that goes over the steps on how to use the provider today.
Couchbase .NET SDK 2.1.3 (and 2.1.2) released!
Today we are releasing a follow up release to 2.1.0 and 2.1.1 that includes support for Multidimensional Scaling (MDS) for Couchbase Server 4.0 Beta and a plethora of bug fixes! In this post i’ll explain what MDS is and...
Top Posts
- Data Modeling Explained: Conceptual, Physical, Logical
- What are Embedding Models? An Overview
- Data Analysis Methods: Qualitative vs. Quantitative Techniques
- What Is Data Analysis? Types, Methods, and Tools for Research
- Application Development Life Cycle (Phases and Management Models)
- Data Normalization vs. Denormalization Comparison
- App Development Costs (A Breakdown)
- What are Vector Embeddings?
- High Availability Architecture: Requirements & Best Practice...
