<p>I don't know how much work it is, I have the impression it's not to much, but haven't investigated yet. But I agree with Pat that we should use an abstraction layer. As that offers the most flexibillity in the future<br /><br />I would like to implement MySQLi and PDO to start with.<br /><br />Fundings are always welcome. I just don't think it is so much work, as we don't do anything fancy with SQL.<br /><br />The other thing I would like to do (and I already started on that) for the next version, is to get rid of the current site_details table, and replace it with a key,value table.<br /><br />Tom</p>
<p>.On Wed, 16 Oct 2013 09:50:34 +0100 Julian Tenney <Julian.Tenney@nottingham.ac.uk> wrote</p>
<div style="padding-left: 10px; border-left: solid 2px #0000FF;">
<div class="WordSection1">
<p><span style="font-size: 11pt; font-family: Calibri, 'sans-serif'; color: #1f497d;">It strikes me this is case where the ‘scratch your own itch’ principle fails to provide an optimum solution. Do we need to find some sponsorship to pay for the work to be done? How much work do you think there is?</span></p>
<p> </p>
<div>
<div style="border: none; border-top: solid #B5C4DF 1pt; padding: 3pt 0cm 0cm 0cm;">
<p><strong><span style="font-size: 10pt; font-family: Tahoma, 'sans-serif';" lang="en-us" xml:lang="en-us">From:</span></strong><span style="font-size: 10pt; font-family: Tahoma, 'sans-serif';" lang="en-us" xml:lang="en-us"> xerte-dev-bounces@lists.nottingham.ac.uk [mailto:xerte-dev-bounces@lists.nottingham.ac.uk] <strong>On Behalf Of </strong>Tom Reijnders<br /><strong>Sent:</strong> 15 October 2013 19:36<br /><strong>To:</strong> For Xerte technical developers<br /><strong>Subject:</strong> [Xerte-dev] Re: PHP compatibility</span></p>
</div>
</div>
<p> </p>
<p>I already formulated my wish to be able to use more db engines than only mysql/mariadb.<br /><br />I am willing to spend some time on it. Not sure how far I will get. But, I simply think that we can't afford to simply formulate our wishes and expect it to be implemented.<br /><br />That doesn;t mean that we shouldn't formulate our wishes.<br /><br />Tom</p>
<div>
<p>David Goodwin schreef op 15-10-2013 19:12:</p>
</div>
<blockquote style="margin-top: 5pt; margin-bottom: 5pt;">
<p> </p>
<div>
<div>
<p>On 15 Oct 2013, at 18:04, Tom Reijnders <<a href="mailto:reijnders@tor.nl">reijnders@tor.nl</a>> wrote:</p>
</div>
<p><br /><br /></p>
<div>
<p>I understand where you are coming from, and I understand your reasoning. But I respectfully disagree.<br /><br />This is just a typical re-factoring which we will be obliged to do from time to time. No new functionality involved, perhaps new opportunities.<br /><br />The question is more MySQLi vs. PDO. Or a more generic approach Like David Goodwin used for authentication. We don't do anything fancy with the database.</p>
</div>
<div>
<p> </p>
</div>
<p>( See also my previous email) </p>
</div>
<div>
<p> </p>
</div>
<div>
<p>I think someone needs to start from stating the requirements (do you just want to stick to using MySQL/MariaDB) or do you need to support e.g. SQLite (or whatever).</p>
</div>
<div>
<p> </p>
</div>
<div>
<p>thanks,</p>
</div>
<div>
<p>David.</p>
</div>
<div>
<p> </p>
</div>
<div>
<p>Pale Purple Ltd. (Company No: 5580814)</p>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p><span style="font-size: 13.5pt; font-family: Helvetica, 'sans-serif';">'Web and Mobile Application Development for Business'</span></p>
</div>
<div>
<p> </p>
</div>
<div>
<p><span style="font-size: 13.5pt; font-family: Helvetica, 'sans-serif';"><a href="http://www.palepurple.co.uk">http://www.palepurple.co.uk</a> </span></p>
</div>
<div>
<p><span style="font-size: 13.5pt; font-family: Helvetica, 'sans-serif';">Office: 0845 0046746 Mobile: 07792380669 </span></p>
</div>
<div>
<p> </p>
</div>
<div>
<p><span style="font-size: 13.5pt; font-family: Helvetica, 'sans-serif';">Follow us on Twitter: @PalePurpleLtd</span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p> </p>
<p>This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it. Please do not use, copy or disclose the information contained in this message or in any attachment. Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.</p>
<p>This message has been checked for viruses but the contents of an attachment may still contain software viruses which could damage your computer system, you are advised to perform your own checks. Email communications with the University of Nottingham may be monitored as permitted by UK legislation.</p>
<p><br /><br /><br /><br /></p>
<pre>_______________________________________________</pre>
<pre>Xerte-dev mailing list</pre>
<pre><a href="mailto:Xerte-dev@lists.nottingham.ac.uk">Xerte-dev@lists.nottingham.ac.uk</a></pre>
<pre><a href="http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev">http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev</a></pre>
</blockquote>
<p><br /><br /></p>
<pre>-- </pre>
<pre>--</pre>
<pre> </pre>
<p> </p>
<pre>Tom Reijnders</pre>
<pre>TOR Informatica</pre>
<pre>Chopinlaan 27</pre>
<pre>5242HM Rosmalen</pre>
<pre>Tel: 073 5226191</pre>
<pre>Fax: 073 5226196</pre>
<pre> </pre>
<p> </p>
</div>
<br />
<p>This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it. Please do not use, copy or disclose the information contained in this message or in any attachment. Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.</p>
<p>This message has been checked for viruses but the contents of an attachment may still contain software viruses which could damage your computer system, you are advised to perform your own checks. Email communications with the University of Nottingham may be monitored as permitted by UK legislation.</p>
</div>