It has been almost a year (March 21st 2022) since Alex asked me if I knew someone who could be his co-author for a new book he was asked to write. Before I really knew what I was getting myself into I said yes, I know someone. I’ll do it.And thus began a period of […]
Read moreI explained how I configured the Raspberry Pi and created a Python script to connect to the cloud. Now, I want to be able to keep multiple cloud databases alive using a single Raspberry Pi. In this blog, I will show you how I handled this problem. Connecting more than one cloud environment sounds impossible. […]
Read moreIn my previous article, I showed you how to install Oracle Linux on a Raspberry Pi 3B and make a connection to the Oracle Always Free Tier database. This was all done as the root user, which is, I know, very bad practice. Time to create a better solution. First, I created a user: [root@rpi ~]# […]
Read moreDo you have an Oracle Free Tier cloud account? Then you know it’s important to keep your databases alive if you want to be able to access them at any time. But this is not as easy as it sounds. Of course, you know that: If your Always Free Autonomous Database has no activity for 7 […]
Read moreOver the last couple of months I have been working on a MySQL based system for my current customer. This made me realize, once again, how easy we can do stuff in an Oracle based system.On one hand this is kind of awkward, not being able to do what you are used to, on the […]
Read moreConnecting to the Oracle cloud using SQLDeveloper is easy. You just download the wallet to your machine and tell SQLDeveloper to use the contents of this zip file for your connection. Ofcourse this is easy, because SQLDeveloper is an Oracle product, it would be bad advertising if this was a hard thing to do. Connecting […]
Read moreOn the forum of PL/SQL Developer there was a message by my good friend Erik van Roon. He was having trouble with Reconnecting. Even my plugin didn’t help him. I figured I should update the plugin.
Read moreThe other day a friend called me with a question on constraints. “I have a table where the combination of two columns must be unique”. My response was: “Use a Unique Constraint on these two columns”.That should work, however…
Read moreJust a quick note of something I ran into at my current assignment. I have to import data from external tables into persistent tables. This proces normally is just inserting data into the table, but sometimes a file can be sent in more than once.
Read moreAt my current assignment we are processing files coming from an online system to be inserted into our database (kind of a data warehouse). This is done using external tables and a scheduled job. The job just checks if there is a file available and will process this. The trouble is that the files might […]
Read more