Recent

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

xenblaise

  • Sr. Member
  • ****
  • Posts: 358
Difference of SQLdb and Zeos
« on: October 18, 2010, 04:51:22 am »
I can make database development through SQLdb Component,
I can open all SQL connections using that which is stable.

What about Zeos, why do we need this?

xenblaise

  • Sr. Member
  • ****
  • Posts: 358
Re: Difference of SQLdb and Zeos
« Reply #1 on: October 20, 2010, 05:37:37 am »
is there a serious lazarus expert here to add my comment?
I think the question is simple when you experience both of them.
Whats your comment? :(

Leledumbo

  • Hero Member
  • *****
  • Posts: 8310
  • Programming + Glam Metal + Tae Kwon Do = Me
Re: Difference of SQLdb and Zeos
« Reply #2 on: October 20, 2010, 08:29:14 am »
: shipped by default with Lazarus installation
: 3rd party
DifferenceSQLdbZeos
AvailabilityShipped by default3rd party
Supported databasesSee what's available in component palette and components dirA lot
That's all I know.

michaelthuma

  • New Member
  • *
  • Posts: 46
Re: Difference of SQLdb and Zeos
« Reply #3 on: October 20, 2010, 12:54:40 pm »
Why having more....
There are simply different philosophies to build db access. In the pascal world we have somehting like a standard >> the TDataset compatibilty << that provides a common programmatic as well as a reliable interface databournd components that rely on.

Everything beyond is a matter of taste ...

From my experience SQLDB is good ... many people also under UNIX find it very satisfactory. As long as you come along with them be happy.

In reallity honestly especially if you target with one .exe different databases you will very soon come to the point that you have to provide different SQL statements, have batch insert updates or not, transactions or not, have to store data offline, connection information provided by an infrastructure,.... different layering ... in reallity the componentlayer is something nice but not requried ... if you want to go beyond maybe you want to have a different level of abstraction (when building your own framework for data driven apps....), speed ...

ZEOS is very practicable and available for Delphi too. I think this is a major difference and said to origin form the ideas of JDBC ... whatever this means in the end ... feel free to find it out.

I kindly suggest to try to come along with what comes on board ...

xenblaise

  • Sr. Member
  • ****
  • Posts: 358
Re: Difference of SQLdb and Zeos
« Reply #4 on: October 20, 2010, 02:49:03 pm »
Great answers

Thanks :D

lazguy

  • Jr. Member
  • **
  • Posts: 78
Re: Difference of SQLdb and Zeos
« Reply #5 on: November 05, 2010, 12:53:01 pm »
Hello xenablaise

I had troubles with version 6.6.6 of Zeos.

I'm developping a Linux/Windows application.

In one OS (I don't remember which) a SELECT of a float field return an integer, not a float. If I'm not wrong, for example, 2.74 is returned as 274 (without the decimal separator).

In my opinion is much more easy using Zeos. SQLdb is more "dificult" you have to set more things in order for it to work.

It's a pity this bug in Zeos. I hope they release this correction as soon as possible. 

xenblaise

  • Sr. Member
  • ****
  • Posts: 358
Re: Difference of SQLdb and Zeos
« Reply #6 on: November 19, 2010, 03:45:55 pm »
Quote
SQLdb is more "dificult" you have to set more things in order for it to work.
Yeah, But it is used by default of embarcadero as tdbExpress(tsqlquery, tsqlconnection, etc.,,)

So, it is compatible on delphi whenever I transport my code.
For zeos? you have to install the package if you want to use.

 :D

asdf

  • Sr. Member
  • ****
  • Posts: 310
Re: Difference of SQLdb and Zeos
« Reply #7 on: November 20, 2010, 01:38:05 am »
Could you please compare coding line by line between SqlDB and Zeos  :-\ ?
I've never thought I'd try it because I'm SqlDB fan.
Lazarus 1.2.4 / Win 32 / THAILAND

fredycc

  • Sr. Member
  • ****
  • Posts: 264
Re: Difference of SQLdb and Zeos
« Reply #8 on: November 20, 2010, 02:52:43 am »
SQLdb is good and easy to implement, but I prefer use Zeos 7.0.0 alpha for Firebird 2.5, Why? because I can use Events in my app and others advantages.

I have tested Zeos in Windows, Ubuntu and Mac with great result.

xenblaise

  • Sr. Member
  • ****
  • Posts: 358
Re: Difference of SQLdb and Zeos
« Reply #9 on: November 22, 2010, 02:18:11 pm »
How about a line :D

jgazquez

  • Newbie
  • Posts: 2
Re: Difference of SQLdb and Zeos
« Reply #10 on: December 12, 2010, 03:02:27 am »
I had troubles with version 6.6.6 of Zeos.

I'm developping a Linux/Windows application.

In one OS (I don't remember which) a SELECT of a float field return an integer, not a float. If I'm not wrong, for example, 2.74 is returned as 274 (without the decimal separator).

Zeos does that on Windows when using non US standard decimal/thousand separators, as Zeos on Windows uses its own implementations of StrToFloat/StrToFloatDef (I guess it uses the FPC native version on Linux, don't know why), and that implementations are broken for FPC, or FPC library itself is broken (I guess it works ok on Delphi). Bottom line, I solved it, here es the patch.

Sadly, I couldn't register neither on Zeos forum or bugtracker, I never got the email back.

BTW, I'm still bitten by another Zeos bug, where detail updates on a master detail setup with cached updates are lost. If anybody know something about this I'll be very thankful.
« Last Edit: December 13, 2010, 05:52:07 pm by jgazquez »

marcov

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 9090
  • FPC developer.
Re: Difference of SQLdb and Zeos
« Reply #11 on: December 13, 2010, 01:13:58 pm »
I also have the feeling Zeos leans more towards MySQL as anchor point, and sqldb more towards firebird/interbase.

Both support roughly the same set of databases.  (Zeos also supports ADO, but not with FPC/Lazarus)
« Last Edit: December 17, 2010, 06:16:23 pm by marcov »

guidoaerts

  • New Member
  • *
  • Posts: 12
Re: Difference of SQLdb and Zeos
« Reply #12 on: December 17, 2010, 10:58:55 am »
I am not familiar with SQLdb.  But Zeos is multiplatform (like Lazarus) and multi-database-system.  AFAIK there is no peer to that.

jgazquez: return to the zeos forum, there was/is some problem with the registering, they request you to send a mail.

Guido

JD

  • Hero Member
  • *****
  • Posts: 1822
Re: Difference of SQLdb and Zeos
« Reply #13 on: December 17, 2010, 02:39:27 pm »
According to what I was told, SQLdb can be likened to dbExpress in Delphi.

I personally use Zeos and I've noticed that it shares similar traits to Delphi's BDE without the disadvantages related to its installation quirks. I even read the BDE help file sometimes when I'm stuck with a problem in Zeos.
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 #14 on: December 17, 2010, 02:53:06 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.

 

TinyPortal © 2005-2018