Hi Keenan, My thought about Postgres was because I am trying to have the same data locally as at Heroku. Heroku uses Postgres, I thought I needed to match it. Now I understand that it is possible to synchonize using yaml_db to export sqlite data to a data.yml, then upload it to Heroku, though I wasn't able to get it to work. Thanks for the comment. James
On Thu, Jan 8, 2009 at 7:42 PM, Keenan Brock <[email protected]> wrote: > > 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 > > > > > > > -- James G. Hazard 540 University Ave, Suite 300 Palo Alto, CA 94301 [email protected] 650.204.9100 (voice); 650.204.9101 (fax) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
