Skip to content
simple database import/export app
Ruby
Branch: master
Clone or download
Latest commit 93bd272 Jun 21, 2012
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
bin bump sequel to 3.20.0 Feb 14, 2011
lib Load sqlite3 on-demand rather than making it a hard dependency. Apr 27, 2012
spec support for a simple /health endpoint Mar 12, 2012
.gitignore
Gemfile Switch to using gemspec in Gemfile. Apr 27, 2012
Gemfile.lock
LICENSE added LICENSE, README, jeweler rake tasks Feb 6, 2009
README.rdoc tweak docs for clarity Mar 25, 2011
Rakefile add build rake task Jan 11, 2011
TODO added TODO Apr 15, 2010
VERSION.yml Release 0.3.24. Jun 20, 2012
config.ru specify dependencies manually in the Gemfile for now Jan 12, 2011
taps.gemspec Load sqlite3 on-demand rather than making it a hard dependency. Apr 27, 2012

README.rdoc

Taps – simple database import/export app

A simple database agnostic import/export app to transfer data to/from a remote database.

Usage: Server

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

Usage: Client

When you want to pull down a database from a taps server

$ taps pull postgres://dbuser:dbpassword@localhost/dbname http://httpuser:httppassword@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:httppassword@example.com:5000

or when you want to transfer a list of tables

$ taps push postgres://dbuser:dbpassword@localhost/dbname http://httpuser:httppassword@example.com:5000 --tables logs,tags

or when you want to transfer tables that start with a word

$ taps push postgres://dbuser:dbpassword@localhost/dbname http://httpuser:httppassword@example.com:5000 --filter '^log_'

Known Issues

  • Foreign key constraints get lost in the schema transfer

  • Tables without primary keys will be incredibly slow to transfer. This is due to it being inefficient having large offset values in queries.

  • Multiple schemas are currently not supported

Meta

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

github.com/ricardochimal/taps

Special Thanks to Sequel for making this tool possible sequel.rubyforge.org/

You can’t perform that action at this time.