PHP SQLite3

[coelmay]

Hi all,

I do all my dev work on a Mac (10.6.8) which runs php 5.3.6 as opposed to 5.2.9 on crucial. This has caused a couple of minor issues in the past, but I've overcome them easily.

Now, not so.

I have created a simple script which utilises an SQLite3 database and have it working on my system.

The main class goes something like this:

class myclass extends SQLite3 {

    public function __construct() {
        $this->open("/path/to/sqlite3.sq3");
    }

     // more code here
}

But when I view the page once uploaded, I get

Fatal error: Class 'SQLite' not found in ....

Looking through the output of phpinfo() it says SQLite3 is enabled (though there is a PECL entry which according to the php manual PHP: Installation - Manual is only recommended for experimental use).

I am wondering if there is a configuration option I'm missing? Or maybe it is something to do with being on a "free" hosting account and not having the ability to have SQL databases (which I could understand if I was using a MySQL server, but SQLite3 is a single file, no server needed)?

Any/all solutions welcome.

EDIT:
It seems SQLite3 is not enabled after all as there is not an "sqlite3" entry in phpinfo() output (I'm comparing my output to crucial's output). There is a PDO driver for sqlite 3.x but this is a different thing, and works in a different way, am I correct?

Given this, is it possible to add SQLite3 or is this a compile-time configuration thing?

[ross]

Hi coelmay,

This all depends entirely on what service you are currently hosted on.

If you are on our Business Hosting or Reseller Hosting the quick answer is no, as we set up these services to support a particular array of requirements, major changes are generally not done unless there is a huge demand / requirement.

Both the above mentioned hosting solutions support a wide variety of customer requirements however if you are running something that does not fit the above solutions we would recommend looking at getting a VPS solution where you can custom configure your additional requirements as you see fit.

[coelmay]

Ross,

This all depends entirely on what service you are currently hosted on.

I did mention what plan I am on: Free

If you are on our Business Hosting or Reseller Hosting the quick answer is no, as we set up these services to support a particular array of requirements, major changes are generally not done unless there is a huge demand / requirement.

This I can understand—customising everything for every user would be time consuming to say the least.

Both the above mentioned hosting solutions support a wide variety of customer requirements however if you are running something that does not fit the above solutions we would recommend looking at getting a VPS solution where you can custom configure your additional requirements as you see fit.

Unfortunately apart from the cost factor of the VPS solutions (not saying they are expensive, just I'm not that endowed with cash), I don't have such high needs (my bandwidth last month was about 1/50th of that available on the free hosting solution).

Not to worry. I'll just have a play with MySQL and if I'm happy with the result, will consider upgrading to Business Hosting.

Thanks.

[ross]

Hi coelmay,

Sure not a problem. I missed your comments about the Free hosting, my apologies, clearly time for a caffeine hit of some kind!

[coelmay]

Originally Posted by ross

Hi coelmay,

Sure not a problem. I missed your comments about the Free hosting, my apologies, clearly time for a caffeine hit of some kind!

Just had one of them myself

[adrinasaige]

I moved it to a backup, and then tried a clean install; I was running sqlite3 as my db without a problem and so something is not right. With the clean install; if I picked sqlite3, it'd act like it was about to install, but it would then just go to a blank page after I click "Complete Install". If I pick sqlite instead of sqlite3, it will install. Running a phpinfo() shows that sqlite3 support is one, and the initial install page confirms that sqlite3 is supported (or at least confirms the extension is on).