[REBOL] Re: REBOL database
From: ric:getorbital at: 5-Sep-2001 18:55
Hi Ammon,
IMHO, the answer to your question depends a lot on the size and complexity
of the database, and the risks to it's integrity.
On one end, if the database only has a few tables, they are on the order of
thousands of rows, and no one will access the database _except_ through your
program, then REBOL is better than MSSQL. It is less overhead, easier to
write and just as fast (faster if the database can reside in RAM).
On the other end, if the database has, say, 100 tables, some of them contain
hundreds of thousands of rows, people need ad hoc reporting, and the
integrity of the database is critical to the business, then MSSQL is a
better choice.
A third alternative is MySQL, which is simpler and just as fast as MSSQL,
but doesn't provide as good of protection of the integrity of the data as
MSSQL.
Lately, I've been developing with REBOL and MySQL. The combination is
dynamite! DocKimbel's Rebsite offers an excellent library for working with
the two.
-- Ric