Fast and Simple Database App Development and Deployment to Linux in RAD Studio

The Devart company released UniDAC with support for Linux 64-bit platform. UniDAC makes application development and maintenance easier and simpler because the use of the Direct mode in a custom application does not require the installation of client libraries, additional drivers, etc. This helps to avoid the overhead when accessing a DBMS, hence increasing performance.

So, in this article, we will demonstrate the capability of UniDAC to establish a connection to various DBMSs in the Direct mode:

  • ASE
  • DBF
  • MongoDB
  • MySQL
  • Oracle
  • PostgreSQL
  • SQLite
  • SQL Azure
  • SQL Server

Creating a console application

Let’s create a new UniDAC application for Linux 64-bit in RAD Studio 10.2 Tokyo.

Go to File on the main menu, click New, then click Other

In the appeared dialog box, click Console Application.

Configuring UniDAC to connect in the Direct mode

To use UniDAC in a console application, you should add the Uni unit in the uses section, as well as the unit with the UniDAC provider for each DBMS. Let’s add providers for all DBMSs which are mentioned at the beginning of the article:

Creating connection and dataset instances, as well as executing SQL queries and data fetching are similar for all UniDAC providers:

Establishing connection and data fetching in the Direct mode

The Deployment tab contains only the application file – there are no additional libraries or files:

Delphi-code for ASE:

ASE execution result:

Delphi-code for DBF:

DBF execution result:

dbf

Delphi-code for MongoDB:

MongoDB execution result:

mongodb

Delphi-code for MySQL:

MySQL execution result:

Delphi-code for Oracle:

Oracle execution result:

Delphi-code for PostgreSQL

PostgreSQL execution result:

Delphi-code for SQLite:

SQLite execution result:

Delphi-code for SQL Azure:

SQL Azure execution result:

Delphi-code for SQL Server:

SQL Server execution result:

sqlserver

Here is the complete project source code: UniDAC_Linux

Conclusion

In this article, we showed how easily and simply you can create applications for Linux without deploying additional files, client libraries or drivers. For this, you only need to install UniDAC, write a few code lines, and the application to work with databases on Linux is complete.

4 Responses to “Fast and Simple Database App Development and Deployment to Linux in RAD Studio”

  1. Peter Edwards Says:

    When you refer to DBF – does that mean dbase compatible files ?

    Thanks

  2. DAC Team Says:

    Hello, Peter!
    Thank you for the comment. The list of supported DBF formats you can find by the link: https://www.devart.com/unidac/compatibility.html

  3. Kerbadou Ghazali Says:

    Hi,
    thanks for great products!,
    where can we found our PostgreSQL dabase located in Windows 7?

  4. DAC Team Says:

    Hello, Kerbadou!
    The question about DB administration is not related to UniDAC functionality. Please contact your DB administrator or PostgreSQL provider to get an answer to this question.

Leave a Comment