[REBOL] Re: Using REBOL to navigate a database with a Browser
From: tim-johnsons::web::com at: 16-Jun-2008 12:42
On Monday 16 June 2008, Giuseppe Chillemi wrote:
> Hello,
> I have the following needs:
>
> I want to build a database of internet news and browse it. Actually I
> have it and it is file based but it is limited and I want to port to
> SQLLite and navigate it using a browser the way I do now and more.
>
> When I start the browser a navigation page must be opened. Then you
> select a news to start from or filter the database for a group of news.
> REBOL now it comes. It should receive the input from the browser and
> return:
>
> - the next news
> - the group of news filtered
> - the selection of a checkbox to change the news state into the database.
>
> I have actually no hints about the way to achive this. I know I have:
>
> IIS (Internet Information Server) into XP
> REBOL is able to work using CGI script
>
> I don't know:
>
> How CGI scripting works
> How to setup IIS to interact with REBOL using CGI
>
> Could you please help me ? Maybe I have to switch to somethin else like
> Cheynne. Please le me know.
>
> Thank you !
>
> Giuseppe Chillemi
Hi Giuseppe:
Any journey starts with a first step.
For servers:
Apache is also available for XP, in fact IIS might require a purchase?
Cheyenne is a rebol-based server. I can't speak about it, except that
the developer is the same developer (dockimbel) who developed the
rebol Mysql Protocol.
for scripts
http://www.rebol.com/docs/core23/rebolcore-13.html#section-8.6
Is an example of the first steps in setting up a CGI script
I recommend that you familiarize youself with the Common Gateway
Interface itself:
For rendering: You'll need a user inteface into your database, you will
need to learn the available options for render the interface, that is, how
to deliver the content upon request. Simple print statements can
deliver content but there should some templating options available,
as well as the 'ML dialect available from rebol.org in the scripts library.
Database access. My experience with rebol and databases - and that
is how I make my living - is with the MysqlProtocol system which
interfaces with MySQL. I'm not certain how mature is the sqlite/rebol
library.
Here's a link for a mysql driver:
http://softinnov.org/rebol/mysql.shtml
Here is cheyenne:
http://cheyenne-server.org/
If you go to www.rebol.org and choose scripts, you should be able
to find a driver for sqlite. You should also be able to find many
rendering options there. I highly recommend 'ML. I've used it for
years.
I hope this helps you get started.
Best regards
Tim
