OOo Base

OpenOffice has a database app. It has come a long (long, long) way over the last few years but uff is it ever just not there yet. I do need the query browser. Things you can’t do with OOo Base include add a fulltext index. Not with the gui because the gui doesn’t know that much, and not with the query browser because it balks. CREATE FULLTEXT INDEX `FILER_NAME` ON `commcand` (`FILER_NAME`); gets me an error (“syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIK”) in Base’s interface (“Run Query”) but worked just fine at the mysql command line. Same for “SHOW INDEX FROM tablename“. Works fine at the command line, OOo balks.

So OOo Base isn’t just translating between the two.

I’ll probably update this post as I come up with more new and different things to complain about.