Infrastructure at your Service

Mouhamadou Diaw

PostgreSQL 11 : Procedures are coming

By | Database Administration & Monitoring | No Comments
 

 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 returns a value, we can say, yes it’s true but you cannot manage transactions in a function. To better understand let’s do a quick demonstration. Note that I am using the snapshot developer version of PostgreSQL 11 ….

Read More
Franck Pachot

Installing MAMP to play with PHP, MySQL and OpenFlights

By | Database Administration & Monitoring, Oracle | No Comments
 

 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 students at https://powercoders.org/, a coding academy for refugees in Switzerland. They install MAMP (My Apache – MySQL – PHP) during their curriculum for website development, and then I’ll use this environment to teach data modeling and SQL basics. Thus,…

Read More
Franck Pachot

SQLcl connect target depends on previous connection

By | Oracle | No Comments
 

 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 is the correct behavior, and the 100% compatibility with SQL*Plus is expected only when SET CLASSIC=ON. And as I was surprised, and I think it can be dangerous, here is a blog post about it. Basically, be very careful…

Read More
Jérôme Dubar

Patching ODA lite to 12.2.1.3.0

By | Database Administration & Monitoring | No Comments
 

 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 release and here is how to do that. In this example I was patching from 12.1.2.12.0, no intermediate patch was needed. 1) Download the patch It seems odd but sometimes finding the corresponding patch is…

Read More
David Barbarin

Introducing SQL Server on Kubernetes

By | Database Administration & Monitoring | No Comments
 

 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 of the most popular orchestration tools in the IT industry. By the way, I like to refer to the Portworx Annual Container Adoption Survey to get a picture of container trend over the years and we…

Read More
Cesare Cervini

An awk filter to truncate or wrap around tabular output

By | Entreprise content management | No Comments
 

 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 to be able to truncate the columns instead, in order to have an even compacter output. A shorter, denser table can certainly help is some cases, such as when a quick overview of a query’s result is…

Read More
Cesare Cervini

Adding a Documentum Extension to gawk, part II

By | Entreprise content management | No Comments
 

 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 test program and some helper functions for comfort. Let’s prepare them. o  Move back to the dmgawk directory and edit DctmAPI.awk, the wrapper functions; $ cd ../../.. $ pwd /home/dmadmin/gawk $ vi DctmAPI.awk o  Cut and paste the lines below: @load “dctm” # provides high-level function to do Documentum…

Read More
Cesare Cervini

Adding a Documentum Extension to gawk, part I

By | Entreprise content management | No Comments
 

 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 than 20 years ago. Some statements looked a bit odd, e.g. access to elements from multi-dimensional arrays such as “a[i1][i2]”, or “delete A” to empty an array (instead of the well-known awk idiom split(“”, A))….

Read More
Franck Pachot

OpenShift on my Windows 10 laptop with MiniShift

By | Oracle | No Comments
 

 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 few simple commands only. On Linux you can refer to Daniel’s post. Here is the Windows version. Oh, and Daniel did that to run Postgres but my goal is to run an Oracle container of course. Or MySQL maybe.

Read More
Daniel Westermann

EDB Failover Manager in EDB containers in Minishift/OpenShift – Failovers

By | Database Administration & Monitoring | No Comments
 

 In the last post we had a look at the basic configuration of EDB EFM and confirmed that we can do manual switchovers for maintenance operations. Being able to do a switchover and switchback is fine but what really is important are automatic failovers. Without an automatic failover this setup would be somehow useless as a) EDB EFM is supposed to do exactly that and b) without that we would need to implement something on…

Read More
David Barbarin

SQL Saturday Paris 2018 – Pré-conférence SQL Server Linux, Docker et Azure

By | Database Administration & Monitoring, SQL Server | No Comments
 

 The next SQL Saturday in Paris is coming soon and the agenda has been published by the @GUSS on twitter. Le prochain SQL Saturday Paris arrive bientôt et l’agenda a été publié sur Twitter par le @GUSS Cette année, un savant mélange de speakers francophones et internationaux, un plus pour les participants … Un rapide coup d’œil à l’agenda – si on se focalise sur la partie moteur SQL Server – montre également qu’une bonne…

Read More