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.
