-
Notifications
You must be signed in to change notification settings - Fork 0
Synchronizes SQLite3 databases from the client to the server using tables ROWID.
License
LGPL-3.0, Unknown licenses found
Licenses found
LGPL-3.0
LICENSE
Unknown
COPYING
unmanarc/sqlite3_rsync
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
************** sqlite3_rsync: ************** sqlite3_rsync is a client-server application that synchronizes SQLite3 databases using tables ROWID. [+] Operational mode: - Server: It Waits for TCP Server connections. it may contain a partially filled database or no database at all. - Client: It connect to the Server, and if a database is updated on client side, the client push changes on server. [+] How to use it: 1st Recommendation: If the source database contains a lot of registries copy the database file from the source to your storage server. That will avoid our application to create and transfer the whole database to the server. [-] Then, start the synchronization server with the target backup database: ./sqlite3_rsync -d ~/msgstore-w.db -s [-] Now, from the side where the origin database comes, start the client... ./sqlite3_rsync -v -c 192.168.0.100 -t messages -d msgstore.db where 192.168.0.100 is the server ip address... ** Please don't hesitate to read the help (./sqlite3_rsync -h), if you need ** ** further details and options ** [+] Purporses: Data replication. Which includes: - Near Real Time backup of databases. - Database synchronization [+] Security recommendations: This application uses a very simple and with almost no security considerations protocol, that includes no authentication mechanism, and no ciphering at all. Use a tool like stunnel or a VPN to cipher and authenticate the communication of this application. Otherwise, your SQL queries could be exposed. ****************************************************************************** DISCLAIMER: THIS IS A VERY EXPERIMENTAL APPLICATION. I'M NOT RESPONSIBLE FOR ANY DAMAGE. THAT INCLUDES BUT IS NOT LIMITED TO: MALFUNCTION, BUGS, CORRUPTED DATABASES, FILESYSTEM OR DISK DAMAGE, NETWORK USAGE.
About
Synchronizes SQLite3 databases from the client to the server using tables ROWID.
Topics
Resources
License
LGPL-3.0, Unknown licenses found
Licenses found
LGPL-3.0
LICENSE
Unknown
COPYING
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published