On 21 May 2010, at 11:19am, Gilles Ganault wrote: > Ideally, the executable should be a > simpler language than C that would still be able to include SQLite so > that I would end up with a single executable.
The SQLite library is provided as one long piece of C code. Not even C++, just C, with a couple of includes. So any language for which you can write extensions in C will handle SQLite just fine. > Apparently, there are two solutions: > - use C/C++, and just include sqlite.c + sqlite.h in the project Yep. That is the simplest way to do it and gives a compact result. > - compile the SQLite source code into OBJ, compile this OBJ with the > executable, and somehow call the SQLite functions from the main > program. Or write a little bridge which converts your programs requirements into a few calls to the SQLite library, then compile your bridge as a static library. > Does someone know of a BASIC-like language (ie. with an easy syntax > like Python, Lua, etc.) that can include the SQLite OBJ file? Hard to know what you mean by BASIC-like, but I can name languages you can do this in off the top of my head, including the two you named. For instance, get hold of the lua source code, and add SQLite and a few bridge functions to convert data from SQLite format to lua's indexed table format. Not to mention using non-language applications and writing a plugin which incorporates SQLite, as you can do for Final Cut Pro, FireFox, Safari, MatLab, etc.. I wanted a way to call SQLite from JavaScript in Safari so I wrote a browser plugin. Works fine. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
