Editing Talk:2054: Data Pipeline

<!--Please sign your posts with ~~~~ and don't delete this text. New comments should be added at the bottom.-->

tried my hand at transcipts again, hope i did ok. [[User:Nintendo Mc|Nintendo Mc]] ([[User talk:Nintendo Mc|talk]]) 15:32, 3 October 2018 (UTC)

Oddly prescient, as always. I've just finished writing a fully automated data pipeline that ingests multiple data sources (both manual and automated input), has API support, a frontend, and email dispatch capabilities entirely in Google Sheets. It was about 3x faster to code than doing it right. [[Special:Contributions/172.68.65.6|172.68.65.6]] 16:48, 3 October 2018 (UTC)
: That's so awesome !  Would you come back and let us know if it ever collapses because one of the data sources changes slightly?  (or alternatively, that it _doesn't_ collapse and cueball needs to get his shit together?)  [[Special:Contributions/162.158.78.130|162.158.78.130]] 01:22, 4 October 2018 (UTC)

Just added a line about how this is a logical continuation of the Code Quality series - given it's the same two people, this should be uncontroversial. Is it worth adding a new category for "Code Quality" to group these (and likely subsequent comics) together? [[User:Grimreaperwithalawnmower|Grimreaperwithalawnmower]] ([[User talk:Grimreaperwithalawnmower|talk]]) 17:20, 3 October 2018 (UTC)
::Quite controversial, in fact. I actually found that statement quite questionable and that it should probably be removed (only in part because the title isn't grouping it in with them). Related? Certainly. But a full part of the group? THIS Cueball seems like he's far more capable than Code Quality Cueball. THIS Cueball managed to construct a highly useful piece of software that - until the final panel - did the job they needed. The issue here is the Bobby Tables issue, that he neglected to sanitize the input, i.e. to at least write the program in a way that it could handle variety. The program relies heavily on the exact format of the data it's gathering (a format that he has no control over, it's set by the source). Okay, this suggests he's using prewritten code and connecting it together, but getting code pieces together into a cohesive whole is a considerable feat, showing some programming prowess (far better ability that CQ Cueball). [[User:NiceGuy1|NiceGuy1]] ([[User talk:NiceGuy1|talk]]) 05:05, 5 October 2018 (UTC)

What could we still add to the transcript? I don't think it really needs any more transcripting so maybe we should remove the marker. [[User:Kwonunn|Kwonunn]] ([[User talk:Kwonunn|talk]]) 18:50, 3 October 2018 (UTC)

No comment about the "roll over" text (excuse me if I have the name wrong).  I think this is a comment about the shear computing power, battery life and superior connectivity of modern mobile phones compared to laptops. [[User:RIIW - Ponder it|RIIW - Ponder it]] ([[User talk:RIIW - Ponder it|talk]]) 19:05, 3 October 2018 (UTC)
: IIRC, it's generally called "hover text." {{unsigned ip|162.158.74.57}}
:: pretty sure it's actually "title text" [[User:Halo422|Halo422]] ([[User talk:Halo422|talk]]) 01:09, 4 October 2018 (UTC)
::: It ''is'' actually "title text", though Randall calls it "alt-text" & contrary to W3C recommendations, he seems to use the same text for both. [[User:ProphetZarquon|ProphetZarquon]] ([[User talk:ProphetZarquon|talk]]) 05:13, 4 October 2018 (UTC)
::::Here on the Wiki people usually go with "Title text", occasionally "Mouse-over text". Which I like, partially because it's clear what it means, even to the casual visitor, and partially because it highlights my issue: I use these sites on a tablet, don't have a mouse, I can't see the text until I come here. :) RIIW has a point, this needs a paragraph about the Title Text. But no, it isn't saying phones are more reliable, it's a joke that neither should be hosting anything, neither is meant to be online 24/7. [[User:NiceGuy1|NiceGuy1]] ([[User talk:NiceGuy1|talk]]) 05:32, 5 October 2018 (UTC)
:::::'''Public service announcement:'''  If you can't read the alt-text because you're on a mobile device, you should try using the mobile version of the website:  https://m.xkcd.com/2054 .  Its main features include the ability to tap/click the image to make the alt-text show up, and the whole thing is distraction-free.  [[Special:Contributions/172.68.189.181|172.68.189.181]] 16:59, 5 October 2018 (UTC)

Re: superior connectivity of mobile phones, see https://xkcd.com/1865/ {{unsigned ip|162.158.78.166}}
: This is exactly why I assert that anything hosted from a laptop should at least be considered for hosting from a mobile device instead. It's annoying to me that so many developers still consider a mobile device which has more connected uptime than a laptop to be unsuitable for hosting, say, a text-based game server. It's got a faster connection & more idle processing power than the PCs that used to run some of those game servers; I think my tablet could handle running a BBS Door game, for example. [[User:ProphetZarquon|ProphetZarquon]] ([[User talk:ProphetZarquon|talk]]) 05:14, 4 October 2018 (UTC)
:: Just to clarify in the comic, it is generally preposterous to host a server process like this from a mobile device.  Mobile devices aggressively suspend computing time when processes are in the background, or when the screen is off, and their battery life is much shorter than that of a laptop.  It is far more normal to modify the power settings of a laptop to not suspend when closed, which is doable on all laptops running linux, than to run a central data pipeline on a phone, and any meaningful server process has a dedicated server environment.  The comic is a joke, like all of them.  Cueball has a history of coding for his personal life that he is trying to apply in an environment where more resilience is needed than he is used to. {{unsigned ip|162.158.78.70}}
::: Sorry for the rude tone of this comment.  You do have a point that mobile phones have more connectivity, and many systems use them this way.  I deleted my comment when I actually came to agree with you, but somebody undeleted it. [[Special:Contributions/172.68.50.136|172.68.50.136]] 21:45, 5 October 2018 (UTC)
:::: No offense taken; The comic is obviously a joke, that portable devices should not be used as hosting devices. I'm just saying it's not half as ridiculous as many devs seem to think: Certainly no services which many people rely on should be hosted from a mobile cellular device, but for personal purposes it at least makes more sense than hosting from a notebook computer in many cases. '''Phones have a ''longer'' battery run time than laptops (much longer) & communication apps are commonly designed ''not'' to have their connections suspended when the screen is off.''' Background processes stopping was a common issue a few years ago, when battery management was undergoing frequent change in the OS; but there are a ton of apps which would not work at all if this were an insoluble issue. I run a private messaging server & a torrent client from my mobile cellular device & it has more connected uptime than my desktop computer, because the computer shut off when not in use, whereas the phone never gets shut off for more than a few minutes for resets. Linux ''still'' has issues with the lid switch not doing "nothing" even when the switch is explicitly set to "do nothing", & a mobile cellular device of today has more idle resources than a server built not so many years ago. A ''lot'' of things done via the cloud would be more efficient & reliable done locally, but that's less monetizable so most apps don't try, preferring to offer a service where usage metadata = profits. The data connections of 4G cellular are faster than many of the connections used for home server setups just a decade ago. Overall, mobile cellular devices are actually a pretty ''good'' candidate for a latency tolerant server, & in many cases a user's phone is the device of theirs which remains connected most; Sometimes it's their ''only'' device. Large DBs & compute-heavy tasks obviously are not ideal, but there's a ton of low resource services which could be run on mobile devices but aren't. Thinking it's a bad server platform is largely erroneous & based on outdated assessments. [[User:ProphetZarquon|ProphetZarquon]] ([[User talk:ProphetZarquon|talk]]) 17:32, 10 October 2018 (UTC)
: While all of the comments about connectivity between a laptop and a mobile device may be valid, I think the joke here is that any serious data processing application should not be running on either - it should instead be operated in a fixed-connectivity server-type environment instead. [[User:Ianrbibtitlht|Ianrbibtitlht]] ([[User talk:Ianrbibtitlht|talk]]) 16:37, 4 October 2018 (UTC)
:: Agreed. [[User:ProphetZarquon|ProphetZarquon]] ([[User talk:ProphetZarquon|talk]]) 17:32, 10 October 2018 (UTC)
::I concur, the point is that nothing mobile should be HOSTING, hosted files should be on a system designed to be never off and never disconnected. Both a laptop and a cell could have their batteries die, or they have to be permanently plugged in, defeating the purpose of them being "mobile". [[User:NiceGuy1|NiceGuy1]] ([[User talk:NiceGuy1|talk]]) 05:21, 5 October 2018 (UTC)
::: Except that many ''personal'' servers ''do'' get run on laptops & home computers with a lot of downtime, whereas phones tend to be on & connected much more of the time. Most people don't have a machine set up for server duty, but they do have a phone that runs all day every day. Battery is a non-issue: A mobile device can plug in when needed to maintain uptime; A fixed device cannot run on battery at all. (Unless you buy a battery backup, & you could buy a lot of portable batteries instead, for what one of those UPSs costs.) 
::: Mobile devices ''should'' be hosting a lot more than they currently do. '''Not for business-critical enterprise-wide usage scenarios like shown in this comic''', but for personal use cases where the loads are not high it's silly to think another machine is necessary.  [[User:ProphetZarquon|ProphetZarquon]] ([[User talk:ProphetZarquon|talk]]) 17:32, 10 October 2018 (UTC)
::::Oh, very much NO, LOL! Just because people do it doesn't mean they SHOULD. :) I actually expect the title text is specifically to take a swipe at such people. Getting a cheap computer, or keeping an old computer, to act as a server at home is easy. My mother bought a new desktop computer that came with Windows Vista (back when that's what new computers came with), hasn't used it directly in about 5 years, since getting an iPad and simply entertaining herself with that. But we've got this computer set up with a nice iTunes library it shares over her home network and it just stays on 24/7. Found out the hard way that the stock power supply couldn't handle that so I replaced it with a stronger one 500W, works great. Would probably cost probably $40 to buy that computer second-hand now, keeping the power supply upgrade for later (worked fine as stock for years). It's up as long as there isn't a power outage, far longer than any mobile device (remembering that under normal circumstances a plugged in mobile device is stuck where it is, it can't be carried around, so it's unintuitive to keep it plugged in permanently, unlike a desktop computer which is designed to always be plugged in). Also. I don't think this comic is any kind of business thing, this seems like some kind of group project they're doing (maybe a business they're trying to LAUNCH, but not something that's available outside of the three of them), hence them experimenting. [[User:NiceGuy1|NiceGuy1]] ([[User talk:NiceGuy1|talk]]) 04:54, 12 October 2018 (UTC)

Had to fix the description, it stated that Cueball reluctantly agreed with Ponytail's statement when he actually did the opposite, but his hesitation suggests she's correct. [[User:NiceGuy1|NiceGuy1]] ([[User talk:NiceGuy1|talk]]) 05:21, 5 October 2018 (UTC)

The presence of White Hat is a little mysterious here because he doesn't have any lines. What could be going on?  [[Special:Contributions/172.69.226.143|172.69.226.143]] 07:41, 5 October 2018 (UTC)
: He was just waiting for the next comic to start :) [[User:Hawthorn|Hawthorn]] ([[User talk:Hawthorn|talk]]) 15:46, 5 October 2018 (UTC)

Why is there a six paragraph diversion at the end of this explanation? This may be tangentially relevant, but not enough for an explanation that eclipses the size of the rest of the actual comic explanation.  Consider removing it or boiling it down to one paragraph on the general topic with a link.  I prefer removing it because the comic doesn't make it's own connection to a wider issue. {{unsigned ip|162.158.75.142}}
: I'm not the most organized thinker in the world.  A lot of the explanations on this site read like the person who wrote the explanation does not actually have experience with the topic of the comic, which is generally written as if it is something that Randall does have experience with.  I tried to fix that on this comic, by sharing background from a place of experience, but I wasn't really sure what the most relevent bits were or how to integrate it into the existing work well.  The existing explanation read as if Cueball was simply a horrible coder, when in reality these data pipelines are common things among programming hobbyists, and it takes experience to recognize that they are inevitably a house of cards.  They're not inherently bad though: liberal input validation can be used to notify a dev when something goes wrong, so that they can fix it fast, but that needs more foresight than Cueball may have if he is running it off his phone.  This data pipeline approach is used in live sites still up today.  I'm sorry I'm expressing so verbosely; it's being hard for me to be concise.  [[Special:Contributions/172.68.50.136|172.68.50.136]] 21:43, 5 October 2018 (UTC)
: On the upside, with it running off his phone, at least he's more likely to be nearby when it goes down.  ;D
: [[User:ProphetZarquon|ProphetZarquon]] ([[User talk:ProphetZarquon|talk]]) 17:32, 10 October 2018 (UTC)

Recommend completely removing everything after the paragraph mentioning the connection to the Code Quality series (which I had to fix, it stated the connection too strongly). With the title text having been just explained - usually the last part of the explanation - the rest seems unnecessary and extra. [[User:NiceGuy1|NiceGuy1]] ([[User talk:NiceGuy1|talk]]) 19:51, 10 October 2018 (UTC)


Actually I expected Cueball to have found a way to crash the company mainframe. If he limited te crash to a device not even his laptop's connectivity relies on is not this bad after all...--[[User:Gunterkoenigsmann|Gunterkoenigsmann]] ([[User talk:Gunterkoenigsmann|talk]]) 01:07, 19 January 2022 (UTC)