'ZEOS TZQuery' vs 'FPC TSQLQuery' database component
lazarus / 16-Databases

----------------------------------------------------------------------
vladvons · 2013-09-17 06:11

Im moved from Delphi to Lazarus to write cross platform open source DB
application based on Postgres engine.
Early I used MySQL + UniDAC component under delphi.
Now i need your advice which component to use under Lazarus: TSQLQuery
or TZQuery?

lets take into account following values:
- documentation, examples
- future prospects, updates, supports
- reliability
- speed

my first impressio (IMHO)
ZEOS (-)
- simple EXE application size 18mb enlarged vs TSQLQuery (38-20=18mb)
- no documentation

ZEOS (+)
TZPgEventAlerter, TZSQLMetadata, TZSQLMonitor

----------------------------------------------------------------------
BigChimp · 2013-09-17 06:21

Quote from: vladvons on September 17, 2013, 08:11:05 amZEOS (+)
TZPgEventAlerter, TZSQLMetadata
FPC has both Postgresql and Firebird units for event monitoring
(TFBEventMonitor, TPQTEventMonitor) that work with sqldb. See the
sqldb tab in Lazarus.
SQLDB in FPC trunk has enhanced metadata retrieval functionality built
in (see the connection object); SQLDB in FPC 2.6.2 already has some,
as well.

----------------------------------------------------------------------
marcov · 2013-09-17 08:12

(2.6.3 is roughly the state of trunk of  august 22th, when the
bufdataset format was bumped)

----------------------------------------------------------------------
BigChimp · 2013-09-17 08:29

Quote from: marcov on September 17, 2013, 10:12:04 am(2.6.3 is roughly
the state of trunk of  august 22th, when the bufdataset format was
bumped)
You mean the metadata improvements are in fixes 2.6? Yes, that would
be a plus although the OP would then need to build FPC+Laz himself
rather than use downloaded versions. I've heard though that there is a
tool available for that

----------------------------------------------------------------------
vladvons · 2013-09-17 18:21

nevertheless FPC has very poor metadata information in TPQConnection
component.
PQConnection.GetFieldNames, PQConnection.GetTableNames, 
PQConnection.GetProcedureNames

How to get detailed column information without writing direct query
'SELECT FROM pg_...' to get additional data like a ColumnTYPE,
ColumnLENGTH, etc ?
How to get ForeignKey list?
How to get Indexes list?

----------------------------------------------------------------------
LacaK · 2013-09-18 04:14

Quote from: vladvons on September 17, 2013, 08:21:11 pmnevertheless
FPC has very poor metadata information in TPQConnection component.
PQConnection.GetFieldNames, PQConnection.GetTableNames, 
PQConnection.GetProcedureNames

How to get detailed column information without writing direct query
'SELECT FROM pg_...' to get additional data like a ColumnTYPE,
ColumnLENGTH, etc ?
support must be added

----------------------------------------------------------------------
BigChimp · 2013-09-18 05:52

Quote from: LacaK on September 18, 2013, 06:14:53 amsupport must be
added
... patches welcome.