PostgreSQL - Cancelling statement due to conflict with recovery.
When running a CQRS based system or long running analytics workloads a replica is the fastest route. However, the default PostgreSQL...
Blog
- Oct 24
SQLAlchemy and Idle in transaction queries
Summary Orphaned transactions are a problem that could lead to messy states in the database. This is usually a good indicator that the...
- Oct 9
Transactional Unit Tests with Pytest and Async SQLAlchemy
Summary This is a quick how to post if you’re working on migrating your database backed applications to async-sqlalchemy and are looking...
- Oct 3
Event Driven Architectures with Redis
Simulating the benefits of Kafka with Redis Summary Apache Kafka has become a mainstream component in most technology stacks. The...
- Jun 3
Prefect Cloud based data pipelines using AWS Copilot on ECS
In the next series of blog posts we aim to build and deploy a production grade data stack on Amazon's Elastic Container Service. We aim...
- Jan 21
Yet another caching library
While investigating caching libraries for one of Core27's clients we slipped into a rabbit hole of finding the perfect caching library. A...
- Jan 1
Generating series with Postgres
Social websites usually have a feature that displays the users engagement with a site or a log of a particular activity over time. Here's...
- Dec 19, 2021
Kill a running query - Postgres
Often we notice long running queries in idle or idle in transaction state. This may or may not interfere with other operations that you...
- Dec 19, 2021
SQL - Postgres Long running queries
Quick snippet to discover queries that have been running for over 1 minute on Postgres This gives us a break down of the query and the...