Re: PDO sqlite backend
"Marc-Etienne Vargenau \(Nokia\) via Phpwiki-talk" <[email protected]> Mon, 8 Jan 2024 09:12:54 +0000
| Newsgroups | gmane.comp.web.wiki.phpwiki.talk |
|---|---|
| Message-ID | <PR3PR07MB81832805C9D859B3C1FCE35BAC6B2@PR3PR07MB8183.eurprd07.prod.outlook.com> |
--===============0497163409268267426== Content-Language: fr-FR Content-Type: multipart/alternative; boundary="_000_PR3PR07MB81832805C9D859B3C1FCE35BAC6B2PR3PR07MB8183eurp_" --_000_PR3PR07MB81832805C9D859B3C1FCE35BAC6B2PR3PR07MB8183eurp_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable 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. =93DATABASE_TYPE =3D SQL=94= (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 [email protected]<mailto:marc-etienne.v= [email protected]> 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 <[email protected]= > Date : samedi, 30 d=E9cembre 2023 =E0 20:15 =C0 : [email protected] <[email protected]= t> Cc : Christof Meerwald <[email protected]> Objet : [Phpwiki-talk] PDO sqlite backend CAUTION: This is an external email. Please be very careful when clicking li= nks or opening attachments. See the URL nok.it/ext for additional informati= on. 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 =3D "sqlite:/path/to/file.db") Christof -- https://cmeerw.org sip:cmeerw at cmeerw.org mailto:cmeerw at cmeerw.org xmpp:cmeerw at cmeerw.org --_000_PR3PR07MB81832805C9D859B3C1FCE35BAC6B2PR3PR07MB8183eurp_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:sc= hemas-microsoft-com:office:word" xmlns:m=3D"http://schemas.microsoft.com/of= fice/2004/12/omml" xmlns=3D"http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1= 252"> <meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)"> <style><!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:Aptos; panose-1:2 11 0 4 2 2 2 2 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; font-size:10.0pt; font-family:"Calibri",sans-serif;} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} span.EmailStyle19 {mso-style-type:personal-reply; font-family:"Calibri",sans-serif; color:windowtext;} .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt; mso-ligatures:none;} @page WordSection1 {size:612.0pt 792.0pt; margin:70.85pt 70.85pt 70.85pt 70.85pt;} div.WordSection1 {page:WordSection1;} --></style> </head> <body lang=3D"FR" link=3D"blue" vlink=3D"purple" style=3D"word-wrap:break-w= ord"> <div class=3D"WordSection1"> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;mso-fareast-language= :EN-US">Hi Christof,<o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;mso-fareast-language= :EN-US"><o:p> </o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;mso-f= areast-language:EN-US">Thank you for your report and patches.<o:p></o:p></s= pan></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;mso-f= areast-language:EN-US"><o:p> </o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;mso-f= areast-language:EN-US">I will test them and integrate them.<o:p></o:p></spa= n></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;mso-f= areast-language:EN-US"><o:p> </o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;mso-f= areast-language:EN-US">I must say that there are some issues with PDO. =93D= ATABASE_TYPE =3D SQL=94 (PEAR DB) has been more tested than PDO, and it is = what I use.<o:p></o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;mso-f= areast-language:EN-US"><o:p> </o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;mso-f= areast-language:EN-US">Best wishes for the new year 2024.<o:p></o:p></span>= </p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;mso-f= areast-language:EN-US"><o:p> </o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;mso-f= areast-language:EN-US">Marc-Etienne <o:p></o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;mso-f= areast-language:EN-US"><o:p> </o:p></span></p> <div> <div> <p class=3D"MsoNormal"><span style=3D"font-family:"Courier New";c= olor:#212121">-- <br> Marc-Etienne Vargenau <a href=3D"mailto:marc-etienne.vargenau@nok= ia.com" title=3D"mailto:[email protected]"><span style=3D"col= or:#0078D7;text-decoration:none">marc-etienne</span><span style=3D"color:#0= 078D7">[email protected]</span></a><br> Nokia, 12, rue Jean-Bart, 91300 Massy, FRANCE<br> Mobile: <a href=3D"tel:+33624497868"><span style=3D"color:#0078D7">+33= 6 24 49 78 68</span></a></span><span style=3D"font-size:11.0pt;color:#2121= 21"><o:p></o:p></span></p> </div> </div> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-family:"Cour= ier New";color:#212121">Senior Specialist Open Source<br> Planned absence: </span><b><span lang=3D"EN-US" style=3D"font-size:11.= 0pt;font-family:"Courier New";color:#212121">1-7 January</span></= b><span lang=3D"EN-US" style=3D"font-size:11.0pt;color:#212121"><o:p></o:p>= </span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;mso-f= areast-language:EN-US"><o:p> </o:p></span></p> <p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:11.0pt;mso-f= areast-language:EN-US"><o:p> </o:p></span></p> <div id=3D"mail-editor-reference-message-container"> <div> <div style=3D"border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm = 0cm 0cm"> <p class=3D"MsoNormal" style=3D"margin-bottom:12.0pt"><b><span style=3D"fon= t-size:12.0pt;font-family:"Aptos",sans-serif;color:black">De = ;: </span></b><span style=3D"font-size:12.0pt;font-family:"Aptos",sa= ns-serif;color:black">Christof Meerwald via Phpwiki-talk <phpwiki-talk@l= ists.sourceforge.net><br> <b>Date : </b>samedi, 30 d=E9cembre 2023 =E0 20:15<br> <b>=C0 : </b>[email protected] <phpwiki-talk@lists= .sourceforge.net><br> <b>Cc : </b>Christof Meerwald <[email protected]><br> <b>Objet : </b>[Phpwiki-talk] PDO sqlite backend<o:p></o:p></span></p> </div> <div> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt"><br> CAUTION: This is an external email. Please be very careful when clicking li= nks or opening attachments. See the URL nok.it/ext for additional informati= on.<br> <br> <br> <br> So far I have been using phpwiki with the dba backend, but web hosters<br> don't always make dba available, so been investigating using SQLite as<br> the backend. Anyway, tried to use PDO, but ran into a few issues - I<br> have attached a patch that makes it work (at least for me).<br> <br> BTW, not really sure what that "$date > 1588437560" check was = all<br> about (1588437560 corresponds to "Sat May 2 18:39:20 2020").<br> <br> Also not entirely sure what that "else" branch in PDO.php was try= ing<br> to do with the database dsn - I am just passing the DATABASE_DSN to<br> PDO there now (e.g. DATABASE_DSN =3D "sqlite:/path/to/file.db")<b= r> <br> <br> Christof<br> <br> --<br> <br> <a href=3D"https://cmeerw.org">https://cmeerw.org</a> &nbs= p; &= nbsp; sip= :cmeerw at cmeerw.org<br> <a href=3D"mailto:cmeerw">mailto:cmeerw</a> at cmeerw.org = &nb= sp; xmpp:cmeerw at cmeerw.org<o:p></o:p></span></p> </div> </div> </div> </div> </body> </html> --_000_PR3PR07MB81832805C9D859B3C1FCE35BAC6B2PR3PR07MB8183eurp_-- --===============0497163409268267426== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline --===============0497163409268267426== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Phpwiki-talk mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/phpwiki-talk --===============0497163409268267426==--