Xibo

XIBO running with MSSQL database

Asked by Daniel Kwan

From previous post (http://xibo.org.uk/tag/cms/), it indicates that the current version of Xibo 1.6.4 has begun to support PHP PDO which potentially could connect to not only MYSQL but also MSSQL and other databases. May i get more information about how this can be done? In the post, it says "all queries covered from 1.7 series", does it mean the current version of 1.6.4 is not ready to support other databases? May anyone please kindly advice?

Thanks

Question information

Language:
English Edit question
Status:
Answered
For:
Xibo Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Alex Harrington (alexharrington) said : 		#1

Hi Daniel

We're slowly moving over to PDO.

1.6.4 won't run on anything but MySQL and there won't be official support
for MSSQL in 1.7 series either. Once all queries are converted over to use
PDO then it's feasible for it to run on other databases, but it's not
something that's a priority for the project. We're moving to PDO for other
reasons.

Alex

Revision history for this message
Daniel Kwan (danielkwan) said : 		#2

Alex,

Will there be a rough plan or schedule about when all queries are converted to PDO?

Thanks

Daniel

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Alex Harrington
Sent: Thursday, November 20, 2014 3:47 PM
To: Daniel H.C. Kwan
Subject: Re: [Question #257942]: XIBO running with MSSQL database

Your question #257942 on Xibo changed:
https://answers.launchpad.net/xibo/+question/257942

    Status: Open => Answered

Alex Harrington proposed the following answer:
Hi Daniel

We're slowly moving over to PDO.

1.6.4 won't run on anything but MySQL and there won't be official support for MSSQL in 1.7 series either. Once all queries are converted over to use PDO then it's feasible for it to run on other databases, but it's not something that's a priority for the project. We're moving to PDO for other reasons.

Alex

--
If this answers your question, please go to the following page to let us know that it is solved:
https://answers.launchpad.net/xibo/+question/257942/+confirm?answer_id=0

If you still need help, you can reply to this email or go to the following page to enter your feedback:
https://answers.launchpad.net/xibo/+question/257942

You received this question notification because you asked the question.

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.3485 / Virus Database: 4189/8584 - Release Date: 11/16/14

Revision history for this message
Alex Harrington (alexharrington) said : 		#3

Hi Daniel

They're done as parts of the system are worked on. There's no fixed
timeline.

Alex

Can you help with this problem?

Provide an answer of your own, or ask Daniel Kwan for more information if necessary.

To post a message you must log in.