Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2008-05

Lazarus Newbie Question about DB programming

3 messages · 3 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Daniel Stritt

Hello, I am fairly new to Lazarus, and even newer to database programming, so I have a few questions.

For simple db usage, which components should I use? Also, if I add a database component to my app, do I have to distribute any kind of database server with it? I'm trying to keep the redistributables to a minimum, which is one of the reasons I like Lazarus so much.

Also, is there any kind of tutorial that any of you know about on how to do database things with Lazarus/FPC?

Thanks in advance, and thanks to the developers/maintainers for creating such a nice programming package.

Reply by email

Lee Jenkins
to Daniel Stritt
Daniel Stritt wrote 7 lines
Hello, I am fairly new to Lazarus, and even newer to database programming, so I have a few questions. For simple db usage, which components should I use? Also, if I add a database component to my app, do I have to distribute any kind of database server with it? I'm trying to keep the redistributables to a minimum, which is one of the reasons I like Lazarus so much.

Hi Daniel,

It really depends on which database you are using. SQL database like FirebirdSQL and MySQL certainly require client libraries to be distributed, but usually just the client libraries. Most multi-user systems like FirebirdSQL and MySQL require that you have a database server setup somewhere on the network.

Some databases like FirebirdSQL offer an "embedded" mode for single user access. In that case you only need to distribute a few files.

Also, SQLite is an easy database to use and doesn't require a database server for multi-user use, but does still require the SQLite3 dll/so to be distributed. I don't think it intended for serious multi-user deployments, but if you're just needing a local database to use...

Also, is there any kind of tutorial that any of you know about on how to do database things with Lazarus/FPC?

http://wiki.lazarus.freepascal.org/Lazarus_Database_Tutorial

Cheers,

Warm Regards, Lee "When my company started out, we were really, really, really, really small. Now...we're just really small."

Reply by email

Funky Beast
to Daniel Stritt: Hello, I am fairly new to Lazarus, and even newer to database programming, so I have a…
Daniel Stritt wrote 19 lines
Hello, I am fairly new to Lazarus, and even newer to database programming, so I have a few questions. For simple db usage, which components should I use? Also, if I add a database component to my app, do I have to distribute any kind of database server with it? I'm trying to keep the redistributables to a minimum, which is one of the reasons I like Lazarus so much. Also, is there any kind of tutorial that any of you know about on how to do database things with Lazarus/FPC? Thanks in advance, and thanks to the developers/maintainers for creating such a nice programming package. _______________________________________________ Lazarus mailing list http://www.lazarus.freepascal.org/mailman/listinfo/lazarus

Hi,

For simple lightweight database use TDbf, the database system compiles directly into your executable, you only need to distribute your dbf tables files.

Examples here:
http://wiki.lazarus.freepascal.org/Lazarus_Tdbf_Tutorial

HTH,
Funky Beast

Reply by email