Re: [sqlite] wondering about sqlite and webhosts
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=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
Re: [sqlite] wondering about sqlite and webhosts
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
Re: [sqlite] wondering about sqlite and webhosts
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
Re: [sqlite] wondering about sqlite and webhosts
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=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
[sqlite] wondering about sqlite and webhosts
hi- when thinking about software to use on my next website i came up with sqlite, http://www.freeguppy.org/articles.php?lng=en=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