| --- Log opened Mon Oct 05 00:00:37 2015 |
| 00:12 | | Turaiel[Offline] [Brandon@Nightstar-pkuq0e.mi.comcast.net] has joined #code |
| 00:12 | | Turaiel[Offline] is now known as Turaiel |
| 00:41 | | Turaiel is now known as Turaiel[Offline] |
| 00:44 | | Turaiel[Offline] is now known as Turaiel |
| 01:25 | | catalyst [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has quit [[NS] Quit: ] |
| 01:35 | | catadroid [catalyst@Nightstar-8236l9.dab.02.net] has joined #code |
| 02:50 | | Vash [Vash@Nightstar-uhn82m.ct.comcast.net] has joined #code |
| 02:50 | | mode/#code [+o Vash] by ChanServ |
| 03:27 | | thalass [thalass@Nightstar-m49.o7s.158.104.IP] has quit [Connection closed] |
| 03:49 | | Turaiel is now known as Turaiel[Offline] |
| 04:23 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [Connection reset by peer] |
| 04:54 | | Derakon is now known as Derakon[AFK] |
| 05:36 | | catadroid` [catalyst@Nightstar-lnd099.dab.02.net] has joined #code |
| 05:38 | | catadroid [catalyst@Nightstar-8236l9.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 05:56 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Connection closed] |
| 06:17 | | Reiv [NSwebIRC@Nightstar-q8avec.kinect.net.nz] has quit [Ping timeout: 121 seconds] |
| 06:21 | | Crossfire [Z@Nightstar-pdi1tp.customer.tdc.net] has quit [Ping timeout: 121 seconds] |
| 06:50 | | Vash [Vash@Nightstar-uhn82m.ct.comcast.net] has quit [[NS] Quit: Quit] |
| 06:57 | | celticminstrel [celticminst@Nightstar-o8adld.dsl.bell.ca] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!] |
| 06:58 | | Kindamoody[zZz] is now known as Kindamoody |
| 07:23 | | Scaramanga [subwolf@Nightstar-r53tak.dsl.as9105.com] has joined #code |
| 07:24 | | SubWolf [subwolf@Nightstar-pom1lk.dsl.as9105.com] has quit [Operation timed out] |
| 07:29 | | Crossfire [Z@Nightstar-r9lk5l.cust.comxnet.dk] has joined #code |
| 07:30 | | mode/#code [+o Crossfire] by ChanServ |
| 07:45 | | macdjord is now known as macdjord|slep |
| 07:54 | | catadroid [catalyst@Nightstar-omdd02.dab.02.net] has joined #code |
| 07:54 | | catadroid` [catalyst@Nightstar-lnd099.dab.02.net] has quit [The TLS connection was non-properly terminated.] |
| 08:09 | | Alek [Alek@Nightstar-03ja8q.il.comcast.net] has quit [Ping timeout: 121 seconds] |
| 08:12 | | Alek [Alek@Nightstar-03ja8q.il.comcast.net] has joined #code |
| 08:12 | | mode/#code [+o Alek] by ChanServ |
| 08:24 | | Crossfire [Z@Nightstar-r9lk5l.cust.comxnet.dk] has quit [Ping timeout: 121 seconds] |
| 08:25 | | Kindamoody is now known as Kindamoody|out |
| 08:37 | | catadroid [catalyst@Nightstar-omdd02.dab.02.net] has quit [[NS] Quit: Bye] |
| 10:11 | < wowaname> | Please make IRC safe for ASCII thank you [AMSG] |
| 10:12 | <@gnolam> | What. |
| 10:17 | <&McMartin> | ¿Cómo? |
| 10:25 | <@TheWatcher> | áá¯áá? |
| 10:40 | < wowaname> | _____ |
| 10:40 | < wowaname> | < moo > |
| 10:40 | < wowaname> | ----- |
| 10:40 | < wowaname> | \ ^__^ |
| 10:40 | < wowaname> | \ (oo)\_______ |
| 10:40 | < wowaname> | (__)\ )\/\ |
| 10:40 | < wowaname> | ||----w | |
| 10:40 | < wowaname> | || || |
| 10:42 | < abudhabi> | wowitsfuckingnothing.jpg |
| 10:57 | | catadroid [catalyst@Nightstar-omdd02.dab.02.net] has joined #code |
| 11:04 | <@froztbyte> | an amsg? that's a bit obnoxious |
| 11:05 | < wowaname> | so are you tbh |
| 11:05 | < wowaname> | :3 |
| 11:07 | < [R]> | Says the one who dumped ascii-art pointlessly. |
| 11:08 | < wowaname> | >pointlessly |
| 11:13 | < [R]> | You're right, "pointlessly" was redundant, ascii-art is always such. |
| 11:16 | | wowaname was kicked from #code by froztbyte [cool] |
| 11:16 | | wowaname [h@wowana.me] has joined #code |
| 11:16 | <@froztbyte> | and ajoins? |
| 11:16 | <@froztbyte> | well. I'll leave this for someone else to glance at as well. |
| 11:28 | < [R]> | Ajoins are technically something different. |
| 11:29 | < [R]> | That's an auto-rejoin. |
| 11:35 | <@froztbyte> | yeah, true. misnomer on my part |
| 11:45 | < [R]> | "Eventually, the Bobs stepped in with a new solution: every object in every thread would run its own personal event loop. " Twitch |
| 11:49 | <@TheWatcher> | ... |
| 11:49 | <@TheWatcher> | wut |
| 11:52 | < [R]> | Today's TDWTF |
| 12:04 | < catadroid> | ._. |
| 12:05 | | * catadroid fetches the chainsaw |
| 12:06 | | catadroid` [catalyst@Nightstar-2itjmg.dab.02.net] has joined #code |
| 12:07 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
| 12:09 | | catadroid [catalyst@Nightstar-omdd02.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 12:13 | | catadroid` is now known as catadroid |
| 12:22 | < abudhabi> | Reiver: You here? I could use some SQL advice. |
| 12:25 | <@froztbyte> | [R]: wow |
| 12:26 | < abudhabi> | Namely, I need some kind of way to a) insert a bunch of entries into table A, b) insert entries referring to the entries in table A into table B. |
| 12:26 | < abudhabi> | I would *like* to do it in a way that doesn't require individual INSERT statements for step a). |
| 12:27 | < [R]> | INSERT INTO `tableA` (`colA`, `colB`) VALUES (1, 'A'), (2, 'B'), (3, 'C'), ... |
| 12:28 | < [R]> | You'll need at least two INSERT statements, unless your DB has some funky dual-table insert setup |
| 12:28 | < abudhabi> | Is colA supposed to be the key here? |
| 12:29 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [Connection reset by peer] |
| 12:29 | < abudhabi> | (This is mySQL.) |
| 12:31 | < abudhabi> | As it currently works: 1) Insert one record into A. 2) Retrieve last generated Id. 3) Insert arbitrarily many records into B with the Id as a reference. |
| 12:31 | < abudhabi> | This is slow. |
| 12:31 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
| 12:31 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [Connection closed] |
| 12:31 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
| 12:35 | < [R]> | colA is just a column |
| 12:35 | < [R]> | Ah |
| 12:35 | | * [R] uses UUIDs for everything. |
| 12:36 | < [R]> | Hmm |
| 12:47 | < [R]> | abudhabi: For every insert into A is there a single insert into B? |
| 12:47 | <@TheWatcher> | "arbitrarily many records" |
| 12:48 | < [R]> | Then answer 2: http://stackoverflow.com/questions/8481421/does-a-mysql-multi-row-insert-grab-se quential-autoincrement-ids |
| 12:48 | < [R]> | Answer 1 rather |
| 12:49 | < [R]> | Also: " When doing bulk inserts into tables with auto-increment columns, set innodb_autoinc_lock_mode to 2 instead of the default value 1. See Section 14.8.5.2, âConfigurable InnoDB Auto-Increment Lockingâ for details. " |
| 12:49 | < [R]> | https://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-bulk-data-loading.html |
| 12:52 | <&Reiver> | Yeah, that looks about right |
| 12:52 | <&Reiver> | Inserting into tables with autoincrements is a pain in the ass |
| 12:52 | <&Reiver> | Not many good ways around it. |
| 12:59 | < abudhabi> | Does autoincrementing guarantee consecutiveness in this case? |
| 12:59 | < abudhabi> | I mean, it won't accidentally hit a duplicate or skip over one? |
| 13:04 | <@TheWatcher> | Yes, if you're doing a single-statement multiple insert, it should lock the table during it |
| 13:04 | <@TheWatcher> | If you want to be really, really sure, lock the table yourself. |
| 13:11 | < [R]> | abudhabi: read my first link |
| 13:11 | < [R]> | It explains that |
| 13:23 | -Azash:%#code- froztbyte, our experiences with him elsewhere https://paste.debian.net/plainh/cbf0d8a0 |
| 13:25 | <@froztbyte> | Azash: pleasant |
| 13:25 | < Azash> | Yup, and I just realized the problem with that - oops |
| 13:30 | | Shiz [mark@Nightstar-8tmred.shiz.me] has joined #code |
| 13:32 | | Turaiel[Offline] is now known as Turaiel |
| 13:56 | | celticminstrel [celticminst@Nightstar-o8adld.dsl.bell.ca] has joined #code |
| 13:56 | | mode/#code [+o celticminstrel] by ChanServ |
| 14:10 | | macdjord|slep is now known as macdjord|wurk |
| 14:19 | | Irssi: #code: Total of 40 nicks [22 ops, 0 halfops, 0 voices, 18 normal] |
| 14:19 | | Irssi: No bans in channel #code |
| 14:38 | | Crossfire [Z@Nightstar-r9lk5l.cust.comxnet.dk] has joined #code |
| 14:38 | | mode/#code [+o Crossfire] by ChanServ |
| 14:43 | | Alek [Alek@Nightstar-03ja8q.il.comcast.net] has quit [Ping timeout: 121 seconds] |
| 14:46 | | Alek [Alek@Nightstar-03ja8q.il.comcast.net] has joined #code |
| 14:46 | | mode/#code [+o Alek] by ChanServ |
| 15:52 | | Derakon[AFK] is now known as Derakon |
| 17:01 | | * Derakon grins quietly to himself. |
| 17:02 | < catadroid> | oh? :) |
| 17:02 | <&Derakon> | The previous version of µManager (the microscope-control software I maintain) took many seconds to load plugins. We had to do the loading in parallel with showing an intro dialog to the user, and then had to pop up a "please wait" dialog after that, with a timeout at 15 seconds. |
| 17:02 | <&Derakon> | The new version loads plugins in 200ms on my laptop. |
| 17:02 | < catadroid> | sweet |
| 17:04 | <&Derakon> | (Consequently, the intro dialog is now pluggable~) |
| 17:05 | < catadroid> | hehe x) |
| 17:30 | | catadroid [catalyst@Nightstar-2itjmg.dab.02.net] has quit [A TLS packet with unexpected length was received.] |
| 17:30 | | catadroid [catalyst@Nightstar-2itjmg.dab.02.net] has joined #code |
| 17:45 | | catadroid [catalyst@Nightstar-2itjmg.dab.02.net] has quit [[NS] Quit: Bye] |
| 18:07 | | Meatyhandbag [sebastianfe@Nightstar-7oj.u04.53.184.IP] has joined #code |
| 18:32 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [Connection closed] |
| 18:36 | | catalyst [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has joined #code |
| 18:54 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
| 19:24 | | Meatyhandbag [sebastianfe@Nightstar-7oj.u04.53.184.IP] has quit [Client exited] |
| 19:39 | <@Alek> | Derakon: sweet. |
| 19:56 | | EvilDarkLord is now known as Wolf |
| 20:01 | | Vash [Vash@Nightstar-uhn82m.ct.comcast.net] has joined #code |
| 20:01 | | mode/#code [+o Vash] by ChanServ |
| 20:12 | | Vash [Vash@Nightstar-uhn82m.ct.comcast.net] has quit [Ping timeout: 121 seconds] |
| 20:15 | | Vash [Vash@Nightstar-uhn82m.ct.comcast.net] has joined #code |
| 20:15 | | mode/#code [+o Vash] by ChanServ |
| 20:22 | | * Derakon finds a variable named "version10betaLabel" that is used to display the version string on the intro dialog. |
| 20:22 | <&Derakon> | It took me a bit, but I'm pretty sure this variable was added when version 1.0 of the program was in beta. |
| 20:23 | <&Derakon> | Which was...eight years ago? |
| 20:23 | <&Derakon> | (Naturally the actual text displayed is not "1.0beta" or anything like that) |
| 20:32 | | Kindamoody|out is now known as Kindamoody |
| 20:57 | | Turaiel is now known as Turaiel[Offline] |
| 21:18 | | Reiv [NSwebIRC@Nightstar-q8avec.kinect.net.nz] has joined #code |
| 21:18 | | mode/#code [+o Reiv] by ChanServ |
| 22:09 | < catalyst> | Rust is exciting. |
| 22:11 | <&McMartin> | \o/ |
| 22:12 | | Meatyhandbag [sebastianfe@Nightstar-7oj.u04.53.184.IP] has joined #code |
| 22:12 | < catalyst> | like, I'm actually enjoying wrapping win32 code up in succinct little boxes |
| 22:20 | | Meatyhandbag [sebastianfe@Nightstar-7oj.u04.53.184.IP] has quit [Connection closed] |
| 22:21 | | Meatyhandbag [sebastianfe@Nightstar-7oj.u04.53.184.IP] has joined #code |
| 22:27 | | Kindamoody is now known as Kindamoody[zZz] |
| 22:33 | | Meatyhandbag [sebastianfe@Nightstar-7oj.u04.53.184.IP] has quit [Connection closed] |
| 22:35 | | Meatyhandbag [sebastianfe@Nightstar-7oj.u04.53.184.IP] has joined #code |
| 22:48 | | Meatyhandbag [sebastianfe@Nightstar-7oj.u04.53.184.IP] has quit [Connection reset by peer] |
| 22:57 | | Meatyhandbag [sebastianfe@Nightstar-7oj.u04.53.184.IP] has joined #code |
| 23:36 | | Turaiel[Offline] is now known as Turaiel |
| --- Log closed Tue Oct 06 00:00:53 2015 |