Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <ul> <li>I created a small JS lib named <strong>WebSqlSync</strong> to synchronize a local WebSql DB with a server (client &lt;-> server). Very easy to use and to integrate in your code :</li> </ul> <p><a href="https://github.com/orbitaloop/WebSqlSync" rel="noreferrer">https://github.com/orbitaloop/WebSqlSync</a></p> <ul> <li>The open source project <strong>QuickConnect</strong> contains a JS library to synchronize the local HTML5 SQLite DB to a server DB (MySQL or other) :</li> </ul> <p><a href="http://quickconnect.pbworks.com/Using-Enterprise-Synchronization" rel="noreferrer">http://quickconnect.pbworks.com/Using-Enterprise-Synchronization</a></p> <p><em>To use this lib, you need to use the DataAccessObject of the framework to access your DB. It works by storing all the SQL request applied to the DB (except select of course) , and sending them to the server. It's great to manage deletion, but it's a little heavy if you have a lot of updates, and the server need to use the same SQL language...</em></p> <ul> <li>Another project from <strong>QuickConnect</strong> is a native SQLite synch (in Objective C for iOS or Mac OS and in Java for Android) :</li> </ul> <p><a href="http://www.quickconnectfamily.org/qcdbsync/" rel="noreferrer">http://www.quickconnectfamily.org/qcdbsync/</a> (I think it store also the history of all the SQL requests)</p> <ul> <li>And i just found another promising JS library : <strong>persistenceJS</strong></li> </ul> <p><a href="https://github.com/zefhemel/persistencejs" rel="noreferrer">https://github.com/zefhemel/persistencejs</a></p> <p><em>"persistence.js is an asynchronous Javascript object-relational mapper library. You can use it in the browser, as well on the server (and you can share data models between them)."</em></p> <p>They have a DB synch module: <a href="https://github.com/zefhemel/persistencejs/blob/master/docs/sync.md" rel="noreferrer">DOC of persistence.synch.js</a></p> <p>(works with HTML5 DB SQLite or Google Gears on the client, and MySQL on the server)</p> <ul> <li>And there is also <strong>Impel.inTouch</strong>. It looks very easy to use (with php files included), but you must use the Mootools framework in the client side :</li> </ul> <p><a href="http://impel.simulacre.org/api/Impel.inTouch" rel="noreferrer">http://impel.simulacre.org/api/Impel.inTouch</a></p> <ul> <li>Sencha has also a synchronisation service: <strong>Sencha.io</strong>. Looks great, but it's dependent of the Sencha Touch framework:</li> </ul> <p><a href="http://www.sencha.com/products/io/" rel="noreferrer">http://www.sencha.com/products/io/</a></p>
    singulars
    1. This table or related slice is empty.
    1. POBest way to synchronize local HTML5 DB (WebSQL Storage, SQLite) with a server (2 way sync)
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USSamuel
    1. USSamuel
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POBest way to synchronize local HTML5 DB (WebSQL Storage, SQLite) with a server (2 way sync)
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHi Samuel, did the js lib work out for you?
      singulars
      1. PO
      1. USMathias Conradt
    2. CODB sync is not my priority for now, so I just give up, waiting for a more standard and robust solution...
      singulars
      1. PO
      1. USSamuel
    3. COas the WebSQL Standard is already deprecated ([link](http://www.w3.org/TR/webdatabase/)) and work will not be continued, I would rather search for some alternatives, as WebSQL will probably not be supported in future releases!
      singulars
      1. PO
      1. USMatthias B
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload