Message-ID: <949b0dee-6cdc-4519-b2dd-52182de761a4@technowledgy.de>
Date: Wed, 12 Jun 2024 16:56:49 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
From: walther@technowledgy.de
Subject: Re: RFC: adding pytest as a supported test framework
To: Jelte Fennema-Nio <postgres@jeltef.nl>, Noah Misch <noah@leadboat.com>
Cc: Andres Freund <andres@anarazel.de>, Andrew Dunstan <andrew@dunslane.net>,
 Jacob Champion <jacob.champion@enterprisedb.com>,
 PostgreSQL Hackers <pgsql-hackers@postgresql.org>
References: <CAOYmi+kThkM9Z87u=R_Wi7fCor2i+UZKAyq0UCyprzCwTQvqgA@mail.gmail.com>
 <20240610200411.byj6sv2vpgol6wcf@awork3.anarazel.de>
 <00c5efe6-1abb-42f8-a9a7-ed3a055c4b92@dunslane.net>
 <20240611014911.khxuai5fy2ssbmiw@awork3.anarazel.de>
 <20240611234829.9d@rfd.leadboat.com>
 <CAGECzQTEPcLH-Gjr8aTkK=R36_jHU_ikhhan6hO42zCoUNv=yA@mail.gmail.com>
Content-Language: en-US
In-Reply-To: <CAGECzQTEPcLH-Gjr8aTkK=R36_jHU_ikhhan6hO42zCoUNv=yA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/949b0dee-6cdc-4519-b2dd-52182de761a4%40technowledgy.de>
Precedence: bulk

Jelte Fennema-Nio:
> As scripting languages go, the ones that are still fairly heavily in
> use are Javascript, Python, Ruby, and PHP. I think all of those could
> probably work, but my personal order of preference would be Python,
> Ruby, Javascript, PHP.
> 
> Finally, I'm definitely biased towards using Python myself. But I
> think there's good reasons for that:
> 1. In the data space, that Postgres in, Python is very heavily used for analysis
> 2. Everyone coming out of university these days knows it to some extent
> 3. Multiple people in the community have been writing Postgres related
> tests in python and have enjoyed doing so (me[1], Jacob[2],
> Alexander[3])

PostgREST also uses pytest for integration tests - and that was a very 
good decision compared to the bash based tests we had before.

One more argument for Python compared to the other mentioned scripting 
languages: Python is already a development dependency via meson. None of 
the other 3 are. In a future where meson will be the only build system, 
we will have python "for free" already.

Best,

Wolfgang