BBSysco development log 
Business Basic Systems Corporation

August 7, 2007

Researching -= and +=

Filed under: Coding — Mike King @ 12:05 am

We spent some time today working out the implementation of the -= and += logic.  These (and ultimately the *=, /=, ++ and –) all pose some issues for the syntax parser.  Currently when a symbol is detected (non-alphanumeric) the logic looks at the first character and from that determines what the internal code should be.  We need to change the logic slightly to handle these multi-character codes.  To do this we will basically steal the logic around the : ( which is used for input validation.

We also spent some time looking into MySql and in particular Berkley DB.  While this is now be owned by Oracle, the Berkley DB interface looks like it could be easily adapted to handle a Business Basic style file system.  The records are dynamic is size and key segments values are defined by the caller.  This might be a way to bring Database technology to MicroShare while avoiding the need to generate SQL which itself causes quite a bit of overhead.  Still are anticipating a MySql interface — but a direct Berkley DB may be a interesting offering.

3 Comments »

  1. The BDB interface is a good idea.
    Here are a few links to other light-weight SQL engine available, if you’re interested :
    Mini SQL (mSQL) : http://www.hughes.com.au/products/msql/
    SQLite : http://www.sqlite.org/

    Comment by Stéphane — August 7, 2007 @ 2:07 am

  2. Beware there is a bug with Berkeley DB if you declare a transaction with no data in the file. I need to upgrade to the latest version that may have this fixed. I think Berkeley DB is a smart choice as a BB file system substitute.

    John

    Comment by John — August 7, 2007 @ 4:53 am

  3. Thanks for the info on Berkley DB… and I’ll check out the other SQL offerings although MySql is likely what we will focus on.

    Comment by Mike King — August 7, 2007 @ 11:49 am

RSS feed for comments on this post. TrackBack URL

Leave a comment

You must be logged in to post a comment.

Powered by WordPress