Content

  • N1QL vs SQL
  • Database architecture in DSL & DSM
  • Couchbase Server
  • Couchbase Sync Gateway
  • Couchbase Lite

N1QL VS SQL

N1QL SQL
Data Model  Free-form documents, gathered into large collections called keyspaces












 
Uniform structure

N1QL extends SQL from traditionally operating on tables and rows (tuples) to operate on JSON (nested documents).

N1QL VS SQL


 
N1QL SQL
Data Projection permits data reshaping, by embedding statement-attributes in the desired result-object shape

Query:

SELECT Name, History, {'FullTime': true} AS 'Status' FROM HRData







  
a set of rows is returned; each row consisting of one or more columns, and the columns being the same for each row
Query:

SELECT Name, Company FROM Employee, Employers WHERE Name_Key = Name


  

 Database Architecture in DSL & DSM

Mobile App

Couchbase Server

Couchbase Server is the NoSQL document database for data synchronization with SmartFL App

  • An open source, distributed, JSON document database
  • For mobile and IoT environments Couchbase also runs natively on-device and manages synchronization to the server.
  • Specialized to provide low-latency data management for large-scale interactive web, mobile, and IoT applications

Architecture in DSL 

SmartFL app

Couchbase Sync Gateway

The synchronization server in a Couchbase for Mobile and Edge deployment. It is designed to provide data synchronization for large-scale interactive web, mobile, and IoT applications

Couchbase Sync Gateway

In DSL&DSM: Sync Gateway is the synchronization engine between                            Couchbase Server and SmartFL App

Couchbase Lite

An embedded, NoSQL JSON Document Style database for your mobile apps

Features : 

  • Offline First:

 Data is available in your local embedded database when offline, can sync with the backend data centers when the network becomes available.

Couchbase Lite

Features : 

  • Developer Friendly:

An easy-to-use API provides applications with comprehensive data access functionality using CRUD and query capabilities.

  • Lightweight:

Has a small footprint, ranging from 1MB – 5MB depending on the platform.

Couchbase Lite

Features : 

  • Multiplatform Support:

Support for mobile platforms including iOS, Android, and Windows.

Support for non-mobile desktop and web server apps with .NET and Java libraries.

References

Made with Slides.com