But ESE doesn't have a SQL interface, full text search etc like SQLite does.
I'm working on the former with templates to create the illusion of relations between ESE tables. The latter can be done with Tuple Indexes, which I haven't tried personally. They apparently bloat the index sizes enormously, but get the job done with some practical limits on the min-max size of what is indexed -- Greg
