{"id":309,"date":"2022-01-07T18:18:18","date_gmt":"2022-01-07T21:18:18","guid":{"rendered":"https:\/\/gladiston.net.br\/?page_id=309"},"modified":"2024-04-09T23:01:29","modified_gmt":"2024-04-10T02:01:29","slug":"zeoslib","status":"publish","type":"page","link":"https:\/\/gladiston.net.br\/en\/programacao\/lazarus-ide\/zeoslib\/","title":{"rendered":"ZeosLib"},"content":{"rendered":"<p>Main database access suite. You can also use it in Delphi&nbsp;<strong>Community Edition<\/strong>.<\/p>\n\n\n\n<p><a href=\"https:\/\/sourceforge.net\/projects\/zeoslib\/\">ZeosLib download | SourceForge.net<\/a><\/p>\n\n\n\n<p><strong>IMPORTANT #1:<\/strong>&nbsp;Do not mix the installation of this package with a simultaneous one, install only it, and then install the other packages.<\/p>\n\n\n\n<p>The installation of this package is done directly from the OPM:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"702\" height=\"432\" src=\"https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/02\/zeos_instalacao1.png\" alt=\"\" class=\"wp-image-719\" srcset=\"https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/02\/zeos_instalacao1.png 702w, https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/02\/zeos_instalacao1-300x185.png 300w\" sizes=\"auto, (max-width: 702px) 100vw, 702px\" \/><figcaption class=\"wp-element-caption\">Installation by Online Package Manager(OPM)<\/figcaption><\/figure>\n\n\n\n<p>Watch this video that shows how to make a database connection using this component:<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Part 1: Database connection with Zeos - Lazarus\" width=\"580\" height=\"326\" src=\"https:\/\/www.youtube.com\/embed\/pGTVIOC-TPk?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>You might want to consider this article titled <a href=\"https:\/\/gladiston.net.br\/en\/?page_id=159\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Using Zeos \u2013 Connecting a Database with ZConnection\">Using Zeos \u2013 Connecting a Database with ZConnection<\/a> which shows how to connect a database.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">ZeosLib from the sources in the GIT repository<\/h2>\n\n\n\n<p>Occasionally you may want to install Zeos from the repository manually. This can happen when you are interested in a different version than the one provided by the OPM repository. At the time of editing this article, the official version of Zeos available via OPM is 7.2.14 and it has some problems that have already been fixed in version 8 and which also includes new features, so you may want to consider using this new version instead. from the one already in the OPM repository. <\/p>\n\n\n\n<p>For a manual installation of ZeosLib via GIT, do the following:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd c:\\\ngit clone https:\/\/github.com\/marsupilami79\/zeoslib.git  (esse \u00e9 o github do zeoslib)\ncd zeoslib\ngit branch -r<\/code><\/pre>\n\n\n\n<p>Nas instru\u00e7\u00f5es acima, estamos considerando colocar o zeoslib na raiz C:\\, assim ele ficar\u00e1 em C:\\ZeosLib. \u00c9 altamente recomendado n\u00e3o colocar ele na pasta do Lazarus junto com outros componentes, porque assim o mesmo ZeosLib n\u00e3o poder\u00e1 ser usado tanto pelo Lazarus como o Delphi. Ent\u00e3o o melhor a se fazer \u00e9 t\u00ea-lo separado do caminho de outros programas.<\/p>\n\n\n\n<p>The command &#039;<strong>git branch -r<\/strong>&#039; will list all branches of that component, so we&#039;ll see something like:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">(...)<br>  origin\/7.2-patches<br>  origin\/7.2.0-beta<br>  origin\/7.2.1-rc<br>  origin\/7.2.12-stable<br>  origin\/7.2.14-stable<br>  origin\/7.2.3-rc<br>  origin\/7.2.4-stable<br>  origin\/7.2.6-stable<br>  origin\/8.0-patches<br><strong>  origin\/8.0.0-stable<\/strong><br>  origin\/HEAD -> origin\/master<br>  origin\/master<br>  origin\/testing-7.3<br>  origin\/testing-7.3-aehimself<br>(...) <\/pre>\n\n\n\n<p>When you see the list above, determine which version you want, if you have chosen <strong>&#8220;<strong>8.0.0-stable<\/strong><\/strong>\u201d then run:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>git switch 8.0.0-stable<\/code><\/pre>\n\n\n\n<p>go on <strong>Lazarus-&gt;Package-&gt;Open Package File(.lpk)<\/strong> e com exce\u00e7\u00e3o do pacote zcomponentdesign.lpk, abra todos os demais *.lpk em C:\\ZeosLib\/packages\/lazarus:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"876\" height=\"541\" src=\"https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git1.png\" alt=\"\" class=\"wp-image-1358\" srcset=\"https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git1.png 876w, https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git1-300x185.png 300w, https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git1-18x12.png 18w\" sizes=\"auto, (max-width: 876px) 100vw, 876px\" \/><\/figure>\n\n\n\n<p>Compile all these packages and close the window, after compiling them all then again go to <strong><strong>Lazarus-&gt;Package-&gt;Open Package File(.lpk)<\/strong> <\/strong>and this time open the package<strong> zcomponentdesign.lpk<\/strong> and then  <strong>Use-&gt;Install<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"697\" height=\"182\" src=\"https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git2.png\" alt=\"\" class=\"wp-image-1359\" srcset=\"https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git2.png 697w, https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git2-300x78.png 300w, https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git2-18x5.png 18w\" sizes=\"auto, (max-width: 697px) 100vw, 697px\" \/><figcaption class=\"wp-element-caption\">Compile and install the zcomponentdesign.lpk package<\/figcaption><\/figure>\n\n\n\n<p>After Compiling and Installing, you will need to confirm the IDE&#039;s compilation and restart it. Do it!<\/p>\n\n\n\n<p>After restarting the IDE, just check the components in your palette:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1011\" height=\"74\" src=\"https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git3.png\" alt=\"\" class=\"wp-image-1360\" srcset=\"https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git3.png 1011w, https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git3-300x22.png 300w, https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git3-18x1.png 18w\" sizes=\"auto, (max-width: 1011px) 100vw, 1011px\" \/><figcaption class=\"wp-element-caption\">ZeosLib Palette<\/figcaption><\/figure>\n\n\n\n<p>As you can see, the ZeosLib palette is far from &#039;Data Access&#039; where database-related components are located, we would do well to right-click on the palette, go to <strong>Options<\/strong> and bring the &#039;Zeos Access&#039; palette after the &#039;Data Access&#039; section:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"710\" height=\"473\" src=\"https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git4.png\" alt=\"\" class=\"wp-image-1361\" srcset=\"https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git4.png 710w, https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git4-300x200.png 300w, https:\/\/gladiston.net.br\/wp-content\/uploads\/2022\/04\/ide_opm_zeos_git4-18x12.png 18w\" sizes=\"auto, (max-width: 710px) 100vw, 710px\" \/><figcaption class=\"wp-element-caption\">Move the &#039;Zeos Access&#039; palette closer to &#039;Data Access&#039;<\/figcaption><\/figure>\n\n\n\n<p>Click in &#039;<strong>OK<\/strong>&#039; and you&#039;ll be ready to recompile the IDE and start enjoying ZeosLib.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>ZeosLib components provide access to a variety of databases and is an excellent choice for Delphi, especially the Community where FireDAC has serious usage restrictions. Personally, it seems to me that the native data access of Lazarus(SQLdb) and Delphi(FireDAC) is better than ZeosLib version 7. Nevertheless, using ZeosLib allows you to use it in both languages without worrying about relearning others. data suites. You must remember that Delphi already had BDE, SQL Links, IBX, DBX and now FireDAC and whoever used ZeosLib since the first version didn&#039;t have to rewrite their applications in these changes that Delphi passed.<\/p>\n\n\n\n<p>ZeosLib v.8 solved a number of problems that existed in version 7 and is probably not that far behind SQLdb and FireDAC.<\/p>","protected":false},"excerpt":{"rendered":"<p>Principal su\u00edte de acesso a banco de dados. D\u00e1 para utiliz\u00e1-lo tamb\u00e9m no Delphi&nbsp;Comunity Edition. ZeosLib download | SourceForge.net IMPORTANTE #1:&nbsp;N\u00e3o misture a instala\u00e7\u00e3o desse pacote com outra simult\u00e2nea, instale apenas ele, e depois instale os demais pacotes. A instala\u00e7\u00e3o desse pacote se d\u00e1 diretamente da OPM: Veja este v\u00eddeo que mostra como fazer uma [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":159,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"templates\/template-full-width.php","meta":{"footnotes":""},"class_list":["post-309","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/pages\/309","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/comments?post=309"}],"version-history":[{"count":15,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/pages\/309\/revisions"}],"predecessor-version":[{"id":2439,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/pages\/309\/revisions\/2439"}],"up":[{"embeddable":true,"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/pages\/159"}],"wp:attachment":[{"href":"https:\/\/gladiston.net.br\/en\/wp-json\/wp\/v2\/media?parent=309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}