wondering about sqlite and webhosts

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

wondering about sqlite and webhosts

thirdshiftcoder
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
Reply | Threaded
Open this post in threaded view
|

Re: wondering about sqlite and webhosts

Robert L Cochran
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
>
>
>  
>

Reply | Threaded
Open this post in threaded view
|

Re: wondering about sqlite and webhosts

thirdshiftcoder
Hi Bob-
thanks for the great info.

I will try to word this part more carefully.
I am not worried about the information in my DB being
secured or i would just use mysql. Sometimes a webhost
wont use software like some tcl extension or other for
various reasons including but not limited to security
on their servers.  I am just trying to see how a
webhost might look at the possibility of sqlite on
their system.  I'm guessing because php5 is new that
because most webhosts are still running php4 on shared
hosts that it may be a reason why sqlite is not listed
on many hosts feature list yet.  Or maybe they just
assume and it goes without saying that it would be
easy to add sqlite to someones account.  

Most stuff i would do is used with minimum security
because i am not an expert enough to warrant that
someones information is secure (because my
understanding of security is rather limited).

I might want to secure access to the page where i
enter the data though.  I wouldnt want anyone to be
able to insert data into the database.  Just read
only.

i will be making some inquiries to 1stchoiceweb and
olm.net about sqlite.

thanks very much,
jim

>
> SQLite is not secure, but you can contact Dr. Hipp
> to discuss solutions
> to this that you can license.
>



               
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
Reply | Threaded
Open this post in threaded view
|

Re: wondering about sqlite and webhosts

Clay Dowling
In reply to this post by thirdshiftcoder

Jim McNamara said:

> 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.

Because SQLite doesn't have a database server it isn't likely that hosts
will advertise support for it.  The support you get will mostly be from
the language you use for your application.  For an example check out my
own application (in my signature below).  I staticly link SQLite against
my CGI program (I write in C++), so it doesn't matter whether or not the
web host supports SQLite.

Clay
--
Simple Content Management
http://www.ceamus.com

Reply | Threaded
Open this post in threaded view
|

Re: wondering about sqlite and webhosts

John Stanton-3
In reply to this post by Robert L Cochran
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
>>
>>
>>  
>>
>