OpenEuphoria

RE: data base access

• Posted by Matthew Lewis <matthewwalkerlewis at YAHOO.COM> Aug 03, 2001
• 432 views

--- Jonas  Temple <jktemple at yhti.net> wrote:
> George Walters wrote:
 
> One thought would be to pass the database/table to each record access 
> function in database.e.  For example:
> 
> record_data = db_record("mydb", "mytable", record_number)

This is the approach I've taken with EuSQL, where an empty string indicates to
use the current db/table.  (It's possible to do everything through straight SQL
commands or using the API functions to manipulate a db).

> Rob, hoping that you read this, I would like to again request a thought 
> on indexes withing database.e.   What do you think?

I'm in the process of getting indexes to work with EuSQL.  I've picked it up
again, and have squashed a few bugs, and improved some other things, like how
it handles 'where' clauses.

My approach to indexes is to have a 'system' table, 'INDEXDEF', in which each
index is stored.  Queries can then use the index to quickly do (large) joins on
the data.  I'm actually using Jiri's a-list code to handle the indexes, which
are stored with the indexed value as the list-key, and the list-data being a
sorted list of the record keys which correspond to the value.  Each record in
INDEXDEF is an index on a field.




=====
Matt Lewis
http://www14.brinkster.com/matthewlewis