Difference between revisions of "fcl-db"

From Lazarus wiki
Jump to navigationJump to search
Line 7: Line 7:
 
* No stored procedure resultset >1 row
 
* No stored procedure resultset >1 row
 
* No binary data transfer using parameters (everything is converted to ascii) in most drivers.
 
* No binary data transfer using parameters (everything is converted to ascii) in most drivers.
 +
* most character encoding issues are solved fairly ad hoc. There is no way to manually set the encoding of the connection
 +
    and what the classes public methods return.
 +
* Many driver dependant issues in datetime types and timezone support.
 +
 +
Most of these are being worked on, and the status changes on a monthly basis. A testsuite is also being created that hopefully will accelerate accepting patches. (and make it easier for contributors to create quality patches)
  
 
== Units ==
 
== Units ==

Revision as of 18:27, 27 July 2011

The package FCL-db contains most of FPC's higher level database system, plus table drivers for some popular systems.

Known issues/shortcomings

  • master - detail relations are not complete
  • calculated field support are not complete
  • No stored procedure resultset >1 row
  • No binary data transfer using parameters (everything is converted to ascii) in most drivers.
  • most character encoding issues are solved fairly ad hoc. There is no way to manually set the encoding of the connection
   and what the classes public methods return.
  • Many driver dependant issues in datetime types and timezone support.

Most of these are being worked on, and the status changes on a monthly basis. A testsuite is also being created that hopefully will accelerate accepting patches. (and make it easier for contributors to create quality patches)

Units

(In the below table the subdir is listed as "submodule", so one can see easily to which subsystem the unit belongs.

Unit submodule comment
browseds sqlite
bufdataset base
bufdataset_parser base
concurrencyds sqlite
createds sqlite
customsqliteds sqlite
db base
dbcoll base
dbconst base
dbf dbase
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
dbwhtml base
fillds sqlite
fpcgcreatedbf codegen
fpcgdbcoll codegen
fpcgsqlconst codegen
fpcgtiopf codegen
fpcsvexport export
fpdatadict datadict
fpdbexport export
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
fprtfexport export
fpsimplejsonexport export
fpsimplexmlexport export
fpsqlexport export
fpstdexports export
fptexexport export
ibconnection sqldb/interbase
memds memds
mysql40conn sqldb/mysql
mysql41conn sqldb/mysql
mysql4conn sqldb/mysql
mysql50conn sqldb/mysql
odbcconn sqldb/odbc
oracleconnection sqldb/oracle
paradox paradox
pqconnection sqldb/postgres
sdfdata sdf
sqldb sqldb
sqlite3conn sqldb/sqlite
sqlite3ds sqlite
sqliteds sqlite
sqlscript base
tdbf_l dbase
testcp memds
testdbf dbase
testds sqlite
testfix sdf
testld memds
testopen memds
testpop memds
testsdf sdf
testsqldb sqldb
xmldatapacketreader base

See also