RE: RDMS Database's and/or Record Managers What good is Euphoria?
> From: Euman
> >
> > I doubt this is what Ray meant by 'security' (because it's not
> > what I'd mean if I mentioned RDBMS security :). Commercial RDMBS
> > (Oracle, SQL Server, etc) allow administrators to set up users
> > and grant permissions to them based on activity (SELECT, UPDATE,
> > DELETE, etc) and by table.
>
> Wouldnt this be the same or similar to writting custom
> in-code queries Matt?
Sorta. We're really talking apples and oranges here, though. By
commercial RDBMS I assume that you've got a client-server architecture,
multi-user, etc. A lot of what you've been talking about applies more
to the SQL engine under the hood of the RDBMS.
> You are only limited by your imagination and experience using
> Tsunami. I sure would like for you to look at tsunami and
> make suggestions ;)
I agree. In many ways it's similar to EDS, which I like for the (self
important?) reason that it's 100% Euphoria, extremely simple, and pretty
fast for what it does. I haven't taken too much time to try, but
Tsunami's key's and search stuff confuses me a bit.
> I can see that I need to complete the demo section of the
> wrapper docs an add a snippet that will allow certain users,
> certain rights to certain data. I can see that a seperate
> table would be needed for this which would be the same for those
> commercial grade RDBMS. I guess what Im saying is that I dont
> see need based on my limited knowledge of DB's to have a
> bloated RDBMS unless perhaps its a very large project
You're right. The full database management system is really only needed
when you need it. :) As for using a Btrieve-like record manager vs a
SQL-based relational database, however, it may come down to personal
preference, at least on the types of projects that are worked by the
people on this list. I'm personally more comfortable with SQL, so
that's what I tend to use. Apparently I like it so much that I've built
my own SQL engine to sit atop EDS. As you've noted, something similar
could be done with Tsunami.
> Also, a good idea would be to write a GUI that list users and
> rights. I suppose that would be likened to having database
> normalization and planning ahead.
>
> Matt, please let me know what Im missing here..
I dunno. Depends on what you want to do. I'm not sure what you mean by
'likened to having database normalization and planning ahead.'
Matt Lewis
|
Not Categorized, Please Help
|
|
