{"schema_version":"4ort.packet/1","entity":{"entity_id":"postgresql","kg_uuid":"00920038-9a86-4b6c-a923-819b918d6e48","wikidata_id":"Q192490","name":"PostgreSQL","description":"free and open-source relational database management system","type":"CreativeWork","url":"https://4ort.xyz/entity/postgresql"},"status":"truncated","as_of":{"copy_written_at":"2026-11-15T13:23:30Z","last_source_edit_seen":"2026-11-12T21:06:19Z","stale_possible":false,"claims_refreshed_at":"2026-11-12T21:06:49Z","source_revision":2568422599},"facts":[{"field":"P31","label":"instance of","value":"relational database management system","value_id":"Q3932296","value_raw":"Q3932296","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P31","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P31","label":"instance of","value":"SQL server","value_id":"Q114901705","value_raw":"Q114901705","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P31","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P31","label":"instance of","value":"free software","value_id":"Q341","value_raw":"Q341","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P31","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P571","label":"inception","value":"1996","value_id":null,"value_raw":"+1996-00-00T00:00:00Z","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P571","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"imported_from":"French Wikipedia"}]},"trust":{"band":"medium","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P577","label":"publication date","value":"1996-07-08","value_id":null,"value_raw":"+1996-07-08T00:00:00Z","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P577","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"url":"https://www.postgresql.org/about/news/978/","retrieved":"2017-06-09"},{"imported_from":"English Wikipedia"}]},"trust":{"band":"high","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P856","label":"official website","value":"https://www.postgresql.org","value_id":null,"value_raw":"https://www.postgresql.org","rank":"normal","current":null,"qualifiers":[{"field":"P407","label":"language of work or name","value":"English"}],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P856","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"imported_from":"Italian Wikipedia"}]},"trust":{"band":"medium","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P463","label":"member of","value":"Software in the Public Interest","value_id":"Q685777","value_raw":"Q685777","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P463","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P144","label":"based on","value":"POSTGRES","value_id":"Q28975208","value_raw":"Q28975208","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P144","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P170","label":"creator","value":"Michael Stonebraker","value_id":"Q92758","value_raw":"Q92758","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P170","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"url":"https://www.postgresql.org/docs/current/history.html"}]},"trust":{"band":"high","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P178","label":"developer","value":"PostgreSQL Global Development Group","value_id":"Q65807102","value_raw":"Q65807102","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P178","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P178","label":"developer","value":"Peter Eisentraut","value_id":"Q122909316","value_raw":"Q122909316","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P178","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P178","label":"developer","value":"Tom Lane","value_id":"Q7816527","value_raw":"Q7816527","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P178","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P178","label":"developer","value":"Bruce Momjian","value_id":"Q113653074","value_raw":"Q113653074","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P178","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P178","label":"developer","value":"Marc Fournier","value_id":"Q122909361","value_raw":"Q122909361","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P178","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"url":"http://www.journaldunet.com/developpeur/itws/itw-postgresql-marcgfournier.shtml"}]},"trust":{"band":"high","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P275","label":"copyright license","value":"PostgreSQL License","value_id":"Q18563589","value_raw":"Q18563589","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P275","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P277","label":"programmed in","value":"C","value_id":"Q15777","value_raw":"Q15777","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P277","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"url":"https://github.com/postgres/postgres"},{"url":"https://www.openhub.net/p/postgres/analyses/latest/languages_summary","stated_in":"Open Hub","stated_in_id":"Q124688","title":"The postgres Open Source Project on Open Hub: Languages Page","retrieved":"2018-10-19"}]},"trust":{"band":"high","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P306","label":"operating system","value":"FreeBSD","value_id":"Q34236","value_raw":"Q34236","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P306","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"url":"https://www.postgresql.org/download/"}]},"trust":{"band":"high","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P306","label":"operating system","value":"OpenBSD","value_id":"Q34215","value_raw":"Q34215","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P306","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"url":"https://www.postgresql.org/download/"}]},"trust":{"band":"high","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P306","label":"operating system","value":"Linux","value_id":"Q388","value_raw":"Q388","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P306","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"url":"https://www.postgresql.org/download/"}]},"trust":{"band":"high","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P306","label":"operating system","value":"macOS","value_id":"Q14116","value_raw":"Q14116","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P306","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"url":"https://www.postgresql.org/download/"}]},"trust":{"band":"high","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P306","label":"operating system","value":"Solaris","value_id":"Q14646","value_raw":"Q14646","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P306","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"url":"https://www.postgresql.org/download/"}]},"trust":{"band":"high","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P348","label":"software version identifier","value":"18.7","value_id":null,"value_raw":"18.7","rank":"preferred","current":null,"qualifiers":[{"field":"P548","label":"version type","value":"Q2804309"},{"field":"P577","label":"publication date","value":"2026-11-12"}],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P348","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"url":"https://www.postgresql.org/about/news/postgresql-187-1712-1616-1520-1425-and-19-rc-2-released-3442/","title":"PostgreSQL 18.7, 17.12, 16.16, 15.20, 14.25, and 19 RC 2 Released!","retrieved":"2026-11-12"}]},"trust":{"band":"high","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P348","label":"software version identifier","value":"19 release candidate 2","value_id":null,"value_raw":"19 release candidate 2","rank":"preferred","current":null,"qualifiers":[{"field":"P548","label":"version type","value":"beta version"},{"field":"P577","label":"publication date","value":"2026-11-12"}],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P348","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"url":"https://www.postgresql.org/about/news/postgresql-187-1712-1616-1520-1425-and-19-rc-2-released-3442/","title":"PostgreSQL 18.7, 17.12, 16.16, 15.20, 14.25, and 19 RC 2 Released!","retrieved":"2026-11-12"}]},"trust":{"band":"high","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P348","label":"software version identifier","value":"9.3.5","value_id":null,"value_raw":"9.3.5","rank":"normal","current":null,"qualifiers":[{"field":"P577","label":"publication date","value":"2014-07-24"},{"field":"P4945","label":"download URL","value":"http://ftp.postgresql.org/pub/source/v9.3.5/"}],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P348","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"url":"http://www.postgresql.org/about/news/1534/"}]},"trust":{"band":"high","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P348","label":"software version identifier","value":"9.2.9","value_id":null,"value_raw":"9.2.9","rank":"normal","current":null,"qualifiers":[{"field":"P577","label":"publication date","value":"2014-07-24"},{"field":"P4945","label":"download URL","value":"http://ftp.postgresql.org/pub/source/v9.2.9/"}],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P348","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"url":"http://www.postgresql.org/about/news/1534/"}]},"trust":{"band":"high","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P348","label":"software version identifier","value":"9.1.14","value_id":null,"value_raw":"9.1.14","rank":"normal","current":null,"qualifiers":[{"field":"P577","label":"publication date","value":"2014-07-24"},{"field":"P4945","label":"download URL","value":"http://ftp.postgresql.org/pub/source/v9.1.14/"}],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P348","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"url":"http://www.postgresql.org/about/news/1534/"}]},"trust":{"band":"high","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P366","label":"has use","value":"relational database","value_id":"Q192588","value_raw":"Q192588","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P366","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[{"imported_from":"English Wikipedia"}]},"trust":{"band":"medium","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P366","label":"has use","value":"object-relational database management system","value_id":"Q58756","value_raw":"Q58756","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P366","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P527","label":"has part(s)","value":"PL/pgSQL","value_id":"Q2044345","value_raw":"Q2044345","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P527","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}},{"field":"P527","label":"has part(s)","value":"PL/Perl","value_id":"Q4046208","value_raw":"Q4046208","rank":"normal","current":null,"qualifiers":[],"layer":"source","citation":{"source":"wikidata","source_name":"Wikidata","source_record":"https://www.wikidata.org/wiki/Q192490#P527","source_edition":"2026-11-12T21:06:49Z","edition_basis":"claims_refreshed_at","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"references":[]},"trust":{"band":"unscored","basis":"wikidata-reference-support/2","calibrated":false}}],"unknowns":[],"omitted":{"facts":96,"reason":"max_facts; bare Q-id values without a label are left out"},"licences":[{"source":"wikidata","source_name":"Wikidata","licence":"CC0 1.0 Universal","licence_url":"https://creativecommons.org/publicdomain/zero/1.0/","attribution":null,"fields":["P31","P571","P577","P856","P463","P144","P170","P178","P275","P277","P306","P348","P366","P527"]}],"routes":{"entity_page":"https://4ort.xyz/entity/postgresql","packet_api":"https://4ort.xyz/api/v1/entities/postgresql/packet","facts_jsonld":"https://4ort.xyz/entity/postgresql/facts.json","changes_api":"https://4ort.xyz/api/v1/knowledge/get_entity_changes?entity=postgresql","attention_api":"https://4ort.xyz/api/v1/knowledge/get_attention?entity=postgresql","wikidata":"https://www.wikidata.org/wiki/Q192490","official_website":"https://www.postgresql.org"},"trust_rules":{"wikidata-reference-support/2":"From the references in our copy of the statement: high = it cites a source (stated in P248, or a reference URL that is not Wikipedia); medium = only 'imported from Wikimedia project' or a Wikipedia URL; unscored = our copy holds no reference (older copies dropped references, so this is not evidence that Wikidata has none). Wikidata may hold more references than our copy shows. Reference support, not a probability."},"notes":[]}