This article covers everything from the basics to advanced topics, including examples from the official documentation. The post is designed to be an in‐depth resource detailing how composite types can be used to design clean, maintainable, and efficient database schemas.
Table of Contents Introduction What Are Composite Types? Why Use Composite Types?
A new Patreon-exclusive video is now live, and it’s packed with everything you need to master session management in DMVCFramework.
💡The new Server Session architecture is available since dmvcframework-3.4.2-magnesium
In this video, I’ll guide you through three in-depth demos that show exactly how to set up and use:
Memory sessions for quick, efficient setups.
Vuoi diventare protagonista del più grande evento italiano sull’innovazione tecnologica relativa a Delphi? È il momento giusto: è aperto il call for paper per ITDevCon Spring Edition 2025!
Come anticipato nella newsletter “Delphi Bites” (clicca qui per iscriverti), siamo infatti pronti a dar vita a ITDevCon 2025 Spring Edition: la conferenza tutta italiana dedicata all’innovazione tecnologica relativa a Delphi e alle tecnologie a esso collegate.
With the continuous evolution of DMVCFramework, one of the most appreciated frameworks for building web applications in Delphi, a significant change has been introduced: the new server-side session management system. This update represents a major step forward in terms of modularity and flexibility, allowing developers to choose from different session storage modes based on their project’s specific needs.
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.