endoflifedate_products

58 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: product_name, supported_until, is_supported, supported_until (date), eol_from (date), inserted_at (date)

CREATE TABLE endoflifedate_products (
  -- product_name describes an EndOfLife.date Product name.
  -- For example:
  --   go
  --   ansible
  --   sqlite
  product_name TEXT NOT NULL,

  -- cycle of the given product, as defined by EndOfLife.date, and the product
  -- itself.
  --
  -- For example (non-exhaustively):
  --   sqlite has cycles: `3`, `2`, `1`
  --   go     has cycles: `1.21`, `1.20`, `1.5`
  cycle TEXT NOT NULL,

  -- supported_until describes the date that this release is (actively)
  -- supported until.
  --
  -- Either `supported_until` or `is_supported` will be specified to indicate
  -- whether the release is (actively) supported.
  supported_until TEXT,
  -- is_supported indicates whether the this release is (actively)
  -- supported until.
  --
  -- You'll likely want to query i.e. `WHERE is_supported = false`
  --
  -- Either `supported_until` or `is_supported` will be specified to indicate
  -- whether the release is (actively) supported.
  is_supported BOOLEAN,
  -- eol_from describes the date that this release will be marked as End of
  -- Life, and will no longer be maintained from
  --
  -- Either `eol_from` or `is_eol ` will be specified to indicate whether the
  -- release is End of Life, and will no longer be maintained from
  eol_from TEXT,
  -- is_eol indicates whether this release is marked as End of Life, and will
  -- no longer be maintained
  --
  -- You'll likely want to query i.e. `WHERE is_eol = true`
  --
  -- Either `eol_from` or `is_eol ` will be specified to indicate whether the
  -- release is End of Life, and will no longer be maintained from
  is_eol BOOLEAN,

  -- inserted_at indicates when this row was inserted into the database
  inserted_at TEXT NOT NULL,

  UNIQUE (product_name, cycle) ON CONFLICT REPLACE,
  CHECK(product_name <> ''),
  CHECK(cycle <> '')
);