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 1uDNDL-009rCC-5x for pgsql-general@arkaria.postgresql.org; Fri, 09 May 2025 12:52:31 +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 1uDNDJ-00AcUk-U7 for pgsql-general@arkaria.postgresql.org; Fri, 09 May 2025 12:52:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uDNDJ-00AcUZ-JF for pgsql-general@lists.postgresql.org; Fri, 09 May 2025 12:52:29 +0000 Received: from mail-lf1-x12e.google.com ([2a00:1450:4864:20::12e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uDNDH-000xEH-0C for pgsql-general@lists.postgresql.org; Fri, 09 May 2025 12:52:28 +0000 Received: by mail-lf1-x12e.google.com with SMTP id 2adb3069b0e04-54acc0cd458so2164274e87.0 for ; Fri, 09 May 2025 05:52:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1746795145; x=1747399945; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=F7HHrn3KlsqQDBOVGRLowtEtP3jWtplc7l0+w/HZ7m4=; b=BXywnl5uiTm197Kpt6abrf3+du+67OoBg8OVi2MJQAR1ZZ5m1PbeuZtjvQOOZBEGCz Bhf4ff3hM853U9jp+eBkhOl9jLXDUSZsW5BX5XOm73+Ug+OMpavg+N0A+gnyjuFsqejx +Vs/2Fy0L4bNBM7PhqApw5+2Vw1pSK8az9GEfgmNM40+uc6cuftxlrvVuIVMfP7MMYWY pxC4Lo6W1TpdsYmkzASFKZyblF0qncv5fiVb9uVXhRyebsqZPj8A47PUeA4koUcjTu7c P1bBKgcRGJ00fDtwBYmrrkvVfClPa5PW3iVmH4aA3msgLu7Zmyi7Ded7McIFyxVzwuEY peXQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1746795145; x=1747399945; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=F7HHrn3KlsqQDBOVGRLowtEtP3jWtplc7l0+w/HZ7m4=; b=Pjvb38/FRy4qb79/KlFVj60STs7zvn4oapeVRMg3VkPsCjeCcX6ueGSEjCuBVwoLnY xb5fcSzt2zyUm4FeWJcQjfTj5pfyRI2MTRKcXVYFiKi5wYSaI6HDGAjINV4rgICtZ2Mo 2YBy+XY1tQXXM0OnSroBO6jeE7N7sUNMYBBMRDs2eW85+OCM54NzebmetbEJhfd2hldd XsOeCAUHuQJYIP4S9/N4n+6oXzDyn0+Qum/K7pEvKDII9RDHdPntLvXngTH3prRAjf1G h4sZFBhBoy9KyCRP18NTUMmetPboCDNNhrVI8KTSgcwtc5cJCCh2SxRbBkeY8kTYx4H9 StIw== X-Forwarded-Encrypted: i=1; AJvYcCVliYPxupl1/sEwjky2N6N5/DT/jiA0oV+Oepp2cvN1PKwu3tvlnwXDv+anjpljgDMQnUfHsZDiKDf0v0Jg@lists.postgresql.org X-Gm-Message-State: AOJu0YzlZOsT2XzYpXKF6CwIsLpdc7rfrtcdRQ+VnETvATdLLjzTj7lx ZRfpil7tueeb3CmvtNSqGEwA/ONrJuki99/i7GoNON3DBz5ehNV9BPqYeaXKoUTz346aXMhhUxv 3QUU7bAgRNBZDR+rbtHP2/bpVNwc= X-Gm-Gg: ASbGncvvqd8AqzQ1ELy0ZFgnXq8vSuU8TDBryio9LGjwCgbfhQwrPGqyt6f+hXBAi9B MqZEdECIOfSRGoQCn6FxxGwLESTcJHZmFstnHBdxGvfTnAB5vov3uOaDnAmRkv7YFavUsa5/XCt 6VSe+bKUgDgCUKX9OLPTy5ZNWy68pPgLGFdH/k8OYl6pGHC0vUu1zD/J/k X-Google-Smtp-Source: AGHT+IFiMom5+CAK1GR2PiKCHAUNBPKIVFxY0jrwMQ0tPenhswOpEMLzfPl507HKKHhiKiLNN19AG+3LzfcKan+hags= X-Received: by 2002:a05:6512:460d:b0:54f:c450:311d with SMTP id 2adb3069b0e04-54fc67aced6mr1112798e87.7.1746795144670; Fri, 09 May 2025 05:52:24 -0700 (PDT) MIME-Version: 1.0 References: <6A7ABC92-D755-4CC3-8C8D-B5C4E91F0D21@mcdougall.io> In-Reply-To: <6A7ABC92-D755-4CC3-8C8D-B5C4E91F0D21@mcdougall.io> From: Merlin Moncure Date: Fri, 9 May 2025 07:52:12 -0500 X-Gm-Features: AX0GCFvrzpos5Zc76w51g_YXS4BycT03LBbiqVxVdoGhXnpZY5VAHlE_u3Ai8lI Message-ID: Subject: Re: Is anyone up for hosting the online PG game "Schemaverse"? To: Joshua McDougall Cc: Justin Clift , pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000017f3230634b370e6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000017f3230634b370e6 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, May 8, 2025 at 7:52=E2=80=AFPM Joshua McDougall wrote: > Hi Merlin, > > The core database portion isn=E2=80=99t too complicated to get setup, it= =E2=80=99s a > sqitch project. There are a couple Perl scripts that run continuously in = a > screen session as well. > > The web interfaces are a little dated and need some fiddling to get > operational. This tends to be the most complicated part to get running > lately. > > I would happily help either by answering questions, or by directly workin= g > on the system. I could also spend some time getting it all working smooth= ly > via docker if a container was preferred. > > Thanks for your interest! > Sure. FYI: look familiar? https://github.com/merlinm/rpgame. It should -- it was loosely inspired from your effort. This was the output of a SQL training class I was giving to non technical folks at a prior gig. You may or may not recall I was the one abusing advisory locks so no one could play the game but me :-). Your project is an important part of postgres history IMO. I have some hosting through gcp; I'll set something up. Out of town until late next week but I'll circle back then. merlin --00000000000017f3230634b370e6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

On Thu, May 8, 2025 at 7:52=E2=80=AFPM Joshua McDougall <joshua@mcdougall.io> wr= ote:
Hi Merlin,

The core database portion is= n=E2=80=99t too complicated to get setup, it=E2=80=99s a sqitch project. Th= ere are a couple Perl scripts that run continuously in a screen session as = well.=C2=A0

The web interfaces are a little dated = and need some fiddling to get operational. This tends to be the most compli= cated part to get running lately.=C2=A0

I would ha= ppily help either by answering questions, or by directly working on the sys= tem. I could also spend some time getting it all working smoothly via docke= r if a container was preferred.=C2=A0

Thanks for y= our interest!

Sure.=C2=A0 FYI: = look familiar?=C2=A0=C2=A0htt= ps://github.com/merlinm/rpgame.=C2=A0

It shou= ld -- it was loosely inspired from your effort.=C2=A0 =C2=A0This was the ou= tput of a SQL training=C2=A0class I was giving=C2=A0to non technical folks = at a prior gig.

You may or may not reca= ll I was the one abusing advisory locks so no one could=C2=A0play the game = but me :-).=C2=A0 Your project is an important part of postgres history IMO= .=C2=A0 I have some hosting through=C2=A0gcp; I'll set something=C2=A0u= p.=C2=A0 Out of town until late next week but I'll circle back then.

merlin
=C2=A0
--00000000000017f3230634b370e6--