[Xerte] Re: Xerte Toolkits - installation and management special

Ron Mitchell ronm at mitchellmedia.co.uk
Tue May 27 17:41:16 BST 2014

We previously surveyed via the mailing list whether requiring PHP 5.x was ok
and the concensus was yes and most were running at least 5.2.

-----Original Message-----
From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of David Goodwin
Sent: 27 May 2014 17:29
To: Xerte discussion list
Subject: [Xerte] Re: Xerte Toolkits - installation and management special

> I understand the reasoning, and I do (really) appreciate you doing the 
> work you did. It makes it easier to modify the db back-end, and it 
> makes XOT safer against SQL injection.

Yes. Note there are outstanding pull requests to merge into XOT on github.

> 1. I do think we should probably implement database_library.php using 
> PDO (I would like to do it that way)

Fine with me.

> 2. I do think sqlite has its merits, only not as a default, certainly 
> not for an update

Well - the fact it would make installation a lot easier on LAMP/WAMP style
set ups is one of the big pluses I think - i.e. there is no need to edit any
setting files, try and get MySQL working or go into /setup.

Just upload to the server and fix permissions on USER-FILES.

The downsides are that it has no (real) security / no support for multiple
users, and isn't going to persist very well post-reboot at the moment!

> 3. I think for the time being mysql should still be the default.
> So, again, thank you! I would appreciate a PDO implementation if you 
> have one, I will modify the installer to ask what engine to use (and 
> include sqlite) and go from there.

No problem. I can create a PDO variant easily enough. I'll create a pull
request once done.


Pale Purple Ltd

PHP Web application development and support

07792 380669 / 0845 0046746

Xerte mailing list
Xerte at lists.nottingham.ac.uk
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.

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.

More information about the Xerte mailing list