Announcement

Collapse
No announcement yet.

What the hell is the Schemaverse?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • What the hell is the Schemaverse?

    The Schemaverse is returning for our fifth year (woo!) but it continues to be arguably one of the more obscure games of the conference.

    So, what is it? It is simply your classic space battle game. You start with a home planet, where you can build some ships and mine for resources. From there, you can use those resources to build/upgrade more ships, spanning out to conquer the rest of the planets from other players.

    And what makes the Schemaverse unique then?

    The entire game is written inside a PostgreSQL database, as a player you are a user that has full access to connect directly to the pubic facing database.

    Code:
    SELECT * FROM my_ships;
    Code:
    SELECT * FROM planets;
    Code:
    UPDATE my_ships
        SET
            -- MOVE THIS WAY
            destination=POINT(0,0),
            target_speed=max_speed,
            
            -- KEEP TRYING THIS UNTIL IT STARTS BEING SUCCESSFUL
            action='MINE',
            action_target_id=5 -- FU Planet #5
        WHERE name = 'Explorer';
    Of course, most people don't sit there writing SQL all day, they write code to play for them! Perl, Python, PHP, R, Ruby, anything at all that can connect to Postgres is fair game. Others don't even bother with that and just exploit the many bugs in the system to win without any of that pesky strategy nonsense.

    Thanks to this flexibility, the contest has a number of audiences, including:
    • Database Administrators
    • Programmers
    • Artificial Intelligence Aficionados
    • Crackers
    • Curious
    If you want to learn more leading up to DC, there are a number of resources you can check out:-Abstrct
    Last edited by Abstrct; June 20, 2015, 11:53.
Working...
X