Time  Nick         Message
00:10 soniakeys    I have lots of raster tasks completed in Go.   Posting them now. :)
13:55 mikemol      Lot of new, active users on the wiki lately.
13:55 mikemol      It's been good, IMO.
13:55 mikemol      Magi, Hobley and Ledrug seem to be pulling in some different perspectives.
13:56 mikemol      Liking having more raster tasks, too.
13:56 mikemol      And I'm liking the close examination of a lot of existing tasks; it's good to clean house every now and again.
13:56 mikemol      Especially when it involves the cleaning of tasks I wrote at or near the beginning of the site's lifetime.
13:56 mikemol      One thing I'm worried about, though.
13:57 mikemol      Yes, Rosetta Code is largely a matrix crossing languages and tasks.
13:58 mikemol      One thing I've wanted for years is to have a third dimension, libraries.
13:59 mikemol      RC's purpose isn't just to illuminate languages, but also to illuminate problems being solved and how to solve them. I've occasionally noticed resistence to tasks which 'devolve' to calling out to various libraries. I understand it, but I'd prefer it understood that libraries are suitable for comparison, too.
14:02 opticron     yeah, when I first started writing tasks, I was very hesitant to use libs to accomplish tasks
14:03 opticron     then I came upon the xml-related tasks
15:34 mikemol      I'm digging around on an idea I had this morning.
15:35 mikemol      I'm trying to find out if I can get a credit card line built that donates some small percentage of purchases to RC each time it's used.
15:35 mikemol      That sentence isn't quite right.
15:36 mikemol      What I'm looking for is for RC to get something like 1/100 or 1/1000th of a penny for every penny spent through the card.
16:07 * CodeBlock  raises an eyebrow
18:06 mwn3d_phone  I graphed my number of edits over the years just to see what it looks like. I guess 2010 was a slow year: http://i.imgur.com/1W8EU.png
18:06 mwn3d_phone  Not sure what it means but it was neat to look at
18:56 mikemol      mwn3d_phone: Nice data. I think you'll find the 1st derivative more interesting.
18:57 mikemol      It almost looks like your peak period is in the fall semester, and it trails off in the summer.
18:57 mikemol      Though now that you're no longer in school, I'm not sure what it'll look like in the future.
19:03 mikemol      Since I had Google Analytics start counting edits in early 2009, it looks like we've averaged about 900 edits per month. If you take just the last year, it's about 1,150 edits per month.
19:03 mikemol      May looks like it has the highest count we've ever seen, at 1,673. That's around 500 more than the previous month.
19:03 mwn3d_phone  Unfortunately its difficult to fill in the gaps between 1000 edit intervals because edits to deleted pages are taken off of your contribution list
19:04 mwn3d_phone  And I'm sure there are tons of those
19:04 mikemol      Rather than counting at 1000 edit intervals, count at 250.
19:04 mikemol      It'll still be a bit low, but you should still get the general curve.
19:07 mwn3d_phone1 Don't mind my phone disconnecting...the building blocks a lot of signal...
19:07 mikemol      I don't even notice any more.
19:08 * mikemol    tries to remember how to increment an existing value in an SQL table.
19:08 mikemol      s/SQL table/field in a record/
19:14 mwn3d_phone1 mikemol: add "auto increment" to the column definition. E.g.: create table blah( column_name type contraint auto increment)
19:14 mikemol      Not auto-incrementing. Accumulating.
19:15 mikemol      sqlite's syntax is a little strange for some things, too. I'm pretty sure I used to know how to INSERT or UPDATE in MySQL, but it doesn't look like sqlite's syntax supports that.
19:15 mwn3d_phone1 Add a column whose value is Sum(other_column)?
19:16 mikemol      "If the record exists, increment the column's value by one. Otherwise, create the record with an initial value" <-- that's what I'm going for.
19:17 mikemol      With the way I have to do this, though, to avoid racing, it looks like I'm going to attempt to insert regardless, catch any "already exists exception" if it's thrown, and then increment.
19:17 mwn3d_phone  Count?
19:19 mikemol      mwn3d_phone: I'm building a table for a markov engine. This table counts how many times a symbol has been seen. The table starts clean, and I have to add new symbols to it from time to time, but I don't start off knowing whether or not the symbol is already there.
19:19 mikemol      Think I've got it figured out, though. I'll show you when I'm done.
20:41 Coderjoe     mikemol: um... if this is the totalcounts table, you have to add a record if you added the word to the id table
20:42 Coderjoe     if it is the interword table, I can see that being tricky
20:42 mikemol      Yeah, it's the interword table.
20:42 mikemol      No big deal, though, as long as I can tolerate an error from a redundant op.
20:42 mikemol      "insert (may error)" -> "increment".
20:42 mikemol      That one handles data races safely.
20:43 Coderjoe     there is "replace into" or "insert or replace into"
20:43 mikemol      Not sure how to use the syntax to derive the new value from the existing value in the same statement, though.
20:59 Coderjoe     you could possibly do a create trigger on update that checks if the record exists and inserts it if it does not
20:59 Coderjoe     ... i think
21:02 Coderjoe     or just attempt the update and insert if it fails
21:02 Coderjoe     which is probably easier