Picture of Ravindra Gardi
Database Connectivity
by Ravindra Gardi - Tuesday, 4 July 2017, 8:20 AM
 

Can we do connectivity with MySQL database or Oracle, or any other database using Adapt learn?

Picture of Matt Leathes
Re: Database Connectivity
by Matt Leathes - Tuesday, 4 July 2017, 9:14 AM
 

The Adapt Framework is purely client side HTML/CSS/JavaScript. It is designed to run on SCORM conformant Learning Management Systems, typically these systems handle the backend/database connectivity. So for most users there is no need to have any DB connectivity in Adapt - but that's not to say you couldn't extend it to do that for your needs.

The Adapt Authoring Tool already has database connectivity, it uses MongoDB I think. But I don't think that's what you're asking.

Picture of Ravindra Gardi
Re: Database Connectivity
by Ravindra Gardi - Wednesday, 5 July 2017, 3:36 AM
 

Thanks Matt, I want to fetch questions from database, so quiz can be completely dynamic, questions can be different each time, can we do this? Also I want give the access to Admin to add new questions as well. Please suggest on the same.

Picture of Matt Leathes
Re: Database Connectivity
by Matt Leathes - Wednesday, 5 July 2017, 9:01 AM
 

Hi Ravindra

I want to fetch questions from database, so quiz can be completely dynamic, questions can be different each time, can we do this?

All the Adapt content is held in JSON files so you could just generate those from your database. That would be the easiest route as you wouldn't have to change Adapt in any way, just publish data in the format it understands.

Also I want give the access to Admin to add new questions as well. Please suggest on the same

This sounds less like a question about Adapt and more like a question about how to engineer your back-end service, which is beyond the scope of this forum.

A suggestion: your database is always going to have a finite amount of questions - in which case the only benefit of making it database-driven is that you can update/amend/delete the questions without having to republish the course. Might it not make more sense to instead use the Adapt Authoring Tool to create the list of questions (Adapt can present a random selection). Yes, you would have to republish the course every time you want to change it - but how often are you really going do that? Even if every day, it's still quite a quick thing to do. So, unless you plan to have a huge number of questions in your database, the authoring tool is probably a better route.