The drop is always movingYou know that saying about standing on the shoulders of giants? Drupal is standing on a huge pile of midgetsAll content management systems suck, Drupal just happens to suck less.Popular open source software is more secure than unpopular open source software, because insecure software becomes unpopular fast. [That doesn't happen for proprietary software.]Drupal makes sandwiches happen.There is a module for that

The PDO SQLite challenge

Submitted by nk on Sun, 2008-11-09 18:27

I am willing to give 10 US dollars to the first ten people each who can point out a real webhost (you know, appearing in Google and relevant forums for some time -- nominating the webhost that you run is not nice!) which

  1. Has PHP 5.2.
  2. Has PDO.
  3. Does not have the PDO SQLite driver on. ( Run print_r(PDO::getAvailableDrivers()); to see the drivers available.)
  4. Unwilling to switch it on after a polite request explaining that the award winning Drupal CMS would like to make pdo-sqlite a requirement in its next release.

Send applications to chx1975 at Google's excellent mail service.

Edit: given that noone came, I am changing the rules. 25 dollars to the first four.
Edit2: On Debian, php5-sqlite3 provides the new sqlite3 extension which we do not support. Install php5-sqlite.
Edit3: so far, have been proved not supporting PDO_SQLITE.

Commenting on this Story is closed.

Submitted by Mike_Waters on Sun, 2008-11-09 21:14.

Why don't you use a VPS? That way, you can configure it however you like.
You can get a dedicated VPS from Slicehost for $220 per year.

Submitted by on Sun, 2008-11-09 21:44.

The question is not about finding a host for the author, it is about assessing the compatibility of an enhancement to the next version of Drupal Core across a wide variety of hosting providers.

Submitted by robertDouglass@... on Mon, 2008-11-10 08:21.

Sometimes webhosts have to be urged to invest some time and effort in offering a PHP product that is friendly to the developers of open source software. If chx can come up with enough evidence that PDO/SQlite support won't be a painful technological barrier from the web hosts, he can argue in Draupl 7 development that we can feel free to build features which depend on it.

Submitted by on Mon, 2008-11-10 12:58.

SQlite support is installed as part of PHP5.2+ by default. That means we should have it. Any webhost that intentionally takes it out (which they would have to) should be kicked and publicly rebuked.

I'm inclined to say we just run with it. We assume the filter functions, regex libraries, and other parts of default php are there. Why not assume sqlite support is there.

Submitted by Garrett Albright on Mon, 2008-11-10 16:51.

PHP's "default" SQLite is not the same as PDO's SQLite. The SQLite accessible through PHP's sqlite_*() functions creates and works with SQLite 2 databases, whereas PDO's SQLite functionality works with SQLite 3 databases. The latter is definitely preferable.

Submitted by Anonymous on Thu, 2009-10-22 01:49.

Choose, buy and shop for on sale tiffany jewelry including Tiffany & Co Silver Necklace, Pendants, Bangles, Bracelets, Earrings, Rings and Accessories.
tiffany jewelry
We will surprise to find the high quality tiffany jewelry in much.
Everyone will focus on tiffany and co
Tiffany Bracelets
Tiffany Earrings
Tiffany Necklaces
Tiffany Rings

Submitted by Anonymous on Sat, 2009-10-24 02:11.

I'm assuming you have tried hostgator? I'm not a programmer but I used it along with Drupal for my cheap wsj subscription website in the past and it worked great.

Submitted by Anonymous on Fri, 2009-07-24 09:27.

all the certification should be upto the mark and having the 642-456 dumps
and along with this the next one which comes after are 350-040 dumps and 70-238 dumps

Submitted by Briace on Mon, 2009-10-19 09:40.

discount jewelry
cheap jewelry
handmade jewelry
discount fashion jewelry
china jewelry
wholesale jewelry
wholesale discount jewelry
cheap costume jewelry
handcrafted jewelry

Submitted by Anonymous on Wed, 2009-10-14 11:01.

That is too much money.

Best of luck

email spider software by

Submitted by nicholasThompso... on Mon, 2008-11-10 09:07.

I've heard of SQLite being used on mobile devices for things like repository information... but why should it be made a requirement for D7 if its such a hard thing to come by?

Is there not an argument here that it would be using a technology for the sake of it? Why is it better than MySQL?

Submitted by nk on Mon, 2008-11-10 15:09.

With MySQL you need to support credentials. With SQLite you do not need to. With MySQL, it is quite possible that it is on a different server and we need to cope when that's down. SQLite is a part of PHP, it's always there so Drupal can always rely on something that understands SQL being there.

Submitted by Garrett Albright on Mon, 2008-11-10 16:56.

nicholas, it seems you have a gross misunderstanding of just what SQLite is used for… but you're hardly alone in that regard. It's not hard to come by at all. Odds are you're using software which makes use of SQLite right now, even if you don't realize it. Check out this list for some common uses of SQLite.

And as nk mentioned above, SQLite has lots of benefits over MySQL. I'll add one more. Since all database information is stored in a single file, database backup and restoration is a breeze; just copy or move the file in the operating system as you would any other file. No need for creating and reading dump files. It also makes it possible for large database files to be backed up incrementally by rsync and the like.

Submitted by on Tue, 2008-11-11 06:14.

When I run
I get
Array ( [0] => sqlite [1] => sqlite2 [2] => mysql )

There's nothing there about sqlite3. So does this qualify as one such host?

Submitted by Garrett Albright on Tue, 2008-11-11 16:10.

The unqualified "sqlite" is SQLite 3. The SQLite 2 driver is an optional (I believe) driver for backwards compatibility.

Submitted by lstroobant@drup... on Sat, 2009-02-07 20:01.

Array ( [0] => mysql )

As I already wrote on the mailinglist, sqlite requires a separate package php5-sqlite3.

Submitted by on Sat, 2009-02-07 20:15.

I have in fact found a qualifying host that does not support SQLite, and have emailed chx with the details.

Submitted by on Sun, 2009-02-08 21:40.

A webspace doesn't have it:

Array ( [0] => pgsql [1] => odbc [2] => mysql )

I've opened a support request to see if they will turn it on. Will report back their response.

Submitted by on Thu, 2009-02-12 06:02.

Response from support

Response (Josh V.) - 02/11/2009 08:55 PM
I'm sorry we do not support that.

Thank you

Submitted by Anonymous on Thu, 2009-10-08 02:29.

That means we should have it. Any webhost that intentionally takes it out (which they would have to) should be kicked and publicly rebuked. I'm inclined to say we just run with it.
club penguin cheats

Submitted by Anonymous on Wed, 2009-07-22 05:43.

I think its VPS.

Submitted by Anonymous on Fri, 2009-07-31 14:31.

I personally have had bad experiences with ACCOMMODAT, another occasion you may be able to earn those 10 dollar.
Thanks so much !!
poker online

Submitted by Anonymous on Thu, 2009-08-06 07:16.

How difficult to get 10 US by your requirement, not easy to find.

rahsia perniagaan internet

Submitted by Anonymous on Thu, 2009-09-10 12:26.

Not the easy problem to find a hosting meeting your requirements. But 25 dollars on road do not roll. I will try to help you. My blog - rakeback.

Submitted by Anonymous on Sun, 2009-09-27 11:32.

I am totally agree with you.

Andrew Max, "Online Poker Bots"

Submitted by Anonymous on Fri, 2009-09-18 01:09.

Choose, buy and shop for on sale tiffany jewelry including Tiffany & Co Silver Necklace, Pendants, Bangles, Bracelets, Earrings, Rings and jewelryTiffany Bracelets

Submitted by Anonymous on Fri, 2009-10-02 18:01.

nice post thanks

Submitted by Anonymous on Fri, 2009-10-09 18:47.

i do not know of any with these features. I would love to have
these features with my webhosting. This would definitely make
things easier.

Submitted by lekii on Wed, 2009-10-14 15:02.

Tiffany Jewellery offering bangle jewelry, bracelet jewelry, eardrop jewelry, necklace jewelry, ring jewelry, finger ring jewelry and earring jewelry
Tiffany Necklaces
Tiffany Bracelets
Tiffany Style Silver Jewelry: Rings, Earrings, Necklaces, Bracelets and more Tiffany Jewelry at low prices
Tiffany and co
Links of London, the leading British contemporary jeweller was founded in 1990 by jewellery designer Annoushka Ducas and her husband John Ayton. Excellent craftsmanship, generous tactile forms and the use of the finest materials remain integral to each collection.
links of london store
links of london

Submitted by Anonymous on Thu, 2009-10-29 16:29.

Nice article.

Gregor S.
Free SMS senden