💾 Archived View for dioskouroi.xyz › thread › 29375911 captured on 2021-11-30 at 20:18:30. Gemini links have been rewritten to link to archived content

-=-=-=-=-=-=-

Schemaverse, a space based strategy game to learn PostgreSQL

Author: xupybd

Score: 284

Comments: 24

Date: 2021-11-29 03:06:30

Web Link

________________________________________________________________________________

abstrct wrote at 2021-11-29 05:02:08:

Heh, ok did not expect to see my old project sitting on the front page <3 The server is getting gently hugged to death atm but I'll try to keep it responding.

Some added info...

- The entire thing is open source:

https://github.com/Abstrct/Schemaverse/

- This was discussed on hacker news 10(!) years ago

https://news.ycombinator.com/item?id=3969108

- Some players have written more code to play the game than I wrote to build it

- We have a tournament every year at DEF CON

- Postgres is awesome

busterarm wrote at 2021-11-29 11:59:46:

> - We have a tournament every year at DEF CON

The same guy pretty much wins every year with minor modifications to his code (okay, except the last two years with the whole covid thing). That said, he's an extremely cool guy and very eager to train his potential competition. Please please please take him up on the offer.

I suggest to anyone to show up to the Defcon Is Cancelled party that he co-organizes.

abstrct wrote at 2021-11-29 15:59:02:

Yeah, he's pretty unstoppable lately but there have been a couple new players starting to improve a lot too.

I'll happily share his secret. He recognized that it's not about any single metric, it's all about optimizing for the trophies

https://github.com/Abstrct/Schemaverse/tree/master/trophies

Cyphase wrote at 2021-11-29 06:17:24:

Heads up, you're still pointing to Freenode for the IRC channel. Possibly you'd want to change that to point at Libera.Chat. The channel already exists at the latter.

abstrct wrote at 2021-11-29 06:19:15:

Thanks! Totally forgot to update that.

You can find us in #schemaverse on Libera.Chat

xupybd wrote at 2021-11-29 08:58:32:

Thanks for creating this it helped me improve my Postgresql and SQL 8 years ago.

abstrct wrote at 2021-11-29 16:11:46:

That's awesome! I'm glad to hear it helped. I was personally so sick of every database course I took using the same `department` and `employee` tables, I wanted something fun instead.

antman wrote at 2021-11-29 15:47:13:

Great idea and fyi the how to play link in the game points to a wrong url in your github wiki.

abstrct wrote at 2021-11-29 16:07:09:

Those should be fixed now. Thanks!

tigereyeTO wrote at 2021-11-29 04:53:37:

Such a cool game. It has been responsible for security fixes that improved Postgres itself.

The coolest part is the SQL Injection trophy.

There are paths to get many trophies in this game (most ships killed in a round, most resources mined in a round, most planets conquered, etc.). Those are all granted automatically.

But there is NO automated path to grant a SQL Injection trophy.

...yet some people have them. Hah.

Twisol wrote at 2021-11-29 05:12:21:

Hah. From the tutorial's "Winning" page:

> This is an easy trophy. All you need to do is award it to yourself

gardis wrote at 2021-11-29 13:04:24:

This is genius! So te get the award on SQL Injection you just need to SQL Inject?

cnlwsu wrote at 2021-11-29 16:36:45:

No bad judgement, small servers are limited and you won’t want huge bill. But there’s some irony in it being down from load.

abstrct wrote at 2021-11-29 18:10:40:

Heh, funny you say that. Schemaverse was built for my masters thesis which explored if the application layer and data layer could be successfully merged in a way that improved data consistency and integrity, and thus arguably improved security. I'll save you the 90 page read but short answer yes, but scaling becomes an absolute nightmare.

LoriP wrote at 2021-11-29 12:39:30:

That looks like a project for next weekend to me... By which time some of this excitement may drop down, it's a shame if folk don't come back to it just because of overload on an unexpectant server!

Anyway, thanks for the work you did on this abstrct you have made a community manager very happy :)

abstrct wrote at 2021-11-29 16:16:40:

You're welcome! Feel free to drop by #Schemaverse on Libera.Chat if you have any questions.

mrfusion wrote at 2021-11-29 14:21:39:

I’d love to see way more of this kind of stuff. It’s such a great way to learn.

abstrct wrote at 2021-11-29 16:13:55:

One of the players dockerized it all too

https://github.com/frozenfoxx/docker-schemaverse

I highly recommend running your own instance for battles between classmates or employees.

an1sotropy wrote at 2021-11-29 16:24:58:

Am I the only one who hurriedly read this as "schmetaverse", as in "bah, metaverse, schmetaverse ..." (sorry if off-topic)

unnouinceput wrote at 2021-11-29 05:52:25:

Clicked "How to play", got this:

Whoa there!

You have sent an invalid request.

Please do not send this request again. "

Not the best incentive to start playing

abstrct wrote at 2021-11-29 05:56:16:

The very tiny server is getting a bit crushed at the moment. If you actually want to try it out, check the tutorial tomorrow when the traffic goes back to normal.

https://schemaverse.com/tutorial/tutorial.php

matthberg wrote at 2021-11-29 07:18:54:

I encountered the same error message, yet it seemed to be from a broken link instead. From the homepage [0] while signed in, I clicked on "How to play" right under the query entry box. It sent me to this page, which is a different url from the one you linked:

https://wiki.github.com/Abstrct/Schemaverse/how-to-play

https://schemaverse.com/tw/index.php

abstrct wrote at 2021-11-29 07:24:55:

Ah, it does look like GitHub changed their wiki url scheme. Thanks for the info!

That should link directly to the tutorial (link above) instead of that wiki anyways

pbhjpbhj wrote at 2021-11-29 11:15:06:

That's just a side-quest surely. ;o)