Hi there,
I am currently looking at the local storage of chapter data, and therefor I need your help:
I want to use SQLite as a storage engine for this method as it is local, but also a database, best of both worlds and all that.
Now I need to know if this is enabled on the usual webserver out there, so I would ask you, if possible, to send me your phpinfo, you can find this in your current eFiction in the admin panel, either send me the whole thing via PN here, or just the sections about SQLite or PDO, that's all I would need.
If you help me here, the reward will be the possibility to switch from MySQL storage to local storage anytime without any hassle, now I think that's a deal, right? (And the other way around, also).
pdo_sqlite
PDO Driver for SQLite 3.x enabled
SQLite Library 3.7.7.1
sqlite3
SQLite3 support enabled
SQLite3 module version 0.7
SQLite Library 3.7.7.1
Directive Local Value Master Value
sqlite3.extension_dir no value no value
archive:
site:
Available for skin/mod commission! π
PDO
PDO support enabled
PDO drivers mysql, sqlite
pdo_mysql
PDO Driver for MySQL enabled
Client API version 5.5.36
pdo_sqlite
PDO Driver for SQLite 3.x enabled
SQLite Library 3.6.20
sqlite3
SQLite3 support enabled
SQLite3 module version 0.7-dev
SQLite Library 3.7.7.1
Directive Local Value Master Value
sqlite3.extension_dir no value no value
Let me know if you need any other information. Thanks!
Thanks, that's been very helpful, still hoping for more replies but so far everyone that replied has the sqlite extension running via PDO.
PDO
PDO support enabled
PDO drivers sqlite, mysql, sqlite2
pdo_sqlite
PDO Driver for SQLite 3.x enabled
SQLite Library 3.7.7.1
SQLite
SQLite support enabled
PECL Module version 2.0-dev $Id$
SQLite Library 2.8.17
SQLite Encoding iso8859
Directive Local Value Master Value
sqlite.assoc_case 0 0
eFiction Archives:
Mine's a little different. No sections on PDO.
sqlite3
SQLite3 support enabled
SQLite3 module version 0.7-dev
SQLite Library 3.7.7.1
Directive Local Value Master Value
sqlite3.extension_dir no value no value
Mine's a little different. No sections on PDO.
sqlite3
SQLite3 support enabled
SQLite3 module version 0.7-dev
SQLite Library 3.7.7.1Directive Local Value Master Value
sqlite3.extension_dir no value no value
shhhhh, don't want to hear stuff like that - go away :cursing:
Ah well, gotta find another way of addressing the SQLite driver then, will get back to you all with a little test tool in a few days.
I have two sites with efiction on two different servers, so I'm posting this for both (I also hope I'm posting the right stuff).
PDO
PDO support enabled
PDO drivers mysql, sqlite, sqlite2pdo_sqlite
PDO Driver for SQLite 3.x enabled
SQLite Library 3.7.7.1SQLite support enabled
PECL Module version 2.0-dev $Id: sqlite.c 321634 2012-01-01 13:15:04Z felipe $
SQLite Library 2.8.17
SQLite Encoding iso8859
PDO
PDO support enabled
PDO drivers sqlite, mysqlpdo_sqlite
PDO Driver for SQLite 3.x enabled
SQLite Library 3.7.7.1sqlite3
SQLite3 support enabled
SQLite3 module version 0.7
SQLite Library 3.7.7.1Directive Local Value Master Value
sqlite3.extension_dir no value no value
A bit late (happy new year!)
SQLite3 module version 0.7
SQLite Library 3.7.7.1
PDO drivers sqlite, mysql
Just started trying out efiction but already feel like commiting to the community π
PDO
PDO support enabled
PDO drivers mysql, sqlitepdo_mysql
PDO Driver for MySQL enabled
Client API version 5.5.38Directive Local Value Master Value
pdo_mysql.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sockpdo_sqlite
PDO Driver for SQLite 3.x enabled
SQLite Library 3.7.13sqlite3
SQLite3 support enabled
SQLite3 module version 0.7
SQLite Library 3.7.13
Is this the info you need?
PDO
PDO support enabled
PDO drivers mysql, sqlite
pdo_mysql
PDO Driver for MySQL enabled
Client API version 5.1.73
pdo_sqlite
PDO Driver for SQLite 3.x enabled
SQLite Library 3.6.20
sqlite3
SQLite3 support enabled
SQLite3 module version 0.7-dev
SQLite Library 3.6.20
Directive Local Value Master Value
sqlite3.extension_dir no value no value
PDO
PDO support enabled
PDO drivers sqlite, sqlite2, mysql
pdo_mysql
PDO Driver for MySQL enabled
Client API version 5.5.42
Directive Local Value Master Value
pdo_mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock
pdo_sqlite
PDO Driver for SQLite 3.x enabled
SQLite Library 3.7.7.1
Did I get all that right?
Archive: Dragonfayth
eFiction: 3.5.5/6
Latest Patch(es): Yes
bridged?: No
modified?: Yes
PHP: 7.4.25
MySQL: 5.7.32-35-log
Thanks to all that contributed, so from looking into the data I am confident that using PDO as engine and offering SQLite storage will work on all machines.