PDO mysql sqlite and sqlite2

[Jeff]

I've been writing all my utilities using PDO, and MySQL.

So, I'm working on a virtual server and I'm getting a missing driver
error. DSN look like this:

$DSN='mysql:dbn ame=...

PHP info does not show a mysql driver, but an sqlite and a sqlite2.

Now, I've Googled that and I can't seem to get beyond the chaff.

What is SQLite?

I don't have access to the php.ini files (that I know of). This is
php 5.2.4. What does it take to get the mysql driver? Is it likely a
php.ini change, or is this more work? The web host is BlueGenesis who I
long ago lost faith in... but we don't always get to choose our environment.

Jeff

[Tim Streater]

Re: PDO mysql sqlite and sqlite2

In article <JpydncsGNtjkfn rVnZ2dnUVZ_jmdn Z2d@earthlink.c om>,
Jeff <jeff@spam_me_n ot.comwrote:

I've been writing all my utilities using PDO, and MySQL.
>
So, I'm working on a virtual server and I'm getting a missing driver
error. DSN look like this:
>
$DSN='mysql:dbn ame=...
>
PHP info does not show a mysql driver, but an sqlite and a sqlite2.
>
Now, I've Googled that and I can't seem to get beyond the chaff.
>
What is SQLite?

https://www.sqlite.org

[Jeff]

Re: PDO mysql sqlite and sqlite2

Tim Streater wrote:

In article <JpydncsGNtjkfn rVnZ2dnUVZ_jmdn Z2d@earthlink.c om>,
Jeff <jeff@spam_me_n ot.comwrote:
>

> I've been writing all my utilities using PDO, and MySQL.
>>
> So, I'm working on a virtual server and I'm getting a missing driver
>error. DSN look like this:
>>
>$DSN='mysql:db name=...
>>
> PHP info does not show a mysql driver, but an sqlite and a sqlite2.
>>
> Now, I've Googled that and I can't seem to get beyond the chaff.
>>
> What is SQLite?

>
www.sqlite.org

Thanks,

Is there any reason not to use this? I can't see anything that it
doesn't do what I need. Apparently there is no char or varchar, only
text and there doesn't seem to be a limit on the number of characters
that can be indexed.

Jeff

[Tim Streater]

Re: PDO mysql sqlite and sqlite2

In article <Z7OdnWlMOO_03X XVnZ2dnUVZ_gWdn Z2d@earthlink.c om>,
Jeff <jeff@spam_me_n ot.comwrote:

Tim Streater wrote:

In article <JpydncsGNtjkfn rVnZ2dnUVZ_jmdn Z2d@earthlink.c om>,
Jeff <jeff@spam_me_n ot.comwrote:

I've been writing all my utilities using PDO, and MySQL.
>
So, I'm working on a virtual server and I'm getting a missing driver
error. DSN look like this:
>
$DSN='mysql:dbn ame=...
>
PHP info does not show a mysql driver, but an sqlite and a sqlite2.
>
Now, I've Googled that and I can't seem to get beyond the chaff.
>
What is SQLite?

www.sqlite.org

>
>
Thanks,
>
Is there any reason not to use this? I can't see anything that it
doesn't do what I need. Apparently there is no char or varchar, only
text and there doesn't seem to be a limit on the number of characters
that can be indexed.

I'm using it at home for a custom address database. Means I don't have
to run mysql for the purpose (although I have that too). This is under
OS X.