Re: [sqlite] Version 3.3.0 (alpha)

Does anybody know if there anything special we have to do to get the new boolean optimization? Does it apply to any 0/1 integer values you put in a cell, or does the column have to be declared as BOOLEAN? Thanks, Brett On 1/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > SQLite version

Re: [sqlite] Version 3.3.0 (alpha)

On 21.01.2006, at 20:41, [EMAIL PROTECTED] wrote: Weissmann Markus <[EMAIL PROTECTED]> wrote: oh, well - thanks for this hint! Nevertheless sqlite 3.3.1 (still) does not complain: SQLite version 3.1.3 sqlite> create table t (a integer primary key, b integer, check(b > 0)); sqlite> insert

Re: [sqlite] Version 3.3.0 (alpha)

Weissmann Markus <[EMAIL PROTECTED]> wrote: > > oh, well - thanks for this hint! Nevertheless sqlite 3.3.1 (still) > does not complain: > > SQLite version 3.1.3 > sqlite> create table t (a integer primary key, b integer, check(b > 0)); > sqlite> insert into t(b) values(-19); > sqlite> select *

Re: [sqlite] Does anyone know how I would uninstall sqlite?

I think it worked! I tried to the make -n install method and found this: /usr/bin/install -c -d /usr/local/lib ./libtool --mode=install /usr/bin/install -c libsqlite3.la /usr/local/lib /usr/bin/install -c -d /usr/local/bin ./libtool --mode=install /usr/bin/install -c sqlite3 /usr/local/bin

Re: [sqlite] Re: Version 3.3.0 (alpha)

On 21.01.2006, at 19:01, Igor Tandetnik wrote: Weissmann Markus <[EMAIL PROTECTED]> wrote: could someone please elaborate on this one? sqlite> create table t (a int primary key, b int, check(0 insert into t(b) values(1); does not complain, so what checks exactly can

[sqlite] Re: Version 3.3.0 (alpha)

Weissmann Markus <[EMAIL PROTECTED]> wrote: could someone please elaborate on this one? sqlite> create table t (a int primary key, b int, check(0 insert into t(b) values(1); does not complain, so what checks exactly can we do now? check(0

Re: [sqlite] Version 3.3.0 (alpha)

On 11.01.2006, at 02:55, [EMAIL PROTECTED] wrote: SQLite version 3.3.0 is now available on the website http://www.sqlite.org/ Version 3.3.0 incorporates many enhancements and changes. Among the changes in this release: * CHECK constraints are now enforced. could someone please

Re: [sqlite] Does anyone know how I would uninstall sqlite?

> twoeyedhuman wrote: > > I have the latest version of sqlite3 on my debian box and I'd like > > to uninstall it because I keep getting this error through bash: > > sqlite3: error while loading shared libraries: libsqlite3.so.0: > > cannot open shared obje ct file: No such file or directory I'm >

RE: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java

I think if you will closely read you own analysis of your efforts you will realize that all of the "down side" issues you have enumerated relate directly to the implementation language and not the database or its structure. In Java there is no such thing as AnythingLite, IMHO. Java, like so many

[sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java

I did loads of research on this and even tinkered with a c to Java converter, which got me a little bit further forward. However, I realised that I would be facing a huge effort to create the code base and then have to support it within our projects. So despite being an SQLite zealot, I had to

Re: [sqlite] Does anyone know how I would uninstall sqlite?

twoeyedhuman wrote: > I have the latest version of sqlite3 on my debian box and I'd like to > uninstall it because I keep getting this error through bash: > > sqlite3: error while loading shared libraries: libsqlite3.so.0: cannot open > shared obje ct file: No such file or directory > > I'm