Chapter local stora...
 
Notifications
Clear all

Chapter local storage, need your help

13 Posts
10 Users
0 Reactions
5,354 Views
(@sheepcontrol)
Posts: 332
Reputable Member
Topic starter
 

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

 
Posted : 08/12/2014 9:00 pm
 Elle
(@jenny)
Posts: 594
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! πŸ™‚

 
Posted : 10/12/2014 4:59 pm
 SJP
(@sjp)
Posts: 66
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!

 
Posted : 11/12/2014 11:54 am
(@sheepcontrol)
Posts: 332
Reputable Member
Topic starter
 

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

 
Posted : 12/12/2014 4:36 pm
(@banshee)
Posts: 92
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

 
Posted : 13/12/2014 7:00 pm
(@lyndsie)
Posts: 1263
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

 
Posted : 17/12/2014 6:14 pm
(@sheepcontrol)
Posts: 332
Reputable Member
Topic starter
 

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.

 
Posted : 18/12/2014 1:58 am
(@yuidirnt)
Posts: 20
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

 
Posted : 22/12/2014 9:05 pm
 Sue
(@sue)
Posts: 131
Estimable Member
 

A bit late (happy new year!)

SQLite3 module version 0.7
SQLite Library 3.7.7.1

PDO drivers sqlite, mysql

 
Posted : 02/01/2015 6:28 pm
(@muhkuh)
Posts: 27
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

 
Posted : 02/01/2015 8:58 pm
(@Jennmc75)
Posts: 0
New Member 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

 
Posted : 10/01/2015 12:07 am
(@azurite)
Posts: 209
Reputable 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/6
Latest Patch(es): Yes
bridged?: No
modified?: Yes
PHP: 7.4.25
MySQL: 5.7.32-35-log

 
Posted : 15/08/2015 6:39 pm
(@sheepcontrol)
Posts: 332
Reputable Member
Topic starter
 

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.

 
Posted : 15/08/2015 7:41 pm
Share: