All articles

Things you can, but probably shouldn’t do in PostgreSQL: Tables in tables, types in types, and arrays on top

PostgreSQL comes with a lot of flexibility for defining new data types, defining tables and defining arrays over data types. You can make that as complex as you want, which does not mean that you should do it. Somehow(…)

Larry Ellison – Oracle’s Vision for the future

Generative AI changes everything Larry Ellison kicked off his keynote by delving into Artificial Intelligence, particularly focusing on ChatGPT. The phrase is sure to become famous “About a year ago OpenAI demonstrated ChatGPT 3.5 and much to the shock(…)

SQL Konferenz 2023 in Hanau – Meet Tame, the data monster

After 2 years, or even 3 years? The organizers could not agree, the SQL Conference took place again in Hanau. 73 speakers have taught us in over 80 sessions with their experience as well as knowledge new.

Adapt Zabbix to Your Needs

Zabbix comes with an long list of smart and customizable templates (more than 270). In this blog post, I will explain how to customize these templates and adapt them to your environment’s needs. Macro The first level of(…)

Ansible automates roadshow 2023

I attended this tour from Red Hat to promote automation at Ansible automates roadshow with my colleague Arnaud Berbier. You’ll find his review of the journey here) in Geneva. It was the third date from their tour.

Oracle to the rescue of MGM with SQL Firewall?

Introduction It is true that it’s a somewhat daring title, and it’s unlikely that SQL firewall has changed anything about the attack that several casinos in Las Vegas suffered last week. However, the opportunity was too good to(…)

MongoDB: How to translate SQL to MongoDB commands

Introduction Hi everybody If you work with databases, you will be familiar with the two main philosophies used in this domain: The SQL philosophy (RDBMS) and, of course, NoSQL databases.Some examples of SQL databases are Oracle and Postgres,(…)

Ansible Automates – Event Driven & Lightspeed

It was a pleasure to attend the Ansible Automates Roadshow in Geneva this year with my colleague Chay Te. There were several topics and sessions covered during the full day. It was a learning opportunity about the vision and(…)

Las Vegas, from sin city to green city?

Introduction Oracle CloudWorld 2023 will start next week in Las Vegas, and I’m happy to participate in this worldwide event. As a Swiss citizen, when I think of Las Vegas, the first image that comes to my mind is(…)

No more snapshot too old in PostgreSQL 17

Currently PostgreSQL has a feature which is called snapshot too old. While each release of PostgreSQL comes with a bunch of new features, sometimes features also get removed. Starting with PostgreSQL 17 there will be most likely no more(…)