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.
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.
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.
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.
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.
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.
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 :)
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.
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
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