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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1uAcJ8-00HSDW-S2
	for pgsql-general@arkaria.postgresql.org; Thu, 01 May 2025 22:23:07 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1uAcJ6-005eMI-SQ
	for pgsql-general@arkaria.postgresql.org; Thu, 01 May 2025 22:23:05 +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 <justin@postgresql.org>)
	id 1uAcJ6-005eMA-Hd
	for pgsql-general@lists.postgresql.org; Thu, 01 May 2025 22:23:05 +0000
Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <justin@postgresql.org>)
	id 1uAcJ5-000bnh-24
	for pgsql-general@lists.postgresql.org;
	Thu, 01 May 2025 22:23:05 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
	d=postgresql.org; s=20171124; h=Content-Transfer-Encoding:Content-Type:
	Message-ID:References:In-Reply-To:Subject:Cc:To:From:Date:MIME-Version:Sender
	:Reply-To:Content-ID:Content-Description;
	bh=zi/Svx+APWXBp+wn1fU/9RDsQ+3RMpX8OGkJl5Xrkxg=; b=jNqYnU+L8PrwMW0PnZ/+b/cfwT
	uwpELE2H+igCOwbHqLEnD3P5oCK6fuh8je9QIkxfPLz05x9VQw2L+OUVw8j3wdBSv/WpdYlu/EYn5
	2ne48O4l9Y4ZbFtYd1i2b5ySM6z/ZnpWlpsEPC7IMR/TBClvhvjb0/03fBgoIB8ECqQWPWVqGjDEr
	3fc+lxIGciVyEK+LqJTWsmD9cKrpMyyR5nFcFUDROh2jRKg6kahrhyW6KAMa3ZREZFyWtrorAR0YH
	l27NOxLrJKbFJ9C4SbzNUROm+pT2Oq0fHrfjYDS5ztXQDKKXoWP3xtkXAEImpmZeEvcdOmdpL+MrZ
	JC3dIlzg==;
Received: from meldrar.postgresql.org ([87.238.57.231] helo=webmail.postgresql.org)
	by meldrar.postgresql.org with esmtpsa  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <justin@postgresql.org>)
	id 1uAcJ3-001KyZ-2t;
	Thu, 01 May 2025 22:23:03 +0000
MIME-Version: 1.0
Date: Fri, 02 May 2025 08:23:00 +1000
From: Justin Clift <justin@postgresql.org>
To: pgsql-general@lists.postgresql.org
Cc: Joshua McDougall <joshua@mcdougall.io>
Subject: Is anyone up for hosting the online PG game "Schemaverse"?
In-Reply-To: <D70C45C1-78C1-43C0-99A4-55176FCE48DC@mcdougall.io>
References: <D70C45C1-78C1-43C0-99A4-55176FCE48DC@mcdougall.io>
Message-ID: <b74747c27a75b0acb570eadbcf73e47b@postgresql.org>
X-Sender: justin@postgresql.org
Content-Type: text/plain; charset=UTF-8;
 format=flowed
Content-Transfer-Encoding: 8bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/b74747c27a75b0acb570eadbcf73e47b%40postgresql.org>
Precedence: bulk

Hi all,

The PostgreSQL game "Schemaverse" was removed from the PostgreSQL 
website's
links a few months ago because it no longer had hosting.

Does anyone around have spare server/vm/something that could be used to
host it (for free)?

Details in the forwarded message below. :)

Regards and best wishes,

Justin Clift


-------- Original Message --------
Subject: Schemaverse
Date: 2025-04-21 13:01
 From: Joshua McDougall <joshua@mcdougall.io>
To: justin@postgresql.org

Hi Justin,
<snip>

To answer your question, Schemaverse doesn’t take massive power to host. 
It needs a database and a small server for the front-end, which can (and 
has) run off a single virtual machine. I think the last one was 4 vCPUs 
and 16GB of memory but we’ve hosted off smaller too.

The unique part of the setup tends to be its lacking security. All 
players are users on the database, so the pg_hba.conf needs to be 
flexible and the game needs enough permissions to create users. These 
two requirements have made most SaaS offerings non-compatible. 
Admittedly, the last time I investigated such offerings was years ago 
now, so it’s possible things have changed.

If it’s possible that we can find schemaverse a new home, that would be 
wonderful. I still get the occasional inquiry asking about it, usually 
from students, and I’d love to have it back up for those looking to 
learn from it. Regardless though, thank you for reaching out!

-Josh