Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I'm the guy that wrote the "horrible design" called "Empires" :O</p> <p>Initially I knew it would be a lot of logic, but I had no idea what I'd gotten myself into.<br> In the end, knowing there were performance issues (esp. on Mac and Linux), I figured I'd be best off to at least make it playable, patch it up as best as possible and get it out there so me and some friends could play the game.</p> <p>Turns out as the game gets closer to Epoch 7 performance gets pretty bad. (so many pieces on the board). Iain, ealier when I mentioned there were too many DOM elements, it 's the many many images that I was referring to.</p> <p>The main dev behind gamesbyemail.com (who makes awesome games, and don't let Empires fool you about the quality of his games!) he mentioned that there was very little difference in performance between a small gif and a board-size gif which is mostly transparent.</p> <p>The problem is that attempting to clone HoTW-2001 resulted in using a lot of images.</p> <p>There's some optimizations I've got ready to go here, but haven't had the time to finalize. (It'll take me about 12 hours or so to play-test everything before release, and even then it's easy for bugs to get through :(<br> But, I do have plans to:</p> <ul> <li>Eliminate all pngs (if I haven't already... there's a var in there that toggles between gifs or pngs. I so love the tranparency of pngs, but that extra channel doubles the image size :(</li> <li>Turn off the pulse effect.<br> I wanted this on to help identify "the current empire" as opposed to "previous empires" owned by the same player. The problem is that the animation is just far to expensive for most browsers :( (I know, I should probably be using flash or the canvas tag, but Scott's API is so tantalizingly rich and robust... too much to possibly implement on my own).</li> </ul> <p>So ya... I just have to get off my butt and get on it with at least the items above.</p> <p>Troy</p> <p>PS - Another URL to use for testing the game might be the <a href="http://gamesbyemail.com/Games/Empires#Preview" rel="nofollow noreferrer">game preview here</a>. You can play out an entire game as all players.</p>
    singulars
    1. This table or related slice is empty.
    1. POAJAX boardgame runs fine in Windows, but not in Linux
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USTroy Chard
    1. USTroy Chard
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks for the good work on the game. It's perfectly playable on Windows anyway. I can help playtest - if you like.
      singulars
      1. PO
      1. USIain
    2. COThanks Iain, I may take ya up on that :)
      singulars
      1. PO
      1. USTroy Chard
    3. COI don't think changing from PNG to GIF will help noticeably. Your lunch is being eaten by the many, many (sequential!) conversations required to get all those images to the browser. Google Web Tools and other apps approach this problem by merging all graphics into a single big one and then using chunks of that in the places they're needed. I'm short on details but GWT is well enough documented, if you want to have a look.
      singulars
      1. PO
      1. USCarl Smotricz
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload