Camelia, the Perl 6 bug

IRC log for #ilbot, 2012-12-01

| Channels | #ilbot index | Today | | Search | Google Search | Plain-Text | summary

All times shown according to UTC.

Time Nick Message
02:10 pdurbin is there any particular reason AUTO_INCREMENT=2357358 at https://github.com/moritz/i​lbot/blob/master/ilbot.sql ?
16:47 pdurbin oh, right, at those numbers correspond to the per-line permalinks, of course! ok. it really doesn't matter then for http://irclog.greptilian.com because there's no way i'm changing the numbers, since i've already linked to them
16:47 pdurbin but when i start up my next ilbot (hopefully next week) i'll probably start the count at 1
16:48 moritz pdurbin: it's just what mysqldump produced, so it happened to be the next free ID at the time I dumped the schema
16:48 pdurbin right, right. that was my guess. it's fine
16:48 moritz and the irclog.perlgeek.de installation even has negative IDs
16:49 pdurbin my maybe... for future people, it should be "null"
16:49 pdurbin negative id's?!? really?
16:49 moritz because somebody provided old logs for #perl6 which I imported, and gave them negative IDs to maintain montony
16:49 pdurbin oh, oh, yours. not mine. nevermind!
16:49 pdurbin gotcha
16:50 moritz anyway, removed the magic number from ilbot.sql
16:50 moritz thanks
16:52 pdurbin sure
16:52 pdurbin ah! that must be where monotone gets its name! http://en.wikipedia.org/wi​ki/Monotone_%28software%29
16:57 pdurbin ah, you removed not only the magic number but AUTO_INCREMENT itself
16:58 pdurbin but this is still there so the autoincrement will still happen, i'm sure: `id` int(11) NOT NULL auto_increment
16:58 moritz right
16:58 pdurbin i'm not exactly a database guru
16:59 moritz me neither, I'm just a database user :-)
16:59 pdurbin :)
16:59 moritz and I've had various requests to make ilbot run on other databases too (namely postgres and sqlite)
16:59 moritz it's still in the back of my mind
16:59 moritz but I really need to fix up the search first
17:00 pdurbin oh good, because i'd be interested in postgres support
17:00 moritz me too
17:00 pdurbin i start my new job in a week and i'll be working with postgre
17:00 pdurbin s
17:00 moritz these days I only use mysql for legacy projects
17:00 pdurbin right, me too
17:00 moritz oh cool, where and what is your new job?
17:01 pdurbin i get to be an open source developer!! https://twitter.com/philipdur​bin/status/273229031082692608
17:01 pdurbin this is the open source project: http://thedata.org
17:02 pdurbin moritz: want a davaverse? they're free! :)
17:03 pdurbin "create a dataverse of your own to share your social science data and get a formal persistent citation" -- http://dvn.iq.harvard.edu/dvn/
17:04 moritz pdurbin: looks interesting, but I've left academia two months ago
17:04 pdurbin doesn't have to be social science data though... http://theastrodata.org is powered by the same software
17:04 pdurbin ok, cool. well, if you know anyone who might be interested in the dataverse... :)
17:04 pdurbin two months ago, huh? new job?
17:05 moritz yes
17:06 moritz I develop internally used software at an IT outsourcing company
17:06 pdurbin cool
17:07 pdurbin oh, dunno if you'd be interested in getting in on the ground floor of this community i'm trying to get off the ground... http://sourcefu.com
17:07 pdurbin it's only a few days old
17:19 pdurbin ilbot is related to http://dvn.iq.harvard.edu in that i'm hoping (next week) to set up http://irclog.iq.harvard.edu to start logging #dvn and maybe other projects - http://www.iq.harvard.edu/products
17:57 pdurbin cool, this is working... screen -d -m perl -I /var/www/irclog/ilbot /var/www/irclog/ilbot/ilbot2.pl
18:05 pdurbin actually... no... "Can't read configuration in database.conf: No such file or directory" ... because i need to cd to /var/www/irclog/ilbot first. hmm
18:06 pdurbin (that's where my clone of the ilbot repo is)
18:06 pdurbin i guess i'll just write a little wrapper script
18:10 pdurbin yep. that works :)
18:19 pdurbin start philbot on boot · e604991 · pdurbin/greptilian-vagrant - https://github.com/pdurbin/greptilian-vagrant/c​ommit/e6049917d79a53fc917b168e8dafe5dc77d00b9c

| Channels | #ilbot index | Today | | Search | Google Search | Plain-Text | summary