Wiki » History » Revision 15
Revision 14 (Tomek Dziemidowicz, 2019-07-04 01:20 PM) → Revision 15/43 (Tomek Dziemidowicz, 2019-07-04 01:20 PM)
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: 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
Go to top
*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: 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