Oracle Team

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(…)

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(…)

Adding a Documentum Extension to gawk, part I

Recently, I was searching my NAS for some files which, to end this intolerable suspense, I did not find but on the other hand I did stumbled across a couple of interesting dmawk scripts I wrote for on customer more(…)

OpenShift on my Windows 10 laptop with MiniShift

By Franck Pachot . If you want to play with OpenShift on your laptop, you can, in a Virtual Machine. I have VirtualBox installed on my laptop. I'll install Minishift here, which will create the VM to run OpenShift with(…)

Which Bitnami service to choose in the Oracle Cloud Infrastructure?

By Franck Pachot . In the Oracle Cloud PaaS you have a marketplace where you can choose your service. Some are packaged from Bitnami and available on multiple OS. My first idea is that in PaaS you do not care(…)

Postgres, the fsync() issue, and ‘pgio’ (the SLOB method for PostgreSQL)

By Franck Pachot . That's a long blog post title, which is actually just a good pretext to play with Kevin Closson SLOB method for PostgreSQL: pgio I use the beta version of pgio here. If you want to read(…)

ADWC – System and session settings (DWCS lockdown profile)

By Franck Pachot . The Autonomous Data Warehouse Cloud service is a PaaS managed service where we have a PDB and an ADMIN user which has most of the system privileges. For example, we have the privilege to change initialization(…)

Adding a Documentum extension into python

Many years ago, out of frustration by the poorness of scripting tools in Documentum, I realized a Documentum binding for python using the distutils and I remember how easy and straightforward it had been, even for someone not really into(…)