Best FireBird library for Lazarus lazarus / 16-Databases ---------------------------------------------------------------------- motaz · 2014-01-09 09:02 One day I have followed a refer link to TurboBird page, in that link a Russian guy has talked about TurboBird, another one commented "writing admin tool for Firebird using IBX is a bad idea" and since then I was wondering is it bad idea to use Interbase library for FireBird, and is IBConnection and FireBird library depend on Interbase, and what is the best FireBird library that should be used with Lazarus applications? ---------------------------------------------------------------------- exdatis · 2014-01-09 09:11 SQLdb ---------------------------------------------------------------------- marcov · 2014-01-09 09:15 I think if you value designtime database work, Zeos is better. SQLDB is currently a bit geared towards "I'll do my SQL statements in code"  way of thinking. ---------------------------------------------------------------------- exdatis · 2014-01-09 09:34 It's a powerful and flexibility way. I often use stored procedures as select query! ---------------------------------------------------------------------- marcov · 2014-01-09 09:58 Quote from: exdatis on January 09, 2014, 10:34:09 amIt's a powerful and flexibility way. I often use stored procedures as select query! Handcoding is fine if it is your main bread and butter and most of your work is on the same or similar systems, it's laborious if all you do is crank out simple apps for administrative purposes, where auto increment and inserting a value in a 3 way relation with referential integrity are the biggest challenge. ---------------------------------------------------------------------- motaz · 2014-01-09 09:58 QuoteIt's a powerful and flexibility waywhich method do you mean SQLdb or Zeos? To: marcov I have moved to use non-bounded components, using classes that contains all CRUD functionality, so that my SQL queries exist inside units source, and there is no stored procedures, this makes my code more reusable and true object oriented ---------------------------------------------------------------------- exdatis · 2014-01-10 06:11 Quote from: motaz on January 09, 2014, 10:58:39 amwhich method do you mean SQLdb or Zeos? SQLdb ---------------------------------------------------------------------- mangakissa · 2014-01-10 09:24 SQLdb is a part of FPC components and should always be supported as a part of. ZEOS is third party. If a third party doesn't development / support anymore, your components (besides your own development on the source) will be outdated. It took  long ZEOS 7 is a stable version for both parties (Delphi and Lazarus). Yes, I know ZEOS 7 took a long route to get Unicode on Delphi, but when Lazarus/FPC will be, they will get the same problems (that includes SQLdb and all other components). ---------------------------------------------------------------------- motaz · 2014-01-10 10:34 Thank your all for your participation, I'll continue use SQLdb in TurboBird and my small Arabic ERP system regardless of the that Russian guy comment ---------------------------------------------------------------------- marcov · 2014-01-10 13:24 Quote from: mangakissa on January 10, 2014, 10:24:47 am  Yes, I know ZEOS 7 took a long route to get Unicode on Delphi, but when Lazarus/FPC will be, they will get the same problems (that includes SQLdb and all other components). No, not entirely.  SQLDB only will need to support one (major) FPC version. (but in the future there might be 1-byte and 2-byte flavours). But it will never have to support both versions that have a unicode base type (Delphi 2009+) and without (Delphi D2007-).   This also goes for non-unicode related language and RTL improvements. Still, I think that currently ZEOS is more wellrounded for a (mostly) design approach. ---------------------------------------------------------------------- Graeme · 2014-01-10 13:54 SqlDB is pretty good.IBX I've heard is good, but never used it myself.FBLib is also very good, and includes a Firebird Admin (GUI) tool as well. I haven't developed FBLib, but have been maintaining it for a couple of years. [https://github.com/graemeg/firebird-lib] ---------------------------------------------------------------------- exdatis · 2014-01-12 12:50 My earlier opinion about ZEOS has changes...  After 1- 1.5 years I tried 7.1.2. Looks nice and (for now, quick tests, Firebird2.5) works quite well... Congratulation for the ZEOS team. p.s. I had(years ago, with PostgreSQL) problem to use backspace in DbEdit, unusual access violation, etc.