An Introduction to pg_chameleon: A Flexible Replication System for PostgreSQL
pg_chameleon replicates MySQL into PostgreSQL by reading the binlog. How does it work, how do you configure it in YAML, and where does it fit best?
Databases
MySQL Community Edition and the GPL: Can You Ship It Inside a Commercial Product?
MySQL Community Edition is GPLv2: what that means when you ship a commercial product, the SaaS grey area, missing enterprise features and the alternatives.
Databases
MySQL Community Edition e la GPL: puoi distribuirlo dentro un prodotto commerciale?
MySQL Community Edition è sotto GPLv2: cosa comporta se distribuisci un prodotto commerciale, la zona grigia del SaaS, i limiti e le alternative.
Databases
PostgreSQL as a Job Queue: Do You Really Need Redis or RabbitMQ?
PostgreSQL as a job queue: schema design, FOR UPDATE SKIP LOCKED for concurrency-safe polling, retries and parallel workers, without Redis or RabbitMQ.
Databases
PostgreSQL
Quickstart Guide to Modern Web Apps with DelphiMVCFramework and HTMX (with TemplatePro or WebStencils)
DelphiMVCFramework and HTMX: two quickstart projects, one on TemplatePro and one on WebStencils. Which one fits your Delphi version, and how do you run it?
DMVCFramework
TemplatePro
Web Development
Welcome Back TemplatePro
Why TemplatePro was rewritten as the default template engine of DMVCFramework: what existing engines lacked, its design goals and sample template code.
DMVCFramework
TemplatePro
ITDevCon 2024 - The Delphi European Conference
ITDevCon 2024, the European Delphi conference, is on November 14-15 in Rome. The call for papers is open until September 30: what to send to propose a talk.
Events
Why Avoid Using Blocked Columns on Kanban Boards
Kanban boards: what a Blocked column does to lead time, flow metrics and WiP limits, and how to block items in place and track the blockers instead.
Programming
Understanding Data Lake and Data Warehouse: Key Differences Explained
Data lake or data warehouse? What each one stores, how they differ on schema, ingestion and usage, and where PostgreSQL fits in both, with real-world examples.
Databases
DMVCFramework: A Comprehensive Introduction kindly requested by the Orange County Delphi User Group
Video introduction to DMVCFramework for the Orange County Delphi User Group: controllers, routing, parameters, responses, Active Record and a JSON-RPC API.
DMVCFramework
Video