OpenEuphoria

RE: data base access

• Posted by Jonas Temple <jktemple at yhti.net> Aug 03, 2001
• 421 views

George Walters wrote:
George,

Being that I have spent a lot of time with database.e developing similar 
apps to what you're working on I wanted to interject my thoughts:

If you are developing MULTI-user business apps (they are usually 
mult-user) with straight database.e then you are going to run into 
trouble.  The docs pretty much spell out that database.e is not intended 
for multi-user access.  Files opened with database.e don't share well 
and using record numbers to access data will eventually crash your 
progrram if you have more than one user accessing the same file.  

I suggest you check out me EDS/Net package on the contributions page.  
This allows multi-user access of database.e functions across an IP 
network.  It's by no means perfect but it seems to be pretty stable.  
Your wish list of additional functions:

> ic_record = db_read( db_opened_table[x], item_key) -- with one read and
> items 1-4 be taken care of internally.
> ic_record = db_readnext(db_opened_table[x])     -- to provide the next
> ic_record = db_readprev(db_opened_table[x])     -- to provide the 
> previous
> db_add_record(db_opened_table[x], ic_record) -- adding to file
> db_update_record(db_opened_table[x], somePartKey, somePartRecord)
> db_delete_record(db_opened_table[x], somePartKey)

are there as well!  

I am committed to continue improving EDS/Net.  I am currently working on 
speeding up record retrieval for large number of records.  The 
administration interface is also going to get a re-write.

Try it and see if it works for you.  I would also welcome any 
suggestions/feedback.

Good luck.

Jonas