relational tabular data addons?

B

briansol

Well-known member
Licensed customer
I'm looking to build some stand-alone pages (xf wrapper) to store tabular, relational data.

something like

xf_widgets:
WidgetID WidgetName ColorID SizeID
1 Acme 2 3

xf_widgets_colors
ColorID Text
1 black
2 Red


etc

Admins can define new criteria.
eg, add a Price column/lookup table to that.

adding coloumns is dangerous i guess. Is there something out there that exists to do this as an XF addon? I'm ok with using 1 flat table and a relationship table format as well as this will be hundreds of records, not thousands or millions.

I attempted something like this back on 2.1, but it's so out of date and i hate my design so i'm starting over.
 
Hi, I built an addon called Data Tables that lets you create stand-alone pages (in the XenForo wrapper) for storing tabular, relational data.

How it works:
  • Admin creates a "Definition" (your table) with a title and URL slug
  • Add Fields (columns) of any type: Text, Number, URL, Date, Lookup (dropdown), Text Area, Yes/No
  • Lookup fields let you define dropdown options (e.g., Color: Red/Blue/Black), stored relationally, not as flat strings
  • Add/edit/delete Records through the AdminCP with dynamic forms
  • Public pages at /data-tables/{slug}/ display the table with sortable columns
  • Members can optionally submit records from the public side (permission-controlled)

It's basically a dynamic table builder inside XenForo, no code needed. You define the schema through the AdminCP and it handles the rest.

Architecture matches your example exactly:
  • Your xf_widgets table = a "Definition" with fields for WidgetName, ColorID, SizeID
  • Your xf_widgets_colors lookup table = "Lookup Options" on the Color field (Red, Blue, Black, etc.)
  • Adding a Price column = just add a new Number field in the admin, no schema migration needed (records use JSON storage, so new fields appear automatically)

Features:
  • 7 field types (text, number, url, date, lookup/dropdown, textarea, yes/no)
  • Sortable columns on public pages
  • Paginated (50 records per page)
  • Clean uninstall (all tables dropped)
  • No class extensions, zero conflicts with other addons
  • Designed for hundreds of records (your use case)

Compatible with XF 2.3.x. Free, open source.
 
I'm having trouble with my dev site, so i haven't successfully loaded this yet. i'll report back in later. thank you!
 
briansol said:
I'm having trouble with my dev site, so i haven't successfully loaded this yet. i'll report back in later. thank you!
Click to expand...
No worries, take all the time you need. I made this specifically for the request you've made. So feel free to let me know any suggestions for improvements or if you run into issues with the addon.
 
You must log in or register to reply here.
Back
Top Bottom