PostgreSQL - geekmonkey

geekmonkey

Sign in Subscribe

PostgreSQL

A collection of 3 posts

Detecting unused database columns using Ecto schemas

Detecting unused database columns using Ecto schemas

When building large database-backed Elixir applications using Ecto, it is inevitable for your database schema to evolve over time. As your database schema changes, it's possible for there to be discrepancies between the tables in the database and your local schema definitions. Tracking inconsistencies between the schema defined in your

Optimizing PostgreSQL queries using pg_stat_statements

Optimizing PostgreSQL queries using pg_stat_statements

Postgres comes with a number of really powerful tools to help analyze query and overall database performance. Here's how I usually go about finding and improving query performance.

Deploying your Rails 5 apps to Dokku - Part 1

Deploying your Rails 5 apps to Dokku - Part 1

In this tutorial we will be using a DigitalOcean Droplet to install and run dokku and deploy a Rails app to it. After reading this tutorial, you will be able to: * Set up a DigitalOcean droplet using dokku * Install a dokku plugin to run your database * Deploy a Rails app