Is anyone up for hosting the online PG game "Schemaverse"?

From: Justin Clift <justin(at)postgresql(dot)org>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Cc: Joshua McDougall <joshua(at)mcdougall(dot)io>
Subject: Is anyone up for hosting the online PG game "Schemaverse"?
Date: 2025-05-01 22:23:00
Message-ID: b74747c27a75b0acb570eadbcf73e47b@postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)mcdougall(dot)io>
To: justin(at)postgresql(dot)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2025-05-01 22:27:30 Re: Upgrading PG11 to PG17 without dump/restore
Previous Message Greg Sabino Mullane 2025-05-01 17:42:50 Re: Pgbackrest : Resumable backup of same type exists