前言：

我们经常会被问或者自己主动要查询PG的相关支持时间范围，比如，它的最后支持时间是什么时候，以便于及时对PG进行版本更新和维护。

如果是在PG的官方文档上直接搜，可能还真找不到。因为它只是列出某一个版本下的相关内容。要搜还是直接去官网全局站点上搜： "versioning" ==> https://www.postgresql.org/search/?q=versioning

这样，顺便你也会记下这个网址：https://www.postgresql.org/support/versioning/

基于此，于是感到有些好奇，还真发现网上有人做了一个类似于endofliffe收集器的功能，他把所有重要的软件的end of life信息全部集中收集到一起，开放出来。确实有些点意思，比如，针对PostgreSQL：

https://endoflife.date/postgresql

你能看到这个:

直接访问网站

牛气并且很nice的地方，它还提供了相关的REST API:

三个重要的REST API

比如：

1、提供了所有的endoflife 的产品的列表:

GET: https://endoflife.date/api/all.json

["akeneo-pim",
"alibaba-dragonwell",
"almalinux",
"alpine",
"amazon-corretto",
"amazon-eks",
"amazon-glue",
"amazon-linux",
"amazon-neptune",
"amazon-rds-mysql",
"amazon-rds-postgresql",
"android",
"angular",
"angularjs",
"ansible",
"ansible-core",
"antix",
"apache",
"apache-activemq",
"apache-airflow",
"apache-camel",
"apache-cassandra",
"apache-groovy",
"apache-hadoop",
"apache-kafka",
"apache-spark",
"api-platform",
"argo-cd",
"artifactory",
"azul-zulu",
"azure-devops-server",
"azure-kubernetes-service",
"beats",
"bellsoft-liberica",
"blender",
"bootstrap",
"cakephp",
"centos",
"centos-stream",
"cfengine",
"citrix-vad",
"clamav",
"coldfusion",
"composer",
"confluence",
"consul",
"contao",
"cortex-xdr",
"cos",
"couchbase-server",
"craft-cms",
"debian",
"dependency-track",
"devuan",
"django",
"docker-engine",
"dotnet",
"dotnetfx",
"drupal",
"drush",
"eclipse-temurin",
"elasticsearch",
"electron",
"elixir",
"emberjs",
"envoy",
"esxi",
"etcd",
"eurolinux",
"exim",
"fairphone",
"fedora",
"ffmpeg",
"filemaker",
"firefox",
"flux",
"fortios",
"freebsd",
"gerrit",
"gitlab",
"go",
"godot",
"google-kubernetes-engine",
"gorilla",
"graalvm",
"gradle",
"grafana",
"grails",
"graylog",
"gstreamer",
"haproxy",
"hashicorp-vault",
"hbase",
"horizon",
"ibm-aix",
"ibm-semeru-runtime",
"intel-processors",
"internet-explorer",
"ionic",
"ios",
"ipad",
"ipados",
"iphone",
"isc-dhcp",
"istio",
"jekyll",
"jenkins",
"jhipster",
"jira-software",
"joomla",
"jquery",
"jreleaser",
"kde-plasma",
"keycloak",
"kibana",
"kindle",
"kirby",
"kotlin",
"kubernetes",
"laravel",
"libreoffice",
"lineageos",
"linux",
"linuxmint",
"log4j",
"logstash",
"looker",
"macos",
"mageia",
"magento",
"mariadb",
"mastodon",
"mattermost",
"maven",
"mediawiki",
"micronaut",
"microsoft-build-of-openjdk",
"mongodb",
"moodle",
"msexchange",
"mssqlserver",
"mulesoft-runtime",
"mxlinux",
"mysql",
"neo4j",
"netbsd",
"nextcloud",
"nextjs",
"nexus",
"nginx",
"nix",
"nixos",
"nodejs",
"nokia",
"nomad",
"numpy",
"nutanix-aos",
"nutanix-files",
"nutanix-prism",
"nuxt",
"nvidia",
"nvidia-gpu",
"office",
"openbsd",
"openjdk-builds-from-oracle",
"opensearch",
"openssl",
"opensuse",
"openwrt",
"openzfs",
"oracle-database",
"oracle-jdk",
"oraclelinux",
"pangp",
"panos",
"pci-dss",
"perl",
"photon",
"php",
"phpbb",
"phpmyadmin",
"pixel",
"plesk",
"pop-os",
"postfix",
"postgresql",
"powershell",
"prometheus",
"proxmox-ve",
"puppet",
"python",
"qt",
"quarkus-framework",
"quasar",
"rabbitmq",
"rails",
"raspberry-pi",
"react",
"readynas",
"red-hat-openshift",
"redhat-build-of-openjdk",
"redhat-satellite",
"redis",
"redmine",
"rhel",
"rocky-linux",
"ros",
"ros2",
"roundcube",
"ruby",
"salt",
"samsung-mobile",
"sapmachine",
"scala",
"sharepoint",
"silverstripe",
"slackware",
"sles",
"solr",
"sonar",
"splunk",
"spring-boot",
"spring-framework",
"sqlite",
"squid",
"surface",
"symfony",
"tails",
"tarantool",
"telegraf",
"terraform",
"tomcat",
"twig",
"typo3",
"ubuntu",
"umbraco",
"unity",
"unrealircd",
"varnish",
"vcenter",
"visual-cobol",
"visual-studio",
"vmware-cloud-foundation",
"vmware-srm",
"vue",
"vuetify",
"wagtail",
"watchos",
"weechat",
"windows",
"windows-embedded",
"windows-server",
"wordpress",
"xcp-ng",
"yarn",
"yocto",
"zabbix",
"zookeeper"]

2、指定某一产品某一版本时，获取它的endoflife的信息 (Single cycle details)

GET https://endoflife.date/api/{product}/{cycle}.json
如：
https://endoflife.date/api/python/3.10.json
response: 
{"support":"2023-04-05","eol":"2026-10-04","latest":"3.10.13","latestReleaseDate":"2023-08-24","releaseDate":"2021-10-04","lts":false}

如：就拿PostgreSQL
https://endoflife.date/api/postgresql/16.json

{"releaseDate":"2023-09-11","eol":"2028-11-09","latest":"16.0","latestReleaseDate":"2023-09-11","lts":false}

3、直接获取某个产品所有的endoflife信息

还拿刚才PostgreSQL做例子:

https://endoflife.date/api/postgresql.json
[{
    "cycle": "16",
    "releaseDate": "2023-09-11",
    "eol": "2028-11-09",
    "latest": "16.0",
    "latestReleaseDate": "2023-09-11",
    "lts": false
},
{
    "cycle": "15",
    "releaseDate": "2022-10-10",
    "eol": "2027-11-11",
    "latest": "15.4",
    "latestReleaseDate": "2023-08-07",
    "lts": false
},
{
    "cycle": "14",
    "releaseDate": "2021-09-27",
    "eol": "2026-09-30",
    "latest": "14.9",
    "latestReleaseDate": "2023-08-07",
    "lts": false
},
{
    "cycle": "13",
    "releaseDate": "2020-09-21",
    "eol": "2025-11-13",
    "latest": "13.12",
    "latestReleaseDate": "2023-08-07",
    "lts": false
},
{
    "cycle": "12",
    "releaseDate": "2019-09-30",
    "eol": "2024-11-14",
    "latest": "12.16",
    "latestReleaseDate": "2023-08-07",
    "lts": false
},
{
    "cycle": "11",
    "releaseDate": "2018-10-15",
    "eol": "2023-11-09",
    "latest": "11.21",
    "latestReleaseDate": "2023-08-07",
    "lts": false
},
{
    "cycle": "10",
    "releaseDate": "2017-10-02",
    "eol": "2022-11-10",
    "latest": "10.23",
    "latestReleaseDate": "2022-11-07",
    "lts": false
},
{
    "cycle": "9.6",
    "releaseDate": "2016-09-26",
    "eol": "2021-11-11",
    "latest": "9.6.24",
    "latestReleaseDate": "2021-11-08",
    "lts": false
},
{
    "cycle": "9.5",
    "releaseDate": "2016-01-04",
    "eol": "2021-02-11",
    "latest": "9.5.25",
    "latestReleaseDate": "2021-02-08",
    "lts": false
},
{
    "cycle": "9.4",
    "releaseDate": "2014-12-15",
    "eol": "2020-02-13",
    "latest": "9.4.26",
    "latestReleaseDate": "2020-02-10",
    "lts": false
},
{
    "cycle": "9.3",
    "releaseDate": "2013-09-02",
    "eol": "2018-11-08",
    "latest": "9.3.25",
    "latestReleaseDate": "2018-11-05",
    "lts": false
},
{
    "cycle": "9.2",
    "releaseDate": "2012-09-06",
    "eol": "2017-11-09",
    "latest": "9.2.24",
    "latestReleaseDate": "2017-11-06",
    "lts": false
},
{
    "cycle": "9.1",
    "releaseDate": "2011-09-08",
    "eol": "2016-10-27",
    "latest": "9.1.24",
    "latestReleaseDate": "2016-10-24",
    "lts": false
},
{
    "cycle": "9.0",
    "releaseDate": "2010-09-17",
    "eol": "2015-10-08",
    "latest": "9.0.23",
    "latestReleaseDate": "2015-10-05",
    "lts": false
},
{
    "cycle": "8.4",
    "releaseDate": "2009-06-27",
    "eol": "2014-07-24",
    "latest": "8.4.22",
    "latestReleaseDate": "2014-07-21",
    "lts": false
},
{
    "cycle": "8.3",
    "releaseDate": "2008-02-01",
    "eol": "2013-02-07",
    "latest": "8.3.23",
    "latestReleaseDate": "2013-02-04",
    "lts": false
},
{
    "cycle": "8.2",
    "releaseDate": "2006-12-02",
    "eol": "2011-12-05",
    "latest": "8.2.23",
    "latestReleaseDate": "2011-12-01",
    "lts": false
},
{
    "cycle": "8.1",
    "releaseDate": "2005-11-05",
    "eol": "2010-11-08",
    "latest": "8.1.23",
    "latestReleaseDate": "2010-12-13",
    "lts": false
},
{
    "cycle": "8.0",
    "releaseDate": "2005-01-17",
    "eol": "2010-10-01",
    "latest": "8.0.26",
    "latestReleaseDate": "2010-10-01",
    "lts": false
}]

以后，如果有人问你，帮我查一下PostgreSQL 14的支持周期，你可以说，请访问：https://endoflife.date/api/postgresql/14.json

https://endoflife.date/api/postgresql/14.json
{
    "releaseDate": "2021-09-27",
    "eol": "2026-09-30",
    "latest": "14.9",
    "latestReleaseDate": "2023-08-07",
    "lts": false
}

请给我一份MySQL的endoflife信息：

https://endoflife.date/api/mysql.json

[{
    "cycle": "8.1",
    "latest": "8.1.0",
    "support": true,
    "eol": false,
    "latestReleaseDate": "2023-06-21",
    "releaseDate": "2023-06-21",
    "lts": false
},
{
    "cycle": "8.0",
    "latest": "8.0.34",
    "support": "2025-04-30",
    "eol": "2026-04-30",
    "lts": "2023-07-18",
    "latestReleaseDate": "2023-06-22",
    "releaseDate": "2018-04-08"
},
{
    "cycle": "5.7",
    "latest": "5.7.43",
    "support": "2020-10-31",
    "eol": "2023-10-31",
    "latestReleaseDate": "2023-06-21",
    "releaseDate": "2015-10-09",
    "lts": false
},
{
    "cycle": "5.6",
    "latest": "5.6.51",
    "support": "2018-02-28",
    "eol": "2021-02-28",
    "latestReleaseDate": "2021-01-05",
    "releaseDate": "2013-02-01",
    "lts": false
},
{
    "cycle": "5.5",
    "latest": "5.5.63",
    "support": "2015-12-31",
    "eol": "2018-12-31",
    "latestReleaseDate": "2018-12-21",
    "releaseDate": "2010-12-03",
    "lts": false
}]

好玩好用的工具： https://endoflife.date/api/  ,  可以用起来。