Time  Nick       Message
02:34 pdurbin    helpful: http://www.rackspace.com/knowledge_center/article/mysql-resetting-a-lost-mysql-root-password
17:36 semiosis   http://www.markshuttleworth.com/archives/1316 -- farewell Upstart, what a long strange trip it's been
17:40 pdurbin    systemd-lish: https://plus.google.com/u/1/111049168280159033135/posts/PpxUSXcF4CU #rejectedcandyhearts
17:40 pdurbin    mhayden: glad you plus oned that :)
18:06 mhayden    pdurbin: i lol'd
18:06 mhayden    and ubuntu finally caved!
18:42 pdurbin    :)
19:11 pdurbin    python doesn't have something like perl's DBI? http://stackoverflow.com/questions/3128961/what-is-the-python-equivalent-of-perls-dbi
19:25 pdurbin    right so if you're using || with psql to concatenate two columns it gets an ugly label: ?column?
19:25 pdurbin    but then you just add this: AS the_label_i_want
19:25 pdurbin    as explained here: http://stackoverflow.com/questions/5179648/prepend-table-name-to-each-column-in-a-result-set-in-sql-postgres-specifically/10261640#10261640
19:38 pdurbin    psql myDb -F $'\t' --no-align --pset footer -c "select id, createtime, extract(epoch from createtime) as epoch_time, protocol || ':' || authority || '/' || studyid as global_id from study;" > out.tsv
19:39 ironcamel  thats just standard SQL i think
19:39 pdurbin    having to use $ there is also weird: http://stackoverflow.com/questions/10315916/how-to-set-tab-delimiter-using-psql-f/10316104#10316104
19:39 pdurbin    ironcamel: yeah, probably
19:40 pdurbin    oh and the pset footer thing is to get rid of the row count: http://stackoverflow.com/questions/12783314/can-i-get-a-csv-header-but-no-row-count-in-postgresql/12795738#12795738
20:16 melodie    hi
20:16 melodie    Debian and Ubuntu are going systemd
20:17 melodie    I have commented this related post and talked about the Fedora configuration gui allowing to start and stop services and so on: https://plus.google.com/116965050091309960242/posts/JFVDasEDtns
21:26 semiosis   a bit sad today... after struggling for the last two years i was just now beginning to really understand upstart
21:28 * pdurbin  never bothered to learn! o/
21:36 joshu_     semiosis you ever thought about switching from Ubuntu to Debian?
21:37 semiosis   nope
21:38 semiosis   i'm extremely happy with ubuntu... imho Kubuntu is the best desktop OS ever & ubuntu server best server OS ever
21:39 semiosis   <3 the fixed release schedule, i'm a big fan of that.
21:41 semiosis   joshu_: now that doesnt mean i dislike debian... in fact i like debian a whole lot, it is most of ubuntu after all.  and as the deb package guy for glusterfs i support & contribute to both debian & ubuntu
21:41 * semiosis used debian before there was ubuntu
21:42 semiosis   redhat too in fact
21:48 joshu_     semiosis how do you setup your kubuntu. Do you start with the mini.iso and add packages or do you use the main kubuntu iso?
21:49 semiosis   the regular desktop 64bit iso
21:49 semiosis   i normally split my ssd into two & switch between the partitions with each new release
21:50 semiosis   so i can still boot into my old desktop while i set up my new one
21:50 semiosis   i usually avoid in-place upgrades
21:50 semiosis   although i was forced to do in-place upgrade for saucy on my laptop because of a bug related to EFI in the installer :(
21:50 semiosis   the upgrade was very smooth though