Editing 1409: Query
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 1: | Line 1: | ||
{{comic | {{comic | ||
| number = 1409 | | number = 1409 | ||
− | | date = August | + | | date = August 17, 2014 |
| title = Query | | title = Query | ||
| image = query.png | | image = query.png | ||
Line 8: | Line 8: | ||
==Explanation== | ==Explanation== | ||
− | [[Megan]] picks up a strange device that mysteriously asks her to enter a query after stating " | + | [[Megan]] picks up a strange device that mysteriously asks her to enter a query after stating "LOADED TABLE: PEOPLE / ENTER QUERY." In computer databases, "{{w|Table (database)|tables}}" are groups of similar information consisting of records each having certain attributes. Databases are generally made up of many tables, each containing different types of records. A database for a traditional library might have a "Books" table and a "Cardholders" table with records of all of the books in the library, and all of the people who have library cards. Each table will have different columns for certain attributes for every record. For example, the "Books" table might have columns for "title", "author", "date", etc. |
− | A request from a database by a user is called a "query". {{w|SQL}} (Structured Query Language) is a programming language designed for databases, and has a certain syntax for its queries. A common query is "select" which requests certain information from the database. In the library example, one might select (in plain English) all books written by a certain author or published after a certain date, etc. | + | A request from a database by a user from a computer database is called a "query". {{w|SQL}} (Structured Query Language) is a programming language designed for databases, and has a certain syntax for its queries. A common query is a "select" which requests certain information from the database. In the library example, one might select (in plain English) all books written by a certain author or published after a certain date, etc. |
− | Megan | + | In this comic, Megan tests the device by entering a SQL query into it: "SELECT * FROM PEOPLE WHERE AGE > 30" (show all the people older than 30). In appears that the actual people around her who are over 30 are basked in a yellow light. Megan then tries other experimental queries, presumably to determine whether the results are correct. First, she queries for people with a high annual income (a group that does not include her), then for those who are afraid of flying (which she is). Because the results for herself are valid both times, she then indulges her curiosity by asking who has watched porn in the preceding twelve hours. This suggests that whatever "database" she is accessing is extremely thorough as it contains ongoing records of people's day-to-day activities. |
− | The | + | Finally, she types "DROP TABLE PEOPLE". Drop is an SQL command to delete a table. When she enters the command, everybody, including herself, disappears. The implications are unclear. It may be a suggestion that all of reality is a computer program, all of the people are merely "data" in the program, and Megan was somehow granted access to the database for the program |
− | + | The title text suggests the possibility that when the people disappeared or "died", their records were moved to a table called "GHOSTS." The query would then, presumably, see all the people that were deleted. In some implementations of SQL, when records are deleted, they are hidden but remain in the database until a "Ghost Cleanup Process" removes the data permanently. The title text may also allude to this process. | |
− | |||
− | |||
− | |||
− | The title text | ||
==Transcript== | ==Transcript== | ||
− | + | [Megan picks up device] | |
− | : | + | Device: LOADED TABLE: PEOPLE |
− | : | ||
− | : | + | Device: ENTER QUERY |
− | |||
− | |||
− | + | [Megan looks at the people around her] | |
− | |||
− | |||
− | + | [Megan types into device]: SELECT * FROM PEOPLE WHERE AGE > 30 | |
− | : | ||
− | + | [5 people are highlighted] | |
− | + | [Megan types into device]: SELECT * FROM PEOPLE WHERE ANNUAL_INCOME > 100000 | |
− | : | ||
− | + | [1 person is highlighted] | |
− | + | [Megan types into device]: SELECT * FROM PEOPLE WHERE AFRAID_OF_FLYING = TRUE | |
− | : | ||
− | + | [4 people, including herself, are highlighted] | |
− | + | [Megan types into device]: SELECT * FROM PEOPLE WHERE HOURS_SINCE_WATCHING_PORN < 12 | |
− | : | ||
− | + | [3 people highlighted] | |
− | + | Megan: Neat | |
− | |||
− | |||
− | + | Megan: ... | |
− | |||
− | + | [Megan types into device]: DROP TABLE PEOPLE | |
− | : | ||
− | + | [Everyone disappears; the items they were holding drop to the ground] | |
{{comic discussion}} | {{comic discussion}} | ||
− | [[Category:Comics | + | [[Category:Comics featuring Cueball]] |
[[Category:Comics featuring Megan]] | [[Category:Comics featuring Megan]] | ||
[[Category:Comics featuring Ponytail]] | [[Category:Comics featuring Ponytail]] | ||
− | [[Category:Comics featuring | + | [[Category:Comics featuring Hairy]] |
− | [[Category: | + | [[Category:Comics with color]] |
− |