Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Worry about scaling when you need to worry about scaling, not before. At that point you should know the answer or be able to hire someone who does.</p> <p><em>Let me attempt to clarrify this answer a little.</em></p> <p>Scaling is a fairly convaluted term in modern development because very often "best practices" such as using <a href="http://en.wikipedia.org/wiki/Design_pattern_(computer_science)" rel="nofollow noreferrer">design patterns</a>, <a href="http://en.wikipedia.org/wiki/Software_framework" rel="nofollow noreferrer">frameworks</a>, <a href="http://en.wikipedia.org/wiki/Database_abstraction_layer" rel="nofollow noreferrer">database abstraction</a>, and <a href="http://en.wikipedia.org/wiki/Database_normalization" rel="nofollow noreferrer">normalization</a> are the root cause of bottlenecks which limit scalability in extremely demanded websites.</p> <p>Throwing hardware at software will basically allow you to scale anything to a point.</p> <p>At that point (where you need to throw more hardware at the problem) you most likely have enough of a user base that you either are making money off of your website/service or in the case of an open source product you'll likely have a following. These resources will provide you access to higher level computer scientists/engineers which can help with scaling.</p> <p>Scaling at the level of reducing stress on hardware becomes very anti-"best practices". You begin writing code to do very specific tasks quickly. Take twitter for example, they've basically rewritten twitter to no longer use <a href="http://rubyonrails.org/" rel="nofollow noreferrer">ruby on rails</a>, but instead use <a href="http://www.scala-lang.org/" rel="nofollow noreferrer">scala</a> and designed twitters already successful features around <a href="http://www.artima.com/scalazine/articles/twitter_on_scala.html" rel="nofollow noreferrer">performance alone</a>. Facebook on the other hand has written custom PHP packages in order to <a href="http://wiki.github.com/facebook/hiphop-php/" rel="nofollow noreferrer">compile PHP</a>.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to make Dynamic Website High Scalable?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. UStplaner
    1. UStplaner
    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. COI disagree with this. Even if they don't make it highly scaleable from day one, they at least need to give some thought to the design of the software such that it can be made to scale, should it ever be required. There is a vast difference between premature optimisation and good design.
      singulars
      1. PO
      1. USDanSingerman
    2. CO"Premature optimisation is evil" is dogma to some people on here :-/
      singulars
      1. PO
      1. USDanSingerman
    3. COIt might not be easier to scale a product after it is already live, however now-a-days you can always just throw hardware at it until you redevelop it to scale properly. Famous examples: twitter, facebook (to some extent). Basically preemptive scaling could be considered a waste of time and resources for startups. (I'm not saying I agree with what I'm writing, I'm just stating the facts).
      singulars
      1. PO
      1. UStplaner
 

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