Set up plugin tables

[tillmariajuergens]

Scalable tables

post_emoji_id	post_id	emoji
1	2	👍
2	2	❤️

post_emoji_id	user_id
1	1
1	2
2	1

• user 1 & 2 added a 👍 to post 2. user 2 added ❤️ to 2.
• con: difficult setup, creates lots of tables.
• con: lots of effort
• con: can't use wordpress board-tools
• pro: filter by user id
• pro: quick

Post meta

compared to first solution post meta:

• pro: easy to build
• con: filter by user is slow for large blog
• con: slows down large blogs

Decision

We went for postmeta to get it running first. If we want more scalability, we go for the custom tables. If we want network-wide visibility an event-bus (with a limited time) could be a solution.