Page 1 of 1

sqlite and web

Posted: Tue Sep 07, 2010 7:24 pm
by marcopuppo
I need to realize a web interface for a fantasy football game organized by a newspaper.

I create a sqlite database with all the tables and data inside.
I've made a rev studio stack that works pretty good on my mac.

I've create the standalone web app and uploaded it with the database in the same directory on the web.
If try to open it in a web browser i get always a connection error and the stack is "broken".

Is it possible to use a instruction like

Code: Select all

put revOpenDatabase("sqlite","www.website.it/fanta.db",,,,,,) into tConID 
?

What i need to change to make the stack work ?

Thank you

Marco

Re: sqlite and web

Posted: Tue Sep 07, 2010 8:56 pm
by bangkok
marcopuppo wrote:I need to realize a web interface for a fantasy football game organized by a newspaper.
We can assume that several users would access the database, through you web interface, correct ?

In that case, the easiest way is to set up a MySQL database plus a RunRev app, saved in "plug-in" format.

You seem to have access to a web hosting service. Look around : most of those services offer a MySQL database, with no surcharge.

Compared to SqlLite there is little difference. You queries should work in the same way. So no need to change anything, excepted the parameters for the command revOpenDatabase.