How can I use sqlite3.dll embed inside App as resource

Sapiem · Post by **Sapiem** » 14.11.2011, 20:40

Hello:

How can I use sqlite3.dll embed inside App as resource? I can use sqlite functions directly using sqlite3.dll as resource, loading with BTMemoryModule, but, Zeos need the file in the root of the app, no recognise it from memory

This will be the best for developers, beause Zeos is very helpfull and strong, but need the sqlite3.dll plus the app.

Thanks

Post by **mdaems** » 17.12.2011, 20:47

When reading this, I think you could 'simply' edit ZPlainSqliteDriver.pas and add a new TZSQLiteBaseDriver descendent TZSqlite3ResourcePlaindriver and override TZSQLiteBaseDriver.Create and TZSQLiteBaseDriver.LoadAPI.
Then edit ZDbcSQLite.pas to 'register' this new Plaindriver.

If you can make that work, please share your eperience and code here, so we can evaluate if it's reasonable to put it into zeoslib.

Mark

papelhigienico · Post by **papelhigienico** » 18.12.2011, 12:57

This can be done for all drivers, or not?

Sapiem · Post by **Sapiem** » 18.12.2011, 15:04

I solved the problem using InboxApp that simulate virtual files. It's for me, so don't matter if it's trial. But if somebody can do that you said, will be so usefull. I can't do it myself.

Post by **mdaems** » 21.12.2011, 21:54

papelhigienico,

Not sure if it works for drivers using more than just one dll.

Mark

papelhigienico · Post by **papelhigienico** » 22.12.2011, 12:26

Hi Mark!

What I think is a lot of resources, each one storing a DLL of a specific driver. I'm studding the BTMemoryModule.

The first problem is the licence of BTMemoryModule. Currently it licensed with Mozilla Public License Version 1.1. I don't know if it can be used/distributed directly with ZeosLib.

The second problem is portability. BTMemoryModule can be compiled with Delphi/Lazarus only on Windows 32 bits. I'm thinking in port it to Linux 32/64 bits.

papelhigienico · Post by **papelhigienico** » 22.12.2011, 12:28

This is a good idea, simplify the application distribution, mainly on Windows, where users don't work with package dependency

Zoran · Post by **Zoran** » 22.12.2011, 13:36

I found this article in Lazarus Wiki: http://wiki.lazarus.freepascal.org/fb_embedded2_Laz

It describes the way how to include firebird embeded dll in exe file. I haven't tested it myself.

The author claims success with Zeos components:

The good thing is that your data-access components will work with embedded database, without change. For example, I use Zeoslib. Compiled .exe works without DLLs distributed.

papelhigienico · Post by **papelhigienico** » 22.12.2011, 20:28

It was based on BTMemoryModule too...

Sapiem · Post by **Sapiem** » 23.12.2011, 18:18

I still using InboxApp and over x64, all work fine, perfect. The application only increase the side adding the sqlite3.dll size. I try BTMemoryModule, but can´t do it. The best way is using InboxApp.

papelhigienico · Post by **papelhigienico** » 26.12.2011, 13:55

Sapiem

Where can I found InboxApp?

Sapiem · Post by **Sapiem** » 28.12.2011, 21:43

papelhigienico, give me an email and I'll send you. But if you want, look in Google

papelhigienico · Post by **papelhigienico** » 29.12.2011, 00:47

Sapiem

send it to fabio at pascalscada dot com

OR

papelhigienico at gmail dot com

Sapiem · Post by **Sapiem** » 29.12.2011, 01:18

Sorry, the real name is BoxedApp, not InboxApp.