public inbox for [email protected]  
help / color / mirror / Atom feed
From: Justin Clift <[email protected]>
To: [email protected]
Cc: Joshua McDougall <[email protected]>
Subject: Is anyone up for hosting the online PG game "Schemaverse"?
Date: Fri, 02 May 2025 08:23:00 +1000
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

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 <[email protected]>
To: [email protected]

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






view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Is anyone up for hosting the online PG game "Schemaverse"?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox