N1QL = SQL + JSON : A Practical Guide
N1QL = SQL + JSON : A Practical Guide
Consider this your one stop shop for N1QL tutorials, research, and, well, anything else you may want to learn about regarding N1QL.
Join the DZone community and get the full member experience.
Join For FreeDatabases are better when they can run themselves. CockroachDB is a SQL database that automates scaling and recovery. Check it out here.
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 and extends SQL to handle flexible, nested structures of JSON.
This book is a compilation of DZone articles on NoSQL concepts, N1QL features, optimization techniques, tools and use cases, written by the Couchbase N1QL R&D team and solution team. This makes it a bit more practical for readers who enjoy reading by sub-topics.
Click on this image to download the full book or read individual articles below.
Table of Contents
Enterprise Jobs to Be Done by Gerald Sangudi and Keshav Murthy
Query on JSON
Keep Calm and JSON by Keshav Murthy
Keep Calm and Query JSON by Keshav Murthy
NESTing and UNNESTing in Couchbase N1QL by Johan Larson
Working with Schema in a Schema Flexible Datastore by Eben Haber
Indexing
Indexing JSON in Couchbase by Keshav Murthy
Designing Index For Query In Couchbase N1QL by Sitaram Vemulapalli
JOIN Faster With Couchbase Index JOINs by Keshav Murthy
A Couchbase Index Technique for LIKE Predicates With Wildcard by Tai Tran
Optimization
A Deep Dive Into Couchbase N1QL Query Optimization by Keshav Murthy and Sitaram Vemulapalli
Understanding Index Scans in Couchbase N1QL Query by Sitaram Vemulapalli
COUNT and GROUP Faster With N1QL by Keshav Murthy
More Than LIKE: Efficient JSON Searching With N1QL by Keshav Murthy
SPLIT and CONQUER: Efficient String Search With N1QL in Couchbase by Keshav Murthy
Performance Ingredients for NoSQL: Intersect Scans in N1QL by Prasad Varakur
The Latest Performance Tricks in N1QL by Prasad Varakur
Apps in N1QL Land: Magic With Pretty, Suffix, Update, and More by Prasad Varakur
Use Cases
SQL on Twitter: Analysis Made Easy Using N1QLby by Keshav Murthy
What's in a New York Name? Unlock data.gov Using N1QL by Keshav Murthy
How to Speed Up Spatial Search in Couchbase N1QL by Keshav Murthy
Monitoring and Tooling
Mastering the Couchbase N1QL Shell: Connection Management and Security by Isha Kandaswamy
Query Performance Monitoring Made Easy With Couchbase N1QL by Marco Greco
Migration and Competition
ELT Processing With Couchbase and N1QL by Manuel Hurtado
Migrate From Any Relational Engine to Couchbase Using N1QL and SQSL by Marco Greco
How Couchbase Won YCSB by Keshav Murthy
Concurrency Behavior: MongoDB vs. Couchbase by Keshav Murthy
Databases should be easy to deploy, easy to use, and easy to scale. If you agree, you should check out CockroachDB, a scalable SQL database built for businesses of every size. Check it out here.
Like This Article? Read More From DZone
Opinions expressed by DZone contributors are their own.
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}