[REBOL] Re: dbms3.r
From: g:santilli:tiscalinet:it at: 14-Jan-2002 21:35
Hello Petr!
On 14-Gen-02, you wrote:
PK> OK, I can now see your point - however - starting to build
PK> dbms system and allowing it to be only one-user-per-time
PK> system, ie no locking, no concurency, etc., is a mistake in
Well, the mistake is in calling it "dbms"... :-) I can change that
to THF (Table Handling Functions) or anything seems more
appropriate.
PK> btw: what about Elan's dbms system? Wasn't
PK> it "distributed"? We should look in its principles then at
PK> least ...
It stores the data in a way similar to dbms.r (a bit better,
actually). It has better handling of references between tables,
but they need to be hard-coded IIRC. The query system of dbms.r is
more powerful IMHO.
PK> had with my XBase systems - so I decided to stop the work -
PK> too much complex for Rebol script level, reinventing the
PK> wheel....
Indeed, but that is not what *I* want --- I already use MySQL when
I need it. I'd be satisfied with the current dbms.r if it was able
to handle more than 1000 rows per table without starting to be
extremely slow (due to the fact that filesystems are not designed
to have some thousands of files in a directory... :).
PK> ... Maybe RT could license and pack it into rebol and we
PK> would be done :-)
:-)
PK> Just one question - where can I read more about your rdbms
PK> thoughts? I would like to know more about it. For me the one
[...]
Well... it always depends on the goal you have. In your case, even
MySQL might be limited (you may need triggers and referential
integrity); personally, I think that the relational model is
starting to be old. It is very simple, so it is very good; but can
we do better? I have some ideas, but nothing that can be put into
practice yet.
Regards,
Gabriele.
--
Gabriele Santilli <[giesse--writeme--com]> - Amigan - REBOL programmer
Amiga Group Italia sez. L'Aquila -- http://www.amyresource.it/AGI/