Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
Introduction In this Blog I will describe how to create an API Backend with NodeJS using PostgreSQL as Database. We will create API for public events with CRUD options. CRUD means: create, read, update and delete. Firstly, we will create our PostgreSQL Tables and history tables. And then we will continue with NodeJS. If you don’t have PostgreSQL installed yet,…
In my previous blog Oracle REST Data Services – Installation and Configuration : We have installed ORDS in standalone mode. Configured ORDS to be administer by SQL Developer In this blog, we will explain how to create simple RESTful Web Services using PL/SQL and a browser Rest Client.. My sources are : Oracle REST Data Services documentation. Thatjeffsmith. oracle-base. First,…
The goal of this blog is to install and configure Oracle REST Data Services 19.2 in Standalone mode into an oracle database 12.2. The official documentation is stored here and you will find a lot of resources and examples from the Thatjeffsmith website. The first step is to download the last version of ORDS from the Oracle REST Data Services…
This blog provides you with a short overview of easy to control settings that enhance your PostgreSQL security. Mostly by creating a separate group to assign privileged database members. And checking different logging and log rotations settings for better and more secure logging management. In this blog I will go over a few PostgreSQL security settings that help to secure…
By default, PostgreSQL will only allow localhost connection. If you want allow remote connections, you need to configure it. Configuring postgresql.conf First we need to find out where our conf file is located. You have two options: If you are new to Postgres, you would like to use the classic ‘find’ command: find / -name “postgresql.conf” And the Pro users…
AWS comes with the great service of auto scaling, that gives the possibility to automatically adapt the environment to the changing needs. This helps to optimize costs and performance. With rising needs, your environment scales up and as soon as the needs decrease again, your environment will scale down again. The benefits of EC2 Auto Scaling are quite simple: 1.…
By Franck Pachot . On my Oracle Cloud Free Tier Autonomous Transaction Processing service, a database that can be used for free with no time limit, I have seen this strange activity. As I’m running nothing scheduled, I was surprised by this pattern and looked at it by curiosity. And I got the idea to take some screenshot to show…
By Mouhamadou Diaw In my previous blog, I described the steps to deploy an ODA 19.8 by reimaging. The ODA was reimaged with the latest available version 19.8 but some components were not up-to-dated. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 [root@serveroda ~]# odacli describe-component System Version ————— 19.8.0.0.0 Component Installed…
By Mouhamadou Diaw Recently I was deploying some ODA X8-2M. To install the 19.8 software, I decide to reimage the server with the 19.8 image. In this blog I describe the main steps I did. First, we will need to download following patches from Oracle support website -Patch 30403643: Oracle Database Appliance 19.8.0.0.0 OS ISO IMAGE for all platforms -Patch…
By Franck Pachot . In the previous blog post I’ve installed SQL Server on the Oracle Cloud. My goal was actually to have a look at Redgate SQL Clone, a product that automates thin cloning. The SQL Server from the Oracle marketplace is ok for SQL Clone prerequisites. There’s a little difference in .NET Framework version (I have 4.6 where…
Introduction There is no need to decrease the number of cores on your ODA when using Standard Edition 2, because your license is based on the number of physical CPU. So why would you do that? Obviously, the more cores you have, the more performance you should get. But that simply isn’t always true. Base CPU speed and Turbo Boost…
By Franck Pachot . You can create a VM with SQL Server running in the Oracle Cloud. This is easy with a few clicks on the marketplace: Here are the steps I did above: Oracle Cloud -> Marketplace -> Application -> Category -> Database management You have multiple flavors. I’ve chosen the lastest cheaper “Microsoft SQL 2016 Standard with Windows…
