Newbie Paintball Master

    dexie-syncable
    TypeScript icon, indicating that this package has built-in type declarations

    3.0.0-beta.10 • Public • Published

    Dexie.Syncable.js

    Enables two-way synchronization with remote database.

    Install

    npm install dexie --save
    npm install dexie-observable --save
    npm install dexie-syncable --save
    

    Use

    import Dexie from 'dexie';
    import 'dexie-syncable'; // will import dexie-observable as well.
     
    // Use Dexie as normally - but you can also register your sync protocols though
    // Dexie.Syncable.registerSyncProtocol() api as well as using the db.syncable api
    // as documented here.
     

    Dependency Tree

    Tutorial

    1. Include Required Sources

    In your HTML, make sure to include Dexie.js, Dexie.Observable.js, Dexie.Syncable.js and an implementation of ISyncProtocol.

    <html><head>
        <script src="dexie.min.js"></script>
        <script src="dexie-observable.min.js"></script>
        <script src="dexie-syncable.min.js"></script>
        <script src="WebSocketSyncProtocol.js"></script> <!-- Example implementation of ISyncProtocol -->
        ...
    </head><body>
    </body></html>
    
    Usage with existing DB

    In case you want to use Dexie.Syncable with your existing database, but do not want to use UUID based Primary Keys as described below, you will have to do a schema upgrade. Without it Dexie.Syncable will not be able to properly work.

    import Dexie from 'dexie';
    import 'dexie-observable';
    import 'dexie-syncable';
    import 'your-sync-protocol-implementation';
     
    var db = new Dexie('myExistingDb');
    db.version(1).stores(... existing schema ...);
     
    // Now, add another version, just to trigger an upgrade for Dexie.Syncable
    db.version(2).stores({}); // No need to add / remove tables. This is just to allow the addon to install its tables.

    2. Use UUID based Primary Keys ($$)

    Two way replication cannot use auto-incremented keys if any sync node should be able to create objects no matter if it is offline or online. Dexie.Syncable comes with a new syntax when defining your store schemas: the double-dollar prefix ($$). Similarly to the ++ prefix in Dexie (meaning auto-incremented primary key), the double-dollar prefix means that the key will be given a universally unique identifier (UUID), in string format (For example "9cc6768c-358b-4d21-ac4d-58cc0fddd2d6").

    var db = new Dexie("MySyncedDB");
    db.version(1).stores({
        friends: "$$oid,name,shoeSize",
        pets: "$$oid,name,kind"
    });
    

    3. Connect to Server

    You must specify the URL of the server you want to keep in-sync with. This has to be done once in the entire database life-time, but doing it on every startup is ok as well, since it won't affect already connected URLs.

    // This example uses the WebSocketSyncProtocol included in earlier steps.
    db.syncable.connect ("websocket", "https://syncserver.com/sync");
    db.syncable.on('statusChanged', function (newStatus, url) {
        console.log ("Sync Status changed: " + Dexie.Syncable.StatusTexts[newStatus]);
    });
    

    4. Use Your Database

    Query and modify your database as if it was a simple Dexie instance. Any changes will be replicated to the server and changes on the server or an other window will replicate back to you.

    db.transaction('rw', db.friends, function (friends) {
        friends.add({name: "Arne", shoeSize: 47});
        friends.where('shoeSize').above(40).each(function (friend) {
            console.log("Friend with shoeSize over 40: " + friend.name);
        });
    });
    

    NOTE: Transactions only provide the Atomicity part of the ACID properties when using 2-way synchronization. This is due to the fact that the syncronization phase may result in another change overwriting the changes. However, it's still meaningful to use the transaction() method for atomicity. Atomicity is guaranteed not only locally but also when synced to the server, meaning that a part of the changes will never commit on the server until all changes from the transaction have been synced. In practice, you cannot increment a counter in the database (for example) and expect it to be consistent, but you can have a guaranteed that if you add a sequence of objects, all or none of them will replicate.

    API Reference

    Static Members

    Dexie.Syncable.registerSyncProtocol (name, protocolInstance) Define how to replicate changes with your type of server.

    Dexie.Syncable.Statuses Enum of possible sync statuses, such as OFFLINE, CONNECTING, ONLINE and ERROR.

    Dexie.Syncable.StatusTexts Text lookup for status numbers

    Non-Static Methods and Events

    db.syncable.connect (protocol, url, options) Create a persistend two-way sync connection with the given URL.

    db.syncable.disconnect (url) Stop syncing with the given URL but keep revision states until next connect.

    db.syncable.delete(url) Delete all states and change queue for given URL.

    db.syncable.list() List the URLs of each remote node we have a state saved for.

    db.syncable.on('statusChanged') Event triggered when sync status changes.

    db.syncable.setFilter ([criteria], filter) Ignore certain objects from being synced defined by the given filter.

    db.syncable.getStatus (url) Get sync status for the given URL.

    db.syncable.getOptions (url) Get the options object for the given URL.

    Source

    Dexie.Syncable.js

    Description

    Dexie.Syncable enables synchronization with a remote database (of almost any kind). It has its own API ISyncProtocol. The ISyncProtocol is pretty straight-forward to implement. The implementation of that API defines how client- and server- changes are transported between local and remote nodes. The API support both poll-patterns (such as ajax calls) and direct reaction pattern (such as WebSocket or long-polling methods). See samples below for each pattern.

    Sample ISyncProtocol Implementations

    Sample Sync Servers

    Install

    npm i dexie-syncable

    Homepage

    dexie.org

    DownloadsWeekly Downloads

    182

    Version

    3.0.0-beta.10

    License

    Apache-2.0

    Unpacked Size

    372 kB

    Total Files

    11

    Last publish

    Collaborators

    • dfahlander