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 shares 10 essential PostgreSQL features and tips for 2016, including CTEs, performance tuning, and configuration.
A detailed overview of key new features in PostgreSQL 9.5, including Upsert, grouping sets, and pg_rewind.
A guide for tech startups on evolving from simple blog posts to coordinated product launches, covering product readiness and messaging.
A hands-on tutorial demonstrating how to use PostgreSQL's JSONB feature as a NoSQL document store with the MassiveJS library in a Node.js application.
Exploring MassiveJS, a Node.js library for PostgreSQL that offers a better alternative to traditional ORMs by embracing SQL power and good database design.
Explores strategies for launching sharing-economy and platform startups by bootstrapping and 'faking it til you make it' to solve the two-sided market problem.
Explains how to use SQL window functions and percentiles in Postgres for more meaningful data analysis than simple averages.
A first look at the new UPSERT feature in PostgreSQL 9.5, explaining its syntax and practical use cases for developers.
A blueprint for product management focusing on building trust, establishing velocity, and strategically killing scope to align product and engineering teams.
A guide on safely adding NOT NULL columns in PostgreSQL without downtime, by breaking the migration into multiple steps.
A developer's wishlist for upcoming features in PostgreSQL 9.5, including upsert, foreign data wrapper improvements, and better replication.
A product development philosophy on deciding when to ship a new feature or kill it, based on user feedback when the feature is removed.
Discusses the importance of meeting scribing and documentation as a company scales, offering practical tips for effective note-taking and communication.
A primer on PostgreSQL connection pooling, covering framework-level and standalone poolers to optimize database performance and manage connections.
Explores how personas, data science, and k-means clustering can be used together to analyze user data and gain actionable business insights.
Explores underutilized PostgreSQL data types like hstore, range types, timestamptz, and UUID, highlighting their benefits for specific use cases.
Explains the April 7 web security vulnerability, its impact on major sites, and provides steps for users to protect their accounts.
A retrospective on the first year of the Postgres Weekly newsletter, highlighting key articles, extensions, and community insights about PostgreSQL.
Overview of new PostgreSQL 9.4 features, focusing on the performance benefits of JSONB for document storage and the introduction of logical decoding.
A technical guide on using SQL window functions, specifically LAG, to calculate month-over-month revenue growth percentages for SaaS or recurring billing analysis.
