An empty database in every pocket at DevTalks Bucharest

Slide 1

Slide 1 text

A empt databas i ever pocke Phil Nash DevTalks Bucharest 2017

Slide 2

Slide 2 text

Phi Nas @philnash http://philna.sh [email protected]

Slide 3

Slide 3 text

Warnin

Slide 4

Slide 4 text

Bi Dat Trac

Slide 5

Slide 5 text

Smal dat

Slide 6

Slide 6 text

A empt databas i ever pocke

Slide 7

Slide 7 text

Problem

Slide 8

Slide 8 text

Performanc

Slide 9

Slide 9 text

O lin

Slide 10

Slide 10 text

O lin Poo connectivit

Slide 11

Slide 11 text

O lin Poo connectivit Resilienc

Slide 12

Slide 12 text

Use experienc

Slide 13

Slide 13 text

Progressiv We Ap

Slide 14

Slide 14 text

A empt databas i ever pocke

Slide 15

Slide 15 text

Th option

Slide 16

Slide 16 text

Slide 17

Slide 17 text

LocalStorag

Slide 18

Slide 18 text

LocalStorag localStorage.setItem('DevTalks', 'Awesome');

Slide 19

Slide 19 text

Bu ...

Slide 20

Slide 20 text

WebSQL?

Slide 21

Slide 21 text

S ...

Slide 22

Slide 22 text

IndexedDB

Slide 23

Slide 23 text

IndexedDB ha ba reputatio

Slide 24

Slide 24 text

Wha i IndexedDB?

Slide 25

Slide 25 text

Objec stor

Slide 26

Slide 26 text

Transactiona

Slide 27

Slide 27 text

Asynchronou

Slide 28

Slide 28 text

Sam origi polic

Slide 29

Slide 29 text

Dem

Slide 30

Slide 30 text

Ther ' mor !

Slide 31

Slide 31 text

Indexe

Slide 32

Slide 32 text

Indexe request.onupgradeneeded = (event) => { const db = event.target.result; const objectStore = db.createObjectStore('messages', { keyPath: 'sid' }); objectStore.createIndex('dateUpdated', 'dateUpdated'); }; 01. 02. 03. 04. 05. 06. 07.

Slide 33

Slide 33 text

Indexe const transaction = db.transaction(['messages']); const objectStore = transaction.objectStore('messages'); const index = objectStore.index('dateUpdated'); index.openCursor().onsuccess = (event) => { // do stuff } 01. 02. 03. 04. 05. 06.

Slide 34

Slide 34 text

Upgrade

Slide 35

Slide 35 text

Upgrade request.onupgradeneeded = (event) => { const db = event.target.result; db.createObjectStore("messages", { keyPath: "sid" }); }; 01. 02. 03. 04.

Slide 36

Slide 36 text

Upgrade request.onupgradeneeded = (event) => { const db = event.target.result; if (event.oldVersion < 1) { db.createObjectStore("messages", { keyPath: "sid" }); } if (event.oldVersion < 2) { db.createObjectStore("channels", { keyPath: "sid" }); } }; 01. 02. 03. 04. 05. 06. 07. 08. 09.

Slide 37

Slide 37 text

Slide 38

Slide 38 text

Safar

Slide 39

Slide 39 text

Librarie !

Slide 40

Slide 40 text

id -keyva localForag id Dexi PouchDB

Slide 41

Slide 41 text

Dexi const dexie = new Dexie("messageStore"); dexie.version(1).stores({ messages: 'sid,dateUpdated' }); 01. 02. 03. 04.

Slide 42

Slide 42 text

Dexi dexie.open().then((db) => { db.messages.where("sid").equals(key) .then((message) => { console.log(message.body); }); }); 01. 02. 03. 04.