PostgreSQL
PostgreSQL Autonomous Transaction
PostgreSQL is an all round impressive Relational DataBase Management System which implements the SQL standard (see the very useful reference page Comparison of different …
tag
YeSQL
87 posts
Conferences
Open World Forum Conference
Last Friday I had the chance to be speaking at the Open World Forum in the NewSQL track, where we had lots of interest and excitement around the NoSQL offerings. Of …
PostgreSQL
Using trigrams against typos
In our ongoing Tour of Extensions we played with earth distance in How far is the nearest pub? then with hstore in a series about trigger, first to generalize Trigger …
PostgreSQL
Auditing Changes with Hstore
In a previous article about Trigger Parameters we have been using the extension hstore in order to compute some extra field in our records, where the fields used both for …
PostgreSQL
Trigger Parameters
Sometimes you want to compute values automatically at INSERT time, like for example a duration column out of a start and an end column, both timestamptz. It’s easy …
PostgreSQL
Understanding Window Functions
There was SQL before window functions and SQL after window functions: that’s how powerful this tool is. Being that of a deal breaker unfortunately means that it can …
PostgreSQL
How far is the nearest pub?
In our recent article about The Most Popular Pub Names we did have a look at how to find the pubs nearby, but didn’t compute the distance in between that pub and …
PostgreSQL
The Most Popular Pub Names
In his article titled The Most Popular Pub Names Ross Lawley did show us how to perform some quite interesting geographic queries against MongoDB, using some nice Open …
PostgreSQL
Archiving data as fast as possible
In a recent article here we’ve been talking about how do do Batch Updates in a very efficient way, using the Writable CTE features available in PostgreSQL 9.1. I …
PostgreSQL
Simple Case for Pivoting in SQL
In a recent article Craig Kerstiens from Heroku did demo the really useful crosstab extension. That function allows you to pivot a table so that you can see the data from …
Conferences
Make the Most ouf of SQL
Tonight I had the pleasure to present a talk at the Dublin PostgreSQL User Group using remote technologies. The talk is about how to make the most ouf of PostgreSQL when …
PostgreSQL
Nearest Big City
In this article, we want to find the town with the greatest number of inhabitants near a given location. A very localized example We first need to find and import some …