Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sHBEF-004K86-C8 for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Jun 2024 23:48:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sHBEC-00BJJS-5k for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Jun 2024 23:48:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sHBEB-00BJJJ-Ry for pgsql-hackers@lists.postgresql.org; Tue, 11 Jun 2024 23:48:36 +0000 Received: from mail-yw1-x112f.google.com ([2607:f8b0:4864:20::112f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sHBEA-001BCI-9q for pgsql-hackers@postgresql.org; Tue, 11 Jun 2024 23:48:35 +0000 Received: by mail-yw1-x112f.google.com with SMTP id 00721157ae682-62ce008743fso45432007b3.1 for ; Tue, 11 Jun 2024 16:48:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1718149712; x=1718754512; darn=postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=ZzNaZuuEqqDb3SmG2220NahcJkJrIMpqQCfy5eisqqI=; b=XtqgXW8VpUc88E659hMNzu2aVDRJ047fwuVAXH6BetxvUbFjfQ+d8hRKlQh0NyIhZj 4uSttwKGeepov4kvpKcXBiV/gCSWF8UlxRI1bILVPPBmMDjEsQTC0vpGmvgg4qMpOOSc wKdg+v1aCu/Br+G1KOCxmmXZD8ajHOoTRK2G8= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718149712; x=1718754512; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=ZzNaZuuEqqDb3SmG2220NahcJkJrIMpqQCfy5eisqqI=; b=HOX5nzhbYPfxe314WtDt6vDRqFESkPbVP1FZvTI2wrPMP2EVE1B1H9tt9gNu7Jtw2p cEFrwXPQ7WytA5Wc8ya+OA29+rlU/g+DG6tIqMgVRex1kAUozUHHuXLzm7aS05ihpvkp S9tTnHA2SbGf8z1savTthNDhOrLl1NGWGOARqreTHZyJWmBIJPBGjIoQTXTcX0D/JXFx mlpOLekBMImUp5t31uRHJ+Y4BKzYl+Yc+ISJxwQM7frtSzB0zzWI4ZDCl77THvBjMYKh 08fKm/Rj6hLVQd7JVxCnGKAKNFOCCEuBGQf2c3fpX7C5kVYGLyjw/kt0gSoOoYpd1GQk Ypdw== X-Forwarded-Encrypted: i=1; AJvYcCVqO4e07pJkXpHj6aWRGVkxukqmkAA5k9tHjPVrcqgQs0cByO4LYnEmhC1xnTZZsoQP7TLBYccPsV6XpLgxGgrLKtUaOo9fpZ9JnX7J X-Gm-Message-State: AOJu0Yzj0CssBZU3wQUFg/tm/19RqHG+IRBdUsYq1y3cPzXAmdx8BEiS HJAKx/M2g0ewURJyDlMf0KGI4Haevq2N1Qmn1VtYpuQ26LC6cULAJyB9BmygSA== X-Google-Smtp-Source: AGHT+IGciiY9eEqoGhmHGftW/Wk19b9A+Q+/B/mntL3RoFA6zonFG/LgkOniAbG7MsgM2nTB/3Sl2w== X-Received: by 2002:a0d:ea91:0:b0:62a:530:472f with SMTP id 00721157ae682-62fb9db1f0amr2485167b3.32.1718149712526; Tue, 11 Jun 2024 16:48:32 -0700 (PDT) Received: from rfd.leadboat.com ([2600:1702:a20:5750::48]) by smtp.gmail.com with ESMTPSA id 00721157ae682-62ccacb1d60sm22400037b3.8.2024.06.11.16.48.31 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 11 Jun 2024 16:48:32 -0700 (PDT) Date: Tue, 11 Jun 2024 16:48:29 -0700 From: Noah Misch To: Andres Freund Cc: Andrew Dunstan , Jacob Champion , PostgreSQL Hackers Subject: Re: RFC: adding pytest as a supported test framework Message-ID: <20240611234829.9d@rfd.leadboat.com> References: <20240610200411.byj6sv2vpgol6wcf@awork3.anarazel.de> <00c5efe6-1abb-42f8-a9a7-ed3a055c4b92@dunslane.net> <20240611014911.khxuai5fy2ssbmiw@awork3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20240611014911.khxuai5fy2ssbmiw@awork3.anarazel.de> User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Jun 10, 2024 at 06:49:11PM -0700, Andres Freund wrote: > On 2024-06-10 16:46:56 -0400, Andrew Dunstan wrote: > > On 2024-06-10 Mo 16:04, Andres Freund wrote: > > > Just for context for the rest the email: I think we desperately need to move > > > off perl for tests. The infrastructure around our testing is basically > > > unmaintained and just about nobody that started doing dev stuff in the last 10 > > > years learned perl. > > As for what up and coming developers learn, they mostly don't learn C > > either, and that's far more critical to what we do. > > C is a a lot more useful to to them than perl. And it's actually far more > widely known these days than perl. If we're going to test in a non-Perl language, I'd pick C over Python. There would be several other unlikely-community-choice languages I'd pick over Python (C#, Java, C++). We'd need a library like today's Perl PostgreSQL::Test to make C-language tests nice, but the same would apply to any new language. I also want the initial scope to be the new language coexisting with the existing Perl tests. If a bulk translation ever happens, it should happen long after the debut of the new framework. That said, I don't much trust a human-written bulk language translation to go through without some tests accidentally ceasing to test what they test in Perl today.