No Service

Legal Disclaimer

• © IBM Corporation 2015. All Rights Reserved.
• The information contained in this publication is provided for informational purposes only. While efforts were made to verify the completeness and accuracy of the information contained in this publication, it is provided AS IS without warranty of any kind, express or implied. In addition, this information is based on IBM’s current product plans and strategy, which are subject to change by IBM without notice. IBM shall not be responsible for any damages arising out of the use of, or otherwise related to, this publication or any other materials. Nothing contained in this publication is intended to, nor shall have the effect of, creating any warranties or representations from IBM or its suppliers or licensors, or altering the terms and conditions of the applicable license agreement governing the use of IBM software.
• References in this presentation to IBM products, programs, or services do not imply that they will be available in all countries in which IBM operates. Product release dates and/or capabilities referenced in this presentation may change at any time at IBM’s sole discretion based on market opportunities or other factors, and are not intended to be a commitment to future product or feature availability in any way. Nothing contained in these materials is intended to, nor shall have the effect of, stating or implying that any activities undertaken by you will result in any specific sales, revenue growth or other results.
• If the text contains performance statistics or references to benchmarks, insert the following language; otherwise delete: Performance is based on measurements and projections using standard IBM benchmarks in a controlled environment. The actual throughput or performance that any user will experience will vary depending upon many factors, including considerations such as the amount of multiprogramming in the user's job stream, the I/O configuration, the storage configuration, and the workload processed. Therefore, no assurance can be given that an individual user will achieve results similar to those stated here.
• If the text includes any customer examples, please confirm we have prior written approval from such customer and insert the following language; otherwise delete: All customer examples described are presented as illustrations of how those customers have used IBM products and the results they may have achieved. Actual environmental costs and performance characteristics may vary by customer.
• Please review text for proper trademark attribution of IBM products. At first use, each product name must be the full name and include appropriate trademark symbols (e.g., IBM Lotus® Sametime® Unyte™). Subsequent references can drop “IBM” but should include the proper branding (e.g., Lotus Sametime Gateway, or WebSphere Application Server). Please refer to http://www.ibm.com/legal/copytrade.shtml for guidance on which trademarks require the ® or ™ symbol. Do not use abbreviations for IBM product names in your presentation. All product names must be used as adjectives rather than nouns. Please list all of the trademarks that you use in your presentation as follows; delete any not included in your presentation. IBM, the IBM logo, Lotus, Lotus Notes, Notes, Domino, Quickr, Sametime, WebSphere, UC2, PartnerWorld and Lotusphere are trademarks of International Business Machines Corporation in the United States, other countries, or both. Unyte is a trademark of WebDialogs, Inc., in the United States, other countries, or both.
• If you reference Adobe® in the text, please mark the first use and include the following; otherwise delete: Adobe, the Adobe logo, PostScript, and the PostScript logo are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States, and/or other countries.
• If you reference Java™ in the text, please mark the first use and include the following; otherwise delete: Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both.
• If you reference Microsoft® and/or Windows® in the text, please mark the first use and include the following, as applicable; otherwise delete: Microsoft and Windows are trademarks of Microsoft Corporation in the United States, other countries, or both.
• If you reference Intel® and/or any of the following Intel products in the text, please mark the first use and include those that you use as follows; otherwise delete: Intel, Intel Centrino, Celeron, Intel Xeon, Intel SpeedStep, Itanium, and Pentium are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries.
• If you reference UNIX® in the text, please mark the first use and include the following; otherwise delete: UNIX is a registered trademark of The Open Group in the United States and other countries.
• If you reference Linux® in your presentation, please mark the first use and include the following; otherwise delete: Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both. Other company, product, or service names may be trademarks or service marks of others.
• If the text/graphics include screenshots, no actual IBM employee names may be used (even your own), if your screenshots include fictitious company names (e.g., Renovations, Zeta Bank, Acme) please update and insert the following; otherwise delete: All references to [insert fictitious company name] refer to a fictitious company and are used for illustration purposes only.

Who am I?

Mike Elsmore

Developer Advocate

mike.elsmore@uk.ibm.com

Follow Along

http://elsmore.me/no-service-seium-2016/

Demo

http://elsmore.me/seium-demo/

Offline WebApps

web SQL & Indexed DB

SQL in the browser

SQL in the browser

Kinda

Transaction Datastore that's Relational

Browser Compatibility

Desktop

Mobile

API differences

Another way…

Dexie

localForage

Etc

Dexie

localForage

Etc

So what's special…

In-browser database

Local database on LevelDB

Interface library for CouchDB

Get started

In Node.js

npm install --save pouchdb

var PouchDB = require('pouchdb');
var db = new PouchDB('my_database');

In Browser

bower install --save pouchdb
<script src="bower_components/pouchdb/dist/pouchb.min.js" ></script>

or

<script src="//cdn.jsdelivr.net/pouchdb/5.0.0/pouchdb.min.js" ></script>

then

var db = new PouchDB('my_database');

As a client

var db = new PouchDB('http://localhost:5984/my_database');

JSON Document

var doc = {
  event: "BrumJS",
  type: "conference",
  date: "2015-10-15"
}

Create

db.post(doc, [options], [callback]);

db.post(doc, function (err, response) {
  if (err) { return console.log(err); }
  // handle response
});

Read

db.get(docId, [options], [callback]);

db.get('brumjs', function(err, doc) {
  if (err) { return console.log(err); }
  // handle doc
});

Update

db.put(doc, [docId], [docRev], [options], [callback]);

db.get('brumjs', function(err, doc) {
  if (err) { return console.log(err); }
  db.put({
    _id: 'brumjs',
    _rev: doc._rev,
    talk: "No Service"
  }, function(err, response) {
    if (err) { return console.log(err); }
    // handle response
  });
});

PUT Create

db.put(doc, [docId], [docRev], [options], [callback]);

var doc = {
  _id: "brumjs§",
  event: "BrumJS",
  type: "conference",
  date: "2015-10-15"
}
db.put(doc, function(err, response) {
  if (err) { return console.log(err); }
  // handle response
});

Delete / Destroy

db.remove(docId, [docRev], [options], [callback]);

db.get('brumjs', function(err, doc) {
  if (err) { return console.log(err); }
  db.remove(doc, function(err, response) {
    if (err) { return console.log(err); }
    // handle response
  });
});

That's the basics…now what?

Bulk Actions

Create

db.bulkDocs(docs, [options], [callback]);
db.bulkDocs([
  {event: "BristolJS",}, {event : "BVGS"}
], function(err, response) {
  if (err) { return console.log(err); }
  // handle result
});

Read

db.allDocs([options], [callback]);
db.allDocs({
  include_docs: true,
  attachments: true
}, function(err, response) {
  if (err) { return console.log(err); }
  // handle result
});

Changes

db.changes(options);

var changes = db.changes({
  since: 'now',
  live: true,
  include_docs: true
}).on('change', function(change) {
  // handle change
}).on('complete', function(info) {
  // changes() was canceled
}).on('error', function (err) {
  console.log(err);
});

changes.cancel();

Attachments

Create

db.putAttachment(docId, attachmentId, [rev], attachment, type, [callback]);

Read

db.getAttachment(docId, attachmentId, [options], [callback]);

Delete

db.removeAttachment(docId, attachmentId, rev, [callback]);

Query

MapReduce

db.query(fun, [options], [callback]);

// create a design doc
var ddoc = {
  _id: '_design/index',
  views: {
    index: {
      map: function mapFun(doc) {
        if (doc.type) {
          emit(doc.type);
        }
      }.toString()
    }
  }
}

// save the design doc
db.put(ddoc, function (err) {
  if (err && err.status !== 409) {
    return console.log(err);
  }
  // ignore if doc already exists
  // find docs where type === 'conference'
  db.query('index', {
    key: 'conference',
    include_docs: true
  }, function (err, result) {
    if (err) { return console.log(err); }
    // handle result
  });
});

// Or use existing DDoc

Replication

PouchDB.replicate(source, target, [options]);

db.replicate.to(remoteDB, [options]);
// or
db.replicate.from(remoteDB, [options]);

Sync

var sync = PouchDB.sync(src, target, [options]);

PouchDB.sync('mydb', 'http://localhost:5984/mydb');

Magic bit

CouchDB

Codez!

https://github.com/ukmadlz/seium-demo https://github.com/ukmadlz/apikeyapp

Round Up

Questions?