[sqlite] REGEXP pcre DLL for Windows

\ext\misc\regexp.c -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Richard Hipp Gesendet: Dienstag, 19. Mai 2015 00:34 An: General Discussion of SQLite Database Betreff: Re: [sqlite] REGEXP

[sqlite] REGEXP pcre DLL for Windows

. Thanks! Best regards Martin -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Random Coder Gesendet: Montag, 18. Mai 2015 19:59 An: General Discussion of SQLite Database Betreff: Re: [sqlite

[sqlite] REGEXP pcre DLL for Windows

at mailinglists.sqlite.org] Im Auftrag von sonypsx Gesendet: Mittwoch, 06. Mai 2015 16:55 An: sqlite-users at mailinglists.sqlite.org Betreff: [sqlite] REGEXP pcre DLL for Windows Hello, can somebody me please and provide a working almost recent precompiled windows dll version of "pcre&qu

[sqlite] REGEXP pcre DLL for Windows

On 5/18/15, Keith Medcalf wrote: > > Is there any reason why the default REGEXP is unsuitable? > > ext/misc/regexp.c > > in the source distribution ... > Just in case it helps to answer the above question The RE syntax recognized by regexp.c is summarized in the header comment which can be

[sqlite] REGEXP pcre DLL for Windows

: Monday, 18 May, 2015 10:44 > To: 'General Discussion of SQLite Database' > Subject: Re: [sqlite] REGEXP pcre DLL for Windows > > Dear SQLite Users, > > may i kindly ask again about REGEX pcre DLL for Windows? > > Do someone have an idea or even a precompiled DLL which wor

[sqlite] REGEXP pcre DLL for Windows

On Mon, May 18, 2015 at 9:43 AM, sonypsx wrote: > may i kindly ask again about REGEX pcre DLL for Windows? > > Do someone have an idea or even a precompiled DLL which works under sqlite? As you've found, you don't just need a pcre dll for windows, you need a sqlite3 module to implement the

[sqlite] REGEXP pcre DLL for Windows

Hello, can somebody me please and provide a working almost recent precompiled windows dll version of "pcre" which is capable to load within sqlite3? I did try hard, found some precompiled ones at http://www.airesoft.co.uk/pcre. But they cannot be loaded within sqlite3. I did the try with

Re: [sqlite] regexp within trim function

Linuxed wrote: > Is it possible to use regexp within a trim function? For example, if I wanted > to remove every alpha-numeric character at the end > of a string I could use the statement below. Is there any way to > simplify/condense the statement through regexp or a

[sqlite] regexp within trim function

Is it possible to use regexp within a trim function?  For example, if I wanted to remove every alpha-numeric character at the end of a string I could use the statement below.  Is there any way to simplify/condense the statement through regexp or a wildcard character?  Also, if I want to remove

Re: [sqlite] REGEXP parameter order - embarassed newbie

Hello James630165, I guess it depends on how good a programmer you are. I just used the web site and some reference books on SQL. Wrote my own wrapper and improve it as time goes on and I need new features. C Sunday, January 23, 2011, 8:05:08 PM, you wrote: Jac> JCC/DRH Jac> Jac> If a person

Re: [sqlite] REGEXP parameter order - embarassed newbie

Being one who speaks good English, has a logical mind, and has previously programmed in C, AND who had used SQLite for around five years on the strength of that, I still found the book useful when I read it a couple of months ago. I already knew the basics, but it shed light on a few obscure

Re: [sqlite] REGEXP parameter order

Hi Igor, >I'm not quite sure what you are talking about, but see the >documentation of like() and glob() functions here: You're right about LIKE and GLOB. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] REGEXP parameter order

Jean-Christophe Deschamps wrote: > Digging further I found mention of this only in the VTAB description, > but may be a mention or link to the infix argument reversal should > appear in the LIKE, GLOB, REGEXP, MATCH description, as implementing > simple extension functions doesn't

Re: [sqlite] REGEXP parameter order - embarassed newbie

JCC/DRH If a person speaks good English and has a logical mind, has previously programmed in C ... why is there a need to buy "The definitive guide to programming SQLite"? I understand that "Everyone does". Jim. ___ sqlite-users mailing list

Re: [sqlite] REGEXP parameter order

> > Sorry for elementary questions but when implementing a REGEXP function > > (I'm using PCRE from pcre.org) I need to know in which order the two > > arguments (target, pattern) will be passed to the function. > > > > I also would like to retain the last pattern used in compiled form > >

Re: [sqlite] REGEXP parameter order

On Sun, Jan 23, 2011 at 5:02 PM, Jean-Christophe Deschamps wrote: > Hi all, > > Sorry for elementary questions but when implementing a REGEXP function > (I'm using PCRE from pcre.org) I need to know in which order the two > arguments (target, pattern) will be passed to the

[sqlite] REGEXP parameter order

Hi all, Sorry for elementary questions but when implementing a REGEXP function (I'm using PCRE from pcre.org) I need to know in which order the two arguments (target, pattern) will be passed to the function. I also would like to retain the last pattern used in compiled form (connection-wise).

Re: [sqlite] REGEXP

I think it had more to do with a) the fact that it's non-standard syntax and b) compiling in the regex library would unnecessary bloat the binary. See pcre.org for a free (non-GPL) regex library that has proven to work nicely with SQLite. :) -T On Tue, Dec 16, 2008 at 1:44 PM, Griggs,

Re: [sqlite] REGEXP

Regarding: "...No regexp() user function is defined by default..." The reason, if I recall correctly, is that the regexp routines that were available were GPL'd and would mess with the licensing of sqlite. ___ sqlite-users mailing list

Re: [sqlite] REGEXP

Ben Marchbanks wrote: > I am confused. Is REGEXP enabled in SQLite or does there have to be a > regexp custom function created ? The REGEXP operator is a special syntax for the regexp() user function. No regexp() user function is defined by default and so use of the REGEXP operator will normally

[sqlite] REGEXP

I am confused. Is REGEXP enabled in SQLite or does there have to be a regexp custom function created ? -- *Ben Marchbanks* www.magazooms.com Signature Email: b...@magazooms.com Phone: (864) 284.9918

Re: [sqlite] REGEXP implementation with pcre

On Wed, Jul 11, 2007 at 09:07:39AM -0500, Neil Best wrote: > see code from original post at > http://article.gmane.org/gmane.comp.db.sqlite.general/23584 BTW, the code has been released under the same terms as SQLite itself. http://git.altlinux.org/people/at/packages/?p=sqlite3-pcre.git

[sqlite] REGEXP implementation with pcre

On 14 Nov 2006 Alexey Tourbin <[EMAIL PROTECTED]> writes: Hello, I've just written sqlite3 loadable module which implements REGEXP operator with Perl-Compatible Regular Expressions library. It has LRU cache for compiled regular expressions, so it is probably fast. $ cflags=`pkg-config

Re: [sqlite] Regexp

T wrote: I know there are hooks for adding a Regexp function/operator ourselves, but I need to know it's available on other machines with standard install. It's the same reasoning, I guess, as why Trim() was added, but Regexp seems to serve a wider need. I'm pretty sure the problem is that

[sqlite] Regexp

Hi, I noticed in recent versions of SQLite the addition of some functions such as Trim(). So I am hopeful that at least one more function, Regexp(), can be included since it is such a central and common need. Time and time again I come up with needing a Regexp function, and I notice that

[sqlite] REGEXP implementation with pcre

Hello, I've just written sqlite3 loadable module which implements REGEXP operator with Perl-Compatible Regular Expressions library. It has LRU cache for compiled regular expressions, so it is probably fast. $ cflags=`pkg-config --cflags sqlite3 libpcre` $ libs=`pkg-config --libs sqlite3

RE: [sqlite] REGEXP

> Hi Ulrich, thanks for the answer but I need to implement a > function regexp() for SQLite inside a program in C++. Look at boost: http://www.boost.org/libs/regex/doc/introduction.html Regards, David Carter-Hitchin. -- Royal Bank of Scotland Interest Rate Derivatives IT

Re: [sqlite] REGEXP

Hi Ulrich, thanks for the answer but I need to implement a function regexp() for SQLite inside a program in C++. Thanks, Danilo.

Re: [sqlite] REGEXP

Hi Danilo, take a look at http://aspn.activestate.com/ASPN/docs/ActiveTcl/tcl/TclCmd/re_syntax.htm Kind regards Ulrich On Friday 17 March 2006 10:13, Danilo wrote: > Hi to All , > I'm looking for further information about REGEXP > (http://www.sqlite.org/lang_expr.html). > Someone knows how to

[sqlite] REGEXP

Hi to All , I'm looking for further information about REGEXP (http://www.sqlite.org/lang_expr.html). Someone knows how to point out me some examples! Thanks, Danilo. Home Page: http://www.digitazero.org venerdì 17 marzo 2006, 9.07

RE: [sqlite] REGEXP as an operator

Yes. I needed it to work as an operator in the form: FIELD REGEXP ".*", not regexp(FIELD,".*") -Original Message- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 10, 2005 10:32 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] REGEXP as an

Re: [sqlite] REGEXP as an operator

On 5/10/05, John Buck <[EMAIL PROTECTED]> wrote: > Greetings, > > I am new to this list and the Sqlight project. > > I ran across it while doing research on locating an alternative to the Mysql > Embedded engine. Sqlite seems like it will do the trick with a few tweaks. > I just wanted to share

[sqlite] REGEXP as an operator

Greetings, I am new to this list and the Sqlight project. I ran across it while doing research on locating an alternative to the Mysql Embedded engine. Sqlite seems like it will do the trick with a few tweaks. I just wanted to share one of those tweaks for comment. One problem I ran into