Database structure and API question

Hi there,

Thanks a lot for considering Tutor LMS and contacting. All the courses, lessons, questions and answers, quiz etc are CPT and we have stored in the wp_posts table.

We have plans to add the API feature by mid-2020. Let me know if you have more queries.

Regards,
Mehedi

Thanks for the quick reply!

Tutor looks and functions beautifully but it’s going to run into major performance problems on larger sites by storing everything in wp_postmeta. Easy Digital Downloads, Woocommerce etc. are all moving to custom tables to overcome this issue.

Would you consider implementing custom tables? Here’s an example of LearnDash’s table structure: https://www.learndash.com/support/docs/developers/database-info/#custom_tables

Cheers

Hello @menathor

I’m developer of Tutor LMS, describing you about database structure. We designed the best database structure for Tutor LMS to get the ultimate performance.
We keeping data for course, lesson, topic, in the wp_posts table, below custom table is only for Tutor LMS lists is for

wp_tutor_earnings
wp_tutor_quiz_attempts
wp_tutor_quiz_attempt_answers
wp_tutor_quiz_questions
wp_tutor_quiz_question_answers
wp_tutor_withdraws

Our every database query is optimized, No matters how much data, Tutor LMS can lift tons of data.

Best Regards

Hi there,

I apologize for the misunderstanding. I had a long conversation with our developer team about the database and performance. We have designed the most reliable database structure for Tutor LMS to get the highest performance.

Now I’m trying to give you an overview of the database structure.
We are keeping data for course, lesson, topic, in the wp_posts table to get URL support. And QA, rating in the wp_comments table. We have stored a small amount of data in the wp_postmeta table those are mandatory to put on the wp_postmeta. Also, we have split data to all database tables in the perfect way.

Here is the list of all custom tables dedicated for Tutor LMS:

wp_tutor_earnings
wp_tutor_quiz_attempts
wp_tutor_quiz_attempt_answers
wp_tutor_quiz_questions
wp_tutor_quiz_question_answers
wp_tutor_withdraws

Two new database tables will add in this list after the GradeBook feature releasing.

Besides, all the database queries are well optimized. No matters how much data you have on your site, Tutor LMS can handle tons of data without any performance issue.

Let me know if you have more queries or any confusion.

Best Regards,
Mehedi

Hi guys,

This is great to hear, thanks! Also could you provide some information about REST API endpoints? Do you have any yet, and if not will you be adding them? This is essential for developers to build mobile apps, do custom integrations etc.

Cheers ??

Hi there,

I apologize for the delay. Glad to know that you are happy with the database structure. We don’t have an API right now. Hopefully, we will able to complete the API in mid-2020.

Thanks

Is it possible to build a system where there must be 3 dashboards
1.centers (different Institutes/classes)
2.instructor
3.student

And only centers can be given permission to add/view/remove students and instructors.

Student/instructors cannot enroll themselves or others.

As a admin I can enroll centers with a paid registration.

Free courses will be provided by us for students and instructors.

so as per now using tutor lms i can have students and instructors dashboard but I’am missing centers dashboard and also centers can only acces their own enrollments(students/instructor) and cannot view other centers data(like different branches).

Hi there,

Thanks a lot for considering Tutor LMS and contacting us. I’m sorry to inform you that we don’t have an option (don’t have a plan too) to add another dashboard for centers. We always try to bring new features that are requested by a bigger number of users. We think this is not going to be a required feature for most of our users.

That’s why it will be better for you and us if you can customize Tutor LMS and develop a platform as per your requirements. We have followed the standard and meaning full coding practice. So that a developer will understand the code and extend functionalities are per their requirements.

We appreciate your cooperation.

Regards,
Mehedi

@mehedih any updates on the api?