Craig Kerstiens is a product leader at Crunchy Data, specializing in managed Postgres services, distributed databases, and performance optimization. He curates Postgres Weekly, speaks at conferences, and helps enterprises scale and optimize their Postgres deployments.
164 articles from this blog
A developer's perspective on missing features in PostgreSQL 9.4, focusing on upsert, JSON performance, and extension management.
A guide to maximizing email effectiveness for feedback and communication, focusing on intentional strategies over inbox management.
A first look at PostgreSQL 9.4's new features, including pg_prewarm, concurrent materialized view refresh, and ordered set aggregates.
Strategies for creating effective developer-focused marketing content, including tutorials, timely posts, and expressing strong technical beliefs.
Explores how relational databases like PostgreSQL can adopt benefits from NoSQL, such as schemaless flexibility and JSON document storage.
Advice for marketing teams on creating authentic developer content by focusing on knowledge sharing, not product promotion.
A guide to using PostgreSQL Foreign Data Wrappers (FDWs) to access remote data as if it were local tables, including setup and performance tips.
Explains how to use PostgreSQL's CTEs (WITH clauses) to write more readable, composable, and maintainable SQL queries.
A guide to using SQL queries and a simple Ruby script to send personalized, data-driven emails to users, avoiding complex marketing tools.
A technical hack to disable the auto-mute feature while typing during Google Hangouts calls using a terminal command.
A guide to using JSON operators and functions in PostgreSQL 9.3, covering data extraction and manipulation from stored JSON.
A detailed follow-up on Heroku's 'Rule of Thirds' team planning exercise, sharing refined processes and best practices for long-term technical prioritization.
An analysis of PostgreSQL's documentation strengths and gaps, proposing improvements for onboarding, tutorials, and developer guides.
Explains how to use PostgreSQL Foreign Data Wrappers (FDWs) to query and join data from external sources directly within a Postgres database.
Explains PostgreSQL's dollar quoting feature for handling string literals, including nested quoting and security considerations.
Explains how to use PostgreSQL's COMMENT feature to document tables, columns, and SQL for better data understanding and maintenance.
Compares hstore and JSON data types in PostgreSQL, discussing their features, limitations, and use cases for schema-less data storage.
A tutorial on using PostgreSQL's crosstab function to pivot data directly in SQL, enabling easier analysis without external tools.
A guide to using JavaScript functions within PostgreSQL for JSON data manipulation, featuring examples and code snippets.
A guide to using EXPLAIN and EXPLAIN ANALYZE in PostgreSQL, including JSON output and visualization tools for query execution plans.
