pglinter v2.0.0

What's Changed

• fix(ci): push oci image by @pmpetit in #94
• Remove check() and check_rule() functions; get_violations() is the only API by @Copilot in #95
• fix(ci): new 0.18.0 pgrx version by @pmpetit in #97
• fix(ci): build for arm64 in runner instead of docker by @pmpetit in #99
• fix: sequence OCI image build after package-and-deploy via workflow_run by @Copilot in #100
• fix(ci): 2.0.0 by @pmpetit in #102
• chore: bump actions, pin with sha, and fix input var by @jylenhof in #101

New Contributors

• @jylenhof made their first contribution in #101

Full Changelog: 1.1.2...2.0.0

pglinter v1.1.2

What's Changed

• feat(new rule): add rule b013, row by row processing trigger without where clause by @pmpetit in #92

Full Changelog: 1.1.1...1.1.2

pglinter v1.1.1

What's Changed

• Fix/oci build by @pmpetit in #86
• ci(oci): test oci by @pmpetit in #87
• oci by @pmpetit in #88
• oci by @pmpetit in #89
• oci by @pmpetit in #90

Full Changelog: 1.1.0...1.1.1

pglinter v1.1.0

What's Changed

• feat(ci/patreon): add profil by @pmpetit in #80
• Create LICENSE by @GregoireW in #81
• docs(install): show different way to install by @pmpetit in #82
• Fix spelling and clarity issues in README by @pmpetit in #84
• feat(get_violations): add a fn to list all objects by @pmpetit in #85

New Contributors

• @GregoireW made their first contribution in #81

Full Changelog: 1.0.1...1.1.0

pglinter v1.0.1

What's Changed

• docs(rules): add missing rules by @pmpetit in #67
• doc(tutorial): add a link to tutorial to create rules by @pmpetit in #68
• docs(readme): add env vars in doc and change version by @pmpetit in #70
• ci(oci): build image oci for pcn by @pmpetit in #72
• docs(oci_image): created oci image by @pmpetit in #73
• docs(k8s/oci): give an example for pcn by @pmpetit in #76
• docs(oci): create package by @pmpetit in #77
• docs(remove t-rules): update docs on t-rules by @pmpetit in #78
• feat(rule): add b012 composite primary key by @pmpetit in #79

Full Changelog: 1.0.0...1.0.1

pglinter v1.0.0

What's Changed

• ci(matrix): refacto ci code by @pmpetit in #64
• feat(rules): remove t-rules and merge with b-rules by @pmpetit in #65
• feat(release): bump to 1.0.0 by @pmpetit in #66

Full Changelog: 0.0.20...1.0.0

pglinter v0.0.20

pglinter v0.0.20

PostgreSQL extension for database linting and analysis.

📦 Available Packages

This release includes packages for PostgreSQL versions 13, 14, 15, 16, 17, and 18.

🚀 Installation

Debian/Ubuntu Systems:

# Download and install (replace XX with your PG version: 13, 14, 15, 16, 17, 18)
wget https://github.com/pmpetit/pglinter/releases/download/0.0.20/postgresql_pglinter_XX_0.0.20_amd64.deb
sudo dpkg -i postgresql_pglinter_XX_0.0.20_amd64.deb

# Fix dependencies if needed
sudo apt-get install -f

RHEL/CentOS/Fedora Systems:

# Download and install (replace XX with your PG version: 13, 14, 15, 16, 17, 18)
wget https://github.com/pmpetit/pglinter/releases/download/0.0.20/postgresql_pglinter_XX-0.0.20-1.x86_64.rpm
sudo rpm -i postgresql_pglinter_XX-0.0.20-1.x86_64.rpm
# or
sudo yum localinstall postgresql_pglinter_XX-0.0.20-1.x86_64.rpm

💻 Usage

After installation, enable the extension in your PostgreSQL database:

-- Connect to your database
\c your_database

-- Create the extension
CREATE EXTENSION pglinter;

-- Run a basic check
SELECT pglinter.perform_base_check();

-- Check specific rules
SELECT pglinter.check_rule('B001');  -- Tables without primary keys
SELECT pglinter.check_rule('B002');  -- Redundant indexes

📋 Available Rules

• B001-B008: Base database rules (primary keys, indexes, schemas, etc.)
• C002: Cluster security rules
• T001-T010: Individual table rules
• S001: Schema rules

For complete documentation, visit: https://github.com/pmpetit/pglinter/blob/main/docs/functions/README.md

pglinter v0.0.19

pglinter v0.0.19

PostgreSQL extension for database linting and analysis.

📦 Available Packages

This release includes packages for PostgreSQL versions 13, 14, 15, 16, 17, and 18.

🚀 Installation

Debian/Ubuntu Systems:

# Download and install (replace XX with your PG version: 13, 14, 15, 16, 17, 18)
wget https://github.com/pmpetit/pglinter/releases/download/0.0.19/postgresql_pglinter_XX_0.0.19_amd64.deb
sudo dpkg -i postgresql_pglinter_XX_0.0.19_amd64.deb

# Fix dependencies if needed
sudo apt-get install -f

RHEL/CentOS/Fedora Systems:

# Download and install (replace XX with your PG version: 13, 14, 15, 16, 17, 18)
wget https://github.com/pmpetit/pglinter/releases/download/0.0.19/postgresql_pglinter_XX-0.0.19-1.x86_64.rpm
sudo rpm -i postgresql_pglinter_XX-0.0.19-1.x86_64.rpm
# or
sudo yum localinstall postgresql_pglinter_XX-0.0.19-1.x86_64.rpm

💻 Usage

After installation, enable the extension in your PostgreSQL database:

-- Connect to your database
\c your_database

-- Create the extension
CREATE EXTENSION pglinter;

-- Run a basic check
SELECT pglinter.perform_base_check();

-- Check specific rules
SELECT pglinter.check_rule('B001');  -- Tables without primary keys
SELECT pglinter.check_rule('B002');  -- Redundant indexes

📋 Available Rules

• B001-B008: Base database rules (primary keys, indexes, schemas, etc.)
• C002: Cluster security rules
• T001-T010: Individual table rules
• S001: Schema rules

For complete documentation, visit: https://github.com/pmpetit/pglinter/blob/main/docs/functions/README.md

pglinter v0.0.17

pglinter v0.0.17

PostgreSQL extension for database linting and analysis.

📦 Available Packages

This release includes packages for PostgreSQL versions 13, 14, 15, 16, 17, and 18.

🚀 Installation

Debian/Ubuntu Systems:

# Download and install (replace XX with your PG version: 13, 14, 15, 16, 17, 18)
wget https://github.com/pmpetit/pglinter/releases/download/0.0.17/postgresql_pglinter_XX_0.0.17_amd64.deb
sudo dpkg -i postgresql_pglinter_XX_0.0.17_amd64.deb

# Fix dependencies if needed
sudo apt-get install -f

RHEL/CentOS/Fedora Systems:

# Download and install (replace XX with your PG version: 13, 14, 15, 16, 17, 18)
wget https://github.com/pmpetit/pglinter/releases/download/0.0.17/postgresql_pglinter_XX-0.0.17-1.x86_64.rpm
sudo rpm -i postgresql_pglinter_XX-0.0.17-1.x86_64.rpm
# or
sudo yum localinstall postgresql_pglinter_XX-0.0.17-1.x86_64.rpm

💻 Usage

After installation, enable the extension in your PostgreSQL database:

-- Connect to your database
\c your_database

-- Create the extension
CREATE EXTENSION pglinter;

-- Run a basic check
SELECT pglinter.perform_base_check();

-- Check specific rules
SELECT pglinter.check_rule('B001');  -- Tables without primary keys
SELECT pglinter.check_rule('B002');  -- Redundant indexes

📋 Available Rules

• B001-B008: Base database rules (primary keys, indexes, schemas, etc.)
• C002: Cluster security rules
• T001-T010: Individual table rules
• S001: Schema rules

For complete documentation, visit: https://github.com/pmpetit/pglinter/blob/main/docs/functions/README.md

0.0.16

What's Changed

• feat(regtest): add regtest on b001 by @pmpetit in #17
• feat(regtest): add test on b002 rule by @pmpetit in #18
• feat(new rule): new approach by @pmpetit in #20
• docs(template): add template for issues and fix functions doc by @pmpetit in #23

Full Changelog: 0.0.1...0.0.16