1409: "Query"

This forum is for the individual discussion thread that goes with each new comic.

Moderators: Moderators General, Prelates, Magistrates

timepiece
Posts: 6
Joined: Mon Apr 02, 2012 2:50 pm UTC

Re: 1409: "Query"

Postby timepiece » Mon Aug 18, 2014 4:41 pm UTC

Shouldn't the guy with the ice cream on the box still be there? He was never selected.

Psydekick
Posts: 4
Joined: Wed Sep 19, 2012 5:08 pm UTC

Re: 1409: "Query"

Postby Psydekick » Mon Aug 18, 2014 4:49 pm UTC

I want to see the results of a BEGIN and ROLLBACK (PostgreSQL syntax).

Code: Select all

BEGIN;
DELETE FROM PEOPLE;
ROLLBACK;

User avatar
chalkie
Posts: 44
Joined: Wed Feb 24, 2010 10:03 am UTC
Location: River Trent, UK

Re: 1409: "Query"

Postby chalkie » Mon Aug 18, 2014 5:04 pm UTC

Psydekick wrote:I want to see the results of a BEGIN and ROLLBACK (PostgreSQL syntax).


Noooooo - they'd be zombies :(

User avatar
SomeGuyNamedDavid
Posts: 17
Joined: Mon Sep 03, 2012 4:52 am UTC

Re: 1409: "Query"

Postby SomeGuyNamedDavid » Mon Aug 18, 2014 5:24 pm UTC

timepiece wrote:Shouldn't the guy with the ice cream on the box still be there? He was never selected.

Nah, he was only never selected because he's under age 30, makes less than $100,000 a year, isn't afraid of flying, and hasn't watched porn in the last 12 hours.

User avatar
Someguy945
Posts: 189
Joined: Fri Jul 22, 2011 5:09 am UTC

Re: 1409: "Query"

Postby Someguy945 » Mon Aug 18, 2014 5:56 pm UTC

sotanaht wrote:How could dropping "People" remove herself if she was loaded separately from the table?


She shows up under afraid_of_flying so she is definitely part of the table.

ps.02 wrote:3) WTF are these == and != SQL operators? Are they anything like = and <>?


Go ahead and hop on your SQL or MySQL server and try out !=
It will work just fine.

davidhbrown
Posts: 47
Joined: Wed Dec 10, 2008 1:42 pm UTC

Re: 1409: "Query"

Postby davidhbrown » Mon Aug 18, 2014 7:26 pm UTC

If the "Rapture" ever comes, I will remember this cartoon!

Showsni
Posts: 117
Joined: Wed Sep 14, 2011 9:09 pm UTC

Re: 1409: "Query"

Postby Showsni » Mon Aug 18, 2014 9:42 pm UTC

cjm wrote:The panel where only the cellphones drop to the ground is the clearest indication yet that everyone in XKCD is in fact naked.


Heh, that's what I took away from this comic too.

That, or clothes are in fact people. Not sure which is more disturbing.

User avatar
PinkShinyRose
Posts: 834
Joined: Mon Nov 05, 2012 6:54 pm UTC
Location: the Netherlands

Re: 1409: "Query"

Postby PinkShinyRose » Mon Aug 18, 2014 9:54 pm UTC

Showsni wrote:
cjm wrote:The panel where only the cellphones drop to the ground is the clearest indication yet that everyone in XKCD is in fact naked.


Heh, that's what I took away from this comic too.

That, or clothes are in fact people. Not sure which is more disturbing.

They probably wear clothes, but the clothes only have two dimensions: depth and panel progression. This makes them difficult to see in the comic.

User avatar
Dr What
Posts: 69
Joined: Wed Dec 26, 2012 6:43 am UTC

Re: 1409: "Query"

Postby Dr What » Mon Aug 18, 2014 11:16 pm UTC

An SQL version Death Note! Well, much more powerful though. 8-)

Mikeski
Posts: 1104
Joined: Sun Jan 13, 2008 7:24 am UTC
Location: Minnesota, USA

Re: 1409: "Query"

Postby Mikeski » Mon Aug 18, 2014 11:58 pm UTC

addams wrote:
cjm wrote:The panel where only the cellphones drop to the ground is the clearest indication yet that everyone in XKCD is in fact naked.

Everyone except me.
I know for a fact, I am not naked.

Everyone else is likely to be naked.

Correct! I am currently completely naked.


...under my clothes.

User avatar
addams
Posts: 10268
Joined: Sun Sep 12, 2010 4:44 am UTC
Location: Oregon Coast: 97444

Re: 1409: "Query"

Postby addams » Tue Aug 19, 2014 12:06 am UTC

chalkie wrote:
FrobozzWizard wrote:Really, the final panel suggests the story of Bobby Tables rather morbid: One little prank, and a town's worth of teenagers is wiped out, including the son of the person who committed the prank.


Oh good grief! - I never saw that one coming either. Well played.

yep.
I like it.

That is an interesting way to leave the story.
Definatly leaves a sense of unease hanging in the air.

Where did the Stick Figures go?

Poof.
Gone?

Where?
Poof.

That is one of the unnerving things about the internet and computers in general.

Poof.
It's gone.

Where did it go?
I am still likely to pick it up and look under.

I'm a Monkey!
Life is, just, an exchange of electrons; It is up to us to give it meaning.

We are all in The Gutter.
Some of us see The Gutter.
Some of us see The Stars.
by mr. Oscar Wilde.

Those that want to Know; Know.
Those that do not Know; Don't tell them.
They do terrible things to people that Tell Them.

kventin
Posts: 6
Joined: Fri Nov 25, 2011 9:22 am UTC

Re: 1409: "Query"

Postby kventin » Tue Aug 19, 2014 8:19 am UTC

"Were you listening to me, Megan? Or were you querying the man in the black hat?"
"I was..."
"Run the query again"

User avatar
PayasYouDraw
Posts: 91
Joined: Tue Jan 07, 2014 12:57 pm UTC

Re: 1409: "Query"

Postby PayasYouDraw » Tue Aug 19, 2014 9:22 am UTC

chalkie wrote:
orthogon wrote:And yet you don't mind the nonstevenicity being hard-coded? Clearly the anti-Steve movement is even more widespread than I feared.



Its already started elsewhere:
http://www.stevessence.com/2011/10/19/a ... -protests/

Eee gads - I just started reading that site, then I stopped pronto.

"They're all mad except thee and me, and I'm not so sure about thee"


Creepy, but funny.

Ok his takedown of the ignorant UK rabbi was decent, but I completely lost it where he defended Steve for not having a number plate on his car (the excuse given was that he was actually above the law by being successful) and of course, how Apple saved us from a "1984" type world order. :lol:

I do like wackjob but essentially harmless websites like that. Always good for a laugh. (Expecting "Worshipping Steve Jobs as a god" to appear on whatstheharm.net now.)

FrobozzWizard wrote:Really, the final panel suggests the story of Bobby Tables rather morbid: One little prank, and a town's worth of teenagers is wiped out, including the son of the person who committed the prank.


I always took it that Bobby was in primary school (US equivalent) and was maybe about 8 years old.
Ah-ooooh! Rolling back the rivers in Time!

Kename Fin
Posts: 6
Joined: Mon May 28, 2012 3:39 am UTC

Re: 1409: "Query"

Postby Kename Fin » Tue Aug 19, 2014 9:34 am UTC

airdrik wrote:
cjm wrote:The panel where only the cellphones drop to the ground is the clearest indication yet that everyone in XKCD is in fact naked.

No, I'd suggest that this is more an indication of improper normalization of the schema or inconsistent management of foreign key relationships, resulting in the deletes cascading to certain relationships (e.g. objects worn) and not to others (e.g. objects held). After all, an object that is worn doesn't cease to be after it is removed and has no business being deleted just because the wearer is no more.

On the other hand, maybe there's a way we can exploit this understanding of the schema to rig the system and get infinite supplies of certain items? (anybody have a game genie or game shark that works on life?)


Heh, I rather headed the opposite direction with exactly the same thought. Let's manipulate the schema to drop the foreign keyed objects related to it such that we are left with a naked world. Everyone would be happier naked IFF everyone was naked. Right? Even if not completely true, it would still be a fun endeavour to embark upon.

pachinkoid
Posts: 20
Joined: Tue May 12, 2009 11:42 am UTC

Re: 1409: "Query"

Postby pachinkoid » Tue Aug 19, 2014 11:50 am UTC

my take on this was that the "porn" query showed her that she was not included in the dataset, and therefore it would be safe to drop the table...

User avatar
chalkie
Posts: 44
Joined: Wed Feb 24, 2010 10:03 am UTC
Location: River Trent, UK

Re: 1409: "Query"

Postby chalkie » Tue Aug 19, 2014 12:07 pm UTC

Another feature of peopleSQL is that the entire table contents are visible all of the time, and a select just causes the matching objects to fluoresce.

davidp
Posts: 3
Joined: Wed Sep 22, 2010 1:59 pm UTC

Re: 1409: "Query"

Postby davidp » Tue Aug 19, 2014 12:39 pm UTC

I'm surprised no one has really talked about the allusions to current events that seem to be in this comic. Here the protagonist has the power to find out essentially any piece of information that she wants about other people around her. Out of curiosity, she discovers a few things, but then she voluntarily deletes the tables and gives up the power that she had. She simply decides that she doesn't need to know everything about everybody. It doesn't necessarily mean she killed all the people when she dropped the tables, just that they simply aren't in the database anymore. This seems to be a powerful allusion to information gathering and person tracking by governments, which has been a large topic of discussion over the past couple of years amongst the general population and in the press.

forbiddenSpell
Posts: 16
Joined: Sat Oct 29, 2011 4:44 pm UTC

Re: 1409: "Query"

Postby forbiddenSpell » Tue Aug 19, 2014 4:28 pm UTC

Am I the only person that thought of Watch_Dogs while reading this?

User avatar
San Fran Sam
Posts: 228
Joined: Tue Nov 15, 2011 5:54 pm UTC

Re: 1409: "Query"

Postby San Fran Sam » Tue Aug 19, 2014 5:48 pm UTC

Someguy945 wrote:
sotanaht wrote:How could dropping "People" remove herself if she was loaded separately from the table?


She shows up under afraid_of_flying so she is definitely part of the table.

ps.02 wrote:3) WTF are these == and != SQL operators? Are they anything like = and <>?


Go ahead and hop on your SQL or MySQL server and try out !=
It will work just fine.


My question is if everyone disappeared when the table was dropped, who was around to select from ghosts?

User avatar
Horselover Frost
Posts: 28
Joined: Wed Dec 09, 2009 10:36 pm UTC
Location: NY

Re: 1409: "Query"

Postby Horselover Frost » Tue Aug 19, 2014 5:58 pm UTC

The ghosts. ;3

k_woods
Posts: 1
Joined: Tue Aug 19, 2014 7:30 pm UTC

Re: 1409: "Query"

Postby k_woods » Tue Aug 19, 2014 7:32 pm UTC

chalkie wrote:
Psydekick wrote:I want to see the results of a BEGIN and ROLLBACK (PostgreSQL syntax).


Noooooo - they'd be zombies :(


Not zombies, just orphans :)

Ken

Mikeski
Posts: 1104
Joined: Sun Jan 13, 2008 7:24 am UTC
Location: Minnesota, USA

Re: 1409: "Query"

Postby Mikeski » Tue Aug 19, 2014 9:05 pm UTC

chalkie wrote:Another feature of peopleSQL is that the entire table contents are visible all of the time[...]

That's an artifact of the architecture; the full table exists whether or not you're querying it at the time.

The alternative is solipsistSQL, where other people only exist while you're thinking about them.

User avatar
drachefly
Posts: 197
Joined: Thu Apr 23, 2009 3:25 pm UTC

Re: 1409: "Query"

Postby drachefly » Tue Aug 19, 2014 9:10 pm UTC

Called it.

What did she think would happen?

rmsgrey
Posts: 3632
Joined: Wed Nov 16, 2011 6:35 pm UTC

Re: 1409: "Query"

Postby rmsgrey » Wed Aug 20, 2014 12:11 am UTC

kventin wrote:"Were you listening to me, Megan? Or were you querying the man in the black hat?"
"I was..."
"Run the query again"


"Another training program designed to teach you one thing: never delete a structure of which you're a member."

User avatar
addams
Posts: 10268
Joined: Sun Sep 12, 2010 4:44 am UTC
Location: Oregon Coast: 97444

Re: 1409: "Query"

Postby addams » Wed Aug 20, 2014 1:06 am UTC

davidp wrote:I'm surprised no one has really talked about the allusions to current events that seem to be in this comic. Here the protagonist has the power to find out essentially any piece of information that she wants about other people around her. Out of curiosity, she discovers a few things, but then she voluntarily deletes the tables and gives up the power that she had. She simply decides that she doesn't need to know everything about everybody. It doesn't necessarily mean she killed all the people when she dropped the tables, just that they simply aren't in the database anymore. This seems to be a powerful allusion to information gathering and person tracking by governments, which has been a large topic of discussion over the past couple of years amongst the general population and in the press.

ahhh.
Such depth.
Are you new to the Internet?

Not only are Governments tracking us, keeping information on us, deleting our information, changing data and generally fucking with people.
People are doing that.

Are we safe, NoWhere??
(shrug) maybe not.

Where did the Stick Figures go?
The Table still exists? Where?
Life is, just, an exchange of electrons; It is up to us to give it meaning.

We are all in The Gutter.
Some of us see The Gutter.
Some of us see The Stars.
by mr. Oscar Wilde.

Those that want to Know; Know.
Those that do not Know; Don't tell them.
They do terrible things to people that Tell Them.

StapleHorseOctopus
Posts: 23
Joined: Wed Jun 25, 2014 9:56 am UTC

Re: 1409: "Query"

Postby StapleHorseOctopus » Mon Sep 01, 2014 8:57 am UTC

Mutex wrote:
addams wrote:
cjm wrote:The panel where only the cellphones drop to the ground is the clearest indication yet that everyone in XKCD is in fact naked.

Everyone except me.
I know for a fact, I am not naked.


Oh. That totally changes my mental image of you.


Translation: Set flag not_naked for object "addams" to "true" (default is "false").

...

Alternatively, set flag is_deluded for object "addams" to "true" (default is "false").

In any case, set flag easily_convinced for object "Mutex" to "true" (default is "false").

User avatar
addams
Posts: 10268
Joined: Sun Sep 12, 2010 4:44 am UTC
Location: Oregon Coast: 97444

Re: 1409: "Query"

Postby addams » Tue Sep 02, 2014 4:37 am UTC

Damn it!
Am I Naked, now?
Life is, just, an exchange of electrons; It is up to us to give it meaning.

We are all in The Gutter.
Some of us see The Gutter.
Some of us see The Stars.
by mr. Oscar Wilde.

Those that want to Know; Know.
Those that do not Know; Don't tell them.
They do terrible things to people that Tell Them.


Return to “Individual XKCD Comic Threads”

Who is online

Users browsing this forum: Leovan and 29 guests