Store - a simplistic data store over [TDBC] (25Jan2011 [CMcC])

Latest version can always be found here [http://code.google.com/p/wub/source/browse/trunk/Utilities/Store.tcl] and was developerd as a [Wub] utility.

A 'store' is considered to be a database with fairly simple access/update requirements: 

Store presumes we're primarily interested in one table of a db, and that all tables can meaningfully be accessed by row number / oid.

Store LRU-caches tdbc-prepared statements for all DB interactions this saves time re-preparing statements which might not change

Store provides get/set/incr for individual fields by record oid

Store provides for record matching/fetching/updating/deleting using a match alist, passed in args, whose terms are ANDed together.

Match alists comprise pairs of words, similar to a dict, but with repetition permitted.  The name part of each pair may be a simple field name, in which case it represents a match for equality with the named field.

If the name part of a match alist is suffixed with **, * or %, it will be treated as a REGEXP, GLOB or LIKE field comparison, respectively.

The name part may also be suffixed with >=, <=, >, <, != or = to indicate the respective SQL comparison operator.

Despite its focus on simple matches and single table access, Store exports [db], [stmt] and [stmtL], providing unfettered access to the underlying database.  The stmt commands provide caching.

<<categories>>Enter Category Here