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…

initially published on dev.to During an application release, you may run some DDL and DML to bring the database from one version to another. If anything fails, for whatever reason, you don’t want to leave it in an intermediate state and restore the initial state. This is an In-Place Point…

originally posted on LinkedIn One of the most difficult concepts to understand in SQL databases is probably transaction Isolation Level (the I in ACID). If this is your case, don’t panic, the fault is not yours. Unlike most of other Relational and SQL concepts, isolation levels were never correctly defined…