{"repo":"secp256k1-sha256/postgres-compatibility-index","free":true,"listed":false,"github":"https://github.com/secp256k1-sha256/postgres-compatibility-index","clone":"git clone https://github.com/secp256k1-sha256/postgres-compatibility-index.git","description":"Postgres Compatibility Index (PGScorecard)","language":"Python","stars":34,"topics":["databases","postgres","postgresql"],"license":"MIT","category":"databases-storage","readme_excerpt":"PostgreSQL Compatibility Index (PCI) This repository provides a standardized method to evaluate the compatibility of a database system with PostgreSQL using fixed feature categories and scoring rules. PostgreSQL 17 is used for baseline. A visualization of the up-to-date results can be found on \"PG Sorecard\" : pgscorecard Origin story in a blog format = drunkdba.medium.com/postgres-is-3cbae80c84a3 Philosophy behind \"Postgres-Compatibility-Index\" Update: In response to a trademark notice from the PostgreSQL Community Association of Canada, domain has been changed from “Postgres.Is” to \"pgscorecard.com\" Methodology The PCI evaluates a fixed set of PostgreSQL features across 12 categories. Each feature is scored as: - full (1.0) - partial (0.5) - no (0.0) The final PCI score is a weighted average of the scores for each category. Prerequisites - Python 3.5+, psycopg2, postgresql client and working connection to the database to be tested. - pip install tabulate - Install postgis, pgvector extension to score more points as in some cases it will require pre-installation. Automated scoring - Set environment variables or provide inline username, connection details of the database where tests are supposed to run. - You will lose points for extensions that you do not install. - python3 pci autotest.py Example Output in Tabular Format PostgreSQL Compatibility Report Overall Compatibility Score: 85% Failed Features: Category Feature ------------------------ --------------------- data types","default_branch":null,"files":null,"tree":[],"storefront":"/r/secp256k1-sha256","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/secp256k1-sha256/postgres-compatibility-index/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}