imported>FatalFit: Reverted edits by 186.248.219.51 (talk) to last revision by I dream of horses: nonconstructive edits

2023-05-18T17:51:17Z

Reverted edits by 186.248.219.51 (talk) to last revision by I dream of horses: nonconstructive edits

New page

{{More citations needed|date=October 2021}}
'''Borland Database Engine''' ('''BDE''') is the [[Microsoft Windows|Windows]]-based core [[database engine]] and connectivity software behind [[Borland Delphi]], [[C++Builder]], IntraBuilder, [[Corel Paradox|Paradox]] for Windows, and Visual dBASE for Windows.

==History==
Borland’s [[Turbo Pascal]] had a "database" Toolbox add-on, which was the beginning of the Borland compiler add-ons that facilitated database connectivity. Then came the Paradox Engine for Windows – PXENGWIN – which could be compiled into a program to facilitate connectivity to Paradox tables.

The first DLL-based connectivity engine was '''ODAPI''' (Open Database API). It represented Borland’s attempt to centralise connectivity in its suite of applications that included the brand-new Paradox for Windows 4 and Quattro. With version 4.5 / 5.0 of Paradox for Windows, this database engine was crystallised as [[IDAPI]].

In 2000, Borland introduced a new SQL driver architecture called [[dbExpress]], which deprecated BDE SQL links technology.

In 2014, Embarcadero removed the BDE installer from its Rad Studio XE7 install, making it a separate download in order to strengthen the message that the BDE has been deprecated for a number of years. Programmers using the BDE are encouraged to update their software to use newer database connectivity technologies like Embarcadero's FireDAC, or third-party-provided solutions.

Replacements for BDE include:
*DBISAM from Elevate Software<ref>{{cite web |title=DBISAM - Everywhere, yet seldom seen |url=https://www.elevatesoft.com/products?category=dbisam |website=Elevate Software |access-date=2021-10-11}}</ref>
*Absolute Database from ComponentAce<ref>{{cite web |title=BDE Replacement, single-file Delphi embedded database Absolute Database |url=https://www.componentace.com/bde_replacement_database_delphi_absolute_database.htm |website=ComponentAce |access-date=2021-10-11}}</ref>
* BDE eXpress by Dr. Erhard Regener: a compatible API that uses [[dBase]] or [[Paradox (database)|Paradox]].<ref>{{cite web |title=BDE eXpress for Windows 8 / 7 / Vista |url=http://www.drregener.com/en/bde7.php |website=DrRegener.com |access-date=2021-10-11}}</ref>

==Design==
The included set of database drivers enables consistent access to standard data sources: [[Corel Paradox|Paradox]], [[dBASE]], [[FoxPro]], [[Microsoft Access|Access]], and text databases. You can add Microsoft [[ODBC]] drivers as needed to the built-in ODBC socket. Optionally, Borland's SQL Links product provides access to a range of [[database management system]]s (DBMS), including [[Informix]], [[IBM Db2]], [[InterBase]], [[Oracle database|Oracle]], and [[Sybase]].

BDE is [[object-oriented]] in design. At runtime, application developers interact with BDE by creating various BDE objects. These runtime objects are then used to manipulate database entities, such as [[database table|tables]] and [[SQL query|queries]]. BDE's application program interface ([[API]]) provides direct [[C (programming language)|C]] and C++ optimized access to the database engine, as well as BDE's built-in drivers for dBASE, Paradox, FoxPro, Access, and text databases.

The core database engine files consist of a set of [[Dynamic-link library|DLLs]] that are fully [[Reentrant (subroutine)|re-entrant]] and [[thread-safe]]. Included with BDE are a set of supplemental tools and examples with sample code.

BDE system is configured using the BDE Administrator (BDEADMIN.EXE).

Included with BDE is Borland's Local SQL, a subset of [[ANSI-92]] [[SQL]] enhanced to support Paradox and dBASE (standard) naming conventions for tables and fields (called "columns" in SQL). Local SQL lets you use SQL to query "local" standard database tables that do not reside on a database server as well as "remote" DBMS servers. Local SQL is also essential to make multi-table queries across both local standard tables and those on remote SQL servers.

The older name for the BDE API is the "Integrated Database Application Program Interface" or "IDAPI".

==References==
<references/>

[[Category:Borland software]]
[[Category:Database engines]]
[[Category:Proprietary database management systems]]

Borland Database Engine - Revision history

imported>FatalFit: Reverted edits by 186.248.219.51 (talk) to last revision by I dream of horses: nonconstructive edits