search

Abstrct / Schemaverse

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!
schemaverse.com
PostgreSQL License
356 stars 39 forks source link

Voila, reconciliation against production #22

Closed cbbrowne closed 12 years ago

cbbrowne commented 12 years ago

a) Changes in player_creation(), which autogenerates a bunch of planets if there aren't already any.

b) Add last_move_tic to player table

c) Revised update_ships_near_ships() that uses temp tables

d) create_ship() needs to use location rather than location_x/location_y

e) Sundry changes to fleet_script_update()

f) Add query_store table used to capture queries used in web front end

g) Changed distance_travelled, avg_ship_upgrades, avg_fuel_mined from integer to bigint to avoid overflow

h) Triggers enable/disable changed to 'all' level from 'user' level

i) Add missing archive_events() function

Abstrct commented 12 years ago

Getting the production and master in sync is great but more-so I love some of the simple optimization you have proposed in a couple spots. I am going to work on making sure all the new optimization is working nicely within the production and then get all this merged. Hopefully get it all in place within the next couple days.