DB-Local-Sync is a very small nodejs package that keeps your local database in sync with a remote database, for development purposes.
Right now, DB-Local-Sync only works with MySQL databases. But I'm already working on MongoDB support.
If you are having some problems while updating your local database, this may be due to the MySQL strict mode.
Just add this to your dbconfig.json and DB-Local-Sync will temporarily disable strict mode.
{
"strictMode": false, // disable sql strict mode
}You simply set the configuration file with the local and remote databases and a time interval. It will check every N minutes if there are changes and you will get a notification to update it. That's it.
Install it globally so you can run on your projects:
$ npm install -g db-local-sync
On your working directory, create a dbconfig.json file, like this:
{
"strictMode": false, // disable sql strict mode
"interval": 5, // time interval to check for new changes (in minutes)
"local": { // local database settings
"host": "localhost",
"user": "root",
"password": "password",
"database": "local_db",
"port": 3306 // default is 3306
},
"remote": { // remote database settings
"host": "mysql://remotedatabase",
"user": "root",
"password": "password",
"database": "remote_db",
"port": 3306 // default is 3306
}
}And run this command from the working directory:
$ db-local-sync
You will get something like this:
[DB-Local-Sync] Watching for changes of remote_db in mysql://remotedatabase
[DB-Local-Sync] Database has not changed since last time...
Go on and make some changes on your remote database. After the time interval you've set on the dbconfig.json has passed, you'll get this to pop up on your screen:
Click on it and you're going to sync your local database. You'll get another pop up message saying
Booya! Databases are synced!
If you check your database, you'll see that there's a backup for your local database (in case you run into any problems, you can easily revert) and the changes from the remote database are there on your local database.
- MongoDB support
- Create tests
Any help is more than welcome. If you've found any bug, have ideas for new features or want to help in any way, please get in touch!