Connecting Tech Pros Worldwide Forums | Help | Site Map

SQLite DB using without SQLite Extension

Cafer Şimşek
Guest
 
Posts: n/a
#1: Sep 5 '05
Hi all,

I want to use SQLite databases to my site. But the hosting company's
server does not support SQLite extension. Is there any way to use
SQLite DB's to my site?

PS: safe mode is off, php version is 4.3.4

Thanks

--
Cafer Şimşek
http://cafer.org

RolandD
Guest
 
Posts: n/a
#2: Sep 6 '05

re: SQLite DB using without SQLite Extension


SQLite is not introduced until PHP 5. Correct me if I am wrong ;)

Cafer Şimşek wrote:[color=blue]
> Hi all,
>
> I want to use SQLite databases to my site. But the hosting company's
> server does not support SQLite extension. Is there any way to use
> SQLite DB's to my site?
>
> PS: safe mode is off, php version is 4.3.4
>
> Thanks
>[/color]
Cafer Şimşek
Guest
 
Posts: n/a
#3: Sep 6 '05

re: SQLite DB using without SQLite Extension


Yes, that's true, but PHP5 has only bundeled version of SQLite
library. You may extend to SQLite with PECL components see the
database section of http://pecl.php.net

Best Regards


RolandD <rdalmulderno@spamhotmail.com> writes:
[color=blue]
> SQLite is not introduced until PHP 5. Correct me if I am wrong ;)
>
> Cafer Şimşek wrote:[color=green]
>> Hi all,
>> I want to use SQLite databases to my site. But the hosting company's
>> server does not support SQLite extension. Is there any way to use
>> SQLite DB's to my site?
>> PS: safe mode is off, php version is 4.3.4
>> Thanks
>>[/color][/color]

--
Cafer Şimşek
http://cafer.org
Oliver Grätz
Guest
 
Posts: n/a
#4: Sep 8 '05

re: SQLite DB using without SQLite Extension


SQLite is available since PHP 4.3.x as a PECL extension. In PHP5 it is
included in the standard installation. With PHP 5.1 SQLite 3.x databases
are supported through PDO. All of these are PHP extensions and have to
be activated in the php.ini file. If your provider does not feature a
SQLite installation you can

- try installing a matching version of the sqlite.so (or .dll) extension
in your account and load it with dl() or PHP directives in a .htaccess
file.
- Use the command line SQLite client. This should be a pain in the a**
because you can't use any of the SQLite commands of PHP and it will
be VERY slow.
- Convice your provider to switch install the extension or (even better)
install PHP5. The german provider Strato shows that a provider can
feature PHP 4.0/4.3/5.0 in parallel...
- Switch the provider. PHP5 is out for over a year now!
Your provider doesn't feature it: Man, that's slow!

AllOLLi
Closed Thread