在heroku上查看数据库

问题描述

我试图看看我的heroku实例上的数据。
我希望能够查看他们的服务器上的数据库..

我不想把它拉到我的本地系统..更重要的是，我不想等那么久，去看看数据。假设我将当前拥有800万本书籍（以及所有关联的元数据）的数据库推到heroku上。然后在两个月内再增加1200万。 （我还处于开发模式）
如果我遇到一批数据有问题，我认为将整个数据库下拉并不可行。

我想我可以在等待下载数据的时候进行仰卧起坐。我听说这是编程期间的老程序员做的。

https://stackoverflow.com/questions/9052419/viewing-database-in-heroku\">在Heroku中查看数据库，它只是一个不能这样做。

是那个真正？我们无法查看实时数据吗？

解决方案

（未经测试，但看起来就是您要查找的内容） / p>

I am attempting to take a look at the data on my heroku instance.I'd like to be able to view the database on their server..

I don't want to pull it down to my local system.. More to the point I don't want wait that long, to take a look at the data.

Lets assume I push my current database of 8 million books(and all the meta data associated) up to heroku. Then in two months I add another 12 million. (I'm still in development mode)If I have a problem with one batch of data, I don't think it's feasible to pull down the whole database.

I suppose I could do crunches while I wait on the download of the gigs of data. I hear that's what old programmers did during compiles.

---

I've looked at Viewing database in Heroku and it's just a "Can't do it."
Is that true? We can't look at the live data?

解决方案

(untested but seem it is what you are looking for.. )

https://github.com/ddollar/heroku-sql-console

这篇关于在heroku上查看数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！