All articles

How to compile PostgreSQL 11 with support for JIT compilation on RHEL/CentOS 7

As you might already know PostgreSQL 11 will bring support for just-in-time compilation. When you want to compile PostgreSQL 11 with jit support on RedHat/CentOS 7 this requires a little hack (more on the reason below). In(…)

PostgreSQL 11: Instant add column with a non null default value

As I am currently preparing my session for the Swiss PGDay which is about some of the new features for PostgreSQL 11, I though this one is worth a blog post as well. Up to PostgreSQL 10(…)

How to flashback databases in dataguard with broker

Last week I had to do some tests with dataguard. To make restores easier restore points were required. Given is following configuration: show configuration; Configuration - ila Protection Mode: MaxAvailability Databases: ila - Primary database(…)

PostgreSQL 11 : Procedures are coming

By Mouhamadou Diaw Reading about new features about future version PostgreSQL 11. I see that procedures will be implemented. Why is it so important? Until now only functions are available in PostgtreSQL. Of course a function is a procedure that(…)

Installing MAMP to play with PHP, MySQL and OpenFlights

By Franck Pachot . You may wonder what I'm doing with those technologies that are completely different from what I usually do. I'll detail in a future blog post but the idea is giving a short introduction to databases to(…)

SQLcl connect target depends on previous connection

By Franck Pachot . I thought it was a bug for two reasons: first, because I don't like that my connect destination depends on the context, and then because it is a different behavior than in SQL*Plus. But finally, it(…)

Patching ODA lite to 12.2.1.3.0

Here is the latest patch for your ODA and it seems that Oracle documentation for this patch is not exactly the procedure you’ll have to follow to successfully patch your appliance. I recently updated X6-2M and X6-2L to this latest(…)

Introducing SQL Server on Kubernetes

After spending some times with Docker Swarm let’s introduce SQL Server on Kubernetes (aka K8s). Why another container orchestrator? Well, because Microsoft gives a strong focus on Kubernetes in their documentation and their events and because K8s is probably one(…)

An awk filter to truncate or wrap around tabular output

In my previous blog “idql and its column output”, see link here, I provided a small awk filter to reflow the idql output’s columns by wrapping their content around. Later I came of thinking that it could be useful(…)

Adding a Documentum Extension to gawk, part II

This is part II of the article “Adding a Documentum Extension to gawk”. You can find Part I here Before we can test the extension, we need a(…)