vonsmith,
Well, let see...
I am using SQLite version 3.0.8 (
http://www.sqlite.org) with a wrapper to allow for use within vbscript and javascript (
http://www.republika.pl/roed/litex). The site has examples in javascript. This allows you to open an SQLite database file, do whatever you want (begin, commit, create table, insert, select, delete, etc.) then close it. VERY streamlined. It only takes a little code.
Anyway, to test it, I put together a "brain.db3" file, created a music table, and inserted listings of the top40 from around 1955 to 1985. Then created a section in XTF1.2 to use it. Here is a very simple exchange:
me: Who sang Hound Dog?
hal: Elvis presley sang hound dog. Fabian sang hound dog man.
I've got it doing a simple "like", so that it will find any occurance of the word (or string). I've also put a few language files in a table, so that Hal can return the word in another language, like so:
me: Translate wife to Spanish.
hal: Wife in Spanish is la esposa. Wife in Spanish is marida[Noun].
me: Translate wife to Italian.
hal: Wife in Italian is moglie[Noun].
As you can tell from the Spanish result, it will give me all listings for the word. Right now, I only have Spanish, French, German, Italian, and some Portuguese. I wrote a small vbscript to run outside Hal to import delimited text files into my brain.db3.
I was thinking about moving all of Hal's brain over to SQLite. That way, it would be more portable (take her to work with you, then take her home at night). Also, since SQLite is ported to MANY OSes, the input and output parser could be written in the programming language of choice for that OS. (And the Hal community would grow to include Linux, MAC, etc.)
Since I have kids, I was also thinking about how to control different versions of Hal (PG, PG-13, R, XXX, etc.). If I placed Hal's brain into a database, I could have a field for...say "personality key" or pkey for short, then Hal would only return data with the right pkey. Change your pkey for work or in public, then change the pkey to make her raunchy as hell when your alone.
I had left vbscript a few years back, so I had to dig out some of my old scripts to familiarize myself with the language again. If I moved all of Hal's brain to SQLite, I think I could use (and everyone else) the hal5_XTF_v1.2.uhp for the parser.
Sorry I got so long-winded. I'll shut up, and listen to some of the responses.
virtually,
Joseph