sinatra + heroku + postgres

Now that the (read-only) web service was working locally on my machine, I wanted to see if I could push it to Heroku. The first thing I did was to dump my Postgres database. Since the basic/free Heroku account only supports databases with at most 10k rows, I truncated the zip code database. There are a total of 42k+ rows, so chomping off this many rows is significant, but I'm mostly doing this just as a demonstration. Usually, you'd run pg_dump to export an entire Postgres database to a file. However, pg_dump is…Read more …