Re: [sqlite] where to find an examples of writing a extension?

2010-06-20 Thread Liam Healy
See extension-functions.c in http://sqlite.org/contrib. On Sat, Jun 19, 2010 at 10:52 PM, Sam Carleton wrote: > I need to add a new where clause to my query, one that checks to see > if the file actually exits.  I am thinking the correct solution is a > user defined

Re: [sqlite] load_extension() and extension-functions.c

2010-02-06 Thread Liam Healy
Thank you for the Windows compilation instructions. I have updated the file http://sqlite.org/contrib/download/extension-functions.c?get=25 to include them, along with a small fix to the assert for squareFunc. Liam On Tue, Jan 19, 2010 at 4:14 AM, Oliver Peters <oliver@web.de> wrote:

Re: [sqlite] load_extension() and extension-functions.c

2010-01-18 Thread Liam Healy
On Mon, Jan 18, 2010 at 5:18 AM, Oliver Peters wrote: > Hello out there, > > I just wanted to say "thank you" for this wonderful feature (load_extension) > and > the work invested into these very useful extra functions > (extension-functions.c). Thanks! The real work on

Re: [sqlite] "extension-functions.c" in windows mobile

2009-04-11 Thread Liam Healy
On Fri, Apr 10, 2009 at 3:40 AM, Jay A. Kreibich wrote: > On Thu, Apr 09, 2009 at 04:34:53PM +0200, Thibaut Gheysen scratched on the > wall: > >> I have found the "extension-functions.c" in the >> contrib page of the SQLite website but I'm not able to build it for windows >> ce.

Re: [sqlite] SQL POSITION function?

2008-09-02 Thread Liam Healy
I think charindex in extension functions might do what you want; see extension-functions.c in http://sqlite.org/contrib. Liam On Tue, Sep 2, 2008 at 6:20 PM, Jim Dodgen <[EMAIL PROTECTED]> wrote: > Any plans on adding a string matching function like the SQL99 > (E021-11) "POSITION" > > -- > Jim

Re: [sqlite] Math Functions

2008-06-13 Thread Liam Healy
the new version if you already have the old file. Liam On Fri, Jun 13, 2008 at 10:31 AM, Jay A. Kreibich <[EMAIL PROTECTED]> wrote: > On Fri, Jun 13, 2008 at 09:43:51AM -0400, Liam Healy scratched on the wall: > >> Interesting; I tried it on Debian sid (unstable) and it wor

Re: [sqlite] Math Functions

2008-06-13 Thread Liam Healy
On Fri, Jun 13, 2008 at 4:31 AM, Alexey Pechnikov <[EMAIL PROTECTED]> wrote: >> The extension-functions file doesn't actually implement any of the >> math functinos, it simply acts as a glue layer between SQLite and the >> system math library. In this case, it looks like the run-time linker

Re: [sqlite] Math Functions

2008-06-12 Thread Liam Healy
In the file you have downloaded, there is the following statement: Note: You cannot use these functions from the sqlite3 program, you must write your own program using the sqlite3 API, and call sqlite3_enable_load_extension. See "Security Considerations" in

Re: [sqlite] BCD representation of floats

2008-03-29 Thread Liam Healy
ers? You may have sufficient precision. The COBOL-style > COMP3 integers are pretty much obsolete these days. > > > > Liam Healy wrote: > > I am porting a numerical application from Oracle to SQLite. For the > > most part, I have been successful, but there are slight di

Re: [sqlite] BCD representation of floats

2008-03-29 Thread Liam Healy
representation. This > should then produce exact match to oracle (in theory). You could use a text > field or blob field to store the number datatype. Then apply your conversion > function to it! > > HTH, > Ken > > > > Liam Healy <[EMAIL PROTE

[sqlite] BCD representation of floats

2008-03-26 Thread Liam Healy
I am porting a numerical application from Oracle to SQLite. For the most part, I have been successful, but there are slight disagreements in the floating point number results. I have traced this back and found a problem. According to http://articles.techrepublic.com.com/5100-22_11-5224536.html,

[sqlite] Contrib on home page

2008-01-12 Thread Liam Healy
With the reorganization of the sqlite.org home page, it seems that "contrib" has been lost. The page still exists; sqlite.org/contrib comes up fine, but I can't find a link to it from the home page. Can this be restored somewhere either on the home page in something linked from there? Thank

Re: [sqlite] Suggests for improving the SQLite website

2007-11-08 Thread Liam Healy
I think the documentation section needs to be organized. I count over two dozen links in a simple list with no apparent organization. Some (like "copyright") might be best under some other heading, like downloading. Some are minor topics, or of transient interest, such as moving from 3.4 to

Re: [sqlite] Having issues Loading an external (extension-functions.c)

2007-09-29 Thread Liam Healy
Makes sense. I've applied the patch and posted the new version. Liam On 9/28/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > --- Liam Healy <[EMAIL PROTECTED]> wrote: > > Can you explain why you would want it to not compile as a > > loadable module? (i.e. under w

Re: [sqlite] Having issues Loading an external (extension-functions.c)

2007-09-28 Thread Liam Healy
Can you explain why you would want it to not compile as a loadable module? (i.e. under what circumstances you would not define COMPILE_SQLITE_EXTENSIONS_AS_LOADABLE_MODULE). On 9/28/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > --- Liam Healy <[EMAIL PROTECTED]> wrote: > > Tha

Re: [sqlite] Having issues Loading an external (extension-functions.c)

2007-09-28 Thread Liam Healy
Thanks. I have included your changes in extension-functions.c so now sqlite3_load_extension is usable. I had been using sqlite3RegisterExtraFunctions which is not the official interface, and that is why I never encountered this problem. Also, I have improved the Mac OSX instructions for those

Re: [sqlite] sqlite3_open_v2 and SQLITE_OPEN_READONLY

2007-09-20 Thread Liam Healy
No, I meant like in http://sqlite.org/capi3ref.html#sqlite3_open, adding a small logo or box "new in 3.5.0" adjacent to the description of _v2. Then it is clear what version(s) support the feature. On 9/20/07, Kees Nuyt <[EMAIL PROTECTED]> wrote: > > On Thu, 20 Sep 2007 13:57:58 -0400, Liam

Re: [sqlite] sqlite3_open_v2 and SQLITE_OPEN_READONLY

2007-09-20 Thread Liam Healy
OK thanks, I'll upgrade when it hits Debian unstable which I expect will be fairly soon. It would be nice if the documentation gave a brief indication when a feature is added ("new in 3.5.0" unobtrusively somewhere). Liam On 9/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrot

[sqlite] sqlite3_open_v2 and SQLITE_OPEN_READONLY

2007-09-20 Thread Liam Healy
I tried to use sqlite3_open_v2 and SQLITE_OPEN_READONLY as described in http://sqlite.org/capi3ref.html#sqlite3_open, but the symbol SQLITE_OPEN_READONLY is unknown, even though I have included sqlite3.h. I am using version 3.4.2. Was this symbol not added until a later version, or am I supposed

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

2007-09-17 Thread Liam Healy
for a tarball. I made some revisions so that it will compile without warnings under Mac OS X, which is fussier about unsigned vs. signed chars. Liam On 9/15/07, Nuno Lucas <[EMAIL PROTECTED]> wrote: > > On 9/14/07, Liam Healy <[EMAIL PROTECTED]> wrote: > > I tried

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

2007-09-14 Thread Liam Healy
/11/07, Nuno Lucas <[EMAIL PROTECTED]> wrote: > > 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.hand > > > vdbeInt

Re: [sqlite] Compiling/installing extension-functions on Mac OS X

2007-09-12 Thread Liam Healy
I'm not an OSX expert but I do know the flags need to be different for gcc gcc -Isqlite -Isqlite/src -dynamiclib func_ext.c map.c -o libsqlitefunctions.so might work better. Liam On 9/12/07, Jared Haworth <[EMAIL PROTECTED]> wrote: > > Hi, > > Has anyone successfully compiled and installed

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

2007-09-10 Thread Liam Healy
> 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. > > -

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

2007-09-05 Thread Liam Healy
3.4. Liam On 9/1/07, Liam Healy <[EMAIL PROTECTED]> wrote: > > 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

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

2007-09-01 Thread Liam Healy
what to do. Liam On 9/1/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > > --- 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 > >

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

2007-08-31 Thread Liam Healy
appreciate hearing about it. Liam On 8/31/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > > --- 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

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] How to obtain the integer part of a result

2007-05-06 Thread Liam Healy
See the "floor" function (largest integer value not greater than argument) in http://sqlite.org/contrib/download/extension-functions.tgz?get=17 On 5/6/07, A.J.Millan <[EMAIL PROTECTED]> wrote: Hi all: I would like to know if there are a way to obtain a result without decimals (the integer

[sqlite] Import quoted and NULL values with .import

2007-04-26 Thread Liam Healy
I am trying to import (with .import) into SQLite3 some tables that are currently in an Oracle instance. To do this I am using an Oracle script (a nice one I found at http://www.tek-tips.com/viewthread.cfm?qid=1250849=8) . This script produces another script which is then executed. The result

Re: [sqlite] Submitting patches?

2007-04-23 Thread Liam Healy
On 4/23/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: (drh makes a mental note to improve the formatting of the contributed code section. The original table format seems a bit cluttered...) As long as you may be making a change, may I request a feature if it's not too much trouble? It

Re: [sqlite] Fortran 95 Language Bindings

2007-04-23 Thread Liam Healy
Arjen, Thank you for attentive maintenance and development on this valuable interface. On 4/23/07, Arjen Markus <[EMAIL PROTECTED]> wrote: Liam Healy wrote: > Arjen, > > I've taken another look at these bindings, and at my project. For a > variety > of reas

Re: [sqlite] Fortran 95 Language Bindings

2007-04-18 Thread Liam Healy
Arjen, I've taken another look at these bindings, and at my project. For a variety of reasons, most not related to the sqlite3 Fortran bindings, I have decided to proceed in a different direction. However, on closer examination of the Fortran bindings and other language bindings to sqlite3 (C

Re: [sqlite] trim available ??

2007-04-16 Thread Liam Healy
An option for versions that do not have trim is http://sqlite.org/contrib//download/extension-functions.tgz?get=17 On 4/16/07, Stef Mientki <[EMAIL PROTECTED]> wrote: > The TRIM function was added on 2007-03-17 17:52:42. > Thanks, that explains .. cheers, Stef > -- > D. Richard Hipp <[EMAIL

Re: [sqlite] Fortran 95 Language Bindings

2007-04-16 Thread Liam Healy
Arjen, The project I was working on was part of a larger effort to port a suite of software which included Fortran programs that connect to Oracle (using Pro*Fortran). Some of it we ported earlier by rewriting the database access portions in C. One of the alternatives to sqlite3 bindings for

Re: [sqlite] Fortran 95 Language Bindings

2007-04-15 Thread Liam Healy
I am very interested in this for a project of increasing urgency. A few months ago I found the two links that the other emails mentioned, but found both of them inadequate and not well documented. I think a complete, documented F95 API would be very useful. I am willing to help and critique

[sqlite] Re: sqlite3 extensions; was: Re: Bug#404242: closed by Laszlo Boszormenyi (GCS) <[EMAIL PROTECTED]> (Bug#404242: fixed in sqlite3 3.3.14-1)

2007-04-06 Thread Liam Healy
that someone can provide this information. Liam On 4/6/07, Laszlo Boszormenyi <[EMAIL PROTECTED]> wrote: Hi Liam! On Thu, 2007-04-05 at 17:04 -0400, Liam Healy wrote: > There is now in 3.3.14 a new and more serious problem related to the > extensions: while the > header

Re: [sqlite] Math functions

2007-04-04 Thread Liam Healy
Please see http://sqlite.org/contrib under extension-functions.tgz. On 4/4/07, Nathan Biggs <[EMAIL PROTECTED]> wrote: Does anyone know if there is a floor function in sqlite, or of a way to implement it.

Re: [sqlite] Transferring the oracle databse to sqlite database

2007-03-28 Thread Liam Healy
I made the same transition last year. Below is a sample script that I used successfully to have Oracle generate a file of SQL statements which can be read in to sqlite with .read. Obviously, this needs to be tailored to each table dumped. If this script is called oracle-dump.sql, then run

Re: [sqlite] Extension functions for SQLite in C for free

2007-03-27 Thread Liam Healy
I want to express my appreciation for this valuable contribution. I have taken the liberty of simplifying this source code to three files: func_ext.c, map.c, and map.h. Otherwise, all that's needed is the SQLite source code. Because config.h doesn't seem to be created in the configuration