Lazarus Components x Zeos lazarus / 16-Databases ---------------------------------------------------------------------- cidadejr · 2018-03-20 02:23 Hi! I'm an old developer and Delphi/Zeos libs user. But, I'm planning to start developing using Lazarus but I'm not sure Lazarus DB components (Postgres and Firebird) would work like  (easy use) Zeos components. Can anyone help me? ---------------------------------------------------------------------- Handoko · 2018-03-20 02:41 Lazarus supports Zeos, read more here: http://wiki.freepascal.org/Zeos_tutorial Someone please add Zeos in to this wiki page: http://wiki.freepascal.org/Databases ---------------------------------------------------------------------- GAN · 2018-03-20 03:55 Sure, download https://sourceforge.net/projects/zeoslib/files/Zeos%20D atabase%20Objects/ and install this package ZComponents.Lpk And this https://drive.google.com/open?id=0B8ezhnpufAnQUEEyR2xINmNmaEE is the most complete documentation that I found "Zeos Documentation Collection" ---------------------------------------------------------------------- af0815 · 2018-03-20 05:20 In a mixed enviroment (Lazarus/Delphi) your best choice is ZEOS. If you only support Lazarus the sqlDB are so good and stable as ZEOS. The different between SqlDB and ZEOS is not so great on the first sight, BUT important. IMHO, you cannot easy change from ZEOS to SqlDB or other direction with only redefining the Components.  The small details makes a great diffence. Reporting COmponents in Lazarus are more centered to SqlDB not on ZEOS. If you work with report check this. The community of ZEOS is still active and it is supported. I have seen this last year :-) Thank to the guys of ZEOS :-) The documentation found by GAN are the completest. The ZEOS Forum is still active. But a lot of dead links are found in the internet, becaus a great knowledgebase was gone some years ago :-( Andreas ---------------------------------------------------------------------- cidadejr · 2018-03-21 02:09 Quote from: af0815 on March 20, 2018, 06:20:48 amIn a mixed enviroment (Lazarus/Delphi) your best choice is ZEOS. If you only support Lazarus the sqlDB are so good and stable as ZEOS. The different between SqlDB and ZEOS is not so great on the first sight, BUT important. IMHO, you cannot easy change from ZEOS to SqlDB or other direction with only redefining the Components.  The small details makes a great diffence. Reporting COmponents in Lazarus are more centered to SqlDB not on ZEOS. If you work with report check this. The community of ZEOS is still active and it is supported. I have seen this last year :-) Thank to the guys of ZEOS :-) The documentation found by GAN are the completest. The ZEOS Forum is still active. But a lot of dead links are found in the internet, becaus a great knowledgebase was gone some years ago :-( Andreas Thank you Andreas and you all. I’m very used to Zeos Lib on Delphi XE7. But besides Delphi anual renewal charge became quite expensive and I’m a OSx user and Linux lover, I’m thinking about starting a new project, that works in OSx, Linux and Windows. But some code and design I’ll try to import from my Delpho project (Zeos based). And yes Andreas, of course I’ll need lots of reports for my application. Should I change to SqlDB? Or keep Zeos? Thanks again! ---------------------------------------------------------------------- af0815 · 2018-03-21 05:07 QuoteAnd yes Andreas, of course I’ll need lots of reports for my application. Should I change to SqlDB? Or keep Zeos? It depends :-) You can only write some tests and check - Test, test, test, ... and look for the caveats  It depends on the reportengine you use. I have no exp. in OSX. Andreas ---------------------------------------------------------------------- cidadejr · 2018-03-21 20:53 Well, does Lazarus comes with any report engine? ---------------------------------------------------------------------- howardpc · 2018-03-21 21:27 Yes, but it is not installed by default. In Package->Install/Uninstall Packages... search for lazreport in the right hand "Available for installation" treeview listing. Once you have installed that package in the IDE you will be able to use TFrReport. If you have the OPM (Online Package Manager) installed you also have access to another report engine, Fortes4Lazarus, which the OPM will install for you. Quite recently a completely new reporting tool has been developed, FPReport. See http://wiki.freepascal.org/FPReport for more details. ---------------------------------------------------------------------- af0815 · 2018-03-22 05:27 Quote from: howardpc on March 21, 2018, 10:27:37 pmQuite recently a completely new reporting tool has been developed, FPReport. See http://wiki.freepascal.org/FPReport for more details. Actual fpc trunk and Lazarus trunk only, no stable version ! And it is SqlDB only (yet), no interfaces to ZEOS. fpreport is fast growing and more and more bugs are gone. The goals are - native FPC/Lazarus (no port), splitted in reportengine, rendering engine and editor. The LCL renderer is nice in Lazararus to bring the Report direct visible   without a previev. You can reports create easy by code too, see in the example dir of (trunk) Lazarus. The other report, LazReport is availabnle in the stable Lazarus. Running for years. It was a fork of an early version of FreeReport (a Dephi component). It is working for years, with pros and cons. I have no knowledge with Fortes4Lazarus. Andreas ---------------------------------------------------------------------- miab3 · 2018-03-25 11:49 A stable version of ZeosLib 7.2.4 has been released. https://sourceforge.net/projects/zeoslib/ https://sourceforge.net/projects/zeoslib/files/Zeos%20Database%20Objec ts/zeosdbo-7.2.4-stable/ https://sourceforge.net/projects/zeoslib/files/documentation/ Development version 7.3.x (with added OLE DB and ODBC). http://sourceforge.net/p/zeoslib/code-0/HEAD/tree/branches/testing- 7.3/ ZeosLib Web Site: http://zeoslib.sourceforge.net/index.php Michal