fcl-db
The package fcl-db contains most of FPC's higher level database system, plus table drivers for some popular systems. (<LAZDIR>/fpc/3.0.0/source/packages/fcl-db)
Known issues/shortcomings
- Master - detail relations are not complete; however you can implement it using MasterDetail
- Calculated field support is not complete
- No binary data transfer using parameters (everything is converted to ASCII) in most drivers.
- There are some floating point issues, with precision and scale parameters only minimally supported in some drivers (amongst others mysql)
- Most character encoding issues are solved fairly ad hoc. There is no way to set the fundamental encodings manually:
- the encoding of the connection
- the encoding of the components' internal storage
- the encoding of GUI components
- (optionally, encoding of exports, or fileformats)
- Many driver dependent issues in datetime types and timezone support.
- Between the drivers, Firebird is used the most, then Mysql, SQLite, PostgreSQL and ODBC. Finally comes Oracle which is mostly still at a proof of concept level. The Microsoft SQL Server and Sybase ASE drivers are a recent addition to FPC (2.6.1 and higher) and Lazarus.
- Before FPC 2.6: no stored procedure resultset >1 row
Most of these are being worked on, and the status changes on a regular basis, so be sure to do your own testing and source inspection, since this will be most certainly out of date.
A testsuite exists (test/testresult-db) and is expanded when new bugs and functionality occur.
Units
(In the below table the subdirectory is listed as "submodule", so one can see easily to which subsystem the unit belongs.
| Unit | submodule | comment |
|---|---|---|
| browseds | sqlite | |
| bufdataset | base | In memory dataset. More capable than memds. See TBufDataSet for some usage examples |
| bufdataset parser | base | |
| concurrencyds | sqlite | |
| createds | sqlite | |
| customsqliteds | sqlite | |
| db | base | |
| dbcoll | base | |
| dbconst | base | |
| dbf | dbase | TDBF components for DBase/FoxPro/Visual Foxpro tables (upstream code: Sourceforge TDBF project). See also Lazarus Tdbf Tutorial |
| dbf avl | dbase | |
| dbf collate | dbase | |
| dbf common | dbase | |
| dbf cursor | dbase | |
| dbf dbffile | dbase | |
| dbf fields | dbase | |
| dbf idxcur | dbase | |
| dbf idxfile | dbase | |
| dbf lang | dbase | |
| dbf memo | dbase | |
| dbf parser | dbase | |
| dbf pgcfile | dbase | |
| dbf pgfile | dbase | |
| dbf prscore | dbase | |
| dbf prsdef | dbase | |
| dbf prssupp | dbase | |
| dbf reg | dbase | |
| dbf str | dbase | |
| dbf str es | dbase | |
| dbf str fr | dbase | |
| dbf str ita | dbase | |
| dbf str nl | dbase | |
| dbf str pl | dbase | |
| dbf str pt | dbase | |
| dbf str ru | dbase | |
| dbf wtil | dbase | |
| dblib | Wrapper around FreeTDS; required for the mssqlconn SQLDB driver for Microsoft SQL Server and Sybase ASE | |
| dbwhtml | base | |
| fillds | sqlite | |
| fpcgcreatedbf | codegen | |
| fpcgdbcoll | codegen | |
| fpcgsqlconst | codegen | |
| fpcgtiopf | codegen | |
| fpcsvexport | export | |
| fpdatadict | datadict | |
| fpdbexport | export | See the dbftool example included in FPC 2.7.1+: creating, using DBF files and exporting data using db export. Also used in the Lazarus db export component. |
| fpdbfexport | export | |
| fpddcodegen | codegen | |
| fpdddbf | datadict | |
| fpdddiff | datadict | |
| fpddfb | datadict | |
| fpddmysql40 | datadict | |
| fpddmysql41 | datadict | |
| fpddmysql50 | datadict | |
| fpddodbc | datadict | |
| fpddoracle | datadict | |
| fpddpopcode | codegen | |
| fpddpq | datadict | |
| fpddregstd | datadict | |
| fpddsqldb | datadict | |
| fpddsqlite3 | datadict | |
| fpfixedexport | export | Dataset export to fixed width text format |
| fprtfexport | export | Dataset export to RTF format |
| fpsimplejsonexport | export | Dataset export to JSON format |
| fpsimplexmlexport | export | Dataset export to ASCII encoded XML |
| fpsqlexport | export | Dataset export to SQL Insert/Update statements |
| fpstdexports | export | |
| fptexexport | export | Dataset export to Latex format |
| fpXMLXSDExport | export | Dataset export to various XML formats: Access, ADO.Net, Excel, Delphi ClientDataset |
| ibconnection | sqldb/interbase | |
| memds | memds | In memory dataset. Not as capable as bufdataset. See How to write in-memory database applications in Lazarus for some usage examples |
| mssqlconn | sqldb/mssqlconn | Microsoft SQL Server and Sybase ASE drivers, introduced in FPC 2.6.1. Requires dblib. |
| mysql40conn | sqldb/mysql | Connector for MySQL server using MySQL 4.0 client library |
| mysql41conn | sqldb/mysql | Connector for MySQL server using MySQL 4.1 client library |
| mysql4conn | sqldb/mysql | Connector for MySQL server using MySQL 4?? client library |
| mysql50conn | sqldb/mysql | Connector for MySQL server using MySQL 5.0 client library |
| mysql51conn | sqldb/mysql | Connector for MySQL server using MySQL 5.1 client library |
| mysql55conn | sqldb/mysql | Connector for MySQL server using MySQL 5.5 client library |
| odbcconn | sqldb/odbc | Connector for ODBC databases (e.g. Microsoft Access, DB2) |
| oracleconnection | sqldb/oracle | Connector for Oracle (XE) databases |
| pqconnection | sqldb/postgres | Connector for PostgreSQL databases |
| sqlite3conn | sqldb/sqlite | |
| paradox | paradox | |
| sdfdata | sdf | CSV dataset support |
| sqldb | sqldb | |
| sqlite3ds | sqlite | |
| sqliteds | sqlite | |
| sqlscript | base | SQL scripting component that lets you run multiple SQL statement as a batch. Has support for Firebird SET TERM. See example in Lazarus examples/database/tsqlscript and Firebird#Creating_objects_programmatically |
| tdbf l | dbase | |
| testcp | memds | |
| testdbf | dbase | |
| testds | sqlite | |
| testfix | sdf | |
| testld | memds | |
| testopen | memds | |
| testpop | memds | |
| testsdf | sdf | |
| testsqldb | sqldb | |
| xmldatapacketreader | base | |
| fpjsondataset | json | Dataset for JSON data |
See also
From the Free Pascal wiki, page "fcl-db", as it stood on 2021-04-01 after a change by Socke, out of the wiki's dump of 2024-05-26. Copyright stays with the author who wrote it, according to the old wiki's Licensing page. If you have concerns about this material, message the admin.
Talk about this page
Nobody has opened a bench for this page yet. Sign in to open one.