From this article, you will learn the difference between working with databases via the ADO technology and the FireDAC library. Using the right database technology is often a critical part of designing your apps, particularly for Windows application development where there is a very rich array of database choices, not all of which may be hosted on a Windows server.
ADO (ActiveX Data Objects) is…
Delphi and C++ developers have a wide spectrum of available tools to help build solutions for their companies and customers. Beyond just the compiler, IDE, components and libraries, Embarcadero and Idera provide tools you can leverage to get development done faster and with…
Hello fellow developers!
We’ve had a terrific week over on LearnCPlusPlus.organd we wanted to share a few glimpses with you here. You can also click on the following link to discover a real treasure-trove of posts in the C++ Category.
LearnCPlusPlus.Org…
The processing of data is the soul of computing. Almost every single computer ever invented was designed so that human beings could take information in the form of data and manipulate it in one way or another, either through visualizations or use it in other ways to make decisions about our lives, work, and future. If data processing is the soul, then the pieces of data itself are the bones we…
HeidiSQL is a wildly successful open source database management tool. Apart from being extremely useful in the management of MySQL, SQL Server, PostgreSQL, and SQLite databases, it is also open-source and that source code is written in Delphi. Furthermore, if we integrate it…
Object Relational Mapping is the idea of being able to write queries using the object-oriented paradigm in your preferred programming language. So this means we are trying to utilize our language to talk with the database instead of using SQL.
Why utilize ORM?
It…
TrapSql is a free software and it is developed in Delphi. According to the developer, “TrapSql lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, MsSql. TrapSql is the perfect backup software. It also features master / detail management and query history. The Master / detail system automatically searches for foreign keys and allows…
The sample shows in a nice way how to use theTFDLocalSQLcomponent to execute SQL commands on in-memory database, represented by several TFDMemTables.
This sample uses aTFDConnectionto connect to the SQLite in-memory database (with…
ThexDBMSsample shows you how use theTFDLocalSQLclass to implement a cross-DBMS query application. To this end, each queryable dataset must be registered with theLocal SQL engineusing theDataSetscollection property.Note: The…
TheAsyncsample shows you how to use theIFDPhysCommandinterface to configure the differentasynchronous execution modes. To this end, the sample uses a group of four radio buttons. Each radio button sets theOptions.ResourceOptions.CmdExecModeproperty of theIFDPhysCommandinterface to one of the following execution…
