Recent

Author Topic: 'ZEOS TZQuery' vs 'FPC TSQLQuery' database component  (Read 5591 times)

vladvons

  • Jr. Member
  • **
  • Posts: 65
'ZEOS TZQuery' vs 'FPC TSQLQuery' database component
« on: September 17, 2013, 08:11:05 am »
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
 
« Last Edit: September 17, 2013, 08:43:30 pm by vladvons »
Windows 7, Ubuntu 12.04, Lazarus 1.2.2, FPC 2.6.4, PostgreSQL 9.2

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: 'ZEOS TZQuery' vs 'FPC TSQLQuery' database component
« Reply #1 on: September 17, 2013, 08:21:54 am »
ZEOS (+)
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.
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

marcov

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 8793
  • FPC developer.
Re: 'ZEOS TZQuery' vs 'FPC TSQLQuery' database component
« Reply #2 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)
« Last Edit: September 17, 2013, 10:15:00 am by marcov »

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: 'ZEOS TZQuery' vs 'FPC TSQLQuery' database component
« Reply #3 on: September 17, 2013, 10:29:51 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 ;)
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

vladvons

  • Jr. Member
  • **
  • Posts: 65
Re: 'ZEOS TZQuery' vs 'FPC TSQLQuery' database component
« Reply #4 on: September 17, 2013, 08:21:11 pm »
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?
Windows 7, Ubuntu 12.04, Lazarus 1.2.2, FPC 2.6.4, PostgreSQL 9.2

LacaK

  • Hero Member
  • *****
  • Posts: 605
Re: 'ZEOS TZQuery' vs 'FPC TSQLQuery' database component
« Reply #5 on: September 18, 2013, 06:14:53 am »
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 ?
support must be added


BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: 'ZEOS TZQuery' vs 'FPC TSQLQuery' database component
« Reply #6 on: September 18, 2013, 07:52:33 am »
support must be added
... patches welcome.
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

 

TinyPortal © 2005-2018