Re: [sqlite] thoughts on a web-based front end to sqlite3 db?

[Darren Duncan]

I suggest using a Perl 5.8 based solution.  Perl is very mature and 
has strong SQLite 3 support in its extensions (DBD::SQLite).  This 
will run on anything.  It also isn't dependent on Microsoft 
technology.  There are a number of pre-existing solutions on CPAN and 
elsewhere that you can look at for ideas, or for customizing. -- 
Darren Duncan

At 4:22 PM -0500 3/7/05, Eli Burke wrote:
I've been working on a project using sqlite3 since last fall. At the time,
I knew that it would need a web-based front-end eventually. I have a very
small bit of experience with PHP, and I assumed that PHP would support
sqlite3 sooner or later. Well, it's later, and as far as I know, PHP
is still using the 2.x branch.
So, I was wondering if any of the more opinionated among you would care
to suggest an interface language. It'll be on a Linux box, presumably
running apache although I'm open to alternatives. The app itself uses
sqlite3 for scheduling jobs and storing job data, so the web interface
only needs to be able to insert some data and do visualization
(pretty standard stuff I think).
Ease of learning is a plus as I need to get something basic up and
running fairly fast. I've heard good things about Python in that respect.
Does anyone have alternative suggestions, or if you agree that Python Is
Good, would you suggest using APSW, pysqlite, or something else?
Thanks,
Eli