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 reason
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 w
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&page=8) . This script
produces another script which is then executed. The resu
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 part
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
suggestion
I'd 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 origi
l have to figure
out 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
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
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.
>
&
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 Liam'
it.
Liam
On 9/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
> > >
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 eli
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
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]>
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 wrot
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 th
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
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
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 3.5.
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 you.
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,
t would basically implement an oracle Number 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
>
>
>
>
t
> Sqlite integers? 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
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. Anybody can help
I have a database that has one writer which runs once a day, and
potentially many readers running whenever someone wants some
information. I am trying to understand concurrency in sqlite3 so that
I can have the writer run each day, regardless of whether a reader is
already running or a reader sta
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 proc
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
sqlplu
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.
t in hopes 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
> he
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 as
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 Fo
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 PR
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 a
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
http://www.sqlite.org/cvstrac/wiki?p=Lo
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
nload
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 i
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 D
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 extension-functions was
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 wrote:
> Liam Healy wri
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 function, something like:
>
>
40 matches
Mail list logo