Forum > Windows
dBase in Lazarus
compispezi@web.de:
Hi friends. I'm a beginner. That means, these are my first steps after a pause of 15 years. I would like to use simple databasestructures without client-Serverfunction.
A very good way was to use dBase in an older Delphi 7 version.
Is here a way to work with dbase structures in Lazarus (create database / add / edit / sql...) ?
Thank you very much
Zvoni:
Do yourself a favour, and forget DBase.
Use SQLite.
And FWIW: There is a Sub-Forum called "Databases"...... ..oO(now what could this be for?)
compispezi@web.de:
Hi Zvoni, in the past i used dBase in all projects.
SQLite ist a single component without server needed?
Zvoni:
--- Quote from: compispezi@web.de on August 09, 2022, 04:19:42 pm ---Hi Zvoni, in the past i used dBase in all projects.
SQLite ist a single component without server needed?
--- End quote ---
Correct. The only thing you‘d need is the sqlite-library/dll placed in the same folder as your executable
Handoko:
Lazarus has TDBF component installed by default but you have to enable it first:
Lazarus main menu > Package > Install/uninstall packages > Available for installation > type: DBFLaz 0.1.1 > Save and rebuild IDE > wait and the IDE will be restarted
TDBF is very easy to use similar to DBase, zero installation on the user computer and no *.dll file needed. This is the tutorial for TDBF:
https://wiki.lazarus.freepascal.org/Lazarus_Tdbf_Tutorial
I use it in my personal note taking program and a small inventory software I wrote many years ago. They're working good, no problem so far.
But TDBF is not suitable for multi-client environment. If you need to store huge amount of data or performance is important, you should consider to use the other options:
https://wiki.lazarus.freepascal.org/Databases#Supported_databases
I ever roughly tested the SQLite, it is about 4 times faster than TDBF. Currently I am learning Firebird, which is similar to SQLite but it has some advantages.
https://wiki.lazarus.freepascal.org/Firebird
Firebird basically means free but if you modify the source code, you need to comply to their license. SQLite is in Public Domain license.
Also TDBF may have licensing issue, read here:
https://forum.lazarus.freepascal.org/index.php/topic,60100.msg448769.html#msg448769
Navigation
[0] Message Index
[#] Next page