[REBOL] Re: dbms3.r
From: petr:krenzelok:trz:cz at: 13-Jan-2002 23:17
Gabriele Santilli wrote:
>I still think a small REBOL dbms can be useful. I've been using
>MySQL a lot, and I'm not going to abandon it... but it's not
>always the best solution IMHO.
OK, I can now see your point - however - starting to build dbms system
and allowing it to be only one-user-per-time system, ie no locking, no
concurency, etc., is a mistake in its roots imo ... btw: what about
Elan's dbms system? Wasn't it "distributed"? We should look in its
principles then at least ...
... I started to build rebol dbms system in Rebol alpha (pre 1.0 days)
and I had it almost working. But then I was not satisfied and wanted
even more functionality, so I added another functionality ... and so on
... and so on ... in the end I found out, that what I want to have is
what I already had with my XBase systems - so I decided to stop the work
- too much complex for Rebol script level, reinventing the wheel....
If e.g. mySQL embedded (libmysqld) is free, small enough, but robust,
available in sources and already multiplatform, I can still see the
point to have a wrapper, and I will link to it one day, once I proceed
with my C lang knowledge. The main advantage is, that it is developed by
the whole community of dedicated programmers, so I can concentrate on
other things ... Maybe RT could license and pack it into rebol and we
would be done :-)
Just one question - where can I read more about your rdbms thoughts? I
would like to know more about it. For me the one and only view of dbms
is that of data consistency. We built our sales department IS in
CA-Visual Objects. It used XBase .dbf files and foxpro indices (.CDX).
We thought it was robust enough. We put our databases onto Novell
Netware server, and our users were connected thru old Token-Ring network
The network was problematic. We stopped the testing phase, because our
databases became complete mess in less than two weeks. Once you have
some even small cross table relationships, and you have not transaction
support and roll-backs, you are dead. Inconsistent data = dead data = no
data. NEVER AGAIN :-) No data corruption since we switched to Advantage
Database Server - the "complexity" outweights "simplicity" in factor
more than 1000 times for us ....