Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-09-17 Thread Liam Healy
Thank you Nuno and Joe for your help. I have posted a new version, now called extension-functions.c, which works on external interfaces only and therefore does not require the sqlite3 source code. I have made everything a single C file with instructions as a comment at the top, hence no need for

Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-09-14 Thread Liam Healy
I tried eliminating sqliteInt.h and replacing with explicit declarations of i64 and u8. That part worked fine, but func_ext.c also uses sqliteMalloc which is also defined in sqliteInt.h which led me down a rabbit hole of pulling more and more from sqliteInt.h, and I still can't eliminate the

Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-09-11 Thread Nuno Lucas
On 9/10/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > --- Liam Healy <[EMAIL PROTECTED]> wrote: > > Thanks for the tip Joe. With sqlite3.h included, I can eliminate os.h and > > vdbeInt.h, but not sqliteInt.h. Apparently sqliteInt.h is not included by > > sqlite3.h, and there are typedefs there

Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-09-10 Thread Joe Wilson
--- Liam Healy <[EMAIL PROTECTED]> wrote: > Thanks for the tip Joe. With sqlite3.h included, I can eliminate os.h and > vdbeInt.h, but not sqliteInt.h. Apparently sqliteInt.h is not included by > sqlite3.h, and there are typedefs there that are needed. It would be nice if people could use the

Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-09-10 Thread Liam Healy
Thanks for the tip Joe. With sqlite3.h included, I can eliminate os.h and vdbeInt.h, but not sqliteInt.h. Apparently sqliteInt.h is not included by sqlite3.h, and there are typedefs there that are needed. Liam On 9/5/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > > Hi Liam, > > In func_ext.c and

Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-09-05 Thread Joe Wilson
Hi Liam, In func_ext.c and map.h you're including private sqlite3 header files: sqliteInt.h, os.h and vdbeInt.h, which change from release to release. If you only use the public sqlite3.h header file instead, it has a greater chance of being compatible with new releases. --- Liam Healy

Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-09-05 Thread Liam Healy
OK I have posted a new version of extension-functions.tgz on sqlite.org/contrib. This version includes definitions for READ_UTF8, sqlite3ReadUtf8, SKIP_UTF8, sqlite3utf8CharLen, xtra_utf8_bytes, xtra_utf8_bits, utf_mask taken from the 3.3.13 source code, so it should continue to work in sqlite

Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-09-01 Thread Liam Healy
Good point. I guess my intent is this: I'd like to use the external API completely if possible. If not, I'm not sure whether to include source or use the current library (I can see advantages to each). I guess there aren't external API calls that do the needed tasks, so I'll have to figure out

Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-08-31 Thread Joe Wilson
--- Liam Healy <[EMAIL PROTECTED]> wrote: > Thanks. I have changed the use of sqlite3CreateFunc to > sqlite3_create_function. I did not need to include the source code for > sqlite3utf8CharLen because there's a sqlite3Utf8CharLen (note different > capitalization) in the library. However, the

Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-08-31 Thread Liam Healy
Thanks. I have changed the use of sqlite3CreateFunc to sqlite3_create_function. I did not need to include the source code for sqlite3utf8CharLen because there's a sqlite3Utf8CharLen (note different capitalization) in the library. However, the definition of sqlite3ReadUtf8 and needed

Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-08-31 Thread Joe Wilson
--- Liam Healy <[EMAIL PROTECTED]> wrote: > I was the one who packaged up extension-functions.tgz and posted on > contrib. I didn't author the original code but I'd like to fix this up. > I'm not clear on what needs to be changed. I gather that sqlite3utf8CharLen > and sqlite3CreateFunc

Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-08-31 Thread Liam Healy
I was the one who packaged up extension-functions.tgz and posted on contrib. I didn't author the original code but I'd like to fix this up. I'm not clear on what needs to be changed. I gather that sqlite3utf8CharLen and sqlite3CreateFunc shouldn't be used. I'm not sure how to convert to use the

Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-08-02 Thread Joe Wilson
--- Paul Harris <[EMAIL PROTECTED]> wrote: > I wanted to get a LOG10() function in sqlite3, and I found the > extension-functions.tgz file in http://sqlite.org/contrib > > I am using the all-in-one sqlite3.h/c version of sqlite3, and the > extension-functions files don't seem to fit at all. > >

[sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-08-02 Thread Paul Harris
Hi, I wanted to get a LOG10() function in sqlite3, and I found the extension-functions.tgz file in http://sqlite.org/contrib I am using the all-in-one sqlite3.h/c version of sqlite3, and the extension-functions files don't seem to fit at all. For example, it wants to call a function called

[sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-08-01 Thread Paul Harris
Hi, I wanted to get a LOG10() function in sqlite3, and I found the extension-functions.tgz file in http://sqlite.org/contrib I am using the all-in-one sqlite3.h/c version of sqlite3, and the extension-functions files don't seem to fit at all. For example, it wants to call a function called