Simcountry is a multiplayer Internet game in which you are the president, commander in chief, and industrial leader. You have to make the tough decisions about cutting or raising taxes, how to allocate the federal budget, what kind of infrastructure you want, etc..
  Enter the Game

Poll Idea 04: Provide a Queryable Interface to SimCountry. (White Giant)

Topics: Suggestions: Poll Idea 04: Provide a Queryable Interface to SimCountry. (White Giant)

David Wendelken (White Giant)

Monday, September 1, 2008 - 12:48 pm Click here to edit this post
This is based upon the assumption that the Simcountry database is a relational database that allows SQL queries against it.

Publish a set of read-only data views to the SimCountry data tables, and the data definitions of those views. These views would have built-in security in them that would limit the user to seeing the data that they are allowed to see.

Provide an interface that lets us write queries against those views. This lets us write our own reports to get the data we need.

As this might cause an additional load upon the system, users who overuse it might be charged extra. The cost in game dollars might also be added to the cost of government, and the amount of usage might be limited by one's business and trade index, which would represent one's ability to gather this economic data.

At the very least, provide a spreadsheet for the following topics:

- Corporation types and labor usage by worker type at each effectivity setting.

- Weapons and labor usage by worker type.

- Our corporations with hiring levels by worker type, effectivity and quality settings.


Add a Message