On Dec 8, 2009, at 12:24 PM, J. King wrote: > On Tue, 08 Dec 2009 12:11:13 -0500, li...@mgreg.com <li...@mgreg.com> > wrote: > >> Hi All, >> >> I'm currently using SQLITE in a few production apps. I'm using various >> languages such as Ruby, PERL, RB, etc. I have need to use regular >> expressions in some of my queries, but I'm not sure how to implement >> "user defined functionality". Where are the hooks? Is there a >> particular mechanism/language I must use to create them? Is this >> something I'm required to recompile SQLITE for? > > You do so by defining a user function called 'regexp'. The means by which > one defines a user function depends on the language. See, for instance, > [1] for Ruby. For a 'regexp' function you would specify two arguments, > pattern and string to match against. > > [1] > <http://sqlite-ruby.rubyforge.org/sqlite3/classes/SQLite3/Database.html#M000115> > > -- > J. King
What if you're making calls to SQLITE directly, and not via the language's API? Is there any way to make the support "native"? Can I drop a script of some sort that SQLITE will call (no matter what language I'm using to perform the call)? I guess I'm looking for a more abstract understanding of the hows and whys first. Thanks, Michael _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
