Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Since the taps servers will be decommissioned at some future point, the plugin is probably not the best long term solution. But of course you can run your own taps server.</p> <h2>Steps</h2> <p><strong>Step 1: Start Your taps server</strong></p> <pre><code>taps server `heroku config:get DATABASE_URL` db db </code></pre> <p><strong>Step 2: Run the taps client</strong></p> <p>In a different shell:</p> <pre><code>taps pull sqlite://db/development.sqlite3 http://db:db@localhost:5000 </code></pre> <p><strong>Step 3: Shut down the taps server</strong></p> <p>Once the import is done you can shutdown the server with the normal Ctrl-C key combination.</p> <h2>Notes</h2> <ul> <li>This will pull my production database down into a local SQLite database. Of course if you are using MySQL or something locally just replace the sqlite URI with the equivalent MySQL URI.</li> <li>Taps requires you to set a username/password. Since I am just running it locally for a short time I just use "db" for both. If you change these you will need to also update the username/password in the URL for step 2.</li> <li>You can also use <code>taps push</code> to copy data to the production server although you should obviously do that with caution.</li> <li>Taps has a number of bugs it has acquired over time due to the lack of activity by the maintainer: <ul> <li>The biggest annoyance is the fact that <a href="https://github.com/ricardochimal/taps/issues/128" rel="nofollow">it stopped working after rack incorporated OKJson into Rack</a>. The OKJson in Rack conflicts with the modified version that is included in taps. <a href="https://github.com/ricardochimal/taps/pull/133" rel="nofollow">I created a patch to resolve this</a> but no activity has been done to merge it. In the meantime workarounds include forcing taps to use an earlier rack. <a href="https://github.com/ricardochimal/taps/issues/128#issuecomment-18461702" rel="nofollow">Paxa suggested an easy approach by modifying the bin/taps file</a>. If you don't want to modify packaged installed files on your system you can also <a href="https://github.com/ricardochimal/taps/issues/128#issuecomment-21049046" rel="nofollow">follow hax8or's instructions which use bundler to force the right version of Rack</a>.</li> <li>The progress bar does not render correctly. <a href="https://github.com/ricardochimal/taps/pull/126" rel="nofollow">fd fixed this in his pull request</a> but it has also not been merged in. Since this is purely cosmetic you can just ignore the bad output.</li> </ul></li> </ul> <p>@wijet recently <a href="https://github.com/wijet/taps" rel="nofollow">forked</a> taps and incorporated some of the most important patches. He has named his gem "taps-taps" if you are looking for an easy out-of-the-box install.</p>
    singulars
    1. This table or related slice is empty.
    1. POHeroku db:pull 'db:pull is not a heroku command'
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USEric Anderson
    1. USEric Anderson
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload