[Xerte-dev] Re: PHP compatibility

Wed Oct 16 11:24:29 BST 2013

I think one of the first things that i need to do is revisit the api... We had discussed previously turning all the ajax calls into api endpoints. That way most of the database abstractions would actually be being called from within the api code.

My initial interpretation of the api was external only so i have done all the work of oauth authorization so i think just taking care of logged in user authentication should allow us to expand the api to take care of the other internal processes...

Regards

John Smith
Learning Technologist
School of Health and Life Sciences

Sent from Samsung Galaxy SII

Tom Reijnders <reijnders at tor.nl> wrote:

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

I would like to implement MySQLi and PDO to start with.

Fundings are always welcome. I just don't think it is so much work, as we don't do anything fancy with SQL.

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.

Tom

.On Wed, 16 Oct 2013 09:50:34 +0100 Julian Tenney <Julian.Tenney at nottingham.ac.uk> wrote

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?

From: xerte-dev-bounces at lists.nottingham.ac.uk [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] On Behalf Of Tom Reijnders
Sent: 15 October 2013 19:36
To: For Xerte technical developers
Subject: [Xerte-dev] Re: PHP compatibility

I already formulated my wish to be able to use more db engines than only mysql/mariadb.

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.

That doesn;t mean that we shouldn't formulate our wishes.

Tom

David Goodwin schreef op 15-10-2013 19:12:

On 15 Oct 2013, at 18:04, Tom Reijnders <reijnders at tor.nl<mailto:reijnders at tor.nl>> wrote:

I understand where you are coming from, and I understand your reasoning. But I respectfully disagree.

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.

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.

( See also my previous email)

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

thanks,

David.

Pale Purple Ltd.  (Company No: 5580814)

'Web and Mobile Application Development for Business'

http://www.palepurple.co.uk

Office: 0845 0046746     Mobile: 07792380669

Follow us on Twitter: @PalePurpleLtd

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.

_______________________________________________

Xerte-dev mailing list

Xerte-dev at lists.nottingham.ac.uk<mailto:Xerte-dev at lists.nottingham.ac.uk>

http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

--

--

Tom Reijnders

TOR Informatica

Chopinlaan 27

5242HM Rosmalen

Tel: 073 5226191

Fax: 073 5226196

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.

Glasgow Caledonian University is a registered Scottish charity, number SC021474

Winner: Times Higher Education’s Widening Participation Initiative of the Year 2009 and Herald Society’s Education Initiative of the Year 2009.
http://www.gcu.ac.uk/newsevents/news/bycategory/theuniversity/1/name,6219,en.html

Winner: Times Higher Education’s Outstanding Support for Early Career Researchers of the Year 2010, GCU as a lead with Universities Scotland partners.
http://www.gcu.ac.uk/newsevents/news/bycategory/theuniversity/1/name,15691,en.html