Hi,

I remember that years ago in Delphi I often used Paradox (less often dBase) to create a small stand-alone database with my Delphi desktop programs. It had tge advantage of
1. using Delphi database controls,
2. no need for a database server or DBMS to be installed on the client's machine (= less resources),
3. having the ability to deploy the database (basically the DB file(s) (I think it was one file per table), a .dll and a setup file telling the program where the db is stored (and links between tables?)) all together in a single install file (Installshield most of the time, sometimes a custom self-extracting file).

I am sure that Lazarus must still be used for these kind of quick-and-easy small stand-alone desktop applications. But what is your favourite small/embedded database for this kind of once-off personal programs these days, and why? Preferably something that can be used on both Linux and Windows without the need for ODBC or similar.

Cheers
Chavoux
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20171122/1b6491c6/attachment.html>

It would be hard to beat SQLite for a small stand-alone single-user RDBMS.

---- On Wed, 22 Nov 2017 00:07:02 -0500 Chavoux Luyt via Lazarus &lt;&gt; wrote ----

Hi,

I remember that years ago in Delphi I often used Paradox (less often dBase) to create a small stand-alone database with my Delphi desktop programs. It had tge advantage of

1. using Delphi database controls,

2. no need for a database server or DBMS to be installed on the client's machine (= less resources),

3. having the ability to deploy the database (basically the DB file(s) (I think it was one file per table), a .dll and a setup file telling the program where the db is stored (and links between tables?)) all together in a single install file (Installshield most of the time, sometimes a custom self-extracting file).

I am sure that Lazarus must still be used for these kind of quick-and-easy small stand-alone desktop applications. But what is your favourite small/embedded database for this kind of once-off personal programs these days, and why? Preferably something that can be used on both Linux and Windows without the need for ODBC or similar.

Cheers

Chavoux

just plain text Files that works with SQL-Statements

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20171129/b6613d07/attachment.html>

John Landmesser wrote

just plain text Files that works with SQL-Statements http://wiki.lazarus.freepascal.org/ZMSQL

tiOPF also supports persistence of data to XML, TAB or CSV files - JSON to follow shortly. A simple compiler define changes (no other code changes needed), and that same application can do persistence to a Relational Database Server (client/server) or even 3-tier application server.

http://tiopf.sourceforge.net

See also:
http://wiki.freepascal.org/tiOPF

Regards,
Graeme