Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search

[REBOL] Re: dbms3.r

From: petr:krenzelok:trz:cz at: 13-Jan-2002 23:17

Gabriele Santilli wrote:
>Hello Petr! > >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 .... -pekr-