PostgreSQL - geekmonkey

geekmonkey

Sign in Subscribe

PostgreSQL

A collection of 4 posts

How to update multiple records with different values in Ecto.Repo.update_all

How to update multiple records with different values in Ecto.Repo.update_all

I recently ran into a problem where I wanted to update many database records with a single update_all/2. In this particular case, I was dealing with a table that leveraged parent_id to model a basic parent-child hierarchy. id parent_id name 1 NULL root 2 1 child

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

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