Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Check version of Firefox installed against latest version from Firefox website
--Tested and working as of 2020-07-14
select
version as Current,
(
select
substr(
result,(
(
select
instr(result, 'data-latest-firefox=')
from
curl
where
url = 'https:' || '/' || '/' || 'www.mozilla.org/en-US/firefox/new/'
) + 21
),
6
) as Latest
from
curl
where
url = 'https:' || '/' || '/' || 'www.mozilla.org/en-US/firefox/new/'
) as Latest
from
programs
where
name like '%firefox%'
and version < (
select
substr(
result,(
(
select
instr(result, 'data-latest-firefox=')
from
curl
where
url = 'https:' || '/' || '/' || 'www.mozilla.org/en-US/firefox/new/'
) + 21
),
6
) as Latest
from
curl
where
url = 'https:' || '/' || '/' || 'www.mozilla.org/en-US/firefox/new/'
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment