CODEWITHSUNDEEP
ruby-on-railsrubypostgresqlheroku
Sultan Saadat
Sultan Saadat

Reputation: 2288

Heroku PostgreSQL

I need to edit data in my tables at Heroku, how can i do that with an IDE for PostgreSQL or some other solution to this? I'm really new to Heroku, so please can you guide me what's the best way around it. thanks

Upvotes: 3

Views: 2473

Answers (4)

fdr
fdr

Reputation: 467

If you have access to a dedicated database, you will be able to take advantage of the "ingress" feature to get a raw connection to your database, compatible with all programs that need to speak over the Postgres wire protocol (examples include: psql, pgadmin, navicat, or Microsoft Excel with ODBC -- yes, really, and it's not half bad sometimes!)

But on shared databases you are somewhat out of luck at this time unless you somehow bounce your interactions off ruby and the pg gem.

Upvotes: 1

jpw
jpw

Reputation: 19257

for my rails app I use the typus gem which provides a very simple to implement fairly nice db admin interface to the application.

Upvotes: 0

John Beynon
John Beynon

Reputation: 37507

Alternatively (if you're able to) use db:pull to bring the database locally, do the work locally and then db:push it back up.

Or more likely the easiest option is to do it from console (heroku console at prompt)

John.

Upvotes: 0

edgerunner
edgerunner

Reputation: 14983

To the best of my knowledge, Heroku does not offer direct access to the database. Does heroku console cut it for you? You can access the db through your models directly.

Otherwise you may want to look at how to import/export your database.

Upvotes: 3

Related Questions