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 …
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: 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, …
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 …
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 …
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 …
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 …
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 …
PostgreSQL
Object Relational Database Management System
PostgreSQL is the world’s most advanced open source database, and per the PostgreSQL Wikipedia page it is an object-relational database management system (ORDBMS) …
PostgreSQL
Database Normalization and Primary Keys
In our previous article we saw three classic Database Modelization Anti-Patterns. The article also contains a reference to a Primary Key section of my book The Art of …
PostgreSQL
Database Modelization Anti-Patterns
Next week we see two awesome PostgreSQL conferences in Europe, back to back, with a day in between just so that people may attend both! In chronological order we have …
PostgreSQL
Sustainable Open Source Development
Current trend in software deployments is to rely on open source software for entire production stacks. You can find open source software in the core technical stacks of …
PostgreSQL
Find the number of the longest continuously rising days for a stock
Today I want to react to an article that claims that Relational Algebra Is the Root of SQL Problems in which the author hand-waves the following position: SQL becomes …