Forum

Chapter local stora...
 
Notifications
Clear all

Chapter local storage, need your help

Sheepcontrol
(@sheepcontrol)
Member Admin

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).

Quote
Topic starter Posted : 09/12/2014 3:00 am
Elle
 Elle
(@jenny)
Honorable Member

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: dramione.org
site: accio.nu

Available for skin/mod commission! 🙂

ReplyQuote
Posted : 10/12/2014 10:59 pm
SJP
 SJP
(@sjp)
Trusted Member

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!

ReplyQuote
Posted : 11/12/2014 5:54 pm
Sheepcontrol
(@sheepcontrol)
Member Admin

Thanks, that's been very helpful, still hoping for more replies but so far everyone that replied has the sqlite extension running via PDO.

ReplyQuote
Topic starter Posted : 12/12/2014 10:36 pm
banshee
(@banshee)
Member Admin

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: Tom Paris Dorm | Twice Bitten | Underground

ReplyQuote
Posted : 14/12/2014 1:00 am
Lyndsie
(@lyndsie)
Member Moderator

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

ReplyQuote
Posted : 18/12/2014 12:14 am
Sheepcontrol
(@sheepcontrol)
Member Admin

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

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.

ReplyQuote
Topic starter Posted : 18/12/2014 7:58 am
Tsukasa
(@yuidirnt)
Eminent Member

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, sqlite2

pdo_sqlite
PDO Driver for SQLite 3.x enabled
SQLite Library 3.7.7.1

SQLite 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, mysql

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

ReplyQuote
Posted : 23/12/2014 3:05 am
Sue
 Sue
(@sue)
Estimable Member

A bit late (happy new year!)

SQLite3 module version 0.7
SQLite Library 3.7.7.1

PDO drivers sqlite, mysql

ReplyQuote
Posted : 03/01/2015 12:28 am
muhkuh
(@muhkuh)
Eminent Member

Just started trying out efiction but already feel like commiting to the community  😉

PDO

PDO support enabled
PDO drivers mysql, sqlite

pdo_mysql

PDO Driver for MySQL enabled
Client API version 5.5.38

Directive Local Value Master Value
pdo_mysql.default_socket /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock

pdo_sqlite

PDO Driver for SQLite 3.x enabled
SQLite Library 3.7.13

sqlite3

SQLite3 support enabled
SQLite3 module version 0.7
SQLite Library 3.7.13

ReplyQuote
Posted : 03/01/2015 2:58 am
Anonymous
 Anonymous
(@Anonymous)
Guest

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

ReplyQuote
Posted : 10/01/2015 6:07 am
Azurite
(@azurite)
Estimable Member

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
Latest Patch(es): Yes
bridged?: No
modified?: Yes
PHP: 5.3.27
MySQL: 5.5.42-cll

ReplyQuote
Posted : 16/08/2015 1:39 am
Sheepcontrol
(@sheepcontrol)
Member Admin

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.

ReplyQuote
Topic starter Posted : 16/08/2015 2:41 am
Share: