Thursday, December 1, 2011

Sqlite3 bind and the machine

Sqlite3 allows the machine to bind machine variable to an sql statement before running. For the installed operators, we want sql programmers to have wide acess to machine tabe names and variable. But we do not want to load version2 down with a bunch of symbol management. So I have the compromise method to identify variables for binding. The index,sub index method. Writing installable sql statements, in a macro processor, for example, the index identifies the bind handler in the machine, and the sub index a defined variable for the handler. Thus, version 2 need only identify the three or four handlers, and indexed variable under each. Not all possible variable groupings per statement are allowed, but enough to make the thing sql programmable.

Completed that task. Also the machine now pre-loads the insert,pop and update operators so any open graph is can have the nested form managed by the machine. Later I will add read operators that can read by set or by descent along the nested form. Use that for matching structure.

Still pounding on the machine and updating all the various defines I shouldn't be using.

No comments: