Skip to main content

Craig Kerstiens

The art of PostgreSQL

If you’re looking for one book to come and learn more about Postgres this is it. It is targetted towards application developers that may not have a background as a DBA, but has the info you need to know how to do about anything you want with Postgres. Multiple editions available, several come with an example database and over 300 queries that you can easily run/test/modify for yourself.

Skunk works

If there’s a book that makes me want to believe in a 10X engineer its this one. An amazing read on skunk works, or more formally Lockheed Martin’s Advanced Development Programs (ADP), what this team was able to achieve over and over with more limited resources is absolutely remarkable. The U2 in so many ways was counter to what the standard direction was at the time, as well an incredible engineering feat.

What most stood out to me was the level at which the team operated at, and when process was introduced for “safety” and “process” the results were actually initially more harmful than good.

The hard things about the hard things

In one sense this felt like the cliff not version of Andy Grove’s High output management. In another sense Ben distils things down into some very practical guidance. It hits on some things that High output management does not such as how to handle layoffs, how to pivot, and in general some just interesting stories from his experiences of the years. His guidance on 1:1’s is spot on and for any manager I’d consider this required reading. I’d recommend this to anyone in tech/business, and not just as a replacement for High output management but as a supplement.

High output management

There’s a reason this is a cult classic in Silicon Valley among founders–it’s chocked full of great insight. It really is remarkable that while running Intel he took time to personally write this book. Unlike the previous, extracting some of the details and insights in this takes a little more focus. You can breeze through it, but you’ll lose so much of the value. For all the love that exists for this book I’ve not seen enough of it applied, from stagger charts to explicitly using meetings for various purposes–that said anything from this book you can apply you’re then better off.

Creativity Inc

Being a Disney fan this of course was a fun read to me. Even discounting that there’s some nice guidance in here for innovative/creative companies. Key themes include: the team, an environment of feedback that improves the product, a lot around creating an environment that helps you innovate but not burn out.

Effective Executive

Some of this ran counter to how I would approach a startup. Focus on the things you need to be doing and the process is the broad summary, which at the same time so much of it absolutely made sense. If you’re newer to upper management or to the executive team I’d highly recommend it. Even if not an exectuive there’s some good tidbits and it’ll give you some insight into a good executives world view. A few of the key themes:

  1. Track and then manage your time - which is useful guidance for anyone
  2. Focus on new opportunities not problem solving and damage control - this was a surprising concept to me but made a lot of sense
  3. Focus on one thing at a time as opposed to multitasking. This was an interesting one to me and while I can understand it’s argument there were also a few counter examples in the book.
  4. Creating organizational structures for success and outstanding performance

Inspired Products

This is a must read for product managers, engineers, project managers, and essentially everyone else involved in the product creation process. It clearly lays out what the goal of product management is, its interaction with other roles, and how to accomplish building great products.

Managing Humans

For a first time manager this has a lot of great insights. I typically enjoy Lopp’s style of writing as well, and this is essentially a number of blog posts converted to book form. Going from contributor to manager the biggest take away is that the manager’s job is different and should focus on the individual being successful. Beyond that there are a ton of small stories that apply to various situations, which makes for a light but worthwhile read.

Home game: An Accidental Guide to Fatherhood

As a father who had two children born at Alta Bates this one rings so very true. Tears were in my eyes from laughing so hard at this one. A great Michael Lewis style book that hits on modern fatherhood in a very humorous read. Highly encouraged for any father of young children or soon to be.

What problem are we trying to solve?

Gonna use a personal trick/hack? Use it often

Unfinished Business with Postgres

Guidance for Scaling - Reversible vs. Irreversible Decisions

Top 5 Product and Management skills: SQL, Excel, Clear Communication, Story, Prioritization

Exploring a new Postgres database

Spokesperson certification

Lessons from college: Efficient meetings

An interview on what makes Postgres unique (extensions)

Interesting Upcoming pgDays

Guidance for conducting offsites

The Engineering Manager/Product Manager Marriage

Come over for dinner

Talking on the phone: better communication

Using email as an effective tool

OKRs aren't going to fix your communication issues

Tips for your first tech conference

Give me back my monolith

Why I love building developer products

How can I help? East coast vs. West coast mentalities

SQL: One of the most valuable skills

The biggest mistake Postgres ever made

Postgres 11 - A First Look

PostgresOpen 2018 - First look at talks

Same great Postgres with a new player in town

Postgres hidden gems

Sourcing developer marketing content

Guidance on performing retrospectives

Postgres - the non-code bits

Dear Postgres

Tracking and managing your Postgres connections

Better database migrations in Postgres

Postgres backups: Logical vs. Physical an overview

Working with time in Postgres

Getting started with JSONB in Postgres

Simple but handy Postgres features

Syncing from Postgres to Salesforce - Data Mappings

Open DNS for when DNS outages occur

A tour of Postgres' Foreign Data Wrappers

Five mistakes beginners make when working with databases

What being a PM is really like - Software is easy, People are hard

Marketing definitions for developers

Writing more legible SQL

My top 10 Postgres features and tips for 2016

Postgres 9.5 - The feature rundown

Going from blog posts to full launches

Postgres and Node - Hands on using Postgres as a Document Store with MassiveJS

Node, Postgres, MassiveJS - A better database experience

Seeding a sharing-economy or platform company

A guide to analyst relations for startups

A guide to PR for startups

Moving past averages in SQL (Postgres) – Percentiles

Upsert lands in PostgreSQL 9.5 – A first look

A product management blueprint

A simple guide for DB migrations

A year's look at Postgres

Tracking Month over Month Growth in SQL

PostgreSQL 9.4 - What I was hoping for

How I hack email

Examining Postgres 9.4 - A first look

Where to go with developer content

Rethinking the limits on relational databases

Where to start with developer content

The best Postgres feature you're not using – CTEs aka WITH clauses

Tooling for Simple but Informative Emails

Disabling muting while typing in Google hangouts

Diving into Postgres JSON operators and functions

The Rule of Thirds - followup

The missing PostgreSQL documentation

A look at Foreign Data Wrappers

Postgres Dollar Quoting

Documenting your PostgreSQL database

hstore vs. JSON - Which to use in Postgres

Pivoting in Postgres

Javascript Functions for PostgreSQL

Explaining your PostgreSQL data

Postgres Indexing - A collection of indexing tips

Postgres Indexes – Expression/Functional Indexing

My SQL Bad Habits

CX – Conference Experience (Facilitating Communication)

CX – Conference Experience (Talks)

Using array_agg in Postgres – powerful and flexible

Scaling Evangelism – Creating Advocates

Doing Marketing (for developers) Differently

Prioritizing and Planning within Heroku Postgres

Fixing Database Connections in Django

Getting more out of psql (The PostgreSQL CLI)

Introducing django-db-tools

More on Postgres Performance

How I Write SQL

Using Postgres Arrays in Django

Redis in my Postgres

Understanding Postgres Performance

Rapid API Prototyping with Heroku Postgres Dataclips

Protips for Conference Talks

Schemaless Postgres in Django

Why PostgreSQL Part 2

Feedback for Conference Organizers

Why Postgres

Apps to Services

Sphinx Build Pack on Heroku

Securing your Internal Organization with OpenID

How Heroku Works - Hiring

Getting Started with Django

How Heroku Works - Maker's Day

How Heroku Works - Teams and Tools

Installing Python Packages

Getting Setup with Python

Environment Structure for Django Apps

Attribution 101

Startup/Bootstrapped Marketing Recap

Reading Metrics to Evaluate Marketing

Setting up Goals and Funnels - Google Analytics

Evaluating Paying for a Blog Post

JQuery and Django Autocomplete

Bootstrapped/Startup Marketing Part 3

Bootstrapped/Startup Marketing Part 2

Bootstrapped/Startup Marketing Part 1

Requirements Gathering for Consumer Startups

Tactical Steps for Startup Metrics

Events with Google Analytics and Tricking Pageviews

Converting Bookmarklet to Chrome Extension

Selling Something New

Interviewing, A Reflection of the Company

Selling... Seduction... same difference

Why The Cloud Will Finally Work

Valuing Employees

Who will filter the stream first?

Issues Aren't Always Bad

Forget Doing Something Better, Do Something Different

Parallelizing the Product Process?

Who Cares About Visitors?

Behavioral Targeting versus Contextual Advertising

Does Authenticity Matter?

Motivating Users

Micromanaging

Why the enterprise cant reach consumers

How to succeed in the workplace? Go to lunch!

Building apps from the echo chamber

Leaders and Developers

Mentoring

Takeaways from Consulting

Why Google Wave Will Fail

The benefit of leverage

Why Twitter Is About To Get Old

Takeaways for a startup

All the bubbles haven't burst yet

Ads is not a business model

Google did something right . . . . Finally

Being an employee

A Lesson from the Wal-Mart Model

Why Qik Matters

Don't Do It Yourself

Fotoviewr

How Ebay Missed the Boat

How social networking advertising should work

Microsoft vs. Apple

Facebook apps worth using

Conversation aggregators vs. social network aggegators

The problem with facebook's platform, is the problem isn't the platform

Web 2.5

A Generation

The site that gets it right

Site Review: Friendfeed

iPhone 1.1

How not to be successful in the valley

The value in content as a commodity

Nearsighted Business

Blurring the lines, the flip side

Mixing personal and professional, Transparency

Adobe came to play

Changing etiquette?

Is web 2.0 more utopian?

Consuming versus Publishing

Reduced noise in exchange for transparency

Why Twitter matters to you

Web, Scalability, SAAS

Bearish on mobile

Large corporations versus startups

Twitter will be commonplace in the enterprise

Adobe AIR is a game changer, if people would build for it...

Why Google may not exist in 8-10 years