Forum > Other

Go on with Lazarus for database app or not?

(1/3) > >>

JJTTBB:
Hello to everyone, this is my first post and I am really happy to see that Pascal still exists... I was using Turbo Pascal just for hobby back in 90's and I loved it!
Of course these days everything is different and Databases are a good way to keep your data about customers, projects etc... and there are many database management software out there.

There is also Filemaker, Radbuilder (Longtion Software) etc... the Database RAD applications that are similar to Lazarus or Visual Studio for databases.
However, most of them are expensive and the others have limited capabilities.

I was wondering if Lazarus is good for Database apps... I see that there are the necessary components, for handling databases, SQL queries and reports but I would like to hear from people with some experience in database handling with Lazarus.

- Should I try and remember (or better start from the begining) with Pascal or try with a Database RAD like the once I mentioned?

- If I avoid databases at least for the begining... Is file/record handling and reporting easy to handle with good results?

Thank you in advance for your answer

Thaddy:
Lazarus is excellent for database applications (even better than Delphi) and supports many, many back-ends: custom, MySql, Sqlite, Paradox, dBase, CSV, SDF, Json, XML, MariaDb, Oracle, PostGress, MsSQL even ODBC .... and many more.
I consider both Delphi and Lazarus much better than your other examples. Because of more natively supported standards and ease of use. And it supports more platforms, often with the same code Linux, Windows, Mac, Android, BSD's

JJTTBB:
Thank you!
So, I guess I have to start reading!

Handoko:
Lazarus supports wide range of databases, just pick the one suits your need:
http://wiki.freepascal.org/Databases


--- Quote from: JJTTBB on February 24, 2018, 10:07:07 am ---If I avoid databases at least for the begining... Is file/record handling and reporting easy to handle with good results?

--- End quote ---

Nothing wrong using file's record handling, I use it and I even wrote my own module for it to ease my programming. But for medium to large projects, performance is important and/or multiusers programs, you need to consider 'better' options.

For small and single user program, dBase should be enough. It is easy to learn and deploy:
http://wiki.freepascal.org/Lazarus_Tdbf_Tutorial

valdir.marcos:
@JJTTBB

As Thaddy and Handoko have well explained, you're in the right place.

I do consulting helping teams to migrate systems in [Delphi, Visual Basic, Java, Clipper, etc] + [Oracle, MS-SqL Server, Sybase, PostDrive, MariaDb, MySQL, SQLite, Paradox, dBase, etc] into Lazarus or PHP using Firebird as back end.
https://www.firebirdsql.org/en/documentation/
https://www.firebirdsql.org/en/server-packages/
https://www.firebirdsql.org/en/support/

Start by searching information about these various database management systems.
Take a special look at Relational DataBase Management System (RDBMS):
https://en.wikipedia.org/wiki/Relational_database_management_system
https://www.tutorialspoint.com/sql/sql-rdbms-concepts.htm
https://www.tutorialspoint.com/sql/index.htm
http://database.guide/what-is-an-rdbms/

Then, see how to integrate Lazarus with several databases at:
http://wiki.freepascal.org/Databases
http://wiki.freepascal.org/SqlDBHowto
http://wiki.freepascal.org/Working_With_TSQLQuery
http://wiki.freepascal.org/Lazarus_Database_Overview
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_Tutorial4
http://wiki.freepascal.org/SQLdb_Programming_Reference

Make your own tests to see which one suits you best.
Whatever your choice, the people here at the forum are very participative and always try to help.

Navigation

[0] Message Index

[#] Next page

Go to full version