Differences between Database Components?
lazarus / 16-Databases

----------------------------------------------------------------------
Giu · 2014-01-07 09:14

Hi all,

I see a lot of components to work with databases from Lazarus. I see
Zeos is very popular. I saw today IBX was updated for Lazarus too, and
there are SQLdb.

I would like to know, if there are some site to see what the main
differences between them, because, I think SQLdb is the best option,
being bundled and supported officially by Lazarus, but don't know if
I'm missing something not using others like Zeos and so on.

Regards.

Note: Don't know if, for example, Greyhound, ghORM and so on uses it's
own layer, or it's based over SQLdb for example.

----------------------------------------------------------------------
Leledumbo · 2014-01-07 09:33

No website for their comparisons AFAIK, you could infer yourself.
People use each usually due to familiarity. ZEOS is available for both
Delphi and Lazarus, so people coming from Delphi with ZEOS usually
will use ZEOS again when coding in Lazarus. Greyhound is another layer
on top of them, which can be tuned to use which backend. ghORM is my
ORM layer on top of Greyhound.

----------------------------------------------------------------------
exdatis · 2014-01-07 09:40

Quote from: Giu on January 07, 2014, 10:14:03 am I think SQLdb is the
best option
Agree. Earlier I used ZEOS and I had problems, I'm not sure how it
works now, but SQLdb is stable, fast and easy to use and in my opinion
the best solution.
Regards.

----------------------------------------------------------------------
Giu · 2014-01-07 10:14

Quote from: Leledumbo on January 07, 2014, 10:33:40 amNo website for
their comparisons AFAIK, you could infer yourself. People use each
usually due to familiarity. ZEOS is available for both Delphi and
Lazarus, so people coming from Delphi with ZEOS usually will use ZEOS
again when coding in Lazarus. Greyhound is another layer on top of
them, which can be tuned to use which backend. ghORM is my ORM layer
on top of Greyhound.

I suppose with ghORM and Greyhound, data should be "writed" over
components by hand (no DBEdit, DBGrid and so on). This could be cool
otherwise, because We would like to develop over a similar MVC model.

----------------------------------------------------------------------
mangakissa · 2014-01-09 08:42

I see SQLdb as a tool like DBExpress in Delphi.

----------------------------------------------------------------------
exdatis · 2014-01-09 09:10

Quote from: mangakissa on January 09, 2014, 09:42:31 amI see SQLdb as
a tool like DBExpress in Delphi.
I can not agree. SQLdb is much better, fast  and simple,  powerfull,
cursor position is implemented with quite different ideas, etc.

----------------------------------------------------------------------
Leledumbo · 2014-01-09 11:50

QuoteI suppose with ghORM and Greyhound, data should be "writed" over
components by hand (no DBEdit, DBGrid and so on). This could be cool
otherwise, because We would like to develop over a similar MVC
model.Yup, the emphasize is not RAD, but easy hand coding.