Difference of SQLdb and Zeos lazarus / 16-Databases ---------------------------------------------------------------------- xenblaise · 2010-10-18 02:51 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 · 2010-10-20 03:37 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 · 2010-10-20 06:29 : shipped by default with Lazarus installation : 3rd party DifferenceSQLdbZeosAvailabilityShipped by default3rd partySupported databasesSee what's available in component palette and components dirA lotThat's all I know. ---------------------------------------------------------------------- michaelthuma · 2010-10-20 10:54 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 · 2010-10-20 12:49 Great answers Thanks ---------------------------------------------------------------------- lazguy · 2010-11-05 11:53 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 · 2010-11-19 14:45 QuoteSQLdb 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. ---------------------------------------------------------------------- asdf · 2010-11-20 00:38 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. ---------------------------------------------------------------------- fredycc · 2010-11-20 01:52 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 · 2010-11-22 13:18 How about a line ---------------------------------------------------------------------- jgazquez · 2010-12-12 02:02 Quote from: lazguy on November 05, 2010, 12:53:01 pmI 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. ---------------------------------------------------------------------- marcov · 2010-12-13 12:13 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) ---------------------------------------------------------------------- guidoaerts · 2010-12-17 09:58 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 · 2010-12-17 13:39 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. ---------------------------------------------------------------------- Dibo · 2010-12-17 13:53 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. ---------------------------------------------------------------------- JD · 2010-12-17 13:58 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. ---------------------------------------------------------------------- Dibo · 2010-12-17 14:59 And I remember, ZEOS probably have component specialy for FireBird Events ---------------------------------------------------------------------- marcov · 2010-12-17 17:17 Quote from: Dibo on December 17, 2010, 02:53:06 pmI 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 · 2010-12-17 18:24 No, this was only example of ZEOS idea ---------------------------------------------------------------------- xenblaise · 2010-12-21 19:28 I think sqlDb and Zeos differ in properties I have NOT use Zeos, But if Zeos has a feature of Quoteyou 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_MsSQLi te := ? then the best. ( i doubt is not like this)