Using Lazarus First Time.. seek some help!

[440bx]

for _practical_ purposes, a 32bit PE file is normally limited to be about 1.7GB because that's about what's left in the 32bit version of Windows once all its system  stuff is loaded.  That's the case even if the PE is marked as being large address aware because it still needs to fit entirely in the low area of the process (the part that is below ntdll, kernel32, etc)

A 64bit PE file is a different thing.  Those can normally reach 4GB _BUT_ the code section cannot exceed 2GB because the PE format uses 31 bit offsets for some tables, e.g, the import table.  The resource section is also limited to 2GB because the offset to directory is also a 31 bit offset.  Those are two 31 bit offsets in the PE format that come to mind, if there are others, I cannot think of them at this time.

[Mudassir]

5. Database Functions: never used any on-form controls/widgets to control database. I always prefer to handle database using my procedures. No idea how it works on lazarus (as asked already in first query).

Finally someone after my taste. Haven't used any DB-Bound controls in over 20 years, either
If you need help with Database stuff give a shout.
Note: Currently, i only have SQLite as a Database-Engine, but with Lazarus it's pretty easy to handle different Database-Systems once you understand how it works

As mentioned at https://wiki.freepascal.org/Databases, there are a few packages for database support I would like to learn about (classes and components not visual data bound controls).

1. There is DBFLaz / Tdbf that support (read/write) dBase / Foxpro / VFP tables and does not require Server / Libs at client side (the best part).
2. There is SQLdb / SQLite(3)Laz for SQLite.
3. Also sdf for Text files.

Please guide through some detailed documentation (if any) or some other way to learn about those. I found some pages demonstrating basic functions only at wiki.freepascal.org. Seek advice from people who used to work with the packages. Thank you.

Edit: Found this PDF about Tdbf, IDK if it covers everything, so better ask than..

[TRon]

1. There is DBFLaz / Tdbf that support (read/write) dBase / Foxpro / VFP tables and does not require Server / Libs at client side (the best part).
2. There is SQLdb / SQLite(3)Laz for SQLite.
3. Also sdf for Text files.

Please guide through some detailed documentation (if any) or some other way to learn about those. I found some pages demonstrating basic functions only at wiki.freepascal.org. Seek advice from people who used to work with the packages. Thank you.

1. https://wiki.freepascal.org/Lazarus_Tdbf_Tutorial
2. https://wiki.freepascal.org/SQLdb_Tutorial0
3. https://wiki.lazarus.freepascal.org/TSdfDataSet

etc. etc. The wiki is full of database related examples/tutorials but it depend on your needs which exact tutorial suits you. Do you use or want to use (sql) queries, do you visually design your DB or do you prefer to do things manually etc. etc. etc.

[Mudassir]

@TRon, thank you for sharing links...

I had a quick look at Tdbf, and found that it does not allow SQL queries on DBF tables
Doing a dummy SqLite3 project in attempt to study SQLdb and SQLite3Connection.