Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Newer
Older
100644 52 lines (27 sloc) 1.84 kB
6959e64 @ricardochimal added LICENSE, README, jeweler rake tasks
ricardochimal authored
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
6af935f @ricardochimal updated README.rdoc
ricardochimal authored
7 Here's how you start a taps server
8
fd87cbf @ddollar put server start directions back
ddollar authored
9 $ taps server postgres://localdbuser:localdbpass@localhost/dbname httpuser httppassword
6959e64 @ricardochimal added LICENSE, README, jeweler rake tasks
ricardochimal authored
10
6af935f @ricardochimal updated README.rdoc
ricardochimal authored
11 You can also specify an encoding in the database url
12
fd87cbf @ddollar put server start directions back
ddollar authored
13 $ taps server mysql://localdbuser:localdbpass@localhost/dbname?encoding=latin1 httpuser httppassword
6af935f @ricardochimal updated README.rdoc
ricardochimal authored
14
6959e64 @ricardochimal added LICENSE, README, jeweler rake tasks
ricardochimal authored
15 == Usage: Client
16
0983c38 @ricardochimal rename receive to pull and senddata to push. I don't know why but it…
ricardochimal authored
17 When you want to pull down a database from a taps server
b28d5f7 @ricardochimal updated README with example of how to push a database
ricardochimal authored
18
0e767b1 @ricardochimal updated README.rdoc with a list of known issues
ricardochimal authored
19 $ taps pull postgres://dbuser:dbpassword@localhost/dbname http://httpuser:httppassword@example.com:5000
6959e64 @ricardochimal added LICENSE, README, jeweler rake tasks
ricardochimal authored
20
0983c38 @ricardochimal rename receive to pull and senddata to push. I don't know why but it…
ricardochimal authored
21 or when you want to push a local database to a taps server
b28d5f7 @ricardochimal updated README with example of how to push a database
ricardochimal authored
22
0e767b1 @ricardochimal updated README.rdoc with a list of known issues
ricardochimal authored
23 $ taps push postgres://dbuser:dbpassword@localhost/dbname http://httpuser:httppassword@example.com:5000
24
0155be8 @ricardochimal updated README
ricardochimal authored
25 or when you want to transfer a list of tables
4a9f1ef @ricardochimal updated readme
ricardochimal authored
26
0155be8 @ricardochimal updated README
ricardochimal authored
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_'
4a9f1ef @ricardochimal updated readme
ricardochimal authored
32
0e767b1 @ricardochimal updated README.rdoc with a list of known issues
ricardochimal authored
33 == Known Issues
34
e489148 @ddollar tweak docs for clarity
ddollar authored
35 * Foreign key constraints get lost in the schema transfer
6b41c2c @ricardochimal updated README
ricardochimal authored
36 * Tables without primary keys will be incredibly slow to transfer. This is due to it being inefficient having large offset values in queries.
4a9f1ef @ricardochimal updated readme
ricardochimal authored
37 * Multiple schemas are currently not supported
b28d5f7 @ricardochimal updated README with example of how to push a database
ricardochimal authored
38
6959e64 @ricardochimal added LICENSE, README, jeweler rake tasks
ricardochimal authored
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
7b481bd @ricardochimal updated README
ricardochimal authored
50
51 Special Thanks to Sequel for making this tool possible http://sequel.rubyforge.org/
Something went wrong with that request. Please try again.