PostgreSQL SERIAL or IDENTITY? The Auto-Increment Choice Most Schemas Get Wrong
PostgreSQL IDENTITY or SERIAL for auto-incrementing primary keys? How smallserial, serial and bigserial work, what GENERATED AS IDENTITY changes.
Databases
PostgreSQL
DelphiMVCFramework 3.4.0-neon
DelphiMVCFramework 3.4.0-neon is out after five months and 40+ contributors. What changes in your APIs with functional actions, dotEnv, HTMX and named queries?
DMVCFramework
Premium
Simplify and improve data access code using ActiveRecord design pattern | Video tutorial collection
Delphi ActiveRecord pattern with DMVCFramework's MVCActiveRecord: where the pattern comes from, key features, ten mapping examples and the Patreon video series.
DMVCFramework
Design Patterns
Premium
JSON support in Delphi, a simple example (refresh)
JSON support in Delphi with TJSONObject and TJSONArray: what JSON is, the built-in classes, when a third-party parser makes sense, and web APIs that speak JSON.
Delphi
Programming
Programming
ITDevCon 2023 - The Delphi European Conference
ITDevCon 2023, the Delphi European conference, is on October 26-27 in Rome. The call for papers is open until September 30: what to send, topics and audience.
Events
Speaking at the International Pascal Congress in Salamanca (Spain)
International Pascal Congress 2023 in Salamanca, Spain, 3 to 7 July: I speak in the plenary keynotes with Marco Cantù, Primoz Gabrijelcic and others.
Events
Pascal
How To Generate Random Data in PostgreSQL
PostgreSQL random data: how do you generate random numbers, integers in a range, random timestamps and whole sequences with random() and generate_series?
Databases
My Top 3+1 features in the new RAD Studio 11.3 Alexandria
Delphi 11.3 Alexandria: matching-word highlighting, ToolsAPI access to the code editor, the TBiometricAuth component, and faster FireDAC on PostgreSQL.
Delphi
Programming
My Speeches at ITDevCon 2022
My three talks at ITDevCon 2022 in Rome: Python4Delphi from zero to hero, what is cooking in DMVCFramework, and DMSContainer for users and licenses.
Events
My Top 3+1 features in the new RAD Studio 11.2 Alexandria
Delphi 11.2 Alexandria: LLDB debugging on Linux64, Markdown preview in the code editor, inactive code greyed out, and better editor tabs. My top 3+1.
Delphi
Programming