Difference between revisions of "Lazarus DB Faq"

From Lazarus wiki
m (PostgreSQL)
(Link to official documentation; removed superfluous info)
Line 2: Line 2:
  
 
== General ==
 
== General ==
 
 
This FAQ covers database programming with Lazarus.
 
This FAQ covers database programming with Lazarus.
  
Line 10: Line 9:
  
 
=== Where can I find database components? ===
 
=== Where can I find database components? ===
 +
At the moment the SQLdb components are part of FPC and Lazarus. They are installed by default in all more or less recent Lazarus versions.
  
At the moment the SQLdb components are part of FPC and Lazarus. They are installed by default in all more or less recent Lazarus versions.
 
 
Manual installation: if you look in the [$LazarusDir]/components you will see a subdirectory SQLdb. Install the sqldblaz.lpk and you will be able to connect to MySQL, Interbase / Firebird, Postgres, MS SQL and Sybase ASE (if you have FPC 2.6.1+), Oracle servers.
 
Manual installation: if you look in the [$LazarusDir]/components you will see a subdirectory SQLdb. Install the sqldblaz.lpk and you will be able to connect to MySQL, Interbase / Firebird, Postgres, MS SQL and Sybase ASE (if you have FPC 2.6.1+), Oracle servers.
 
See [[Install Packages]] for help on installing packages.
 
See [[Install Packages]] for help on installing packages.
 +
 +
=== Supported databases ===
 +
* See [[Lazarus_Database_Overview]] for a list of what databases are supported by SQLDB.
  
 
=== Are there other components? ===
 
=== Are there other components? ===
* See [[Lazarus_Database_Tutorial]] for a list of what databases work with what components.
+
* See [[Lazarus_Database_Overview]] for a list of what databases work with what components.
  
== IB / FB ==
+
=== FPC documentation ===
* Please see [[Firebird_in_action]]
+
The Lazarus visual database controls use FPC database code. Please see [http://www.freepascal.org/docs-html/fcl/sqldb/index.html SQLDB documentation] for more information.
 
 
 
 
== MySQL ==
 
* Please see [[mysql]]
 
 
 
== PostgreSQL ==
 
* Please see [[postgresql]]
 
 
 
== SQLite ==
 
* Please see [[sqlite]]
 
  
 
== See also ==
 
== See also ==
 
 
* [[Databases]]
 
* [[Databases]]
 
* [[Lazarus_Database_Tutorial]]
 
* [[Lazarus_Database_Tutorial]]

Revision as of 11:35, 2 February 2013

Deutsch (de) English (en) español (es) français (fr) italiano (it) 日本語 (ja) português (pt) русский (ru) slovenčina (sk) 中文(中国大陆)‎ (zh_CN)

General

This FAQ covers database programming with Lazarus.

Where can I find more FAQ?

See Lazarus Faq. See also the official website [1].

Where can I find database components?

At the moment the SQLdb components are part of FPC and Lazarus. They are installed by default in all more or less recent Lazarus versions.

Manual installation: if you look in the [$LazarusDir]/components you will see a subdirectory SQLdb. Install the sqldblaz.lpk and you will be able to connect to MySQL, Interbase / Firebird, Postgres, MS SQL and Sybase ASE (if you have FPC 2.6.1+), Oracle servers. See Install Packages for help on installing packages.

Supported databases

Are there other components?

FPC documentation

The Lazarus visual database controls use FPC database code. Please see SQLDB documentation for more information.

See also