===== Kanboard RAM Disk =====

We use sqlite3 to Kanboard, in documentation of sqlite you can read:

<code>
Actually, SQLite will easily do 50,000 or more INSERT statements per second on an average desktop computer. But it will only do a few dozen transactions per second. Transaction speed is limited by the rotational speed of your disk drive. A transaction normally requires two complete rotations of the disk platter, which on a 7200RPM disk drive limits you to about 60 transactions per second.
</code>

So if you can put the file in a RAM Disk the speed will be improved.

==== Sync the files ====
<code>
$ git clone -b "stable" https://github.com/deajan/osync
$ cd osync
# bash install.sh
# apt-get install inotify-tools
# cp /etc/osync/sync.conf.example /etc/osync/kanboard.conf
# vim /etc/osync/kanboard.conf
</code>

The content of the file can be similar to next, you need to modify INSTANCE_ID, INITIATOR_SYNC_DIR,TARGET_SYNC_DIR:
<code>
## Sync job identification
INSTANCE_ID="kanboard"

## Directories to synchronize.
## Initiator is the system osync runs on. The initiator directory must be a local path.
INITIATOR_SYNC_DIR="/var/www/html/kanboard/ramdisk"

## Target is the system osync synchronizes to (can be the same system as the initiator in case of local sync tasks). The target directory can be a local or remote path.
TARGET_SYNC_DIR="/var/www/html/kanboard/syncdatabase"
#TARGET_SYNC_DIR="ssh://backupuser@yourhost.old:22//home/git/osync/dir2"
</code>

Start the server:
<code>
# systemctl start osync-srv@kanboard.conf
</code>

==== References ====
  * https://sqlite.org/faq.html#q19
  * https://superuser.com/questions/31512/how-to-synchronize-the-home-folder-between-multiple-computers/31909
  * https://github.com/deajan/osync
  * https://packages.debian.org/search?keywords=inotify-tools