Blog: Craig Kerstiens

208 blogs updated: 78 min. ago
Dear Postgres
Dear Postgres, I've always felt an affinity for you in my 9 years of working with you. I know others have known you longer, but that doesn't...
12-10-2017 20:00:36 Craig Kerstiens PostgreSQL
Tracking and managing your Postgres connections
Managing connections in Postgres is a topic that seems to come up several times a week in conversations. I've written some about scaling you...
19-09-2017 01:49:17 Craig Kerstiens PostgreSQL
Better database migrations in Postgres
As your database grows and scales there are some operations that you need to take more care of than you did when you were just starting. Whe...
10-09-2017 18:44:51 Craig Kerstiens PostgreSQL
Postgres backups: Logical vs. Physical an overview
It's not a very disputed topic that you should backup your database, and further test your backups. What is a little less discussed, at leas...
03-09-2017 19:12:14 Craig Kerstiens PostgreSQL
Postgres Open Silicon Valley line-up: First take
This year Postgres open and PGConf SV have combined to great a bigger and better conference right in downtown San Francisco. I'm obviously b...
01-07-2017 17:39:04 Craig Kerstiens PostgreSQL
Working with time in Postgres
A massive amount of reporting queries, whether really intensive data analysis, or just basic insights into your business involving looking a...
08-06-2017 21:10:47 Craig Kerstiens PostgreSQL
Why use Postgres (Updated for last 5 years)
Five years ago I wrote a post that got some good attention on why you should use Postgres. Almost a year later I added a bunch of things I m...
30-04-2017 18:00:47 Craig Kerstiens PostgreSQL
Getting started with JSONB in Postgres
JSONB is an awesome datatype in Postgres. I find myself using it on a weekly basis these days. Often in using some API (such as clearbit) I'...
12-03-2017 19:18:03 Craig Kerstiens PostgreSQL
Simple but handy Postgres features
It seems each week when I'm reviewing data with someone a feature comes up that they had no idea existed within Postgres. In an effort to co...
08-01-2017 18:05:05 Craig Kerstiens PostgreSQL
Syncing from Postgres to Salesforce - Data Mappings
For the second time now I've had to implement a system that syncs from my system of record into, the first at Heroku and now ...
23-11-2016 17:52:03 Craig Kerstiens PostgreSQL

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.