User selection dropdown without relationship field?

  • Hi there!
    I haven’t used Pods in a long time, and I’m trying to find the correct/best way to do something:

    I have an ACT (Advanced Content Type) with a field that is a User selection/dropdown (and might add other relationship fields later on)
    My idea is to just store the ID in the same DB entry, instead of having it in on a different “podsrel” table, to improve performance in big queries and DB size (also for simplicity).

    Is this possible with a Relationship field, or I should have a text/number field that stores the ID and create something like a helper to make it a User dropdown or something similar?

    I’m also open to other ideas or reasons why my approach might be wrong. Trying to create something that is scalable and easy to maintain.

    Cheers!
    S

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Jory Hogeveen

    (@keraweb)

    Hi @sefo262

    When using ACT it already creates a separate table for the object type.
    podsrel is more a relationship index table meant to improve performance ?? I’m honestly not sure if this is even used for ACT, @sc0ttkclark might know more on this topic!

    Cheers, Jory

    • This reply was modified 2 years, 2 months ago by Jory Hogeveen.
    Plugin Contributor Scott Kingsley Clark

    (@sc0ttkclark)

    Pods uses podsrel for all relationships by default. For simple relationships on table-based Pods, it stores those values in the table column on that corresponding table.

    What you’re asking for is the exact same thing that I built for the Advanced Relationship Storage Add-On in Pods Pro here: https://pods-pro.skc.dev/downloads/advanced-relationship-storage/

    It’s a unique feature and took quite a bit of work to make it flexible enough for all of the use cases that it supports.

    Thread Starter Serafín Danessa

    (@sdanessa)

    Thanks to both!
    I’ll check the add-on.

    Cheers

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘User selection dropdown without relationship field?’ is closed to new replies.