Getting comfortable with psql
A guide to getting started with the psql command-line interface for PostgreSQL, covering essential utility commands and configuration tips.
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 guide to getting started with the psql command-line interface for PostgreSQL, covering essential utility commands and configuration tips.
Explores the future of PostgreSQL, focusing on the power of extensions like pg_stat_statements, Citus, and pg_search to add new capabilities.
A guide on using the question 'What problem are we trying to solve?' to improve meeting focus and productivity in a tech/product context.
A former Heroku PM shares the story and vision behind Heroku Postgres, reflecting on its development and future possibilities.
A guide for founders on scaling by empowering new leaders, focusing on reversible vs. irreversible decisions in tech and product management.
A product manager discusses five essential skills for product and leadership roles: SQL, Excel, clear communication, storytelling, and prioritization.
A guide to quickly exploring and understanding a new PostgreSQL database using psql, covering initial setup and table inspection.
A product manager shares his intense experience undergoing official spokesperson certification at a major tech company, preparing for tough media interviews.
A tech professional shares lessons from college on running efficient meetings, focusing on agendas, roles, and timekeeping for better team collaboration.
An interview discussing the importance of PostgreSQL extensions and how they transform it from a relational database into a versatile data platform.
Explores the critical partnership between Engineering Managers and Product Managers, comparing it to a marriage for effective team alignment and decision-making.
A product manager shares practical tips for using email more effectively to communicate, collaborate, and get better engagement in a tech work environment.
OKRs alone won't solve team communication problems; explicit, formal communication is essential for alignment, especially as startups grow.
Practical advice for first-time tech conference attendees on networking, engaging with speakers, and making the most of the event agenda.
A critique of microservices complexity, advocating for the simplicity and maintainability of monolithic architectures in software development.
A developer shares three key reasons why he finds building products for other developers personally rewarding and a lifelong career focus.
An article arguing that SQL is one of the most valuable and enduring technical skills across various roles like engineering and product management.
A critique of PostgreSQL's name change from Postgres to PostgreSQL, arguing it caused persistent pronunciation confusion and was a major mistake.
A preview of PostgreSQL 11's key new features, including usability improvements, safer column additions, and performance enhancements like JIT compilation.
A preview of the top talks at PostgresOpen 2018, covering topics like debugging the Postgres planner, indexes, extensions, and connection pooling.