Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>At the OP's request, I'm going to discuss my experience with JS-only sites. I've written four relevant sites: two JS-heavy (<a href="http://www.slide.com" rel="nofollow">Slide</a> and <a href="http://www.speeddate.com" rel="nofollow">SpeedDate</a>) and two JS-only (<a href="http://www.yazooli.com" rel="nofollow">Yazooli</a> and <a href="http://www.gamecrush.com" rel="nofollow">GameCrush</a>). Keep in mind that I'm a JS-only-site bigot, so you're basically reading John Hinkley on the subject of Jody Foster.</p> <ol> <li>The idea really works. It produces gracefully, responsive sites at very low operational costs. My estimate is that the cost for bandwidth, CPU, and such goes to 10% of the cost of running a similar page-based site.</li> <li>You need fewer but better (or at least, better-trained) programmers. JavaScript is an powerful and elegant language, but it has huge problems that a more rigid and unimaginative language like Java doesn't have. If you have a whole bunch of basically mediocre guys working for you, consider JSP or Ruby instead of JS-only. If you are required to use PHP, just shoot yourself.</li> <li>You have to keep basic session state in the anchor tag. Users simply expect that the URL represents the state of the site: reload, bookmark, back, forward. jQuery's Address plug-in will do a lot of the work for you.</li> <li>If SEO is an issue for you, investigate <a href="http://code.google.com/web/ajaxcrawling/docs/getting-started.html" rel="nofollow">Google Ajax Crawling</a>. Basically, you make a very simple parallel site, just for search engines.</li> </ol> <p>When would I <em>not</em> use JS-only? If I were producing a site that was almost entirely content, where the user did nothing but navigate from one place to another, never interacting with the site in a complicated manner. So, Wikipedia and ... well, that's about it. A big reference site, with a lot of data for the user to read.</p>
    singulars
    1. This table or related slice is empty.
    1. POJust In General: JS Only Vs Page-Based Web Apps
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USMalvolio
    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
    1. COCool, thanks. I appreciate your points and it is encouraging to see some significant sites built as all-JS, for sure.
      singulars
      1. PO
      1. USstofac
 

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