Question about database with source code examples

[Conrad_404]

Hi,
I am a new Lazarus user. I am mainly interested in programming for Windows (WinAPI mainly). I previously used TMT Pascal for years, and was very happy about it, but it is no longer supported and currently lacks many modern components. However, switching requires knowing the differences between both environments. I would like to ask if there is anywhere a database with source code of simple programs for learning purposes.
Best Regards
Conrad

[Handoko]

Hello Conrad_404,
Welcome to the forum.

If you haven't used any database, you probably can start with TDbf. TDbf probably is the easiest for beginners, unfortunately it is lack of several modern features like multi client connections, poor/no support for mutibyte characters, transaction concept, etc. TDbf is installed by default Lazarus installation, but you have to manually enable it.

To enable TDbf in Lazarus:
Lazarus main menu > Package > Install/Uninstall Packages > in the right pane, select "DBFLaz 0.0.1" > Install selected > Save and rebuild IDE > wait and then your Lazarus will be restarted

If you want to learn/use TDbf, you should download the documentation tdbf.pdf, which can be easily found and downloaded from the Internet.

If you already have some knowledge in database programming, you may want to try SQLite or Firebird, which support Structured Query Language. Each database has their own advantages and disadvantages. I recommend SQLite and Firebird for beginners because they are relatively easy to start with. If you want to learn and use SQL-based database, I recommend this link:
https://www.w3schools.com/sql/

This is a list of all databases supported by Lazarus:
https://wiki.freepascal.org/Databases#Supported_databases

For new user in Lazarus/Pascal, I recommend this link, which has plenty of demos for doing simple tasks:
https://wiki.freepascal.org/Portal:HowTo_Demos

And here are demos for TDbf:
https://forum.lazarus.freepascal.org/index.php/topic,37181.msg249361.html#msg249361
https://forum.lazarus.freepascal.org/index.php/topic,37181.msg249208.html#msg249208

And these SQLite demos:
https://forum.lazarus.freepascal.org/index.php/topic,65185.msg496461.html#msg496461

[silvercoder70]

You could also have a look at my video here ...

https://www.youtube.com/watch?v=mPvTyTbX2Ko

It uses SqLite but also talks about the component used.

[Conrad_404]

Thank you for your reply! One more question: is there any repository with sample fpc/lazarus code sources (various topics)?

[cdbc]

Hi
Yes, have a look in the 'Examples' directory under 'Lazarus' install-dir...
Regards benny

[Handoko]

Thank you for your reply! One more question: is there any repository with sample fpc/lazarus code sources (various topics)?

I already gave you the link.

[Conrad_404]

Thanks again!

[Zvoni]

If you haven't used any database, you probably can start with TDbf. TDbf probably is the easiest for beginners, unfortunately it is lack of several modern features like multi client connections, poor/no support for mutibyte characters, transaction concept, etc. TDbf is installed by default Lazarus installation, but you have to manually enable it.

DBF is NOT a Database. Period.
DBF is a ... "storage system".... for lack of a better description.

Go with SQLite. Parallel learning of SQL is.... "advised"....

[CharlyTango]

I agree with @Zvoni

If you are new to programming database frontends don't waste time for DBF.
This type of data storage derives from a time where real databases could not be managed on personal computers and DBF was the answer or a workaround.

Nowadays SQLite ist a very easy and convenient was to be used as a data storage system.
The learning curve is a bit steeper than DBF but has the advantage that you learn and use a modern way.