Database triggers have a bad reputation because, like any powerful feature, they can be abused. However, when used appropriately, triggers can be useful for adding additional data logic without changing the application’s business logic. …

When a new technology emerges, we need to name the previous one, which had no name when it was the only option available. SQL databases, or RDBMS (Relational Database Management Systems as they were designed to store data primarily into relational structures), traditionally run on a single server where applications…

Some NoSQL vendors have introduced transactional behavior and now claim ACID properties in their marketing slides. I’m pleased to see them using SQL terms after proclaiming the end of relational databases. However, it can be misleading if you don’t examine the distinction between a NoSQL transaction and a SQL transaction…

PostgreSQL Tips and Tricks Generate SQL from SQL in PostgreSQL DBAs often need to generate SQL statements, specifically DDL (Data Definition Language), using SQL queries and then…www.yugabyte.com

Generate Random Text Strings in PostgreSQL Need a quick and easy way to generate a random string to fill in a text column, say for generating synthetic data or…www.yugabyte.com

In 1988 Oracle announced SQL*Star to connect to other non-oracle databases, and query or update a remote database through database links: Computerworld For more than 40 years, Computerworld has been the leading source of technology news and information for IT influencers…books.google.ch In 2023 Oracle released the Oracle Free edition that can be deployed anywhere for free (it is actually a rename of Oracle XE with easier deployment):

This is a re-post from dev.to which is the main place where I blog: https://dev.to/franckpachot — original article from Dec 9, 2022 YugabyteDB has always supported User Defined Functions (UDFs) in its PostgreSQL compatible API because… it is PostgreSQL compatible. I’ve been working with Oracle database since version 7.1 and…

This is a re-post from dev.to which is the main place where I blog: https://dev.to/franckpachot — original article from Nov 8, 2022 During Halloween, I’ve heard a creepy story about tombstones, and how database performance may decrease when data dies. It was a nice and funny video, by the way…

Jelastic is a DevOps PaaS, running containers with easy scaling and pay-per-use charging. If you want to test YugabyteDB (open-source PostgreSQL-compatible distributed SQL database) you may encounter some specificity. The main issue you may encounter comes from a bug in OpenVZ/Virtuozzo, the container and virtualization software used by Jelastic, which…