vB-5.5.x: node-Table: add column or provide extra lookup table?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • m97forum
    Member
    • Jun 2017
    • 54
    • 5.3.x

    vB-5.5.x: node-Table: add column or provide extra lookup table?

    Hi there,

    for an Addon, I need a 1:1 lookup between the nodeid and a Slack channel id.
    Right now, I have set up a lookup table, containing just the nodeid and the channelid.

    Now, it can also make sense to just extend the table node by a column which would hold the channelid.
    Of course, this needs to be configurable using AdminCP. And that column would require an index, to keep execution times low.

    Which approach is recommended by vBulletin, since extending internal datastructures can break upgrades.

    Thanks for your recommendation.

    Stefan
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73981

    #2
    I am not sure why every node needs a slack channel id. However, I would recommend using a lookup table with a straight join. We generally recommend that you build your own tables just for portability and ease of installation. Adding a field to the node table should be only done if there is no other solution.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...