PostgreSQL
Setting up psql, the PostgreSQL CLI
PostgreSQL ships with an interactive console with the command line tool named psql. It can be used both for scripting and interactive usage and is moreover quite a …
category
YeSQL
77 posts
PostgreSQL
Mastering PostgreSQL: a reader's interview
Florent Fourcot has read Mastering PostgreSQL in Application Development and has seen tremendous inprovements in his production setup from reading the first chapters and …
PostgreSQL
Mastering PostgreSQL: more about the docker image
The Enterprise Edition of Mastering PostgreSQL in Application Development ships with a docker image that hosts both a PostgreSQL server instance with a pre-loaded …
PostgreSQL
Simple Data Modeling with a Test Data Set
In How to Write SQL we saw how to write SQL queries as separate .sql files, and we learnt about using query parameters with the psql syntax for that (:variable, …
PostgreSQL
The Mode Ordered-Set Aggregate Function
In our article Exploring a Data Set in SQL we discovered a data set related to music: the Chinook sample database. Our discovery led us to find albums containing tracks …
PostgreSQL
Set Returning Functions and PostgreSQL 10
PostgreSQL 10 is now available for everyone to use, and hinted by David Fetter I had to review my previous article on Json and SQL to adapt to Set Returning Functions …
PostgreSQL
on Json and SQL
PostgreSQL has had proper json support for a while now. The unique extensibility approach of the PostgreSQL system allows it to enable native SQL friendly JSON …
PostgreSQL
Regular Expressions and Grouping Sets
There’s a very rich set of PostgreSQL functions to process text, you can find them all at the String Functions and Operators documentation chapter, with functions …
PostgreSQL
SQL Regression Tests
In a previous article here we saw How to Write SQL in your application code. The main idea in that article is to maintain your queries in separate SQL files, where …
PostgreSQL
Playing with Unicode
The reason why I like Unicode a lot is because it allows me to code in text based environments and still have nice output. Today, we’re going to play with Regional …
PostgreSQL
PostgreSQL and the calendar
The modern calendar is a trap for the young engineer’s mind. We deal with the calendar on a daily basis and until exposed to its insanity it’s rather common …
PostgreSQL
SQL and Business Logic
Business logic is supposed to be the part of the application where you deal with customer or user facing decisions and computations. It is often argued that this part …