Getting more out of PostgreSQL

Notes on SQL technique, data modeling, and PostgreSQL internals — from the author of The Art of PostgreSQL. New articles are built on the free Lab so you can run every query yourself.

PostgreSQL

PostgreSQL Data Types

Today it’s time to conclude our series of PostgreSQL Data Types articles with a recap. The series cover lots of core PostgreSQL data types and shows how to benefit …

May 24, 2018 ·10 min read ·#PostgreSQL #YeSQL #Data Types

PostgreSQL

PostgreSQL Data Types: Point

Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL Point type. In order to put the Point datatype in a context where it …

May 7, 2018 ·18 min read ·#PostgreSQL #YeSQL #Data Types #Point

PostgreSQL

PostgreSQL Data Types: ENUM

Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL ENUM type. This data type has been added to PostgreSQL in order to make …

May 2, 2018 ·3 min read ·#PostgreSQL #YeSQL #Data Types #ENUM

PostgreSQL

PostgreSQL Data Types: JSON

Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL JSON type. PostgreSQL has built-in support for JSON with a great range …

Apr 30, 2018 ·5 min read ·#PostgreSQL #YeSQL #Data Types #JSON

PostgreSQL

PostgreSQL Data Types: XML

Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL XML type. The SQL standard includes a SQL/XML which introduces the …

Apr 23, 2018 ·2 min read ·#PostgreSQL #YeSQL #Data Types #XML

PostgreSQL

PostgreSQL Data Types: Arrays

Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL array data types. Arrays can be used to denormalize data and avoid …

Apr 20, 2018 ·7 min read ·#PostgreSQL #YeSQL #Data Types #Arrays

PostgreSQL

PostgreSQL Data Types: Ranges

Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL ranges data type. Range types are a unique feature of PostgreSQL, …

Apr 18, 2018 ·5 min read ·#PostgreSQL #YeSQL #Data Types #Ranges

PostgreSQL

PostgreSQL Data Types: Network Addresses

Continuing our series of PostgreSQL Data Types today we’re going to introduce network address types. PostgreSQL includes support for both cidr, inet, and macaddr …

Apr 16, 2018 ·4 min read ·#PostgreSQL #YeSQL #Data Types #Network Address

PostgreSQL

PostgreSQL Data Types: Date and Time Processing

Continuing our series of PostgreSQL Data Types today we’re going to introduce date and time based processing functions. Once the application’s data, or rather …

Apr 13, 2018 ·8 min read ·#PostgreSQL #YeSQL #Data Types #Date

PostgreSQL

PostgreSQL Data Types: Text Processing

Continuing our series of PostgreSQL Data Types today we’re going to introduce some of the PostgreSQL text processing functions. There’s a very rich set of …

Apr 11, 2018 ·7 min read ·#PostgreSQL #YeSQL #Data Types #Text

PostgreSQL

PostgreSQL Data Types: Text Encoding

Continuing our series of PostgreSQL Data Types today we’re going to introduce the PostgreSQL text data type. The first notion to understand when processing text in …

Apr 9, 2018 ·4 min read ·#PostgreSQL #YeSQL #Data Types #Text

PostgreSQL

PostgreSQL Data Types: an intro

Today, we’re going to begin a dive into the PostgreSQL Data Types. As my colleague Will Leinweber said recently in his talk Constraints: a Developer’s Secret …

Apr 6, 2018 ·8 min read ·#PostgreSQL #YeSQL #Data Types #Boolean