Hi, I am building an app (Replacing my bubble working app) which taxonomy is a core functionality.
I was trying to play around with one-to-many, many-to-many logic, but it looks so complicated which makes me think again about using FF. I would love your ideas as how to build the structure which serve the following specification.
My solution structure goes to some options, but I am afraid of the future work to come and I hope your experience will help me:
Table for Types, and Table for Tags + Table to connect Post with tag_id and type_id
String array field in the Post table for Tags and Types - I am afraid this method will prevent me to accomplish my following needs.
Other?
I have users logged and the basic structure is:
Posts - Title, description, etc.
Collections - A page which showcase posts based on the tagging.
Taxonomies (Tagging families) :
Type - For example - Web, Upload, Video, File, etc
Tags - For example - Fintech, Economy, Sport, etc
Requirements which are related to the tagging:
Users can create, delete, edit tagging - Anywhere in the app (In a management table , inside each post, inside each collection)
Users can add tags to each post - From a list / Create a new one
Users can filter the Collection post list based on tagging - Type AND tags.
I can run a backend API call to OPEN AI >> Extract tags from a user prompt >> Keep this tags list from OPEN AI as a user tags (Pick from existing and create new ones)