OpenEuphoria

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
>
> >
> >
>
>