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…

A famous article, “10 Things I Hate About PostgreSQL”, by Rick Branson summarizes the main pain points people encounter with PostgreSQL. It bring an answer to: “No software is perfect, so exactly what are PostgreSQL’s imperfections?” 10 Things I Hate About PostgreSQL Over the last few years, the software development community’s love affair with the popular open-source relational…rbranson.medium.com

from the YFTT first episode with the Yugabyte founders — Technical questions are better answered by engineers. The Yugabyte Friday Tech Talks is the right place and the first episode had the three founders of the PostgreSQL compatible open-source distributed SQL database YugabyteDB What means “Cloud-Native”? scale: you can ask for a machine and get it in a few minutes always available: machines…

A distributed SQL database provides a service where you can query the global database without knowing where the rows are. You connect to any node, without having to know the cluster topology. …

In 2019 I made a “19 features you will miss if you leave Oracle Database” presentation, about the features that are used every day with Oracle, and that may not be available in other databases. Because, as a consultant, I’ve seen many enterprises thinking about moving to open-source databases, especially…

Originally published at https://blog.yugabyte.com on October 14, 2021. A distributed SQL database reads from remote nodes, which increases the need for optimal data access. …