CodeDatabaseDelphiRAD Studio

6 Easy Ways to Connect to the Top Databases You Should Know

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…
Read more
DatabaseDelphiNews

Connecting Databases with FireDAC through SSH

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…
Read more
CodeDatabaseDelphiRAD Studio

Flexible InterBase AdminUtility Sample Tours You Through Powerful InterBase Features

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…
Read more
CodeDatabaseDelphiRAD Studio

FireDAC Tip: Learn How to Manage Centralized Cached Updates With This Schema Adapter Sample

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…
Read more