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.
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.