Sinatra template application

This application can be used as a starting point for a Postgres database backed, via Sequel, application that uses Sinatra. It can be deployed to Heroku.

There are a few things you need to change for your application:

1. Change scrips/create_databases.sql to create both your development and test databases.
2. Copy the .env.example file to .env.
3. Change the .env file to include your database connection strings for both your development and test databases. This file is ignored by git (see .gitignore) to protect your secrets from the outside world.
4. Add your migrations to the migrations folder. Once you have one migration there, you can delete the .gitsave file.

Development

1. bundle install
2. Create a database by running psql -d postgres -f scripts/create_databases.sql
3. Populate the database environment variables in the currently running terminal by running source .env.
4. Run the migrations in the development database using sequel -m migrations $DATABASE_URL_DEVELOPMENT
5. Run the migrations in the test database using sequel -m migrations $DATABASE_URL_TEST
6. rerun rackup
   • running rerun will reload app when file changes are detected
7. Run tests using rspec.

Migrations on Heroku

To run the migrations on heroku, run heroku run 'sequel -m migrations $DATABASE_URL'. If you do not have a Heroku configuration variable named DATABASE_URL, then you will need to create one.