deletemyaccount's home timeline
Notices
-
... Now I have 4 in the sidebar. Wth rdn.
Monday, 11-Jun-12 04:59:19 UTC from web- RedEnchilada (notice the lack of a space) likes this.
- RDN's Lucifer repeated this.
-
@toksyuryel Haha, watch me use MySQL!
-
@redenchilada YOUR BUTTFACE IS A PROBLEM
-
@thelastgershwin oh he's maaad
-
char* ALL THE THINGS! !coderpony #networking
Sunday, 10-Jun-12 21:03:41 UTC from web -
@starlight Thanks. So I'm guessing no one would like a dedicated application?
Saturday, 09-Jun-12 14:08:08 UTC from web-
@redenchilada I'm gonna be quite busy all the time except the weekends, and maybe a half hour here and there during the week (for the next few week) :P and no, I'm sure you'll be the one crying over my horrible code!
-
Wait. CoffeeScript is written in CoffeeScript. Gah meta programming. !coderpony http://coffeescript.org/documentation/docs/rewriter.html
Saturday, 09-Jun-12 04:43:09 UTC from web -
Success! I've successfully mimicked RDN's background using pure CSS3! http://i.imgur.com/0wtXa.png It may not look like much but, it should fix the problems people have been having with their profile designs.
Tuesday, 05-Jun-12 23:46:37 UTC from web -
!technoponies New song :D http://www.youtube.com/watch?v=Hk3Ea-ql1C4
Saturday, 02-Jun-12 16:25:48 UTC from web -
My favourite HTTP status code is HTTP 418. !coderpony
Thursday, 31-May-12 04:45:20 UTC from web- Sir E. Hooves III likes this.
- Sir E. Hooves III repeated this.
-
@minti I like how I said that joke and almost no one will get it. xD
-
@minti I get it. I would really love to actually see someone get that.
-
You know you're doing something right when your compiler freezes windows. #coderpony
Friday, 25-May-12 12:05:26 UTC from web- RDN's Lucifer, derpyshy / chem and Bit Shift like this.
- Bit Shift and derpyshy / chem repeated this.
-
@bitshift A combination of tiredness and forgetfulness. xD
-
!technoponies NEW SONG WHOOO! http://www.youtube.com/watch?v=exHrjX6W3oU&feature=g-all-lik
Tuesday, 22-May-12 00:52:12 UTC from web -
Have a wonderfully atmospheric pony: http://fav.me/d50luc2
Monday, 21-May-12 18:18:24 UTC from web-
-
@scribble we're still churning out fanart of ponies that had a single appearance in S1E3 or something like that so
-
@redenchilada BACKGROUND PONY #31 IS BEST PONY.
derpyshy / chem likes this.
-
-
!technoponies hello my ponies
Saturday, 19-May-12 04:38:42 UTC from web-
@djvinylpon3 Okay, link me to your music. NAOW :D
-
-
Before I go to bed, I wanted to share this because it makes me happy. http://dpaste.com/749403/ @widget @bitshift !coderpony #SQL
Thursday, 17-May-12 16:31:19 UTC from web -
Wednesday, 16-May-12 03:21:49 UTC from web
-
@aeniug2 Hey, welcome back to RDN :D I've missed you *hug*
-
-
Pre-caching the path instead of generating it dynamically seems to only improve cached performance (though the improvement there is dramatic). In some cases the uncached performance was actually *worse* than generating the path in a WITH RECURSIVE block. http://pgsql.privatepaste.com/60741d539f @bitshift @widget !coderpony #SQL
Monday, 14-May-12 09:32:33 UTC from web -
So, first test: building the paths in a WITH RECURSIVE block under normal settings. Test shows that this is, indeed, unacceptably slow but cached performance is phenomenal until the thread gets monstrously huge; as real world threads will never get as big as even the smallest thread in this sample, and certainly won't be so spread out, I consider the cached performance to be acceptable but I'd like something better for uncached performance. Now let's test it with the pre-computed paths. http://pgsql.privatepaste.com/205d6138f2 @bitshift @widget !coderpony #SQL
Monday, 14-May-12 09:10:37 UTC from web -
Hm, that was done faster than I thought. I estimated the total size would get to be over 5GB but it only got to 4.1GB before it finished. Here's an hour-by-hour breakdown of how long it took to populate the database with over ten million rows: http://dpaste.com/747878/ !coderpony #SQL
Monday, 14-May-12 08:23:58 UTC from web-
@toksyuryel Well awesome!
-
-
I can't understand what this error is about. All of my parenthesis seem to line up properly (and it successfully creates the first two tables before the one with the error) and I don't see any misplaced or missing semicolons. Any help? http://dpaste.com/747347/ @bitshift @widget !coderpony #SQL
Sunday, 13-May-12 01:13:01 UTC from web-
@toksyuryel Hm, nope. I'm not seeing anything wrong either. This is most baffling.
-
@toksyuryel Incidentally, isn't "AND thread = postid" redundant in that line, given it only (as far as I can tell) gets used when "thread != postid" is false, and therefore it _must_ be true?
-
@bitshift Good point, I forgot about that. *fix*
-
-
Here's a comparison of uncached performance vs cached performance http://dpaste.com/747276/ @bitshift @widget !coderpony #SQL
Saturday, 12-May-12 20:37:27 UTC from web-
@widget Uncached, the query takes over 7300ms. Cached, it takes about 63ms.
-
-
I'm pretty happy about this. http://dpaste.com/746779/ @widget @bitshift !coderpony #SQL
Friday, 11-May-12 19:14:58 UTC from web -
A question arises: if a column references its own table as a foreign key with ON DELETE RESTRICT and just so happens to refer to its own row, is that row simply completely impossible to delete or will it be deleted normally? !coderpony #SQL
Thursday, 10-May-12 00:42:11 UTC from web -
Today's lesson: arrays are evil. http://dpaste.com/745811/ @bitshift !coderpony #SQL
Thursday, 10-May-12 00:31:17 UTC from web -
Kolmogorov complexity is fun! !coderpony
-
@bitshift Have you looked over the most recent version of the schema yet?
Wednesday, 09-May-12 05:30:04 UTC from web-
@toksyuryel Nyet. Would be better to do so while fully awake, I suspect.
-
@bitshift I dunno, I designed half of it while half asleep anyway. Here it is anyway for your perusal http://dpaste.com/745314/ (to anyone just joining us, I'm learning all of this as I go and currently lack the means to test whether I've gotten any of this right, so if the syntax and such is completely wrong it's because I have no idea what I'm doing) !coderpony #SQL
-
-
Did I do this right? ` replyto bigint CHECK (replyto IS NOT postid AND replyto IS CASE WHEN conversation IS NOT postid THEN NOT NULL),` !coderpony #SQL
Tuesday, 08-May-12 20:19:16 UTC from web-
@bitshift I have stubbed out several functions and created the triggers to demonstrate how I plan to constrain the arrays http://dpaste.com/745194/ !coderpony #SQL
-
@toksyuryel @bitshift I realized I forgot some conditionals in one of the stubbed functions, here's a fixed version of that http://dpaste.com/745201/ !coderpony #SQL
-
@bitshift So how'd I do? :) http://dpaste.com/745233/ !coderpony #SQL
-
-
Cygwin's new(-ish) xterm-derived terminal is a thing of beauty. !coderpony #ANSIArt http://ur1.ca/97cte
Tuesday, 08-May-12 23:44:20 UTC from web -
Using PostgreSQL, can a foreign key reference the table it appears in? Or is there some other way to do this? !coderpony #SQL
Tuesday, 08-May-12 01:48:17 UTC from web-
@toksyuryel *posts row, in both instances
-
@toksyuryel Not too sure on whether PostgreSQL has such a feature, but maybe you can set that as a value constraint somehow?
-
@bitshift Certainly could, though I'd rather not. Maybe I could just work around it by referencing the post id in the conversations table (which references the posts table. Circular references ftw?)
-
-
The Pyramid tutorials could really do with some work. They don't spend much time introducing the concepts and explaining what you're doing at each step, they just give you a bunch of code to copy and paste with only an overall description of what it aims to do when they bother to describe it at all. The writing is also vague and uncertain, like it *means* to give a high-level introduction and then dive in but then it just moves on to the next topic instead of diving in. Here's a tip guys: if I'm reading the tutorial it's because I want to learn how to use your software, not because I'm still deciding whether or not I should use your software. At this point I really don't know much more about how to use it than I did before I went through the tutorials. Guess it's back to plan B then: read somebody else's Pyramid app and try to figure out how it works while cross-referencing the API docs. !coderpony !python
Sunday, 06-May-12 21:01:49 UTC from web-
@widget If you're not going to read a post, don't reply to it. This should be common sense.
-
@widget I personally feel that the idea of a person who has to shorten their posts for no other reason than specifically to conform to the what can only be described as unreasonably abhorrent demands of a specific person simply because they do not wish to take the time out of their life to read an entire message that may be full of unique insight that would help a person improve their mindset is something that I can only figure to be an abhorrent concept that brings shame and tears to the eyes of those who truly appreciate the diversity present in those who take the time to deliberate on their points and give enough content to clarify any bits of vague conjecture that may be present in their wording if they had not taken the time to specify such ambiguities in the notices that they decide are worth their time to write out and then post to an internet discussion forum to await user responses.
Scribus and Toksyuryel like this. -
@redenchilada Like a Boss!
-
-
In other !coderpony -related news, I have received a copy of The Little Schemer thanks to an unknown benefactor. Hooray for Amazon wishlists, I guess (would've preferred if I knew who to thank, but then maybe they wouldn't have done it if their name would be sent with it; either way, pretty nice of them)?
Friday, 04-May-12 23:33:32 UTC from web -
>that feel when you try to RTFM but TFM is F useless !coderpony
Friday, 04-May-12 23:20:55 UTC from web-
@bitshift Sounds like my experience with learning nginx. I finally broke down and looked up alternate guides and now I understand how to work it.
-
@toksyuryel Ugh, yes. The official nginx documentation is certainly not the best I've seen. :(
-
@bitshift I ultimately had to turn to the gentoo wiki to tell me how to work it. Read that sentence a few times for it to sink in.
-
-
!coderpony Programmer hell for me was when I was analyzing a disassembly of another person's program and had to figure out what all the FPU instructions did. Did you know: doing something like "3.14f > 96" causes the compiler/assembler/linker to emit like 40 different OPcode that run on the FPU? (Protip: Floating point math is VERY expensive when it comes to speed of an application.)
Friday, 04-May-12 20:12:10 UTC from web-
@minti Yeah, floating-point math sucks. This is why we measure FLOPS.
-
