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

[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