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

Local database engine

 [1/7] from: sanyi::attglobal::net at: 13-Oct-2001 17:58


Is there a local database engine in Rebol where I could store data pulled from Oracle MSSQL etc. Anybody implemented a data manipulation solution under Rebol? TIA Sanyi

 [2/7] from: greggirwin:mindspring at: 14-Oct-2001 10:28


Hi Sanyi, << Is there a local database engine in Rebol where I could store data pulled from Oracle MSSQL etc. Anybody implemented a data manipulation solution under Rebol? >> There's REBOLBase, but I haven't played with it yet myself so I can't tell you anything about it. --Gregg

 [3/7] from: kenlo:myrealbox at: 17-Oct-2001 10:09


2001/10/13 AM 10:58:30, "Sanyi" <[sanyi--attglobal--net]> wrote:
>Is there a local database engine in Rebol where I could store >data pulled from Oracle MSSQL etc.
ODBCSocketServer is the way. Quite stable on my win98.

 [4/7] from: office:thousand-hills at: 17-Oct-2001 9:29


Gregg: I am using the REBOL "name value pair" database but are using the ASCII data array most. That said, Prasad (who reads this list from time to time) imports the ASCII Space CSV (comma separated values) to send data directly into Oracle, I have the same process working with a dBASE DBF based program. We also use ASCII tab delimited arrays manipulated by REBOL to post our schedules to the Web for our blind riders-ship. Gregg, you helped write that code, remember? All that said, REBOL has the ability to interact directly with SQL and Oracle with and without the use of ODBC (That's my understanding). Prasad will post that procedure here once we get one working. John At 10:28 AM 10/14/2001 -0600, you wrote:

 [5/7] from: office:thousand-hills at: 17-Oct-2001 9:10


Gregg: We are working on SQL and Oracle interface here -but we decided to stop until we purchase order the product (in the hopper now). I will let you know when we move on that. Do you have a specific question, we have several Oracle Programmers here, two of the best are on the Web Team Support and work with me. John At 10:28 AM 10/14/2001 -0600, you wrote:

 [6/7] from: greggirwin:mindspring at: 17-Oct-2001 10:30


Hi John, <<Do you have a specific question, we have several Oracle Programmers here, two of the best are on the Web Team Support and work with me. >> Actually, someone else (Sanyi) asked the original question but I'll definitely keep you in mind for the the future. :) --Gregg

 [7/7] from: sanyi:attglobal at: 17-Oct-2001 12:24


John The implementation of a local database engine in Rebol would decrease the traffic over the connection significantly. The data could be pulled in a chunk and manipulated further locally. Since we do not expect data sets larger than 10MB even a rudimentary local engine with SQL capabilities can do the job. (Larger data sets should be manipulated on the backend) Not going back to the backend (or original data source) every time when you start a new query can save lot of time when you have limited bandwidth. Thank you for your contribution Sanyi