The Schemaverse is a space-based strategy game implemented entirely within a PostgreSQL database. Compete against other players using raw SQL commands to command your fleet. Or, if your PL/pgSQL-foo is strong, wield it to write AI and have your fleet command itself!
i tried to optimize the ship updater in tic.pl, i'm pretty sure it'll be faster without the temp table.
I modified ships_inrange view to use future health instead of current_health, otherwise it's impossible to determine when you should stop attacking a ship and move to the next one... imho if it's in range, i should be able to see if it's heavily damaged...
I modified upgrade max_health to give you the health. otherwise you have to repair to get the health, which i think isn't fair, but i dunno.
i tried to optimize the ship updater in tic.pl, i'm pretty sure it'll be faster without the temp table.
I modified ships_inrange view to use future health instead of current_health, otherwise it's impossible to determine when you should stop attacking a ship and move to the next one... imho if it's in range, i should be able to see if it's heavily damaged...
I modified upgrade max_health to give you the health. otherwise you have to repair to get the health, which i think isn't fair, but i dunno.