how to build your first couchbase application – couchbase live new york 2015

How to build your first Couchbase Application

Martin Esmann | Developer Advocate, CouchbaseMichael Nitschinger | SDK Engineer, Couchbase

©2015 Couchbase Inc. 2

Separation of Concerns

Design around clear system boundaries

FrontendBackendCouchbase JSONSDK


Sample Application

For 4.0, we’ve built a sample application

Uses the travel-sample bucket

Search flights and book your seats!

Pick your Language!

– Java: https://github.com/couchbaselabs/try-cb-java

– .NET: https://github.com/couchbaselabs/try-cb-dotnet

– NodeJS: https://github.com/couchbaselabs/try-cb-nodejs

– Go: https://github.com/couchbaselabs/try-cb-golang

https://github.com/couchbaselabs/try-cb-java

https://github.com/couchbaselabs/try-cb-dotnet

https://github.com/couchbaselabs/try-cb-nodejs

https://github.com/couchbaselabs/try-cb-golang

Data Modeling


Embrace the Couchbase Way

Modeling against Couchbase can be the same, but will likely be different than against an RDBMS (JSON is more flexible)

Think about your data access!

– Embedding vs. Referencing

– Key lookup patterns

– N1QL supports your application model

Check out: Couchbase Webinars & Docs on Data Modeling

– http://www.couchbase.com/nosql-resources/webinar/

– http://docs.couchbase.com/developer/dev-guide-3.0/modeling-docs.html

http://www.couchbase.com/nosql-resources/webinar/

http://docs.couchbase.com/developer/dev-guide-3.0/modeling-docs.html


Answer oriented databases

©2014 Couchbase, Inc. 7

http://martinfowler.com/bliki/AggregateOrientedDatabase.html


Airline bookings



Travel-Sample Data Model

Document Types:

– Airline

– Airport

– Route

– Landmark

– User

Identified by a „type“ attribute

Try: select distinct(type) from `travel-sample`;


Airline

{

"callsign": "SASQUATCH",

"country": "United States",

"iata": "K5",

"icao": "SQH",

"id": 10765,

"name": "SeaPort Airlines",

"type": "airline”

}


Route

{

"airline": "AF",

"airlineid": "airline_137",

"destinationairport": "CDG",

"sourceairport": "TXL",

"distance": 850.4987892267409,

"equipment": "321 319 320 318",

"id": 10012,

"stops": 0,

"type": "route"

"schedule": [

{ "day": 0, "flight": "AF943", "utc": "01:05:00" },

{ "day": 0, "flight": "AF814", "utc": "16:52:00" },

...

}

Document Access


Languages and Interfaces for Couchbase

Official SDKs

– Java – Version 2.2

– .NET – Version 2.1

– Node.js – Version 2.1

– Python – Version 2.0

For each of these we have

– Full Document support

– Interoperability

– Common yet idiomatic Programming Model

Others: Erlang, Perl, TCL, Clojure, Scala

©2014 Couchbase, Inc. — Proprietary and Confidential

PHP – Version 2.0

C – Version 2.5

Go – Version 1.0

Ruby – Version 2.0 DP

JDBC and ODBC


Couchbase SDKs

What does it mean to be a Couchbase SDK?

Cluster

Bucket

CRUDView

QueryN1QL Query

FunctionalManage connections to the bucket within the cluster for different services.Provide a core layer where IO can be managed and optimized.Provide a way to manage buckets.

APIinsertDesignDocument()flush()listDesignDocuments()

FunctionalHold on to cluster information such as topology.

APIReference Cluster ManagementopenBucket()info()disconnect()

FunctionalGive the application developer a concurrent API for basic (k-v) or document management

APIget()insert()upsert()remove()

FunctionalAllow for querying, execution of other directives such as defining indexes and checking on index state.

APIabucket.NewN1QLQuery(

“SELECT * FROM default LIMIT 5” ).Consistency(gocouchbase.RequestPlus);

FunctionalAllow for view querying, building of queries and reasonable error handling from the cluster.

APIabucket.NewViewQuery().Limit().Stale()


Pick your Tool from Toolbelt


Application layer computation Off-load computation

Predictable queries Key-value: pre-computed answers Views

Ad-hoc queries N1QL and key-value with manual indexes N1QL and Views


N1QL or Views?


N1QL Views

Ad-hoc querying Predictable queries

Nested JSON in and unnested JSON out Number crunching

Large growth clusters Multi-dimensional/geospatialqueries


Offloading computations to N1QL

N1QL allows you to choose which elements are returned at the top level.

This is incredibly useful as it reduces the need to write complex parsing logic:

– Within the application

– In Client side front end frameworks (Angular/Backbone etc)

SELECT a.name, s.flight, s.utc, r.sourceairport, r.destinationairport, r.equipment

FROM `travel-sample` r UNNEST r.schedule s JOIN `travel-sample` a ON KEYS r.airlineid

WHERE r.sourceairport='LHR' AND r.destinationairport='LAX' AND s.day=2 ORDER BY a.name


Serving Your Frontend


Exposing an API

Expose a „sane“ API to allow decoupling

Make use of JSON as the primary data storage format Remember: Develop with Agility

Tools like Ember & AngularJS already provide abstractions – use them!

Look at concepts like REST and HATEOAS for „discoverable“ and self-documenting APIs


Travel-Sample API (/api/)

(RequestParams omitted for clarity)

/user

– GET & POST /login

– GET & POST /flights

GET /airport/findAll

GET /flightPath/findAll

Sample Application Walkthrough


Application Walkthrough


What we learned

N1QL is a flexible query language

The SDKs have first class support for N1QL

We used raw N1QL queries to look-up airports by faa, icao and city

We encoded the N1QL query paramters by adding parameters to the QueryRequest.

We used Language Integrated Query (LINQ) to build a type-safe querythat converted Airportnames to an FAA value.

The other SDKs have similar "LINQ" options

This demo was in .NET but you can pick your favorite…


Try out the samples

developer.couchbase.comTo learn more about Couchbase, SDKs, N1QL and more…

Thank you!

how to build your first couchbase application – couchbase live new york 2015

Software