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โฆ
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โฆ
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โฆ
