The extension is live now on Beta Meta-Wiki: https://meta.wikimedia.beta.wmcloud.org/wiki/Community_Wishlist
**Tables**
See https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CommunityRequests/+/09366709a51afcd4e37ca9ef2b758b20edbcfdb6/sql/tables.json
**Should this table be replicated to wiki replicas (does it not contain private data)?**
Yes. There is no private data being stored.
**Will you be doing cross-joins with the wiki metadata?**
If that means i.e. joining on the `page` table, then yes.
**Size and impact of the tables**
| Table | # initial rows | Rows per year | Reads/day | Writes/day |
| ---- | ---- | ---- | ---- | ---- |
| `communityrequests_wishes` | ~400 | 200-500 | < 1000 | ~20 |
| `communityrequests_focus_areas` | ~15 | ~10 | < 1000 | < 1 |
| `communityrequests_wishes_translations` | ~1000 | ~1000 | < 1000 | < 10 |
| `communityrequests_focus_areas_translations` | ~300 | ~100 | < 1000 | < 1 |
| `communityrequests_tags` | ~400 | 200-500 | < 1000 | ~10 |
| `communityrequests_counters` | 2 | 0 | ~5 | ~5 |
**Examples of queries that will be using the table(s)**
From [[ https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CommunityRequests/+/09366709a51afcd4e37ca9ef2b758b20edbcfdb6/includes/Api/ApiQueryWishes.php | ApiQueryWishes ]]:
```lang=sql
SELECT
page_namespace, page_title, cr_page, cr_type, cr_status, cr_focus_area, cr_actor, cr_vote_count, cr_base_lang, cr_created, cr_updated, crt_title, crt_lang
FROM
`communityrequests_wishes`
JOIN `page` ON ((cr_page = page_id))
JOIN `communityrequests_wishes_translations` ON ((crt_wish = cr_page))
WHERE
(
crt_lang = 'en'
OR (crt_lang = cr_base_lang)
)
ORDER BY
cr_created DESC,
crt_title DESC,
cr_vote_count DESC
LIMIT
22
```
This is the only query I believe could even possibly be considered "expensive". The other SELECTs are when viewing wishes and focus areas directly, and the INSERT/UPDATE queries would only ever touch a single row at a time.
**Release plan for the feature**
For the foreseeable future, we will only deploy to Meta. It's possible however that eventually individual communities will want their own local Wishlist, and we might explore releasing the software to more wikis if there's enough demand.
Target deployment date: **End of September 2025**