The Curious Engineer

All blogs / Databases

CRAIG KERSTIENS

craigkerstiens.com

DatabasesEngineering management / careersSoftware / engineering practice

’05’10’15’20’25
Posts
221 from 1 Jan 2001 to 11 Nov 2024
Posting
now and then
Kind
personal blog
Feed
https://www.craigkerstiens.com/index.xml

2024 2

  1. Getting comfortable with psql
  2. The future of Postgres?

2022 3

  1. What problem are we trying to solve?
  2. Gonna use a personal trick/hack? Use it often
  3. Unfinished Business with Postgres

2021 2

  1. Guidance for Scaling - Reversible vs. Irreversible Decisions
  2. Top 5 Product and Management skills: SQL, Excel, Clear Communication, Story, Prioritization

2020 3

  1. Exploring a new Postgres database
  2. Spokesperson certification
  3. Lessons from college: Efficient meetings

2019 13

  1. An interview on what makes Postgres unique (extensions)
  2. Interesting Upcoming pgDays
  3. Guidance for conducting offsites
  4. The Engineering Manager/Product Manager Marriage
  5. Come over for dinner
  6. Talking on the phone: better communication
  7. Using email as an effective tool
  8. OKRs aren't going to fix your communication issues
  9. Tips for your first tech conference
  10. Give me back my monolith
  11. Why I love building developer products
  12. How can I help? East coast vs. West coast mentalities
  13. SQL: One of the most valuable skills

2018 5

  1. The biggest mistake Postgres ever made
  2. Postgres 11 - A First Look
  3. PostgresOpen 2018 - First look at talks
  4. Same great Postgres with a new player in town
  5. Postgres hidden gems

2017 12

  1. Sourcing developer marketing content
  2. Guidance on performing retrospectives
  3. Postgres - the non-code bits
  4. Dear Postgres
  5. Tracking and managing your Postgres connections
  6. Better database migrations in Postgres
  7. Postgres backups: Logical vs. Physical an overview
  8. Postgres Open Silicon Valley line-up: First take
  9. Working with time in Postgres
  10. Why use Postgres (Updated for last 5 years)
  11. Getting started with JSONB in Postgres
  12. Simple but handy Postgres features

2016 8

  1. Syncing from Postgres to Salesforce - Data Mappings
  2. Open DNS for when DNS outages occur
  3. A tour of Postgres' Foreign Data Wrappers
  4. Five mistakes beginners make when working with databases
  5. /2016/02/28/
  6. What being a PM is really like - Software is easy, People are hard
  7. Marketing definitions for developers
  8. Writing more legible SQL

2015 11

  1. My top 10 Postgres features and tips for 2016
  2. Postgres 9.5 - The feature rundown
  3. Going from blog posts to full launches
  4. Postgres and Node - Hands on using Postgres as a Document Store with MassiveJS
  5. Node, Postgres, MassiveJS - A better database experience
  6. Seeding a sharing-economy or platform company
  7. A guide to analyst relations for startups
  8. A guide to PR for startups
  9. Moving past averages in SQL (Postgres) – Percentiles
  10. Upsert lands in PostgreSQL 9.5 – A first look
  11. A product management blueprint

2014 19

  1. A simple guide for DB migrations
  2. My wishlist for Postgres 9.5
  3. When to ship it, when to kill it
  4. Scaling Organizations - Scribing
  5. Postgres and Connection Pooling
  6. Personas, data science, k-means
  7. Postgres Datatypes – The ones you're not using.
  8. What you need to know about April 7 and your security on the web.
  9. Some non-traditional marketing tips
  10. A year's look at Postgres
  11. PostgreSQL 9.4 - Looking up (with JSONB and logical decoding)
  12. Tracking Month over Month Growth in SQL
  13. PostgreSQL 9.4 - What I was hoping for
  14. How I hack email
  15. Examining Postgres 9.4 - A first look
  16. Where to go with developer content
  17. Rethinking the limits on relational databases
  18. Where to start with developer content
  19. Where to start with developer content

2013 32

  1. Digging in with Foreign Tables
  2. The best Postgres feature you're not using – CTEs aka WITH clauses
  3. Tooling for Simple but Informative Emails
  4. Disabling muting while typing in Google hangouts
  5. Diving into Postgres JSON operators and functions
  6. The Rule of Thirds - followup
  7. The missing PostgreSQL documentation
  8. A look at Foreign Data Wrappers
  9. Postgres Dollar Quoting
  10. Documenting your PostgreSQL database
  11. hstore vs. JSON - Which to use in Postgres
  12. Pivoting in Postgres
  13. Javascript Functions for PostgreSQL
  14. Explaining your PostgreSQL data
  15. Postgres Indexing - A collection of indexing tips
  16. Postgres Indexes – Expression/Functional Indexing
  17. My SQL Bad Habits
  18. CX – Conference Experience (Facilitating Communication)
  19. CX – Conference Experience (People)
  20. CX – Conference Experience (Talks)
  21. Heroku's Acquisition 2 Years Later
  22. Using array_agg in Postgres – powerful and flexible
  23. Scaling Evangelism – Creating Advocates
  24. Doing Marketing (for developers) Differently
  25. Why I Blog
  26. Prioritizing and Planning within Heroku Postgres
  27. Fixing Database Connections in Django
  28. Simple database read scaling without sharding in rails
  29. Getting more out of psql (The PostgreSQL CLI)
  30. How I work with Postgres – psql, My PostgreSQL Admin
  31. Introducing django-db-tools
  32. More on Postgres Performance

2012 16

  1. Sharding your database
  2. How I Write SQL
  3. Using Postgres Arrays in Django
  4. Redis in my Postgres
  5. Postgres Pooling with Django
  6. Understanding Postgres Performance
  7. Arrays in Postgres
  8. Rapid API Prototyping with Heroku Postgres Dataclips
  9. Protips for Conference Talks
  10. Schemaless Postgres in Django
  11. Why PostgreSQL Part 2
  12. Feedback for Conference Organizers
  13. Why Postgres
  14. Apps to Services
  15. Sphinx Build Pack on Heroku
  16. Securing your Internal Organization with OpenID

2011 22

  1. How Heroku Works - Hiring
  2. Getting Started with Django
  3. Postgres... The death of NoSQL
  4. How Heroku Works - Maker's Day
  5. How Heroku Works - Teams and Tools
  6. Installing Python Packages
  7. Getting Setup with Python
  8. Environment Structure for Django Apps
  9. Attribution 101
  10. Startup/Bootstrapped Marketing Recap
  11. Reading Metrics to Evaluate Marketing
  12. Setting up Goals and Funnels - Google Analytics
  13. Evaluating Paying for a Blog Post
  14. JQuery and Django Autocomplete
  15. Bootstrapped/Startup Marketing Part 4
  16. Bootstrapped/Startup Marketing Part 3
  17. Bootstrapped/Startup Marketing Part 2
  18. Bootstrapped/Startup Marketing Part 1
  19. Requirements Gathering for Consumer Startups
  20. Tactical Steps for Startup Metrics
  21. Events with Google Analytics and Tricking Pageviews
  22. Converting Bookmarklet to Chrome Extension

2010 11

  1. Selling Something New
  2. Interviewing, A Reflection of the Company
  3. Selling... Seduction... same difference
  4. Why The Cloud Will Finally Work
  5. Valuing Employees
  6. Who will filter the stream first?
  7. Issues Aren't Always Bad
  8. Forget Doing Something Better, Do Something Different
  9. Parallelizing the Product Process?
  10. Who Cares About Visitors?
  11. Behavioral Targeting versus Contextual Advertising

2009 12

  1. Does Authenticity Matter?
  2. Motivating Users
  3. Micromanaging
  4. Why the enterprise cant reach consumers
  5. How to succeed in the workplace? Go to lunch!
  6. Building apps from the echo chamber
  7. Leaders and Developers
  8. Mentoring
  9. Takeaways from Consulting
  10. Why Google Wave Will Fail
  11. The benefit of leverage
  12. Why Twitter Is About To Get Old

2008 37

  1. Takeaways for a startup
  2. All the bubbles haven't burst yet
  3. Ads is not a business model
  4. Google did something right . . . . Finally
  5. Being an employee
  6. A Lesson from the Wal-Mart Model
  7. Why Qik Matters
  8. Don't Do It Yourself
  9. Fotoviewr
  10. How Ebay Missed the Boat
  11. How social networking advertising should work
  12. Microsoft vs. Apple
  13. Facebook apps worth using
  14. Conversation aggregators vs. social network aggegators
  15. The problem with facebook's platform, is the problem isn't the platform
  16. Web 2.5
  17. A Generation
  18. The site that gets it right
  19. Site Review: Friendfeed
  20. iPhone 1.1
  21. How not to be successful in the valley
  22. The value in content as a commodity
  23. Nearsighted Business
  24. Blurring the lines, the flip side
  25. Mixing personal and professional, Transparency
  26. Adobe came to play
  27. Changing etiquette?
  28. Is web 2.0 more utopian?
  29. Consuming versus Publishing
  30. Reduced noise in exchange for transparency
  31. Why Twitter matters to you
  32. Web, Scalability, SAAS
  33. Bearish on mobile
  34. Large corporations versus startups
  35. Twitter will be commonplace in the enterprise
  36. Adobe AIR is a game changer, if people would build for it...
  37. Why Google may not exist in 8-10 years

2001 13

  1. Craig's Disney Food Guide
  2. Craig's Disneyland Guide
  3. Craig's Huntsville Guide
  4. Craig's New Orlenas Guide
  5. Craig's Paso Robles Guide
  6. Craig's San Francisco Guide
  7. Craig's Sonoma and Napa Wine Guide
  8. Craig's Wine Tasting Routes
  9. Past top content
  10. Speaking
  11. Tahoe Donner
  12. Travel/Wine
  13. Wine Club Memberships