Re: [sqlite] SQLite datatypes

HEre's the doc: http://www.sqlite.org/datatype3.html Cheers, Paul On Mon, May 3, 2010 at 12:17 PM, Alan Harris-Reid < aharrisr...@googlemail.com> wrote: > Hi there, > > When creating a table in SQLite, I often get confused when confronted > with all the

Re: [sqlite] FTS3 stop words/chars

On Fri, Apr 30, 2010 at 2:18 PM, Richard Hipp <d...@sqlite.org> wrote: > > > On Fri, Apr 30, 2010 at 4:43 PM, Paul Rigor (uci) <paul.ri...@uci.edu>wrote: > >> Hi, >> >> What are the default stop words and characters for the FTS3 simple >> toke

[sqlite] FTS3 stop words/chars

Hi, What are the default stop words and characters for the FTS3 simple tokenizer? Thanks, Paul -- Paul Rigor Pre-doctoral BIT Fellow and Graduate Student Institute for Genomics and Bioinformatics Donald Bren School of Information and Computer Sciences University of California, Irvine

Re: [sqlite] CHECK constraints and type affinity

Agreed. I would hope that the application (at a higher level) is performing type checks on the input data before attempting any insertion... On Thu, Apr 29, 2010 at 8:28 AM, Igor Tandetnik wrote: > Alexey Pechnikov > wrote: > > Do you want produce

Re: [sqlite] SQlite trigger issues

Checkout: http://www.sqlite.org/capi3ref.html#sqlite3_progress_handler <http://www.sqlite.org/capi3ref.html#sqlite3_progress_handler>Goodluck, Paul On Thu, Apr 29, 2010 at 6:05 AM, Paul Rigor (uci) <paul.ri...@uci.edu>wrote: > Hi, > > There's should be a call back to a

Re: [sqlite] SQlite trigger issues

Hi, There's should be a call back to a progress handler. I haven't done this at the level of C, but I know with the pysqlite wrapper you can set a handler on the connection that's executing a query: con.set_progress_handler(progress, 1000) Where the method/functor progress is called after

Re: [sqlite] CHECK constraints and type affinity

Hey all, SQLite seems to be consistent if you actually provide the proper checks you want to achieve. What's the deal again with prepending the check with "+"? sqlite> CREATE TABLE T2 (N INTEGER CHECK(N >= 0) CHECK(TYPEOF(N)=='integer')); sqlite> INSERT INTO T2 VALUES(-'q'); sqlite> INSERT

Re: [sqlite] Install multiple versions of Sqlite?

That sounds about right, but you should ensure that LD_LIBRARY_PATH is set to reflect the appropriate sqlite lib folder each time you run something that requires this, eg, your latest subversion install. Goodluck, Paul On Mon, Apr 26, 2010 at 1:30 PM, Forrie wrote: > We are