High Performance PostgreSQL for Rails

Configuring PostgreSQL for Rideshare

Normally, in Rails apps, you run bin/rails db:create to create their databases. To set up the databases for Rideshare, you’ll use a custom shell script. The reason is because the script is much more opinionated about how the users, privileges, schemas, and grants should be configured compared with what would be done by default.

Here’s an overview of what the script does:

• Creates users owner, app, and app_readonly with secure passwords
• Creates the rideshare_development database
• Creates the rideshare schema
• Grants the required privileges to the schema and users
• Alters the default privileges following PostgreSQL best practices
• Removes the public schema

In PostgreSQL, users are roles that have the LOGIN privilege. ...