Re: [Phpwiki-talk] PDO sqlite backend

[Marc-Etienne V. (Nokia) <mar...@no...>]

Hi Christof,

Thank you for your report and patches.

I will test them and integrate them.

I must say that there are some issues with PDO. “DATABASE_TYPE = SQL” (PEAR DB) has been more tested than PDO, and it is what I use.

Best wishes for the new year 2024.

Marc-Etienne

--
Marc-Etienne Vargenau mar...@no...<mailto:mar...@no...>
Nokia, 12, rue Jean-Bart, 91300 Massy, FRANCE
Mobile: +33 6 24 49 78 68<tel:+33624497868>
Senior Specialist Open Source
Planned absence: 1-7 January


De : Christof Meerwald via Phpwiki-talk <php...@li...>
Date : samedi, 30 décembre 2023 à 20:15
À : php...@li... <php...@li...>
Cc : Christof Meerwald <cm...@cm...>
Objet : [Phpwiki-talk] PDO sqlite backend

CAUTION: This is an external email. Please be very careful when clicking links or opening attachments. See the URL nok.it/ext for additional information.



So far I have been using phpwiki with the dba backend, but web hosters
don't always make dba available, so been investigating using SQLite as
the backend. Anyway, tried to use PDO, but ran into a few issues - I
have attached a patch that makes it work (at least for me).

BTW, not really sure what that "$date > 1588437560" check was all
about (1588437560 corresponds to "Sat May 2 18:39:20 2020").

Also not entirely sure what that "else" branch in PDO.php was trying
to do with the database dsn - I am just passing the DATABASE_DSN to
PDO there now (e.g. DATABASE_DSN = "sqlite:/path/to/file.db")


Christof

--

https://cmeerw.org                             sip:cmeerw at cmeerw.org
mailto:cmeerw at cmeerw.org                   xmpp:cmeerw at cmeerw.org