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 technical guide on using a Redis Foreign Data Wrapper (FDW) to query and join Redis data directly from within a PostgreSQL database.
Explains how to implement database connection pooling for Django applications using PostgreSQL to improve performance.
A guide for developers on monitoring and improving PostgreSQL database performance, covering cache hit rates and index usage.
Explains how to use the Array datatype in PostgreSQL for storing and querying data like tags or purchase items, with practical examples.
Using Heroku Postgres Dataclips to quickly prototype and test API endpoints by exposing SQL query results as JSON, CSV, or XLS.
Tips for preparing and delivering effective conference talks, based on experiences from tech community leaders and speakers.
Explains how to implement schemaless data storage in Django using PostgreSQL's hstore extension as an alternative to MongoDB.
A detailed exploration of advanced PostgreSQL features like concurrent indexing, transactional DDL, and foreign data wrappers.
A guide offering feedback to conference organizers on timelines, sponsorship, and speaker experience to improve tech conference planning.
A detailed list of technical advantages and features that make PostgreSQL a powerful and versatile database choice for developers.
A critique of Django's app model and advocating for a service-oriented architecture to improve maintainability and scalability in complex applications.
A guide to deploying Sphinx documentation projects on Heroku using a custom buildpack for public or private access.
Explains how to use OpenID with Google Apps to secure internal company applications, replacing VPNs for a cleaner authentication workflow.
An inside look at Heroku's engineering hiring philosophy and process, focusing on cultural fit and practical skills over rigid steps.
A beginner's guide to starting a Django web project, covering project structure, core files, and initial setup.
Argues that PostgreSQL's advanced features and data guarantees make it a superior choice over NoSQL databases for many applications.
Heroku's Maker's Day is a weekly policy giving engineers a full day of uninterrupted, meeting-free time to focus on deep work and boost productivity.
An inside look at Heroku's agile engineering culture, focusing on small team structures, self-chosen tools, and collaborative practices.
A guide to installing Python packages using pip and virtualenv, including creating isolated environments and managing dependencies with requirements.txt.
A beginner's guide to setting up a Python development environment, including Python, virtualenv, and PostgreSQL.
