All articles

Oracle DML (DELETE) and the Index Clustering Factor

As a consultant working for customers, I’m often in the situation that I have an answer to a problem, but the recommended solution cannot be implemented due to some restrictions. E.g. the recommendation would be to adjust the code, but(…)

PostgreSQL 13: Trusted extensions

PostgreSQL 13 is just around the corner and one little, but important feature that was added are trusted extensions. When you want to add an extension to a database you need to be superuser for most of the extension or(…)

Instant PostgreSQL Cloning with SUSE and Btrfs

What if you could clone a PostgreSQL database instantly without affecting the original source database, without impacting performance, without any external tool but using your linux Btrfs storage layer. This is what I will demonstrate in the following blogpost.

Using PostgreSQL’s adminpack extension to write files

In PostgreSQL you have several ways of working with files and you can find quite some examples here on our blog, e.g. Modifying pg_hba.conf from inside PostgreSQL, Can I do it with(…)

VirtualBox issue E_FAIL (0x80004005)

Hi everybody, I get an issue on my VM today , so that I can’t open it anymore. When trying a  system restore I get the same state. I was really embarrassed to fail to restore my VM(…)

Amazon Aurora Serverless (PostgreSQL compatibility)

By Franck Pachot . I’ve written a blog post about serverless databases and here is an example of Amazon RDS Aurora PostgreSQL in serverless mode: When I’ve created the instance (15:55 –(…)

Amazon or AWS services?

By Franck Pachot . When I'm writing about a product I like to be precise about the name, the upper and lower case, and even more: do you know that was taking special care of writing Oracle 12cR2 before then(…)

Duplicate Database on ODA X4

By Mouhamadou Diaw The ODA X4 is still in use for some customers. The last time I was asked to validate the backups . Let me explain the context. Actually the backups are done via RMAN on local in a(…)

What is Object Storage?

By Franck Pachot . I’ve always been working with databases. Before the cloud era, the most abstract term was “data”. A variable in memory is data. A file is data. A block of disk contains data.

Amazon DynamoDB: a r(el)ational Glossary

By Franck Pachot . There are many NoSQL databases. And, because SQL is an ISO standard, “No SQL” also means “No Standard”. Many have a similar API and similar objects, but with completely different names. Today, NoSQL databases are(…)