I have used Sqlite in a web application. It is called from C language
CGI programs running under Apache and performs very well. Its
simplicity and the fact that it only involves one file and is linked
with the CGI process makes it very appropriate for the short sessions
inherent with CGI. As far as multi-user contentions are concerned I
just make sure that it handles BUSY.
JS
Robert L Cochran wrote:
I have no experience with webhosts in this context, but I'm currently
using beta snapshots of PHP 5.1, SQLite 3.2.7, and Apache server, and it
is working great for me. I'm using the PHP Data Objects (PDO)
functionality that comes with PHP 5.1, it has hooks for SQLite. So what
is happening here is that I'm learning SQL itself, querying tables,
using new PHP extensions, building a web application, and learning a lot
from it all.
SQLite is not secure, but you can contact Dr. Hipp to discuss solutions
to this that you can license.
One thing I'm noticing is that my table inserts on SQLite are very fast.
I'm not sure if this is partly because of new PHP optimizations, the
fact that I statically built PHP instead of using shared extensions,
SQLite's optimizations or all these things. But things work fast.
I won't call myself an experienced database programmer just right now,
but I'm getting there. And SQLite is giving me a great education.
Bob Cochran
Jim McNamara wrote:
hi-
when thinking about software to use on my next website
i came up with sqlite,
http://www.freeguppy.org/articles.php?lng=en&pg=55044
,
php5, abyss webserver, and phpedit.
i dont see many webhosts that advertise sqlite
availability. are webhosts excluding support for
sqlite for any reason
i.e. is it a security concern?
it is suppose to be an internal extension. i am not
sure what that means yet.
do webhosts think it is easy to offer sqlite support?
is it less of an administrative headache for them to
offer it. i know there is less administration for a
user.
i hope this information can help me when i approach a
webhost when i am out shopping.
thanks for any tips.
jim
__________________________________ Yahoo! Mail - PC Magazine Editors'
Choice 2005 http://mail.yahoo.com
