Using REBOL to navigate a database with a Browser
[1/5] from: gchillemi::aliceposta::it at: 16-Jun-2008 21:55
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
[2/5] 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:
<<quoted lines omitted: 18>>
> 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
[3/5] from: nick::guitarz::org at: 17-Jun-2008 21:32
I'll second the suggestion to look at MySql and Apache. I wrote a
little section about using Rebol through CGI here:
http://musiclessonz.com/rebol_tutorial.html#section-26
There are also several CGI case study examples here:
http://musiclessonz.com/rebol_tutorial.html#section-31
And another section that has some basic info about setting up and
using Apache/MySql here:
http://musiclessonz.com/rebol_tutorial.html#section-27
It's really basic, but may be helpful as a quick jump start. Good luck!
- Nick
Quoting Tim Johnson <tim-johnsons-web.com>:
[4/5] from: moliad::gmail::com at: 18-Jun-2008 21:12
I'll jump in for the apache/mysql setup... for no other reason than
the fact they work well, are available on almost every server on the
web and are easy to setup for newbies, as all you need is either in
the docs or right in the config files.
cheyenne is also cool, and has definite speed benefits for rebol, but
getting your own server installed on shared servers is usually not
possible... so before you invest time, make sure you'll be able to use
it online afterwards.
-MAx
On Wed, Jun 18, 2008 at 12:32 AM, Nick Antonaccio <nick-guitarz.org> wrote:
[5/5] from: gchillemi::aliceposta::it at: 25-Jun-2008 23:05
> I'll jump in for the apache/mysql setup... for no other
> reason than the fact they work well, are available on almost
<<quoted lines omitted: 4>>
> servers is usually not possible... so before you invest time,
> make sure you'll be able to use it online afterwards.
Probably I'll proceed for Cheyenne/SQLLite. I need a local browser and not a
pubblic one. The news I download are only needed by me.
Another option would be to use .NET and a Internet Explorer component to
show the news moving the navigation buttons outside the browser.
I need to choose the way to go.
Giuseppe Chillemi
Notes
- Quoted lines have been omitted from some messages.
View the message alone to see the lines that have been omitted