What You Need To Know About Databases, Data Access, and Object Relational Mapping in Delphi

TCoffee and Code is back with another interesting set of topics. As described by Ian Barker in this video, “TCoffee and Code is more than just a virtual meeting but more of a group learning experience for everyone involved“. Joining host Ian Barker in this two-hour-long session are his fellow Embarcadero MVPs Holger Flick, and Wagner Landgraf as well as Jim McKeeth to share everything we need to know about databases, data access, and object-relational mapping (ORM).

What are the best practices for using databases and database access for Delphi?

The session starts with a brief introduction to databases and also highlights the notable differences between RDBMS (Relational Database Management System) and NoSQL (a distributed database) as well as prominent samples of these aforementioned databases. Interestingly, we will also get to know more about different database access for Delphi and windows apps studio including the native ones such as FireDAC, dbExpress, ADO, and InterBase Express. The panel will also discuss third-party Delphi database access such as UniDAC, TMS RemoteDB, and many more.

What is ORM and how can we use ORM in Delphi?

Finally, we will also learn more about Object Relational Mapping (ORM) in Delphi particularly the use of TMS Aurelius and the application of its basic features. Discover why TMS Aurelius is described as a state-of-the-art ORM for Delphi, the notable advantages of this framework as well as its limitations.

The session will also share with us some details about the REST Client Library and will give us an overview of the RAD Server Architecture and how to create a cross-platform ecosystem with FireMonkey. The video will also introduce us to the HeidiSQL tool and how it works well with MySQL and other relational databases. Feel free to watch this TCoffee and Code session below to learn more.