Postgresql: Caching with pg_cron and Materialized Views

PostgreSQL — When To Use clock_timestamp(), current_timestamp and Unique Timestamps

Start Treating Your SQL as a First-Class Language with Idempotent SQL DDL

PostgreSQL— Benchmarking the Generation of Primary Key Values

Structured Message Formats: Thoughts on What To Log

Knowing Your Workflow Tools: Streamlining JSON Linting with ESLint, Flat Config, and VS Code

Idempotent Focused Architecting

Idempotent Focused Architecting is an approach to software engineering that handles multiple…

ELT, Data Platforms And SQL: Extracting and Transforming Data From RESTful Services

PostgreSQL — Lock Down Historical Timestamps, such as created_at, updated_at, at the Database Layer