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. …

I have seen a people comparing YugabyteDB and PostgreSQL, and surprised by the different throughput when running a simple test on a from a single session. The purpose of a distributed database is to scale out. When running on a single node without the need for High-Availability-without-data-loss (this is a…

Originally published at https://dev.to on October 7, 2021. When you create an index, you want the creation to be either: fast, blocking concurrent writes to get a stable version of the rows until the creation is completed, usually with a share lock on the table online, which means that it…