In the world of databases, replication is the backbone of availability, scalability, and data resilience. PostgreSQL, one of the most robust and widely used open-source databases, offers several replication solutions. However, pg_chameleon stands out as a particularly flexible tool, designed to replicate data from MySQL to PostgreSQL with a highly configurable architecture that adapts to diverse needs.

🔔 In questo articolo tento di spiegare le problematiche che potrebbero sorgere quando si usa MySQL in maniera poco accorta. Comunque, non sono un avvocato. Per capire se l'uso che fai di di MySQL rispetta la licenza di utilizzo, è meglio rivolgersi a un legale. --- La MySQL Community Edition è distribuita sotto la licenza GPLv2 (GNU General Public License versione 2), che consente l’utilizzo gratuito del software, anche in contesti commerciali.

🔔 In this article, I attempt to explain the issues that might arise when MySQL is used carelessly. However, I am not a lawyer. To ensure that your use of MySQL complies with its licensing terms, it’s best to consult a legal professional. MySQL Community Edition is distributed under the GPLv2 (GNU General Public License version 2), a widely recognized open-source license.

Introduction In this article, we’ll walk through the rationale behind using Postgres as a queue, explore the schema design, implement concurrency-safe task polling with SELECT … FOR UPDATE SKIP LOCKED, and ensure that only one worker processes a specific task at any given time. By the time we’re done, you’ll have the blueprint for a dependable, transactionally-secure system for background task processing—all running in Postgres.

Introduction Building modern web applications requires powerful tools and frameworks tailored to specific needs. Two specialized quickstart projects bring together the strengths of DelphiMVCFramework and HTMX to deliver dynamic and responsive web solutions. Depending on your Delphi version, project requirements and your preferences, you can leverage the TemplatePro HTMX Quickstart or the WebStencils HTMX Quickstart.

⭐ UPDATE (sept 2024): Updated official documentation about TemplatePRO is available here Back in 2016, I embarked on a small experiment: I started developing a simple template language. At the time, I was going through a “funny phase,” and my intention wasn’t to build a full-fledged template language. It was more of a personal challenge, an exploration with no clear end goal in sight.

We’re back! ITDevCon, the richest European conference on Delphi and related technologies, is scheduled for November 14th and 15th 2024. ITDevCon will be held at the bit Time group headquarter in Rome! This will be the 13th conference edition and will be organized, as usual, by bit Time Professionals and bit Time Software.

Kanban boards are vital tools in agile project management, providing a visual representation of work flow. However, one common mistake is the use of a “Blocked” column. This practice can lead to inefficiencies, mismanagement, and extended lead times, which undermines the effectiveness of the Kanban system. Understanding the Kanban Board Kanban boards typically consist of columns representing different stages of a workflow, such as “To Do,” “In Progress,” and “Done.

In the realm of data management, two terms often come up: data lake and data warehouse. Both are essential tools for storing and analyzing data, but they serve different purposes and are suited to different types of data and business needs. Let’s delve into what each one is and highlight their key differences.

▶️ 2° blog update 2024/06/19 ▶️ 1° blog update 2024/05/31 👉 DelphiMVCFramework 3.4.2-magnesium-rc2 is out! Considering the amount of new features contained in this version, I decided to publish a RELEASE CANDIDATE version; 2 so far. 🔴 THIS BLOG POST IS A WORK IN PROGRESS UNTIL THE STABLE VERSION IS RELEASED