Re: data base access
- Posted by George Walters <gwalters at sc.rr.com> Aug 03, 2001
- 462 views
Thanks Jonas, you're right that eventually the multi-user issue has to be solved. I have looked at your eds/net, and you do have some more direct access to records but the 'current table' issue would still be a problem in a program reading from so many different data bases. ..george ----- Original Message ----- From: "Jonas Temple" <jktemple at yhti.net> To: "EUforum" <EUforum at topica.com> Subject: RE: data base access > > > > 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 > > > > > > >