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 <jos...@mcdougall.io>
To: jus...@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
