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…
There are a huge number of Windows App Development tools available on the market. However, not all of them can boost productivity effectively. So, choosing the right one can be tricky. In this post, you will find 7 of my favorite desktop software development tools. They have…
Data ETL: Adding Custom LiveBindings To Your Apps
May 31, 2021
In the recent Data ETL focused TCoffeeAndCode episode there was some excellent discussion around the use of FireDAC to extract and manipulate data in various ways. In this article, you’ll get through what Data ETL is, what is LiveBindings, using Live Bindings with an IDE…
Connecting Databases with FireDAC through SSH
April 22, 2021
A customer recently inquired whether FireDAC could be used to connect to a database via an SSH tunnel. Of course, the short answer is yes. But first, let’s define an SSH tunnel and how it can be easily accomplished with Delphi and FireDAC.
SSH Tunnels
Secure Shell (ssh) is a standard tool that comes with most “network” operating systems, such as Windows. Linux, UNIX, macOS, and…
Learn How Easy It Is To Map Dataset Columns With A Table Adapter In FireDAC For Delphi
March 6, 2021
TheCommandssample shows you how to set up column mappings.
Location
You can find theMappingColumnssample project at:
Start | Programs | Embarcadero RAD Studio Sydney | Samplesand then navigate to: Object PascalDatabaseFireDACSamplesDApt…
Robust DataSet To JSON And JSON To DataSet API For Delphi
February 12, 2021
Most of the time, developers tend to use DataSet to manipulate the data in their applications. DataSet is helpful because it stores data in the dataset’s fields array property. You can easily access these values by number or by name. Moreover, each field can be used to…
Flexible InterBase AdminUtility Sample Tours You Through Powerful InterBase Features
February 11, 2021
The sample also admits authentication.
Apart from the parameters to connect to an InterBase server, the sample has four tabs to perform administrative tasks:
Server UsersTab:
ClickRefresh Usersto get all the users from the InterBase server.
BackupTab:
Use this tab to backup a database. Introduce theDatabase Pathto specify the InterBase database and…
Learn How To Migrate dbExpress To FireDAC With The reFind Tool In This Delphi Sample
February 7, 2021
This sample project demonstrates how to migrate the projectMeetingOrganizerfrom dbExpress to FireDAC using the reFind.exe tool.
Location
You can find theDBX2FDMigrationproject at:
Start | Programs | Embarcadero RAD Studio Sydney |…
Escape sequences allow for writing DBMS-independent SQL commands. The sample predefines some escape function sequences. To execute a predefined escape function, right-click the Function edit box and choose a predefined escape function from the popup menu. Moreover, the…
FireDAC Tip: Learn How to Manage Centralized Cached Updates With This Schema Adapter Sample
February 4, 2021
The FireDAC.SchemaAdapterMemTable Sample uses some methods and properties ofTFDSchemaAdapterin order to implement some features related with the management ofCentralized Cached Updates.
Location
You can find theSchemaAdapterMemTablesample project at:
Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to: Object…