« first day (896 days earlier)      last day (3563 days later) » 

14:00
@AsadaShino what's the right link? :O
I edited the message, my bad~
That's where I read it
sounds like they got the date wrong in the title
Yeah, they do have the right one in the text
july 6th 26:05 xD
which technically is july 7th
Yeah~
Query's taking so loong~ ._.
14:09
@AsadaShino wut r u querying?
@ʞɹɐzǝɹ Orders for a supermarket's bread/pastry department, need all the orders with their respective products, prices, status and date for the last 2 weeks~
apparently some of the orders were either not picked up or never delivered, so now I have to find out who they can blame
Query took 299,974 seconds ._.
I think we may be going over some of the database's set query cache things, forgot the names, but queries have gotten a LOT slower recently, I remember having dealt with this before on another website/database
I was going to just look up only the order ids and query with those, since they are primary keys, which would make the query A LOT faster than just based on a date... But w/e, this works xD
@AsadaShino maybe you need to create indexes
@Unihedron Probably as well, yeah, dunno if there are any on these tables, "it was like this when I got here"
Hahaha, no index in table 1
No index table 2
Same with 3 and 4~
That would probably also help a lot, yes... xD
14:17
>_>
Now to figure out what I should make an index, having worked mostly with Drupal, my knowledge of database performance tweaking is next to naught... ~_~
I can get pretty much any data with queries, but if the data's complicated, the query will take very long xD
Even though the dataset I query is relatively (read only tens of thousands of rows per table) small
maybe the query needs optimization
ugh databases
Hahaha :P
@Unihedron That can probably be optimized as well :P
@Unihedron Hahahaha
Save me, oh code magician~
14:23
not me; I'm a rookie coder as well :)
u maek codifications?
It's a query I only use for manually looking stuff up, not for anything inside the application. But there is one query inside the application that has apparently stopped working somewhere in the last few weeks, possibly because the dataset being queries passed a threshold or something~ xD
banking sucks
@AsadaShino Cool! :p
one inner and 4 left joins and a grouping, doesn't seem too complicated, but the left joins don't really help to make it fast, but I need them because I can't not show the data from the first tables if the left joined tables don't have records...
@Unihedron What's cool about that?! D:
It's annoying xD
thresholds timing out are always fun
14:25
yea I don't think anything about databases is cool
@AsadaShino you are what's cool
The server is so slow that accidentally calling that function makes the website unavailable xD
@ʞɹɐzǝɹ Awww <3
@AsadaShino that's... scary
@Unihedron Yup xD
why is the site on the same server as the database?
or why is the site so stupid that it dies if the database is slow on processing queries
I haven't seen anything and I have a number of questions already
14:27
user image
2
also somebody is supposed to be sleeping
Rin from FSN
@Hakase Because Drupal?
@Hakase Because it's a very weak shared server~
idk who Drupal is :p
@AsadaShino hmm Drupal isn't my favourite CMS, so I don't have many comments there
14:29
@Hakase Drupal is a CMS
@AsadaShino you should not host website and database on the same hardware or virtual server unless you are expert in this stuff and can make site keep working even if database is dragging like a snail
It's what I've been using since I started working where I work now and what I've been using as I learned php
SE has all the answers!
@Hakase Tell that to my sysadmin~ And the client doesn't want to pay for 2 separate servers
this is how it looks to me :p
14:30
@AsadaShino it seems your team isn't ready for devops :p
yup
@Unihedron devops?
development operations
@nhahtdh which anime is that?
@Unihedron I got that far, still don't know what you mean, unless if you mean my team shouldn't be developers
14:32
@GamesBrainiac Fate stay night
@AsadaShino never mind, just realized how ambiguous that was
sorreh
It's a visual novel
how is this i.sstatic.net/2xePa.png fate stay night?
14:33
oh okay.
#post
Sorry, I'm currently on tablet, so I'm a bit lazy
lol, there's a name for it, kabe don :P
14:35
That's the name of the action, not the anime
unbroke #who command
now maybe I'm finally gonna go get udon instead of doing home stuff
@Hakase pix plx
 
1 hour later…
16:02
@ʞɹɐzǝɹ of the home stuff? :p just take any bath tub and turn up yellow by 15-20% and you'll get the "before" pic
also go sleep already man
toaster oven??
like a regular oven but small
cool hot!
@ton.yeung why do you need a new rice cooker?
mad weather stuff going on in US
:(
good luck!
your current can't do that coz it's too simple?
(what's that about Fro and Yuuki)
and I'm interested in seeing the sample work
my work's project manager called me today saying I'm out of my old place and assigned to the place where I'm subbing that one guy and that is not what I'd call an improvement
I wonder when I will switch jobs and what will be the thing I do next :p
@Hakase I imagine that @Frosteeze lives in California.
And is thus going through a drought.
Whereas I live in Texas. And it's raining non-stop.
HAMMERTIME!
16:07
As in flash floods everywhere.
I'm back from udon place, they have a number of new choices but they are mostly mixes of their existing ingredients which is quite funny because I used to ask to mix some stuff they have before and now it's a "new item"
any cool pix?
I've seen a few on imgur like this and this
also I got a random cake and a coconut Lindt chocolate
@Hakase Ah, the latter is I-10, one of the major highways.
Or at least I'm pretty sure it's I-10.
16:12
@Taisho Some of these are from 2003 series, it seems. No wonder some of them looks strange
aren't they all from the old series?
@Hakase Looks like it.
hmm maybe I should make a command that creates a webpage with all the pics from a certain tag pool
16:14
Jon Chan on May 27, 2015

Jon is a web developer and heads up developer evangelism efforts at Stack Exchange.

When I think about the impact that Stack Overflow has had on the world, it’s tempting for me to think about numbers: how many active users we have, how many questions are answered in a day, how many jobs get posted on our Careers platform. These are things that I, as a developer, think about on a daily basis to measure how we’re helping programmers around the world grow. But I find that these numbers are hard to wrap my head around: it doesn’t quite give me a feel for what our work is doing. What is the quality of our impact? What does it feel like at an individual level? …

@Yuuki nice
I would totally rent a kayak or a boat if that happened where I live and swim around
waiting for PC release on steam and then steam sale
all the "top x ps4 games" have 90% games with pc versions
right now bloodborne is the only game worth buying ps4 for (to me at least)
and then you could sell it on local trading board
0
Q: Death Note, Killing the driver of a train/bus/plane

DenslatSo, if you state "Jack Hare" will die at precisely 15:00 12/03/14 and the user writes this without knowing where they will be at the time nor stating it, and the person goes to work as normal, can this be used to kill more than one person?

16:40
I just read this on dead tree news
imgur.com/gallery/o5i8XFr you can make tiny working flintlocks for Mami's figurines
say what you will but I think 75 usd is just the right price for that arduino kit
500 seems way high
So many Death Note questions. Meh, slightly better than id-req questions
I think they are silly
like highschoolers talking "what if"
Right, when they touch on the finer points and scenarios
what if highschoolers stops talking "what if"s?
(so meta)
16:49
actaully not enough
tumblr ppl see psychoanalysis, think "so meta" but it's really what any critically minded person thinks all day every day
i'm not critically minded :(
would love to be one :P
@ton.yeung that is great
0
Q: Do death note users with shinigami eyes, see in a red tint?

DarkYagamiSo quick question here. In several occasions, we see, if for example when Mikami saw everyone's name in the final episode, he saw in a red tint. Now my question is, is this only done for dramatic effect, or do they generally see in a red tint?

@Unihedron think about if you really would and you're one step closer
16:56
This guy is pretty great.
I wonder if he uses some resistors in his circuit or is just fine with getting shocked full power every time
0
Q: what anime is this? pls tell me

Hermawan Buntama what anime is this? anyone? helpp mee

0
Q: Does the AUG | Akihabara Accept come from an anime? If so, which one?

thinly veiled question mark In Counter-Strike: Global Offensive a new skin was released called the Akihabara Accept. The description of the skin is: Powerful and accurate, the AUG scoped assault rifle compensates for its long reload times with low spread and a high rate of fire. It has been decorated with a heat ...

0
Q: Can someone identify this anime for me?

UnknownOkay, I actually don't remember much, so the details are pretty vague. There is this guy, really young guy so I'm assuming Shonen; and he is a biker of sorts. Either that, or he just rides on the bike a lot. He wears a white helmet with red streaks on them. The helmet resembles an actual biker's...

17:54
I leave the evaluation and voting to people with more experience
1
Q: What is the origin of the bubble during sleep trope?

MattA common trope across various anime and manga is the snot bubble trope. I've put a few examples below: I can gather what it signifies from the TV Tropes description, but what's the origin of this? Does anybody know where it was first used, or where the inspiration came from?

18:10
Is it just me or there's a good amount of Death Note activity going on?
@EroSɘnnin There are 5 new Death Note questions last 24 hours
I don't care about it because it's all "what if"
I edited them in succession, so it looks like that there are many of them
watching Kara no Kyoukai movies
first one is not extremely interesting, but interesting enough
music is nice
18:17
@nhahtdh yeah I noticed that. Good to see something other than those id-req stuffs
aaah but I really wanna know what they say at the entrance ceremonies
Got a link? Or the timestamp + episode number?
something like "high school is a cool time, try to enjoy it and don't die"
Don't die
The best advice for life
I miss high school already >.<
18:25
High school is a great time
Someone here knows YTP?
@LucasHenrique Um... what?
Youtube Poop.
I am aware of said phenomenon
18:55
(It's not a joke.)
@Hakase do you like it?
I've only seen the TF2 ytps and it was okay
still remember spyper and mistermild's vids
I know YTP like for 5 years
But as I'm brazillian I watch what they call YTPBR
Which I don't need explain the name
bouhatei raspberry
I just saw an old video that has a great music (well, actually the musics are from games and stuff, but you got it). I feel like, dunno, sleeping or in heaven... like in drugs.
I feel like I could die exactly now.
YTP music video BR
@Yuuki some parts of Texas are in a drought too, but not as bad
but...yes, it'd be nice if we have flash floods right about now :P
19:01
those classifications sound like item quality affixes
19:21
Sourceforge has hijacked the GIMP for Windows repo and is distributing malware-riddled binary installers instead: https://plus.google.com/+gimp/posts/cxhB1PScFpe
That's scary, I used to trust Sourceforge
19:37
who is this source forge
@Frosteeze Wow, I had no idea there were droughts at the moment
@Matt tbh if the state government hadn't made commercials and signs saying we have a drought we wouldn't know we had one either lol
19:52
:L
1
Q: Where did the Skinship Grope trope come from?

Peter RaevesWe have all seen it often before, that when girls are among themselves, they tend to playfully grope their friend's breasts and it all seems to be okay and accepted behaviour. This trope is thus appropriately called Skinship Grope. I am aware this is used often as fan service and it does mention ...

0
Q: When will be Code Geass R3(Season 3) will be released?

MaxySparkI watched code geass both R1 and R2 and i heard swason 3 or R3 will be released, can you tell me about the release date?

scar
kizu
A "scar"y man
friki-diki
has his brother's hand attached to his body iirc
20:01
@ton.yeung Oh nice! We just acquired this company called "Houston Offshore Engineering", so that makes sense
Well, last October
0
Q: How much of the normal process of doing alchemy can be circumvented by seeing Truth?

MaroonI saw someone on the internet wonder if Ed and Al are capable of doing flame alchemy because they have seen Truth. This bothered me, since this would negate the idea that flame alchemy was difficult to learn and that via destroying Hawkeye's tattoo, it would be possible to avert the existence of ...

20:19
hmm I can't remember why Prix left us
I think he got upset but idk why
heh ok
I can understand that
21:11
@LoganM Did you watch Waremete? Do you maybe remember the steps Sou went through to make the planetarium thing?
@JNat Don't think I did. If so, I don't remember it.
Hm, okay
Thanks anyway
Is there a "-dere" word for this?
2
Q: Someone who is cunning but depicts themselves as innocent to others

Dheeraj SinghWhat can you call a person who is cunning but depicts themselves as innocent to others?

21:28
13
Q: Moderator Election Coming Soon

Robert CartainoI'm happy to announced that this site has been cleared for graduation… congratulations! Unfortunately, there has been a long backlog of sites waiting for their custom site design, so rather than waiting for that backlog to clear, we are going to start moving ahead and hold the first community-ba...

@iKlsR are you planning on running?
burenda
@Mysticial isn't that kind of like yandere?
I wonder if SE has anything planned for our design yet
@Hakase Probably not anything definite.
I assume kray-kun didn't post that meta post just for kicks
so there might be somebody who would take into account any sane propositions posted there
but honestly I have no idea how they could make it good if it will have any specific anime elements
I expect them to opt for something very generic
21:32
Honestly, I'm not sure the very specific suggestions people are making on meta really help though. The design team doesn't just take a bunch of user-designed things and mash them together. They want ideas for the design, but they don't really want approximately completed products as I understand; in fact, giving them such details may only make things harder, as it approaches the impossible "design by committee".
making it all naruto would suck for a lot of users lol
well, yes, so I don't think it matters what anyone posts there
I don't think they're likely to use characters from any existing works.
we can always design our own theme overrides if we want
I tried using some custom themes for chat and I found that background images distract me very much
I don't really care what the design looks like for me. What I care about is what image it gives off.
I agree with the importance of the feeling to outsiders
and it has to at least feel neutral to us :p
21:37
35
Q: What are Type A and Type B viewers?

Madara UchihaI keep hearing the terms Type A viewers and Type B viewers in discussions and chat. What do they mean? What is a Type A viewer and what is a Type B?

^ In practice I don't really like this distinction; it's rather overly simplified. But it may be the easiest way to explain why making a neutral design for this site is hard.
they could do some Makoto Shinkai style high-quality scenery but detailed images are not a thing SE site designs have usually, so idk
RPG has a nice commissioned banner, and there's some scenery images on Christianity iirc.
perhaps something generic like school, summer, fireworks, beach and other slice-of-life things
ok then I think if we gotta go with generic stuff, then highly detailed scenery is the way to go
But I'd want something that is decidedly reminiscent of anime, and to the average person that isn't going to be the scenery but character design.
the only kind of theme that would not go well for me is they try an eastern style theme, complete with some kind of oriental font design
21:42
perhaps like it's done on RPG − add some sketches, rough and more final-looking of some generic faces
what do you mean by eastern-style?
wow that's even worse than what I was thinking
I was going to use this as an example:
lol they could use subtitle fonts with black outline
21:44
also considering we're about manga too, they could add some manga panels
and if we're gonna commission it ourselves, the artist better add Taisho somewhere :з
Honestly, manga would be better than anime imo.
I mean the only "anime" part would be color
could be a metaphor for manga → anime adaptation with b/w manga panel gradually turning into colored scenery without panel borders
eww symbolism
idk man I'm not the designer :p
I'd actually be perfectly happy with a generic-looking design.
21:48
I guess me too
ANN, MAL, and most other big anime sites don't really have much in the way of design.
if I really wanted a certain custom theme, I'd make it myself and post a script somewhere
Actually most of them use that space for ads.
it's because they don't want to avert anyone with too specific imagery
I guess same goes for SE
Yes, we're mostly in the same boat.
21:50
whatever, I'm not using the main site that much these days anyway
and we already got the chat how we want it more or less
I care more about what image it gives off to new users than what it looks like.
I suppose that does matter the most
On this topic, can we even think of a single series which would be considered good by most anime fans and inoffensive by basically everyone?
Yotsuba&!
Not that I think we should use images from a particular work, but it might be worth showing as an example.
21:53
although it might be associated with 4chan a bit too much
It is great, but I don't know if everyone feels that way about it. And yes, the 4chan association is definitely real.
obvious anime would be Totoro but personally I dislike it because of all the baseless weaboo hype around it
and I think a lot feel the same
miyazaki's works…
The easiest might be to look for stylistic inspiration in old works that no one really cares about anymore, like what they did on gaming.stackexchange.com. At least that way it doesn't create implicit biases or become obsolete in a few years.
@ʞɹɐzǝɹ
22:13
0
Q: Do you guys know any anime characters with any of these vocal qualities?

joshtheweeabooDISCLAIMER: not all characters have to have most of the qualities, some only need one-two of these qualities > honeyed - sound very nice, but you cannot trust the person speaking matter-of-fact- they know what they are talking about, confident of what they're saying orotund- loud and clear stran...

@Sakamoto ...what?
@Hakase If you removed the "Anime & Manga" logo, the tags, and the questions, would the design imply to you that the site was about anime and/or manga?
It really wouldn't for me at all.
I would guess it was about nightlife.
I guess only krazer will understand :p
I would guess it was about stock photography or something.
a lot of anime is about highschoolers and spring is the season of fun and new stuff, blooming sakura trees, etc
badges would be sakura leaves :p
22:20
ew high school.
plz give me elementary school.
Give me elementary school, or give me death.
plz no vocaloids in the design
a collage of bloodnose fountains across the site header would definitely associate with anime >.>
k time to sleep
see ya tomorrow
22:47
Anyone here following the Law private beta?
i didn't care much about the proposal but I made an account on the site just to see what they post there
You don't actually need an account for that. Just the cookie you get through A51 will let you browse the beta fine.
23:15
TIL
I still have an account on most of the sites anyway
I think I have an account on every site except maybe some hidden ones
like dev.so?
The thing with duplicates silently redirecting was one of the main reasons, because that's pretty annoying.
@Unihedron Dev tier site accounts aren't connected to the main SE.
@LoganM oh I see
But at one point I did have an account on dev.so. Haven't been back there in a long time though so I don't know.
I think my favorite dev tier site is dev.a51. It's broken in all sorts of ways that you don't even have to log in to see.
23:20
o_o
You're right!
I "believe" the policy is for the professor to file a DMCA request for copyright violation. But don't quote me on that. The professor/school would also need to hold a copyright to either the question or the answer. — Mysticial 3 mins ago
^^ Is that the right policy? /cc @LoganM - since it probably happens on Math.SE all the time.
@Mysticial yes it is
23:35
@Mysticial I think SE has said before that they have no interest in catching cheaters. On Math.SE some policies are in place to prevent the most obvious cases or in contests, but it's almost certainly true that people are still cheating there right now. On SO, I don't think anything other than claiming copyright violation is going to get them to take it down.
For reference, it's roughly the same policy if someone asks a question that inadvertently reveals details of some piece of software which are not intended to be public. SE is not a party to the various software TOS, nor the university honor codes, so they have no business enforcing them.
@LoganM Yes, SE is a site for Q&As, it really has no concern over the reasoning behind a post - whether it's made to cheat shouldn't be at all relevant when judging if a post should stay
@Unihedron "SE is a site for Q&As" is true, but only if you adopt a rather broad interpretation of the term "Q&A". For instance, on Math.SE, a majority of the top users view their contributions there as part of their broader efforts in teaching mathematics, and thus seek to answer questions pedagogically, rather than practically.
In some cases, the best pedagogical answer is "you need to figure this out yourself", though usually you can at least get a hint if you show what you do know and where you're stuck.
@ToshinouKyouko what? no Ayano?
@ToshinouKyouko i was more thinking of Ayano being dressed up to, but that's just a cute
I couldnt find one :(
back later~
Youtube's shuffle system's failing
It always return the same results. Weird.
Could it be a potential security hole?
@LucasHenrique not sure how a random order of videos that's not being randomized could be exploited to breach secrutiy
I mean: what if the thing is not limited to playlists?

« first day (896 days earlier)      last day (3563 days later) »