Reputation: 19600

Can SQLite library embed (Link) to Delphi executable file?

I am wondering if we able to embed SQlite library into Delphi executable file and we may deploy our application as single .exe file without any SQlite dll file.

The embed is not keep the sqlite dll file into resource but link to Delphi executable file.

Upvotes: 9

Answers (6)

Simvector Technologies

Reputation: 86

I had the same problem and this is the solution I came up with. Maybe it can help you. Just include sqlite3 and you then have direct access to the dll functions. I used the same methods that have already be outlined: http://simvector.com/download/delphi_sqlite3.zip

The DLL is just encoded in source form and the DLLLoader unit loads it at runtime. The end result is no extra DLL in your distro at the expense of it all being loaded into memory at once vs parts loaded on demand via the OS.

We needed it to work as normal, yet no extra dll in distro. So works for our needs.

Upvotes: 4

r4w8173

Reputation: 608

We have compiled SQLite3 with Borland's free command line tools C compiler and the resulting OBJ file we linked in Delphi with {$LINK 'OBJS\sqlite3.obj'}, and written the pascal wrappers for the functions we needed.

There was a problem resolving some standard C library functions when linking but we re-implemented them in Delphi.

Upvotes: 5

Hot Licks

Reputation: 47729

You can download the SQLite open source and compile it into any environment that can compile vanilla C code. It's not especially hard.

Upvotes: 0

user160694

Reputation:

Delphi can link .obj files, thereby if you have them available (or source code to compile them), you can link them into an executable. But you can't to that with the SQLLite dll.

IIRC DISQLite 3 does exactly that, check it.

Upvotes: 1