Recent

Author Topic: Difference of SQLdb and Zeos  (Read 20973 times)

JD

  • Hero Member
  • *****
  • Posts: 1822
Re: Difference of SQLdb and Zeos
« Reply #15 on: December 17, 2010, 02:58:57 pm »
SQLdb also supports many databases protocols: Firebird/Interbase, MySQL, SQLite3, PostgreSQL, Oracle & has ODBC support.

But Zeos supports all that (except ODBC AFAIK) & even more.  :D
Windows (10), Linux Mint - Lazarus 2.1/FPC 3.2, Delphi

Indy 10.6 series; mORMot; Zeos 7.3; SQLite, Firebird, PostgreSQL & MariaDB; VirtualTreeView 5.5.3 R1

Dibo

  • Hero Member
  • *****
  • Posts: 1048
Re: Difference of SQLdb and Zeos
« Reply #16 on: December 17, 2010, 03:59:23 pm »
And I remember, ZEOS probably have component specialy for FireBird Events

marcov

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 9081
  • FPC developer.
Re: Difference of SQLdb and Zeos
« Reply #17 on: December 17, 2010, 06:17:15 pm »
I think major diference is that ZEOS have support for multiple database types. Company can write base framework on ZEOS and is not restricted to only one database. If client have MSSQL, they just switch ZEOS "Protocol" property to MSSQL, if client want Oracle, they switch to Oracle protocol and so on. Of course, this dosn't solve problems with SQL syntax.

Interesting, you got this to work with Lazarus? Afaik OLEDB is not supported with Lazarus.

Dibo

  • Hero Member
  • *****
  • Posts: 1048
Re: Difference of SQLdb and Zeos
« Reply #18 on: December 17, 2010, 07:24:33 pm »
No, this was only example of ZEOS idea :D

xenblaise

  • Sr. Member
  • ****
  • Posts: 358
Re: Difference of SQLdb and Zeos
« Reply #19 on: December 21, 2010, 08:28:21 pm »
I think sqlDb and Zeos differ in properties

I have NOT use Zeos, But if Zeos has a feature of
Quote
you don't to change anything in your configuration property if you want to switch from mysql to mssql or sqlite or msaccess connection, then bravo, the best.

using sqlDb has to change some properties if using different data models or sql connection.

eq.,
if wanna use mysql, we have to do like this;
mysqldbconnection._the_Here_property_not_in_msSQL_or_MsSQLite := ? then its normal

but if Zeos has;
mysqldbconnection._the__Here_property_iS_the_same_with_msSQL_or_MsSQLite := ? then the best. ( i doubt is not like this)

 :D

 

TinyPortal © 2005-2018