ANN: RebDB Pseudo-Relational Database

[1/11] from: atruter:labyrinth:au at: 26-Jan-2004 14:58

Hi all, Many folks on this list use REBOL for any number of unique and complex tasks, but when it comes to a "real" database we tend to discount REBOL almost out of hand. While the cookbook "Micro database" is a good starting point, it doesn't cut it for more demanding tasks. Some time ago I set out to fill this gap, and am now proud to release the fruits of my labour: RebDB v1.0, free for both commercial and non-commercial use. Software, plus extensive documentation, can be found at: http://www.dobeash.com/RebDB/ If there is sufficient interest, I'll see about an AltME / REBOL Forum presence. Regards, Ashley<

[2/11] from: yeksoon:neuSteps at: 26-Jan-2004 14:10

Is there a way to mix select and order clause in the db-select statement? Thanks YekSoon http://neusteps.com B.efficient. B.Serve On Mon, 26 Jan 2004 14:58:09 +1100, Ashley Tr=FCter wrote

[3/11] from: atruter:labyrinth:au at: 26-Jan-2004 21:39

Hi YekSoon,

> Is there a way to mix select and order clause in the db-select statement?

Ah, not sure what you're asking here, but if you want to use multiple refinements then that's OK: db-select/where/order/desc [date id] my-table [id < 5] id or, if you want to change the order in which they are provided, that's fine too: db-select/desc/order/where [date id] my-table id [id < 5] If that doesn't answer the question, please provide an example of the usage you are attempting. Thanks for taking the time to read the doco! ;) Regards, Ashley<

[4/11] from: petr:krenzelok:trz:cz at: 26-Jan-2004 13:38

Ashley Tr=FCter wrote:

>Hi all, >Many folks on this list use REBOL for any number of unique and complex

<<quoted lines omitted: 9>>

>Regards, > Ashley

Now it will be interesting to see performance comparison of your database vs. DyBase one :-) -pekr-<

[5/11] from: greggirwin:mindspring at: 26-Jan-2004 9:30

Thanks Ashley! I can't wait to check it out. -- Gregg

[6/11] from: andreas:bolka:gmx at: 26-Jan-2004 18:14

Monday, January 26, 2004, 4:58:09 AM, Ashley wrote:

> Some time ago I set out to fill this gap, and am now proud to > release the fruits of my labour: RebDB v1.0, free for both > commercial and non-commercial use. Software, plus extensive > documentation, can be found at: http://www.dobeash.com/RebDB/

Congratulations, Ashley! -- Best regards, Andreas

[7/11] from: jason:cunliffe:verizon at: 26-Jan-2004 14:01

> Some time ago I set out to fill this gap, and am now proud to release the > fruits of my labour: RebDB v1.0, free for both commercial and > non-commercial use. Software, plus extensive documentation, can be found > at: http://www.dobeash.com/RebDB/

Wow great to see this work you've done, and especially with so much nice documentation already with its first release. Thank you - Jason

[8/11] from: gedb01:y:ahoo at: 27-Jan-2004 0:21

> Monday, January 26, 2004, 4:58:09 AM, Ashley wrote: > > Some time ago I set out to fill this gap, and am

<<quoted lines omitted: 5>>

> > documentation, can be found at: > http://www.dobeash.com/RebDB/

Ashley, RebDB is very impressive, and exactly what I've been looking for. The documentation is particularly good, too. DefiantPC has been good enough to add a RebDB forum at RebolTalk. Thanks, Ged ________________________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html<

[9/11] from: cybarite::sympatico::ca at: 27-Jan-2004 6:04

Ashley Thanks for the database work. If there is sufficient interest, I'll see about an AltME / REBOL Forum presence. I would like to use an AltME group for this.

[10/11] from: atruter:labyrinth:au at: 28-Jan-2004 10:48

Ged,

> DefiantPC has been good enough to add a RebDB forum at > RebolTalk.

Thanks, I'm using that now. Cybarite,

> I would like to use an AltME group for this.

REBOL Talk got in first, and it's a bit more accessible IMHO. Pekr,

> Now it will be interesting to see performance comparison of your > database vs. DyBase one

Not really. They have radically different design goals and implementation's, and are optimised for different tasks and data volumes (RebDB being optimised for simple searches in the 10,000 - 1,000,000 record range). Graham,

> Wouldn't work. I read that RebDB uses fixed length fields > whereas I need varchar type fields.

need varchar is true if you need to store something like the email body text *and* you want the DB to operate on it with statements such as soundex, like, etc. If, however, it is the header data you need to operate on and you merely need access to the underlying body text when specific records are retrieved then storing file! references to individual text files (perhaps compressed) has its own advantages: among them the fact that incremental backups are a lot easier! I'm not trying to convince anyone of anything in particular, it's just that I've worked with enough DBA's to know that sometimes storing *everything* in the database is not the best solution: the more successful solutions I've come across play to the strengths of both the DB *and* the underlying file system. -------------------- On a final note, thanks for all the positive feedback. We now return you to your regular program schedule (please move any future RebDB discussion off-list to the RebDB forum at REBOL Talk). Regards, Ashley<

[11/11] from: gchiu:compkarori at: 28-Jan-2004 9:52

On Wed, 28 Jan 2004 10:48:44 +1100 Ashley Tr=FCter <[atruter--labyrinth--net--au]> wrote:

>"need varchar" is true if you need to store something >like the email body

<<quoted lines omitted: 9>>

>them the fact >that incremental backups are a lot easier!

Yes, I guess that would work as well. But I haven't read RebDB docs yet, so don't know what wonders we can do :)

>solutions I've come across play to the strengths of both >the DB *and* the >underlying file system.

well, having just moved thousands of message.r files in IOS from hard drive to USB to hard drive ... I think sometimes the file system can be overused! BTW, this is all on topic :) -- Graham Chiu http://www.compkarori.com/rebolml/<

Notes

Quoted lines have been omitted from some messages.
View the message alone to see the lines that have been omitted