The problem of “identity misalignment” is something that commonly arises in PostgreSQL (and other similar database systems) when there is a mismatch, between the values generated by a sequence or identity column and the actual data stored in the table. This misalignment can occur for reasons, such as errors while inserting values into an identity column, mistakes during data manipulation or issues with sequence generators.

👉 This article is available also in italian. The time is come! On the 25th of September 2023, we are hosting an exclusive online training session on Zoom, and it’s all about the revolutionary DMSContainer 4.2! DMSContainer, as you may already know, has been a game-changer in the world of software architecture and microservices, expecially for Delphi developers but not only for them.

👉 This article is available also in english. È arrivato il momento! Il 25 settembre 2023 ospiteremo un’esclusiva sessione di formazione online su Zoom, tutta incentrata sul rivoluzionario DMSContainer 4.2! DMSContainer, come forse già saprai, ha rappresentato un punto di svolta nel mondo dell’architettura software e dei microservizi, in particolare per gli sviluppatori Delphi ma non solo per loro.

👉 This article is available in english too. 👉 Questo articolo è disponibile anche in inglese. Introduzione DMVCFramework è il framework REST Delphi più popolare su Github. Viene utilizzato per creare soluzioni Web basate sullo stile RESTful o sul protocollo JSON-RPC (o qualsiasi tipo di “stile” che preferisci). A differenza di molti altri compatitor (sia open source che prodotti commerciali) DMVCFramework raggiunge il Richardson Maturity Model di livello 3 - a.

👉 This article is available also in italian. 👉 Questo articolo è disponibile anche in italiano. Introduction DMVCFramework is the most popular Delphi REST framework. It’s used to build web solution based on RESTful style or JSON-RPC protocol (or any kinds of “style” you prefer). It is a first-class framework; it reach the Richardson Maturity Model level 3 - a.

When it comes to generating auto-incrementing primary keys in PostgreSQL, the choice between “identities” and “serial” types holds significant implications for your database design and performance. In this article, we’ll explore the key differences between these options and outline best practices to help you make informed decisions. Defining Identities and Serial Types Both “identities” and “serial” types serve the purpose of automatically generating unique primary key values.

👉 DelphiMVCFramework 3.4.0-neon is out! Tons of new features, some bug fixes and improvements available. Let’s see what’s new! Yes! Following the promises to have more shorter release cycle for DelphiMVCFramework, after only 5 months of development, more than 40 contributors and lot of commits, DelphiMVCFramework 3.4.0-neon is finally out!

The Active Record design pattern is a popular architectural pattern used to manage and interact with data stored in a database. This pattern provides a straightforward way to encapsulate database records as objects, allowing developers to work with data using object-oriented principles. Active Record: Introduction and first adopters Active Record was introduced by Martin Fowler in his 2003 book “Patterns of Enterprise Application Architecture.

One of my old article about ITDevCon and JSON gets interest month over month. Considering that the informaion explained there are useful but quite old nowadays, I decided to write another article updating the contents available there adding also more details. 🔔 WARNING In this article we are not going to talk about event-driven (sax-style) JSON parsers.

We’re back! ITDevCon, the richest European conference on Delphi and related technologies, is scheduled for October 26th and 27th 2023. ITDevCon will be held at the bit Time group headquarter in Rome! This will be the 12th conference edition and will be organized, as usual, by bit Time Professionals, bit Time Software and our spanish sister Delphi Studio.