Set up plugin tables #4
Description
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.