Development & Performance

CloudNativePG – Configuring the PostgreSQL instance

In the last post we’ve created a more detailed version of the cluster definition for CloudNativePG. This gave us a PostgreSQL cluster with enabled data checksum, the correct locale, an increased size of the WAL segments and the possibility(…)

What DEVs need to hear from a DBA and why SQL and RDBMS still matters…

The Average case As a skilled developer, you are well-versed in the latest trends and fully capable of building an application from scratch. From the frontend to the RESTful API backend, through to the ORM and the database, you have(…)

Add authentication in a Feathers.js REST API

Following on from my previous articles: Create REST API from your database in minute with Feathers.js, and Add a UI to explore the Feathers.js API, today I want to add authentication in my Feathers.js REST API. Creation, update(…)

Add a UI to explore the Feathers.js API

Following on from my previous article: Create REST API from your database in minute with Feathers.js, today I want to add a UI to explore the Feathers.js API. When we provide an API, it’s common to make a tool(…)

Create REST API from your database in minute with Feathers.js

Creating REST APIs is a fairly repetitive task. You’re always rewriting the Create, Read, Update, Delete methods…In my search for a framework capable of generating a REST API, I discovered Feathers, a simple and useful framework for Node.js.

SQL Server: Manage large data ranges using partitioning

Introduction:  When it comes to moving ranges of data with many rows across different tables in SQL-Server, the partitioning functionality of SQL-Server can provide a good solution for manageability and performance optimizing. In this blog we will look at the(…)

Boost dynamic SQL with Plan Guides

Recently a customer asked me to check why a load process from a banking application has so poor performance.In fact this process is extremely slow, between 40 minutes up to more than one hour to load around 240’000 rows. As(…)

APEX/ORDS 23.x – DispatcherNotFoundException

The aim of that blog is to look into Oracle REST Data Services (ORDS) 23.x error raised when setting up for APEX 23.1. This is following some experience at a customer who wanted to move to(…)

New Features 23c, Overview (in extracts):

In this blog I want to introduce some of the new features of the Oracle 23c developer edition. It will be only a selection of some of the main features. It is not the intention to give you a thorough(…)

Oracle Lock Free Reservations

The Oracle 23c new feature Lock Free Reservations allows to break with the traditional locking mechanism. Now multiple concurrent sessions can update the same row without be blocked !!! Let’s see how it works. In the traditional locking mechanism,(…)