theScore Tech Blog

Things We Learn While Building the Ultimate, Personalized Mobile Sports Experience

All Posts Tagged “postgresql”

PostgreSQL Queries on JSONB Fields with Ecto

Ecto is a great library for making composable queries, but to query a JSONB field within a schema, it requires falling back to native PostgreSQL functions.

11 min read
elixirectopostgresql

Migrating PostgreSQL to Aurora with near Zero-Downtime

The goal here is to migrate an Amazon Web Services Relational Database Service PostgreSQL Database to Aurora with as little downtime as possible. The following documents the initial strategy that was considered using read replica promotion, followed by the end result using AWS's Database Migration Service.

19 min read
databaseaurorapostgresqlaws