circle.ch :: [RT] Handling SQLite remote files with PHP

circle.ch weblog by Urs Gehrig

A weblog about libre software, law, technology, politics and the like.

2010-03-10T17:24:49

Academic, Apache, Apple, Art, Best Of, Biotech, Civil Society, Content Management, Cooking, Copyright, Creative Commons, Crosspost, Culture, Database, Deutsch, DRM, Economy, Education, Event, Gadget, General, Geodata, Government, Health, Howto, Humor, Innovation, Intellectual Property, Java, Language, LaTeX, Law, Linux, Media, Moblog, Mozilla, Music, Office, Open Content, Open Source, P2P, PHP, Podcast, Politics, Privacy, Projects, Random Thought, Rant, Science, Search, Social Network, Software, Sport, Talks, Technology, Technology Transfer, Travelling, Weblog, Wiki, Wireless and Mobile, XML

27. February 2004

[RT] Handling SQLite remote files with PHP
PHP (wiki) | Open Source (wiki) | Wiki (wiki) | Random Thought (wiki) - urs @ 10:38:28

First I have to clarify the [RT]; Bertrand Delacrétaz [1] mentioned at LOTS, that he indicates "random thoughts" in mailinglists as "[RT]". I like that idea, because the title to this blog post does not mean to be a new feature in the PECL sqlite extension but generally a random thought of mine. I started a new project on sourceforge called wikita [2]. It is a common playground for me to set up a simple wiki based on PEAR classes where ever possible. Since I have started the PEAR sqlite DB wrapper earlier, it needed some more testing. Wikita from that point of view is also a testbed for this wrapper.

Just the other day I checked in some code into the CVS of sourceforge. The code is not much more than a hack for now. Anyway. To come to the point of this post: SF does not yet support the sqlite extension. So the title here suggests that there could/should be a way to handle sqlite remote database files. PHP does allow to handle remote files but IMHO the sqlite extension does not. If this is secure or not is to discuss afterwards. PHP5 will generally offer sqlite support. Nevertheless I ask myself if there are any applications that would make sense to have sqlite databases handled remotely. Maybe for portable devices such as mobile phones or handhelds, if they ever offer PHP support (some actually _do_ offer already Python [3]). Since they offer limited storage space, it could be a solution. Contradictions, comments?

[1] http://codeconsult.ch/bertrand/
[2] http://sourceforge.net/projects/wikita
[3] http://www.mobilewhack.com/programming/python/python_on_nokia_screenshots.html