mORMot Open Source

yogiyang

Member

Registered: 2010-08-18

Posts: 23

Use SQLite for FireMonkey applications targeted for Windows and Linux

Hello,

I have tried FireDAC as well as Zeoslib to access SQLite database. I am able to do this in both but only when I compile my 64bit FMX application for windows platform.

But both of these need SQLite.dll so I take it that I cannot compile my application for Linux.

Are there any possibilities of using mORMot for building FMX app for Windows and Linux Desktop applications that will be accessing SQLite database (both plain and encrypted)?

Please guide me here.

Yogi Yang

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,660

Website

Re: Use SQLite for FireMonkey applications targeted for Windows and Linux

On Linux, there is usually no sqlite3.dll to distribute, because sqlite3 is better installed and maintained as part of the system, using the official apt/yum/rpm package of the distribution.

We don't support Delphi for Linux because we don't need it here (we focus on FPC Linux which is better/less bloated than the Delphi LLVM backend), and we don't own any license of it.
So there is currently no possibility to use mORMot with Delphi for Linux, nor plan to do it.

It could be feasible, much easier with mORMot 2 than with mORMOt 1 because the new mormot.core.os.pas unit centralizes most operating system calls, but it is not available.
As it is an Open Source project, anyone could contribute.

One possibility could be to compile your DB code using FPC/Lazarus into a .so, then use it from your FMX Delphi app.

yogiyang

Member

Registered: 2010-08-18

Posts: 23

Re: Use SQLite for FireMonkey applications targeted for Windows and Linux

!ab,

Thank you very much for the detailed explanation.

Actually I did try my hands on FPC/Lazarus but for compiling a project for Linux one has to install fpcupDelux but could not wrap my head around it so I dropped it.

I also tried my hands on CodeTyphoon.

Yogi Yang

AOG

Member

Registered: 2014-02-24

Posts: 490

Re: Use SQLite for FireMonkey applications targeted for Windows and Linux

@yogiyang
You might ask for help with fpcupdeluxe.
https://synopse.info/forum/viewforum.php?id=10
https://github.com/LongDirtyAnimAlf/fpcupdeluxe/issues