i definitely had issues with trying to develop with sqllite and deploy on heroku (cedar stack) to postgresql. It ended up being imperative to install postgresql locally for the dev environment. as a newbie it was a bit daunting at first but i got through it without too much bloodshed and haven't had any problems since.
i also set up an alternate git remote so i can deploy to a staging version of my site to test things out before delivering to the live production server. that has been great as what works locally doesn't always work on heroku - especially if you're shaking on your CSS (which i am) as heroku is much more rigid about what it likes/thinks is valid. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.