Hey, check my amazingly shitty IRC client! It only took me way to long to actually send data to the server because as usual I forgot AutoFlush = true on the StreamWriter.
An infinite number of mathematicians walk into a bar. The first one orders half a beer. The second orders a quarter beer. The third orders one eighth of a beer.
The bartender goes "I hate you" and gives them two beers.
Bartender should say "you should really know your limits" there...
Does anyone have a recommendation for a site with a decent quick starter intro to SQL? Every so often there's stuff that needs changing here, and I'd like to be able to do it myself rather than always having to ask one of the folks that understands it. I sort of recognise some of the concepts by osmosis, but it feels like there's some really fundamental stuff that I don't know.
Does anyone have a recommendation for a site with a decent quick starter intro to SQL? Every so often there's stuff that needs changing here, and I'd like to be able to do it myself rather than always having to ask one of the folks that understands it. I sort of recognise some of the concepts by osmosis, but it feels like there's some really fundamental stuff that I don't know.
SQLZoo is the best tutorial series I've found. Also depends on the database, as syntax can change based on whether it's MS SQL, Oracle, Teradata etc.
Thanks for the sql pointers -- I'll give them a look. The code is talking to MS SQL server, with bits of entity framework in some places -- there's nothing very complicated going on, I think, but I want to make sure I have the basics of what "join" (etc) means clear in my head, rather than trying to form a mental picture just by looking at existing queries and thinking about what they do.
Also I felt the two RFCs I read were pretty terribly written. I have plenty of info about how the message from the client to the server is to be formed, but only a vague idea about replies from the server.
Eh, you're turning an O(1) check into an O(n) one there (barring absolutely fantastic optimizer work). In practical terms it's unlikely someone routinely sends kilobyte or bigger strings but... doesn't sit right with me
Eh, you're turning an O(1) check into an O(n) one there (barring absolutely fantastic optimizer work). In practical terms it's unlikely someone routinely sends kilobyte or bigger strings but... doesn't sit right with me
I was going to say no, but... yeah. If well-formed the hash is the first character and IndexOf() stops at the first occurence.
Also JOIN takes a second space-separated argument that is the potential password to a protected channel so that code will get scrapped anyway. :rotate:
I was trying to name a variable in a way that made if fairly clear that I was dealing with the distance(adjusted for octave) between the secondary Melody line and the bass line.
I then realized that this variable name is actually my new favourite 90s R&B a capella group.
I suppose I could implement that idea I got for a single-pass check to find the positions of a set of arbitrary characters in a string for situations like that.
I was trying to name a variable in a way that made if fairly clear that I was dealing with the distance(adjusted for octave) between the secondary Melody line and the bass line.
I then realized that this variable name is actually my new favourite 90s R&B a capella group.
I dig that Mel2Bass
Is there a reason you're looping like that instead of using the modulo operator?
I was trying to name a variable in a way that made if fairly clear that I was dealing with the distance(adjusted for octave) between the secondary Melody line and the bass line.
I then realized that this variable name is actually my new favourite 90s R&B a capella group.
I dig that Mel2Bass
Is there a reason you're looping like that instead of using the modulo operator?
Mostly just because I'm an idiot and hadn't thought of it that way.
I think because I was thinking of it from musical terms where I wanted the interval, adjusted for octave, which made me go "find difference -> adjust until the right octave"
Eh, you're turning an O(1) check into an O(n) one there (barring absolutely fantastic optimizer work). In practical terms it's unlikely someone routinely sends kilobyte or bigger strings but... doesn't sit right with me
How could the no-space check occur in O(1)? Or are you just talking about the first line? Cuz we all know that O(1) + O(n) = O(n) :rotate:
(I wonder if compiler would be clever enough to do them both in one go?)
last few weeks have been a return to full time objective-c for me and I'm amused to be reminded that NSString is still the slowest form of string type in the history of all programming languages
want to loop a string comparison? better not have more than 1000 iterations or go ahead and do your laundry
im trying to do unique column constraints in CoreData and it is going.... poorly
if i do it manually, it's performance is abysmal
if I try to get CoreData to do it natively, I get extremely cryptic exceptions and unusual debugging events that makes me question basically everything about my implementation
and oddly this is one of the very few things that Apple hasn't documented particularly well
"How did you get my email address? How awful of you to spam me!"
Okay, first of all? Your email address is abcdtest@gmail.com. That's on you.
Secondly, why is the external QA team using gmail addresses to test things? There are tools for that kind of thing.
0
Options
gavindelThe reason all your softwareis brokenRegistered Userregular
I need to update xml metadata for about 2500 files at once. Be nice to auomate that, right? Send out an email asking if resources exist, get a response:
"Nope, but you can always use a script to manually change the xml. Just make sure not to disrupt the node ordering or you'll nuke the entire system. 8-) "
Ok, I've finally hit a wall with teaching myself how to code, specifically with one problem.
I'm using Python to access a local MySQL server and input values, specifically using the twitter api to do so as a test run. Everything runs perfectly fine until the twitter api cuts me off because it only supports so many calls within a 15 minute time frame. When it happens it cuts off my list of followers I'm inputting, so it stops the script in its tracks. I've got a work around for this, but if I need to run the script again, which I have to since it stops it, the api gives me integrity errors when I try to input it to the server since there's already a copy of that data in the server.
I've come up with a few different work-arounds for this, but the main thing I'm having issue with is running a search for the value that I'm trying to input, and if its there it skips that value. I can't seem to figure out a way to do this while reducing the memory workload of the script and the amount of calls I have to make to the MySQL server.
e: as a further example, this is what it looks like
I'm using a try and except Integrity Error, and printing that error when the except is called, but it's still doing the insert and rollback in the try/except function. Que es esto?
I'm using a try and except Integrity Error, and printing that error when the except is called, but it's still doing the insert and rollback in the try/except function. Que es esto?
Are you asking why the insertion and rollback are still happening?
I'm using a try and except Integrity Error, and printing that error when the except is called, but it's still doing the insert and rollback in the try/except function. Que es esto?
Are you asking why the insertion and rollback are still happening?
Yeah. I did use a new method that has so far seemed to work but I'm having a hard time testing it since the API is still curtailing my calls, but I'd like to know why it's still happening.
You're still getting the integrity error because your code in the try clause executes until it hits the exception, which is what is causing the insertion/rollback, I think
Posts
Now to actually implement the protocol.
I'll happily answer any questions I can as well. My experience is with Transact SQL.
it's a pretty good "beginners" resource or reference sheet
what happens if someone drops #poopybutt without typing spaces?
SQLZoo is the best tutorial series I've found. Also depends on the database, as syntax can change based on whether it's MS SQL, Oracle, Teradata etc.
It returns true? No spaces allowed.
i was told once by a recently graduated student that professors tell their class to not use W3 in the way that teachers told me not to use Wikipedia
to which i say "why?"
Are you actually aiming for IRC or just doing a "chat thing"? That's far from the RFC definition of a channel name.
So far just a chat thing. Not caring much about actual specs. That's my first 15 seconds of sanity checking a channel name.
Good luck, personal projects are a fun way to learn!
Eh, you're turning an O(1) check into an O(n) one there (barring absolutely fantastic optimizer work). In practical terms it's unlikely someone routinely sends kilobyte or bigger strings but... doesn't sit right with me
Also code above is client-side. My general approach to this is "client can send whatever, server does sanity checking".
I was going to say no, but... yeah. If well-formed the hash is the first character and IndexOf() stops at the first occurence.
I then realized that this variable name is actually my new favourite 90s R&B a capella group.
I dig that Mel2Bass
It used to be really crappy, I guess? http://w3fools.com/ was at one point a list of all the things wrong on w3schools, but they seem to have cleaned up since then. https://meta.stackoverflow.com/a/280484 has more.
Mostly just because I'm an idiot and hadn't thought of it that way.
I think because I was thinking of it from musical terms where I wanted the interval, adjusted for octave, which made me go "find difference -> adjust until the right octave"
How could the no-space check occur in O(1)? Or are you just talking about the first line? Cuz we all know that O(1) + O(n) = O(n) :rotate:
(I wonder if compiler would be clever enough to do them both in one go?)
want to loop a string comparison? better not have more than 1000 iterations or go ahead and do your laundry
if i do it manually, it's performance is abysmal
if I try to get CoreData to do it natively, I get extremely cryptic exceptions and unusual debugging events that makes me question basically everything about my implementation
and oddly this is one of the very few things that Apple hasn't documented particularly well
"How did you get my email address? How awful of you to spam me!"
Okay, first of all? Your email address is abcdtest@gmail.com. That's on you.
Secondly, why is the external QA team using gmail addresses to test things? There are tools for that kind of thing.
"Nope, but you can always use a script to manually change the xml. Just make sure not to disrupt the node ordering or you'll nuke the entire system. 8-) "
Well, no pressure, right?
I'm using Python to access a local MySQL server and input values, specifically using the twitter api to do so as a test run. Everything runs perfectly fine until the twitter api cuts me off because it only supports so many calls within a 15 minute time frame. When it happens it cuts off my list of followers I'm inputting, so it stops the script in its tracks. I've got a work around for this, but if I need to run the script again, which I have to since it stops it, the api gives me integrity errors when I try to input it to the server since there's already a copy of that data in the server.
I've come up with a few different work-arounds for this, but the main thing I'm having issue with is running a search for the value that I'm trying to input, and if its there it skips that value. I can't seem to figure out a way to do this while reducing the memory workload of the script and the amount of calls I have to make to the MySQL server.
e: as a further example, this is what it looks like
I'm using a try and except Integrity Error, and printing that error when the except is called, but it's still doing the insert and rollback in the try/except function. Que es esto?
Are you asking why the insertion and rollback are still happening?
Yeah. I did use a new method that has so far seemed to work but I'm having a hard time testing it since the API is still curtailing my calls, but I'd like to know why it's still happening.