James, My suggestion is to run sqlite locally.
Only if you are using a lot of raw SQL would I suggest postgress locally. I can see why someone would suggest the opposite. But why not just focus on rails for now? Once it becomes a big time app, then worry about the version of the database. Indexes however, do need attention. Not today. But soon. Good news is migrations handle those in a database neutral way. Beat of luck, Keenan On Jan 8, 2009, at 5:50 PM, HazardJ <[email protected]> wrote: > > Thanks very much. I confirmed that you are right by getting rid of > the login -- the database is indeed empty of my document content. I > presume that to get local and Heroku to work alike I need to use > Postgres locally? And then git from one to the other? Is there a > simpler way of getting information from sqlite to Postgres? > > > > On Jan 8, 2:22 pm, "Paul Clegg" <[email protected]> wrote: >> The database on the Heroku side is not the same as what you use on >> your >> local development, regardless of whether or not your sqlite >> database is >> checked in or not (it probably shouldn't be). Heroku uses a Postgres >> database, which will, by definition, be separate and different than >> your >> local development Sqlite database. So it's probably failing >> because your >> login data doesn't exist on the Heroku side of things. >> >> ...Paul >> >> On Thu, Jan 8, 2009 at 12:55 PM, HazardJ <[email protected]> >> wrote: >> >>> Hi everyone, >> >>> Heroku is really great. So good that I was able to upload and get >>> my >>> application working, though I'm very, very inexperienced. Bravo. >>> I've got a problem that escapes me -- when I reinstalled the app >>> (tarballed upload) my login _within_the_app (SessionsController) >>> won't >>> let me log in anymore. It doesn't like any of the user / password >>> combinations. >>> The /session page comes up but I go into a samsara of login where it >>> gently declines to accept any of my user/password combinations. >>> As I was uploading the many different times, I did get some kind of >>> error a few times. But others were smooth, including the most >>> recent. >> >>> Tests I've done so far: >>> I've checked the original on my computer (0.0.0.0:3000). It works >>> fine. >>> I've tarballed in tar.gz (both with log and tmp and without) and >>> in .zip any number of times. No luck. >>> I'm used to making mistakes and have tried it over and again. >>> The files seem to all be there, including the sqlite3 file. >> >>> Any thoughts? >>> Thanks, James > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~----------~----~----~----~------~----~------~--~---
