I was looking for something like Using ADO from Delphi but for Lazarus...
If you are coming from Delphi, where you used ADO or BDE, you have to make decision -- move to SQLdb or Zeos. Zeos components are more similar to BDE and ADO, so the migration to Zeos is easier.
SQLdb has some differences:
- The SQLQuery component behaves as it is always in "CashedUpdates" mode - so you have to call ApplyUpdates to actually send the changes to db.
- The SQLConnection needs SQLTransaction component, together they are equivalent to ADOConnection, and the transaction behaves as it is always has "AutoCommit" set to false - so you have to commit every transaction without explicitly starting it.
SQLdb comes with your Lazarus instalation, and Zeos components you have to install yourself.
SQLDb is well documented in our wiki pages:
http://wiki.freepascal.org/Lazarus_Database_Overview http://wiki.freepascal.org/SqlDBHowto http://wiki.freepascal.org/Working_With_TSQLQuerySQLDb tutorial articles:
http://wiki.freepascal.org/SQLdb_Tutorial0,
http://wiki.freepascal.org/SQLdb_Tutorial1,
http://wiki.freepascal.org/SQLdb_Tutorial2,
http://wiki.freepascal.org/SQLdb_Tutorial3,
http://wiki.freepascal.org/SQLdb_Tutorial4Zeos: some basic Zeos tutorial is here:
http://www.intitec.com/varios/A_ZEOS_basics_tutorial_not_only_for_firebird.pdf. It is a good introduction tutorial, but far from full.
However, I think that most of your "Using ADO from Delphi" can be used directly for Zeos.
Zeos can be downloaded here:
http://sourceforge.net/projects/zeoslib/files/?source=navbarTheir forum is here:
http://zeoslib.sourceforge.net/