vielhuber/kiwi

kiwi provides a git-like experience for relational databases.

🥝 kiwi 🥝

kiwi provides a git-like experience for relational databases., _(*1)

, _(*2)

This is currently a proof-of-concept., _(*3)

Features

• No sql triggers
• No binary / ddl logs
• Support for mysql & mariadb
• Works with any shared hosting provider that runs linux
• Detects data and schema changes, at the same time
• Fast
• Command line tool usage
• Requires only ssh access to remote repository
• Search/replace layer for environment specific values (serialize safe)
• Works together with WordPress, Shopware or any other raw sql database

Similiar tools

• mergebot

Planned

• Support for postgresql
• Advanced conflict solver
• Support for syncing views, trigger, functions and transactions
• Test suite
• Branching and other git-like features

Disclaimer

This does not prevent you from taking backups. Use this script at your own risk., _(*4)

Dependencies

• php7
• diff
• patch
• scp

Installation

Install/update globally:, _(*5)

wget https://raw.githubusercontent.com/vielhuber/kiwi/master/kiwi.phar
chmod +x kiwi.phar
sudo mv kiwi.phar /usr/local/bin/kiwi

Usage

First setup kiwi on client:, _(*6)

kiwi init, _(*7)

Change settings for local/remote database:, _(*8)

nano .kiwi/config.json, _(*9)

Get current status:, _(*10)

kiwi status, _(*11)

Push changes to remote repo:, _(*12)

kiwi push, _(*13)

Pull state of remote repo:, _(*14)

kiwi pull, _(*15)