Copyright 2003-2011 T. Kurt Bond

Thu, 17 Dec 2009

sqlite implements table constraints

It's nice to see SQLite supports table constraints:

$ sqlite3 test.db
SQLite version 3.6.19
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table t1
   ...> (k int,
   ...>  s int,
   ...>  e int,
   ...>  d int,
   ...>  constraint se_or_duration check
   ...>    ((s is not null and e is not null) or d is not null));
sqlite> insert into t1 values (1, 8, 4, null);
sqlite> insert into t1 values (2, null, null, 8);
sqlite> insert into t1 values (3, null, null, null);
SQL error: constraint failed
sqlite>

Thu, 19 Nov 2009

oo2c on Mac OS X Snow Leopard

It looks like I got oo2c to build and work under Mac OS X Snow Leopard, with some stupid hacks, at least enough for my purposes. I don't claim that this is suitable for production work.

Here's the configure invocation I used:

CFLAGS='-no-cpp-precomp -fnested-functions -I/opt/local/include' \
LDFLAGS='-L/opt/local/lib' \
    ./configure --prefix=/sw/versions/m64/oo2c/2.1.11 --disable-libs

Here's the patch.


Fri, 25 Sep 2009

Emacs 23.1 and Wanderlust

To get UTF-8 to work when sending drafted messages in Wanderlust with Emacs 23.1 I had to apply this patch to FLIM.

I also checked out the wl-2_15_6-vtl branch in the wanderlust repository and the semi-1_14-vtl branch in the semi repository. (See repos for info about the repositories.)


Wed, 09 Sep 2009

Why is /etc/X11/rgb.txt missing on Ubuntu?

… It's really annoying to have to manually copy rgb.txt to /etc/X11/ to get uxterm to show up with proper foreground and background colors instead of a blank, black window.


Thu, 03 Sep 2009

Chicken 4.1.0 on Cygwin

Weird: after compiling and installing chicken with:

make PLATFORM=cygwin PREFIX=/sw/versions/cygwin/chicken/4.1.0
make PLATFORM=cygwin PREFIX=/sw/versions/cygwin/chicken/4.1.0 install

I had to copy /sw/versions/cygwin/chicken/4.1.0/lib/*.a to /sw/versions/cygwin/checkin/4.1.0/bin before it could link things properly. (I first noticed this while doing a $ chicken-install ncurses.)


Archives