On 4/3/07, Vivek Rajan <[EMAIL PROTECTED]> wrote:
Hello SQLite Community-
For a personal project, I need to dynamically create HTML pages from an
on-disk SQLite database. I don't need cross-network capability, I just need
the ability to query and dynamically generate HTML from an on-disk SQLite
database on a localhost (stand-alone unix machine). I am using PERL as the
API for accessing/querying SQLite.
Has someone done something like this? Could you please post any code
snippets, suggestions and/or pointers for how to do this?
as some others have pointed, your question is very vague and diffused.
Do you want to generate HTML from SQLite or do you want to have an
HTML application that is populated with data from SQLite? The latter
is more common.
The best way is to separate the presentation from the content. This is
easily done using some kind of templating language. Since you are
already familiar with Perl, I would suggest using CGI::Application
(see <http://cgiapp.erlbaum.net/>) using the DBH plugin for SQLite,
which, of course, will require for you to have DBI and DBD::SQLite. In
fact, DBD::SQLite will automatically give you SQLite ready to go
out-of-the-box.
Google around for some standard Ajax code, or, I think there are even
some CGI::Application based Ajax plugins that you could use.
You could have your application ready and going in a few lines of
code. And, don't listen to anyone who points you to PHP when you
specifically ask for Perl ;-)
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
---------------------------------------------------------------------
collaborate, communicate, compete
=====================================================================
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
