Editing Talk:1250: Old Accounts

Jump to: navigation, search
Ambox notice.png Please sign your posts with ~~~~

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision Your text
Line 22: Line 22:
 
Some bullshit on the page. Not sure if it could be edited to something that makes sense, if not it probably should be erased: "''But it also may refer to databases and the query language SQL. Modern web sites are always saved in such databases and using references from one entity to an other. A entity in this context is a thing in the modeled world, in this case Cueball and his friends. By using the entity–relationship model the friends will still have a relationship to the nonexistent user Cueball, the links are orphaned.''". Problems: 1) Modern web sites tend to shift from SQL to No-SQL databases, especially sites like social networks; 2) The described behavior is not a problem in a properly designed SQL database, since absence of orphaned links is ensured by foreign constraints. [[Special:Contributions/213.251.211.65|213.251.211.65]] 07:08, 14 August 2013 (UTC)
 
Some bullshit on the page. Not sure if it could be edited to something that makes sense, if not it probably should be erased: "''But it also may refer to databases and the query language SQL. Modern web sites are always saved in such databases and using references from one entity to an other. A entity in this context is a thing in the modeled world, in this case Cueball and his friends. By using the entity–relationship model the friends will still have a relationship to the nonexistent user Cueball, the links are orphaned.''". Problems: 1) Modern web sites tend to shift from SQL to No-SQL databases, especially sites like social networks; 2) The described behavior is not a problem in a properly designed SQL database, since absence of orphaned links is ensured by foreign constraints. [[Special:Contributions/213.251.211.65|213.251.211.65]] 07:08, 14 August 2013 (UTC)
 
:I disagree. At the title text Randall mentions ''a major looming problem'' belonging to databases. And all modern websites like wordpress, or even this wiki, using SQL databases in the background. No-SQL is an alternative, but still rarely used.--[[User:Dgbrt|Dgbrt]] ([[User talk:Dgbrt|talk]]) 10:27, 14 August 2013 (UTC)
 
:I disagree. At the title text Randall mentions ''a major looming problem'' belonging to databases. And all modern websites like wordpress, or even this wiki, using SQL databases in the background. No-SQL is an alternative, but still rarely used.--[[User:Dgbrt|Dgbrt]] ([[User talk:Dgbrt|talk]]) 10:27, 14 August 2013 (UTC)
::In any good database, when you remove a table it should clean up all the links that when to and from it. There is no such thing as "database linkage accumulation slowdown". Even IF all the derelict links persisted, the only way that a system would slow down is if it was continually trying to access each and every dead link. Even then the system would be very quick to return an null value. An automated cleanup program would take very little time to process all of the "garbage" - IF there was garbage. Likely, the slowdown could refer to "The internet is filled with derelict accounts aggregating news about friends long forgotten.", the fact that when people abandon their old accounts, the system is still functioning and automatically processing whatever "services" they offer and every abandoned account is accumulating data, which could consist of actual data and/or links to other data. As the comic suggests, without users to "clean up" their old accounts the systems would slow down because of this automated data accumulation - which is 95% fiction (imho). [[User:Jarod997|Jarod997]] ([[User talk:Jarod997|talk]]) 14:09, 30 January 2014 (UTC)
 
  
 
Anything that needs to scale significantly gets away from SQL. It is not rarely used, it is the only option beyond a certain size. Facebook makes extensive use of No-SQL. [[Special:Contributions/108.162.246.117|108.162.246.117]] 02:41, 1 November 2013 (UTC)
 
Anything that needs to scale significantly gets away from SQL. It is not rarely used, it is the only option beyond a certain size. Facebook makes extensive use of No-SQL. [[Special:Contributions/108.162.246.117|108.162.246.117]] 02:41, 1 November 2013 (UTC)
Line 28: Line 27:
 
Nevermind the language used to implement current or historical database type websites. This detail is inconsequential to the comic. No program or database would rely on the actions of the everyday user to maintain the integrity of the system. All system maintenance required surrounding account deletion would be handled by separate systems and processes. The looming problem of 'database linkage accumulation' is obvious fiction dressed in technical language to fool the uninitiated. The joke is that Cueball is using a fallacious argument centered in a knowledge of good programming practice to justify a rude behaviour that he finds enjoyable as it provokes reactions in other users.  
 
Nevermind the language used to implement current or historical database type websites. This detail is inconsequential to the comic. No program or database would rely on the actions of the everyday user to maintain the integrity of the system. All system maintenance required surrounding account deletion would be handled by separate systems and processes. The looming problem of 'database linkage accumulation' is obvious fiction dressed in technical language to fool the uninitiated. The joke is that Cueball is using a fallacious argument centered in a knowledge of good programming practice to justify a rude behaviour that he finds enjoyable as it provokes reactions in other users.  
  
Paragraph two of the explanation should be edited to describe good programming practice centering around memory management. re: de-allocation and ordering paragraph three and four can be deleted in favour of explanation on why relying on user input to maintain the health of the system is foolish and would not be considered in such an implementation and the confirmation of d.b.a.s. as a false problem made up to justify Cueball's provocative behavior.  [[User:Mrarch|Mrarch]] ([[User talk:Mrarch|talk]]) 00:17, 3 December 2013 (UTC)
+
Paragraph two of the explanation should be edited to describe good programming practice centering around memory management. re: de-allocation and ordering  
 +
paragraph three and four can be deleted in favour of explanation on why relying on user input to maintain the health of the system is foolish and would not be considered in such an implementation and the confirmation of d.b.a.s. as a false problem made up to justify Cueball's provocative behavior.  [[User:Mrarch|Mrarch]] ([[User talk:Mrarch|talk]]) 00:17, 3 December 2013 (UTC)
  
 
Should we explain that ''derelict'' means ''abandoned''? This comic is about abandoned accounts, not about deleting rows from a database. [[Special:Contributions/173.245.50.84|173.245.50.84]] 13:02, 29 January 2014 (UTC)
 
Should we explain that ''derelict'' means ''abandoned''? This comic is about abandoned accounts, not about deleting rows from a database. [[Special:Contributions/173.245.50.84|173.245.50.84]] 13:02, 29 January 2014 (UTC)

Please note that all contributions to explain xkcd may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see explain xkcd:Copyrights for details). Do not submit copyrighted work without permission!

To protect the wiki against automated edit spam, we kindly ask you to solve the following CAPTCHA:

Cancel | Editing help (opens in new window)

Template used on this page: