SQLite as PB lib ? Single Executable.

[USCode]

Using a tool like this that Fr34k has put together:
http://freak.purearea.net/tools/

And since the source code to SQLite is readily available...

Wouldn't it be possible to compile SQLite into a .lib or .obj file using a C compiler, then combine that with El Choni's SQLite library, run Fr34ks tool and "viola" - create a PB library that could be linked by PB with your PB application all into a single executable? Just like any other PB library?

Rather than importing/exporting the SQLite DLL, etc. as has been discussed here in the past.

Just a thought.

( Caveat: I am PB library ignorant, so I apologize in advance if this question doesn't make any sense. )

[Karbon]

ElChoni has a SQLite userlib already that does that. It might be possible to statically link the SQLite library into a PB executable, though I don't know how.

[USCode]

ElChoni has a SQLite userlib already that does that

Hi Karbon,
Yeah, I'm aware of El Choni's library but what I was driving at was combining El Choni's SQLite interface library and statically linking SQLite into the executable. Some folks have brought SQLite into the data section and writing it out at runtime, etc. but I was looking for a method to formally link it in as part of the executable.
Thanks

[El_Choni]

Since the SQLite dll C source is available, you could implement it as a Purelibrary, entirely.

You only need some spare time XD

EDIT: I don't know if the SQLite license allows this.

[pbSync]

ElChoni has a SQLite userlib already that does that

Hi Karbon,
Yeah, I'm aware of El Choni's library but what I was driving at was combining El Choni's SQLite interface library and statically linking SQLite into the executable. Some folks have brought SQLite into the data section and writing it out at runtime, etc. but I was looking for a method to formally link it in as part of the executable.
Thanks

Quick solution to bundle a dll with your exe could be this tool: http://www.collakesoftware.com/pebundle.htm

don't know, whether this works or is allowed.

[USCode]

Quick solution to bundle a dll with your exe could be this tool: http://www.collakesoftware.com/pebundle.htm

Thanks pbSync and I've seen that discussed is other threads but I wanted SQLite to be a first-class PB library.

[thefool]

But as PE bundle cost some $ you can do this entirely free in PB.
Its very simple to do it, just requires 5 line of simple code.

[HAnil]

Its very simple to do it, just requires 5 line of simple code.

would you like to share this 5 line code.

[thefool]

Sorry. It was 8 lines of code

but here it is, with comments. Just remove those, though..

Code: Select all

;This creates the file.
;Replace "test.txt" with anything else.
CreateFile(1,"test.txt")
WriteData(?startfile,?endfile-?startfile)
CloseFile(1)

;This has to be putted after the createfile()
;I always put it in the bottom of the file.
;Rename "test.txt" to any file you want.
;Remember you need to have the file in the dir
;with the sourcecode.
DataSection
startfile:
IncludeBinary "test.txt"
endfile:
EndDataSection

But if you have to use this for a DLL, you need to do the createfile()
before calling it. But this also works for exe and any other file.

[pbSync]

But as PE bundle cost some $ you can do this entirely free in PB.
Its very simple to do it, just requires 5 line of simple code.

Writing to disk is easy in pb. But PE Bundle extracts the DLL direct to memory, which feels more like a lib and is not so easy to do in pb (at least I don't know how to do it). So it has its uses.