Mathieu Pillard

If you're using an Android browser, that "Download Firefox" link will take you to https://www.mozilla.org/en-US/firefox/download/thanks/ (w/ utm params) which will then take you to the play store page (https://play.google.com/store/apps/details?id=org.mozilla.firefox)

@dependabot rebase

@dependabot rebase

The performance is obviously going to be worse than actual (possibly indexed) columns but I think denormalizing here would be premature. Especially as this is meant for adhoc searches for...

Couple recent examples of where it could have been useful: - Figuring out how many add-ons have an update url - Figuring out how many themes have images set

SRE ticket is https://mozilla-hub.atlassian.net/browse/SVCSE-2158 I'll trigger the task on dev & stage tomorrow.

Example using stage data: ``` >>> FileManifest.objects.count() 809622 >>> FileManifest.objects.filter( Q(manifest_data__browser_specific_settings__gecko__update_url__isnull=False) | Q(manifest_data__apps__gecko__update_url__isnull=False)).count() 30 >>> str(FileManifest.objects.only('file_id').filter( Q(manifest_data__browser_specific_settings__gecko__update_url__isnull=False) | Q(manifest_data__apps__gecko__update_url__isnull=False)).query) 'SELECT `files_filemanifest`.`file_id` FROM `files_filemanifest` WHERE ( JSON_EXTRACT(`files_filemanifest`.`manifest_data`, $."browser_specific_settings"."gecko"."update_url") IS NOT NULL...

@dependabot rebase

@dependabot recreate

> Link to it where necessary anywhere we link to a review page, including the review page itself for other channels. This is notably present in various admin pages, from...