Specifying column name in a “references” migration

For Rails 5+ Initial Definition: If you are defining your Post model table, you can set references, index and foreign_key in one line: t.references :author, index: true, foreign_key: { to_table: :users } Update Existing: If you are adding references to an existing table, you can do this: add_reference :posts, :author, foreign_key: { to_table: :users } … Read more

Deleting all records in a database table

If you are looking for a way to it without SQL you should be able to use delete_all. Post.delete_all or with a criteria Post.delete_all “person_id = 5 AND (category = ‘Something’ OR category = ‘Else’)” See here for more information. The records are deleted without loading them first which makes it very fast but will … Read more

Rails: FATAL – Peer authentication failed for user (PG::Error)

If you installed postresql on your server then just host: localhost to database.yml, I usually throw it in around where it says pool: 5. Otherwise if it’s not localhost definitely tell that app where to find its database. development: adapter: postgresql encoding: unicode database: kickrstack_development host: localhost pool: 5 username: kickrstack password: secret Make sure … Read more