Re: [Lazarus] Favourite stand-alone db file?

[Graeme Geldenhuys via Lazarus]

On 2017-11-29 11:41, John Landmesser via Lazarus 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

--
fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal
http://fpgui.sourceforge.net/

My public PGP key:  http://tinyurl.com/graeme-pgp
--
___
Lazarus mailing list
Lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus

Re: [Lazarus] Favourite stand-alone db file?

[John Landmesser via Lazarus]

just plain text Files that works with SQL-Statements

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


Am 26.11.2017 um 14:52 schrieb DougC via Lazarus:

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 
* 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
--
___
Lazarus mailing list
Lazarus@lists.lazarus-ide.org 
https://lists.lazarus-ide.org/listinfo/lazarus






-- 
___
Lazarus mailing list
Lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus

Re: [Lazarus] Favourite stand-alone db file?

[DougC via Lazarus]

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 
lazarus@lists.lazarus-ide.org 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


--

___

Lazarus mailing list

Lazarus@lists.lazarus-ide.org

https://lists.lazarus-ide.org/listinfo/lazarus






-- 
___
Lazarus mailing list
Lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus

[Lazarus] Favourite stand-alone db file?

[Chavoux Luyt via Lazarus]

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
-- 
___
Lazarus mailing list
Lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus