PostgreSQL
from MySQL to PostgreSQL
Today pgloader v3.4.1 is released and available! This new release comes with 110 commits as show in github compare view. This release of pgloader is following the …
category
PostgreSQL
137 posts
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 …
PostgreSQL
Exploring a Data Set in SQL
Sometimes you need to dive in an existing data set that you know very little about. Let’s say we’ve been lucky to have had a high level description of the …
PostgreSQL
How to Write SQL
Kris Jenkins cooked up a very nice way to embed SQL in your code: YeSQL for Clojure. The main idea is that you should be writing your SQL queries in .sql files in your …
PostgreSQL
Find The Missing Integer
A recent interview question that I had to review was spelled like this: Find missing int element into array 1..100 Of course at first read I got it wrong, you have only …
PostgreSQL
Meetup PostgreSQL à Paris
Mercredi 8 octobre se tiendra le prochain Meetup PostgreSQL à Paris dans les locaux de Mozilla Europe, dont la capacité est de 90 personnes ! Venez nombreux !
PostgreSQL
PostgreSQL, Aggregates and Histograms
In our previous article Aggregating NBA data, PostgreSQL vs MongoDB we spent time comparing the pretty new MongoDB Aggregation Framework with the decades old SQL …
PostgreSQL
Aggregating NBA data, PostgreSQL vs MongoDB
When reading the article Crunching 30 Years of NBA Data with MongoDB Aggregation I coulnd’t help but think that we’ve been enjoying aggregates in SQL for 3 or …
PostgreSQL
Denormalizing Tags
In our Tour of Extensions today’s article is about advanced tag indexing. We have a great data collection to play with and our goal today is to be able to quickly …
Conferences
An Interview about MariaDB and PostgreSQL
At the Open World Forum two weeks ago I had the pleasure to meet with Colin Charles. We had a nice talk about the current state of both MariaDB and PostgreSQL, and even …