{"id":7191,"date":"2020-05-22T08:05:43","date_gmt":"2020-05-22T08:05:43","guid":{"rendered":"https:\/\/www.barnsten.com\/?p=7191"},"modified":"2020-05-22T08:05:43","modified_gmt":"2020-05-22T08:05:43","slug":"erste-schritte-mit-interbase-fur-rad-studio-entwickler","status":"publish","type":"post","link":"https:\/\/www.barnsten.com\/de\/getting-started-with-interbase-for-rad-studio-developers\/","title":{"rendered":"Erste Schritte mit InterBase f\u00fcr RAD Studio-Entwickler"},"content":{"rendered":"

Most, if not all, of your applications will connect to some database backend.\u00a0 For Delphi and C++Builder users, most have either used it previously or have heard of it. InterBase is a zero admin, small footprint database engine that offers enterprise grade database capabilities like\u00a0granular transparent database encryption, powerful access control, point-in-time recovery and patented data change tracking.\u00a0It\u2019s the database running\u00a0across a range of industries, from POS systems to medical laboratories and CRM to railway systems.<\/p>\n

In fact, even RAD Server uses an InterBase database for the storage of user information, user groups, analytics, registered devices, version information, registered Edge Modules, push notification messages and more. So why not see if it can further your development efforts. What\u2019s to lose? It\u2019s included in your RAD Studio license.<\/p>\n

How do I use InterBase as a RAD Developer?<\/h2>\n

All versions of RAD Studio\/Delphi\/C++Builder come with support for InterBase 2020 databases.\u00a0InterBase 2020 is installed with RAD Studio in the following directory: C:\\Program Files (x86)\\Embarcadero\\Studio\\20.0\\InterBase2020<\/p>\n

Installing and Starting the InterBase Server<\/h3>\n

In the additional options of the web installer for RAD Studio, check and install the InterBase Developer Edition and InterBase Express Components.<\/p>\n

InterBase 2020 Developer Edition<\/b>\u00a0is installed with RAD Studio, Delphi or C++Builder and is in the RAD Studio integrated license.\"<\/p>\n

Choose\u00a0Start | Programs | Embarcadero InterBase 2020 | 64-bit\/32-bit instance = gds_db | InterBase Server Manager [instance = gds_db]<\/b><\/p>\n

On the\u00a0InterBase 2020 64 Server Manager<\/b>, start the InterBase server if it is not running\"<\/p>\n

Connecting to InterBase<\/h2>\n

Connecting to the server and database will require entering the host, port, database user and password. InterBase databases are defaulted to the port 3050 or 3051 and\u00a0provide the default system administrator user,\u00a0SYSDBA<\/b>\u00a0(not case-sensitive) with a password of\u00a0masterkey<\/b>\u00a0(all lowercase). Note: It is recommended that you change the SYSDBA password for improved security.<\/p>\n

IBConsole<\/h2>\n

IBConsole is a simple, yet powerful and complete system for managing InterBase servers and databases. IBConsole lets you look into the details of the database structure, query the data, backup and restore the database, and perform any other admin tasks.\u00a0 For more on what IBConsole can do,\u00a0click here<\/a><\/p>\n

\"<\/p>\n

Command Line isql tool<\/h2>\n

The command-line\u00a0isql\u00a0is a utility for processing SQL data definition (DDL) and data manipulation (DML) statements from interactive input or from a source file. It enables you to create and view metadata, add and modify data, grant user permissions, test queries, and perform database administration tasks. For more on invoking isql,\u00a0click here<\/a>.<\/p>\n

Developing Database Applications<\/h2>\n

Delphi includes many components for accessing databases and representing the information they contain. They are typically grouped by their access mechanism. The two recommended data access components are:<\/p>\n

FireDAC<\/a><\/p>\n

FireDAC is the set of standard data-access and data-aware visual components for developing with various database systems including InterBase. FireDAC is designed to deal with real-world high load applications and enables the developer to concentrate on developing the application, not on the complexities of database interaction<\/p>\n

InterBase Express<\/a><\/p>\n

InterBase Express components or IBX, is a set of custom data aware components and controls that allow you to connect to and access data from InterBase servers and databases.\u00a0Applications built using IBX components should work better and faster (even if only marginally), giving you more control over the specific features of the server.\u00a0\u00a0The components are broken down into two sections, the IBX Dataset components and Administrative Components.<\/p>\n

Using IBLite and InterBase ToGo<\/h2>\n

Included with your RAD Studio license is either an IBLite or IBToGo license. The chart below show which version is included:<\/p>\n

\"<\/p>\n

IBLite and InterBase ToGo are a database engine that can be embedded in an application directly by using the InterBase database engine library. They do not have to be installed on any server or end-user workstation, and do not require that InterBase be installed on a machine before it is used (as InterBase Server and InterBase Desktop do).<\/p>\n

If you are\u00a0 targeting database application deployment to Mobile (iOS and Android) OS platforms, you can deploy either with a “ToGo” license, or “IBLite” license.<\/p>\n

InterBase ToGo is one of the best (and few) choices available for iOS, Android, Windows, and macOS applications that need to move data storage offline to:<\/p>\n