Re: Connecting to the database from outside?

[Oren Teich]

It is not possible to connect to your heroku provided database from outside
your heroku application.

Amazon RDS may offer something for you.

Oren

On Thu, Mar 4, 2010 at 6:24 AM, Daniele  wrote:

> Hi,
> I have to connect to the Heroku database from a remote location, is it
> possibile?
>
> Regards,
> Daniele
>
> --
> You received this message because you are subscribed to the Google Groups
> "Heroku" group.
> To post to this group, send email to her...@googlegroups.com.
> To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/heroku?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: Connecting to the database from outside?

[Daniele]

Thanks Carl but this is not a viable solution because I have to push
data while the app is running. I cannot stop it to backup - modify -
restore

On 4 Mar, 21:32, Carl Fyffe  wrote:

> Not sure if this meets your needs or not:
> http://blog.heroku.com/archives/2009/3/18/push_and_pull_databases_to_...

-- 
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: Connecting to the database from outside?

[Daniele]

Hi Roy,
you are right, I can modify my task to use ActiveResource. But it
could be perhaps a quite long work... and I'm lazy :P

On 4 Mar, 21:35, Roy Pardee  wrote:
> Hmmm--well I'd have a look at ActiveResource then.  My understanding is that
> it gives a local, scriptable interface (one that's very ActiveRecord-esque)
> on remote rails apps via REST webservice type calls.  I think the theory is
> that you get a remote-accessible automation interface on your rails app for
> the price of abiding by the various RESTful conventions that rails likes so
> much.  But someone should check me on that--I don't have any direct
> experience w/it myself.
>
> Anyhoo--if that's not too far wrong, and assuming the overhead of the
> underlying HTTP calls isn't too horrible to endure, I'm thinking you could
> make DBI connections to your local mssql db, read stuff into memory, and
> then push the data to your remote app via the ActiveResource objects.
>
> Cheers,
>
> -Roy
>
>
>
>
>
> On Thu, Mar 4, 2010 at 12:25 PM, Daniele  wrote:
> > Hi Roy,
> > actually I have a rake task in my RoR app that connect to a remote
> > MSSQL database and import data. This task use dbi with a quite complex
> > system configuration.
> > Because I cannot use it on Heroku it could be nice to setup the Heroku
> > database as remote one on a second installation so I can use the
> > migration task to push the data.
>
> > On 4 Mar, 21:12, Roy Pardee  wrote:
> > > Is it a rails app?  If so, maybe a ruby script using the ActiveResource
> > > library would work for you?
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Heroku" group.
> > To post to this group, send email to her...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > heroku+unsubscr...@googlegroups.com
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/heroku?hl=en.
>
> --
> Roy Pardeehttp://facebook.com/rpardee

-- 
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: Connecting to the database from outside?

[Roy Pardee]

Hmmm--well I'd have a look at ActiveResource then.  My understanding is that
it gives a local, scriptable interface (one that's very ActiveRecord-esque)
on remote rails apps via REST webservice type calls.  I think the theory is
that you get a remote-accessible automation interface on your rails app for
the price of abiding by the various RESTful conventions that rails likes so
much.  But someone should check me on that--I don't have any direct
experience w/it myself.

Anyhoo--if that's not too far wrong, and assuming the overhead of the
underlying HTTP calls isn't too horrible to endure, I'm thinking you could
make DBI connections to your local mssql db, read stuff into memory, and
then push the data to your remote app via the ActiveResource objects.

Cheers,

-Roy

On Thu, Mar 4, 2010 at 12:25 PM, Daniele  wrote:

> Hi Roy,
> actually I have a rake task in my RoR app that connect to a remote
> MSSQL database and import data. This task use dbi with a quite complex
> system configuration.
> Because I cannot use it on Heroku it could be nice to setup the Heroku
> database as remote one on a second installation so I can use the
> migration task to push the data.
>
> On 4 Mar, 21:12, Roy Pardee  wrote:
> > Is it a rails app?  If so, maybe a ruby script using the ActiveResource
> > library would work for you?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Heroku" group.
> To post to this group, send email to her...@googlegroups.com.
> To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/heroku?hl=en.
>
>


-- 
Roy Pardee
http://facebook.com/rpardee

-- 
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: Connecting to the database from outside?

[Carl Fyffe]

Not sure if this meets your needs or not:

http://blog.heroku.com/archives/2009/3/18/push_and_pull_databases_to_and_from_heroku/



On Thu, Mar 4, 2010 at 3:25 PM, Daniele  wrote:
> Hi Roy,
> actually I have a rake task in my RoR app that connect to a remote
> MSSQL database and import data. This task use dbi with a quite complex
> system configuration.
> Because I cannot use it on Heroku it could be nice to setup the Heroku
> database as remote one on a second installation so I can use the
> migration task to push the data.
>
> On 4 Mar, 21:12, Roy Pardee  wrote:
>> Is it a rails app?  If so, maybe a ruby script using the ActiveResource
>> library would work for you?
>
> --
> You received this message because you are subscribed to the Google Groups 
> "Heroku" group.
> To post to this group, send email to her...@googlegroups.com.
> To unsubscribe from this group, send email to 
> heroku+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/heroku?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: Connecting to the database from outside?

[Daniele]

Hi Roy,
actually I have a rake task in my RoR app that connect to a remote
MSSQL database and import data. This task use dbi with a quite complex
system configuration.
Because I cannot use it on Heroku it could be nice to setup the Heroku
database as remote one on a second installation so I can use the
migration task to push the data.

On 4 Mar, 21:12, Roy Pardee  wrote:
> Is it a rails app?  If so, maybe a ruby script using the ActiveResource
> library would work for you?

-- 
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: Connecting to the database from outside?

[Roy Pardee]

Is it a rails app?  If so, maybe a ruby script using the ActiveResource
library would work for you?

HTH,

-Roy

On Thu, Mar 4, 2010 at 6:24 AM, Daniele  wrote:

> Hi,
> I have to connect to the Heroku database from a remote location, is it
> possibile?
>
> Regards,
> Daniele
>
> --
> You received this message because you are subscribed to the Google Groups
> "Heroku" group.
> To post to this group, send email to her...@googlegroups.com.
> To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/heroku?hl=en.
>
>


-- 
Roy Pardee
http://facebook.com/rpardee

-- 
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Connecting to the database from outside?

[Daniele]

Hi,
I have to connect to the Heroku database from a remote location, is it
possibile?

Regards,
Daniele

-- 
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: Trying to deploy in heroku, but the command: "git push heroku master" failed

[Matt Buck]

Could you gist  the contents of your .gems file?

- Matthew Buck

On Tue, Mar 2, 2010 at 3:23 PM, Mauricio Voto wrote:

> Hi there, I'm a new Heroku's user and I was following the tutorial:
>
>
> http://jqr.github.com/2009/04/24/deploy-your-rails-application-in-2-minutes-with-heroku.html
>
> Everything was going well, except when I typed the "git push heroku
> master" command.
>
> The prompt message was:
>
> "Heroku push rejected, empty or invalid .gems file; 'git rm .gems' if
> no gems are required."
>
> Don't know how to fix it, anyone could help me ??? Would aprecciate
> it !
>
> Thanks folks !!!
>
> --
> You received this message because you are subscribed to the Google Groups
> "Heroku" group.
> To post to this group, send email to her...@googlegroups.com.
> To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/heroku?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: Bundler Update

[morgoth]

Finally 1.9.1.

I have small sinatra app on bamboo.
It looks like you must specify also gem thin in production environment
(I am using it with bundler).

-- 
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.