Taps – simple database import/export app
A simple database agnostic import/export app to transfer data to/from a remote database.
Here's how you start a taps server
$ taps server postgres://localdbuser:localdbpass@localhost/dbname httpuser httppassword
You can also specify an encoding in the database url
$ taps server mysql://localdbuser:localdbpass@localhost/dbname?encoding=latin1 httpuser httppassword
When you want to pull down a database from a taps server
$ taps pull postgres://dbuser:dbpassword@localhost/dbname http://httpuser:email@example.com:5000
or when you want to push a local database to a taps server
$ taps push postgres://dbuser:dbpassword@localhost/dbname http://httpuser:firstname.lastname@example.org:5000
Foreign Keys get lost in the schema transfer
Large tables get slower as the offset gets larger. This is due to it being inefficient having large offset values in queries. This only affects tables without a single primary key.
Tables without primary keys will be incredibly slow to transfer.
Maintained by Ricardo Chimal, Jr. (ricardo at heroku dot com)
Written by Ricardo Chimal, Jr. (ricardo at heroku dot com) and Adam Wiggins (adam at heroku dot com)
Early research and inspiration by Blake Mizerany
Released under the MIT License: www.opensource.org/licenses/mit-license.php