NEWBIE Q': Stacks in databases as BLOBs and RevCGI/RevHTTP

[ceg]

As a newbie I apologise for these questions in advance; but I've been drawn to Runtime Revolution after many successful (but drawn out) battles with Java, ASP.Net[albeit very briefly!] plus funtime flash backs to FORTH and ASM.

Just wondered if any of you specialists could point me in the right direction... particularly as database integration and RevHTTP/RevCGI drew me to Runtime in the first place....

(i) Is is possible to store an actual stack (the Transcript, Properties etc) as a BLOB in a SQLlite database. Clearly there would have to be a master stack that can load in pages.... but this would enable distribution of stacks.

(ii) I am interested in using RunTime Revolution as an http / CGI server...and have read about RevOnRockets, but RevHTTP.zip has disappeared. Is there anything else around, or any non-core libraries that could be jump started to get that approach "back on the rails"?

Looking forward to hearing your comments!

ceg

[Bernard]

Hi, and no need to apologise for being a newbie. We were all newbies once (even those experts who've been using hypertalk/transcript for 20 years or so...)

I've never done much with storing blobs in SQL databases, and I've only a passing acquaintance with sqlite -- that aside, there's no reason why you shouldn't be able to store a stack (including its code, properties, etc) inside a blob - a stack is just a file.

As for Andre's stuff going missing - I just checked and you're right - the site referred to in the Feb 2008 newsletter for RevOnRockets is down.

Pierre Sahores also came up with a mechanism for using Rev as a web application server - his technique was to use Apache-PHP-Rev-Postgresql, with PHP working solely as a conduit between Apache and Rev (using sockets). Unfortunately, I just searched for Pierre's tutorial and I can't find that on the web either.

One resource that help to you is this: http://www.hyperactivesw.com/cgitutorial/intro.html.

Bernard

[Bernard]

I just remembered that Pierre sent me an email with the URL for his tutorial.

http://www2.sahores-conseil.com/insead/index_en.html

Jacqueline's might be easier to follow. Pierre's system is designed to be massively scalable (it's used in some French government web application). also, obviously, Pierre's first language is not English, and some of the code uses French words as variable names, so that might also be confusing (my French is limited to no more than a few phrases!)

Bernard

[ceg]

Great stuff Bernard.

Have managed to download Pierre's but Jacquelines has also gone on a 404 yard walkabout.

Thanks for your help,

ceg

[Bernard]

Nope, Jacqueline is nothing if not professional - she knows people use that tutorial, and I'm sure if she moved it she'd let people know. It was my fault (or ths forum software) - there was a full-stop at the end of the URL, and it doesn't get stripped off if you just click the link (my fault, I think).

So, try this link:

http://www.hyperactivesw.com/cgitutorial/intro.html


Bernard

[ceg]

Bernard...

Perfect! Found Jacquelines notes.... very enlightening.

ceg

[TEDennis]

What happened to "RevOnRockets"?

It was highly touted prior to "runrevlive.08" and even had a download link in the February edition of the "Runtime Revolution Newsletter":

http://www.runrev.com/newsletter/februa ... etter2.php

RevOnRockets is *supposed* to be here:

http://www.andregarzia.com/RevOnRockets