Permalink
Newer
Older
100644 52 lines (27 sloc) 1.8 KB
1
= Taps -- simple database import/export app
2
3
A simple database agnostic import/export app to transfer data to/from a remote database.
4
5
== Usage: Server
6
Feb 18, 2009
7
Here's how you start a taps server
8
9
$ taps server postgres://localdbuser:localdbpass@localhost/dbname httpuser httppassword
Feb 18, 2009
11
You can also specify an encoding in the database url
12
13
$ taps server mysql://localdbuser:localdbpass@localhost/dbname?encoding=latin1 httpuser httppassword
Feb 18, 2009
14
15
== Usage: Client
16
17
When you want to pull down a database from a taps server
19
$ taps pull postgres://dbuser:dbpassword@localhost/dbname http://httpuser:httppassword@example.com:5000
21
or when you want to push a local database to a taps server
23
$ taps push postgres://dbuser:dbpassword@localhost/dbname http://httpuser:httppassword@example.com:5000
24
Apr 16, 2010
25
or when you want to transfer a list of tables
Apr 9, 2010
26
Apr 16, 2010
27
$ taps push postgres://dbuser:dbpassword@localhost/dbname http://httpuser:httppassword@example.com:5000 --tables logs,tags
28
29
or when you want to transfer tables that start with a word
30
31
$ taps push postgres://dbuser:dbpassword@localhost/dbname http://httpuser:httppassword@example.com:5000 --filter '^log_'
Apr 9, 2010
32
33
== Known Issues
34
35
* Foreign key constraints get lost in the schema transfer
Apr 14, 2010
36
* Tables without primary keys will be incredibly slow to transfer. This is due to it being inefficient having large offset values in queries.
Apr 9, 2010
37
* Multiple schemas are currently not supported
39
== Meta
40
41
Maintained by Ricardo Chimal, Jr. (ricardo at heroku dot com)
42
43
Written by Ricardo Chimal, Jr. (ricardo at heroku dot com) and Adam Wiggins (adam at heroku dot com)
44
45
Early research and inspiration by Blake Mizerany
46
47
Released under the MIT License: http://www.opensource.org/licenses/mit-license.php
48
49
http://github.com/ricardochimal/taps
Apr 14, 2010
50
51
Special Thanks to Sequel for making this tool possible http://sequel.rubyforge.org/