How to integrate with Custom Tables

  • Resolved Fran?uel Soares

    (@francuelsoares)


    2 years, 4 months ago

    Hello,

    I’m creating a system for solving university entrance exam questions.

    As follows in the sketch image, I chose to work with Custom Tables in the database.

    Image: https://prnt.sc/KBJ47tANkiFS

    As they are very specific data, I think that the native WordPress tables will make SQL queries difficult to read.

    In addition to the performance being compromised, as this application may have up to +30 thousand questions. And the same should be able to store users history too, which can lead to millions of records.

    So the big question is:

    1) How can I make Rank Math work correctly with my Custom Tables?

    In other words, how to make the questions available in the “Sitemap”, have control of “Titles and Metadata”, “Keywords”, “Schema”, etc.

    Note: each question on the platform will have a unique slug and can be viewed as if it were a Post.

    ****

    Complementary question not related to the plugin:

    2) Would my approach with Custom Tables really be the best way? Would native WordPress tables be better? In case anyone argues that yes, try to show me how I could organize this, please.

    Thanks in advance for any help!

Viewing 1 replies (of 1 total)
  • Plugin Support Rank Math Support

    (@rankmathteam)

    Hello @francuelsoares,

    Thank you for contacting Rank Math support today and bringing your concern to our attention.

    1. Rank Math’s metadata, keywords, and schema will only work for post types, or CPTs created using the standard WordPress function. A custom database table may not be reachable by Rank Math as the plugin follows the standard post meta structure imposed by WordPress.

    As for the sitemap, you can create a custom sitemap and generate it. You may refer to this guide:
    https://rankmath.com/kb/custom-sitemaps/

    2. Personally, we would go with WordPress’s standard post type as this offers features that you can easily access via their filters or functions. If your questions pages have attributes, you can make use of their post meta.

    Hope that helps.

Viewing 1 replies (of 1 total)
  • The topic ‘How to integrate with Custom Tables’ is closed to new replies.