AMPLI-SYNC

h1. SQLite-sync documentation

*Owner* : AMPLIFIER sp. z o.o.

*Contact* : support (at) ampliapps.com

*website* : https://ampliapps.com

{{>toc}}

Welcome to the AMPLI-SYNC documentation!

We have language bindings in JavaScript, .NET C#, Java and Objective-C! 

h2. AMPLI-SYNC concept

h3. Solution diagram

!{width:700px}SQLite-sync-structure.png!

* Devices communicate with server using HTTP/HTTPS protocol. 

* Proxy Load Balancer. If necessary, proxy can redirect request to another instance of SQLite-core.

* Authorization provider will generate token based on response from authorization provider.

h3. Proxy Balancer flowchart

!{width:400px}SQLite-sync-proxy-balancer.png!

h3. Authorization Provider flowchart

!{width:350px}SQLite-sync-authentication-process.png!

h2. REST API (server API)

h3. Protocol version

This document describes integration with the REST API 3.x protocol.

h3. Service description

There are two stages to processing a request:

* Device places an request.

* SQLite-sync server confirms the request has been processed successfully and sends confirmation with eventual conflict list that need to be resolved.

h3. Synchronization flowchart

!{width:200px;}Device-synchronization-diagram.png!

h2. Conflict Resolution

h2. Update procedure

h2. Data filtering

h2. Installation

h3. Manual

Steps needed to install AMPLI-SYNC manually on Ubuntu.

# Install Tomcat on Ubuntu:

https://www.digitalocean.com/community/tutorials/how-to-install-apache-tomcat-8-on-ubuntu-16-04

# Create new user

<pre>

sudo adduser amplisync

</pre>

System will ask you for password for newly created user.

# Add user to group ‘tomcat’

<pre>

sudo usermod -a -G tomcat amplisync

</pre>

# Chang in web.xml path variable to 

<pre>

\home/sqlitesync/demo

</pre>

# Install new application in Tomcat. Start with switching to amplisync user.

<pre>

su amplisync

</pre>

# Create new folder /home/sqlitesync/demo

# Upload new service amplisync-demo to Tomcat. You can do that using Tomcat application manager, or you can put WAR file in Tomcat webapps folder.

# Restart Romcat:

<pre>

service tomcat restart

</pre>

Now you can access your installation using link:

<pre>

http://your_ip:8080/amplisync-app-name/API3

</pre>

# Setup permissions:

<pre>

chown -R sqlitesync:tomcat /home/amplisync/demo/

</pre>

h3. Docker

h2. Supported databases

h2. Samples