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.
 
You must log in or register to reply here.
Back
Top Bottom