DbExpress

DbExpress is a database developed by Borland interface ( for Delphi 6 ) and C Builder is in developing tools Borland Delphi available.

This interface is based on own drivers and is quite fast, but provides only unidirectional access. This means that you can only call in one direction data in a dataset, which has been obtained from the database. " Walking backwards " is not provided. This makes the amount of data easier and more slender. Updates must then via simple, supplied and included in the IDE components such as " DataSetProvider " ( of the proper update statement automatically assembles in SQL) are added.

Drivers are included for many common databases ( depending on the edition of the development tools more or less), but there are also drivers for a number of databases that are not directly supported by Borland. An ODBC → dbExpress driver is also available.

Previously, dbExpress driver is generally not used but were capable Unicode ANSI encoded strings. From Delphi 2006 some of the drivers have been converted to Unicode and Delphi since 2009, most drivers supplied fully Unicode capable, as well as Delphi has been changed with this version of Unicode.

Bundled drivers:

  • InterBase ( Embarcadero 's own database product)
  • MySQL
  • Oracle
  • DB / 2
  • Informix
  • SQL Server
  • Sybase Adaptive Server
  • Firebird (since Delphi 2010 from Enterprise Edition)
  • SQLite (since at least Delphi XE3 )
  • ODBC bridge driver (since Delphi XE2 from Enterprise Edition)
  • Trace driver to log the session of remote Datenbanstatements, from Delphi 2007 (from dbExpress 4)

Other well-known third-party drivers:

  • SQLite
  • Maxdb (formerly SAPdb )
  • Firebird
  • DbExpress ODBC →
  • Mimer
  • PostgreSQL ( pgExpress, Zeos Library)
  • Library (programming)
  • Database interface
Embarcadero Delphi Oracle Corporation IBM Informix Firebird (database server)
223556
de