| --- Log opened Fri Nov 08 00:00:24 2019 |
| 00:25 | | Emmy [Emmy@Nightstar-9p7hb1.direct-adsl.nl] has joined #code |
| 00:39 | | Emmy [Emmy@Nightstar-9p7hb1.direct-adsl.nl] has quit [Connection reset by peer] |
| 01:03 | | Tamber [tamber@furryhelix.co.uk] has quit [Connection closed] |
| 01:03 | | Tamber [tamber@213.138.113.176] has joined #code |
| 01:03 | | mode/#code [+o Tamber] by ChanServ |
| 01:17 | | celticminstrel [celticminst@Nightstar-ocfc15.dsl.bell.ca] has joined #code |
| 01:17 | | mode/#code [+o celticminstrel] by ChanServ |
| 01:17 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Connection closed] |
| 02:39 | | Degi [Degi@Nightstar-j472mr.dyn.telefonica.de] has quit [Ping timeout: 121 seconds] |
| 02:42 | | Degi [Degi@Nightstar-r9nt50.dyn.telefonica.de] has joined #code |
| 02:45 | | abudhabi [abudhabi@Nightstar-7nkq9k.de] has quit [Connection closed] |
| 02:53 | | bluefoxx [fuzzylombax@Nightstar-gmbj85.vs.shawcable.net] has joined #code |
| 03:09 | | Pink` is now known as Pink |
| 03:10 | | Omega [Alek@Nightstar-o723m2.cicril.sbcglobal.net] has joined #code |
| 03:10 | | mode/#code [+o Omega] by ChanServ |
| 03:10 | | Alek [Alek@Nightstar-o723m2.cicril.sbcglobal.net] has quit [NickServ (RECOVER command used by Omega)] |
| 03:10 | | Omega is now known as Alek |
| 03:13 | | himi [sjjf@Nightstar-1drtbs.anu.edu.au] has quit [The TLS connection was non-properly terminated.] |
| 04:07 | | Reiv [NSkiwiirc@Nightstar-ih0uis.global-gateway.net.nz] has quit [[NS] Quit: http://www.kiwiirc.com/ - A hand crafted IRC client] |
| 04:20 | | celticminstrel [celticminst@Nightstar-ocfc15.dsl.bell.ca] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!] |
| 05:42 | | himi [sjjf@Nightstar-v37cpe.internode.on.net] has joined #code |
| 05:42 | | mode/#code [+o himi] by ChanServ |
| 06:33 | | Vorntastic [uid293981@Nightstar-6br85t.irccloud.com] has joined #code |
| 06:33 | | mode/#code [+qo Vorntastic Vorntastic] by ChanServ |
| 08:50 | | mac [macdjord@Nightstar-rslo4b.mc.videotron.ca] has quit [[NS] Quit: Deep inside, every housecat believes themself to be just a temporarily embarrassed tiger.] |
| 09:47 | | Kindamoody[zZz] is now known as Kindamoody |
| 11:06 | | Pinkhair [user1@Nightstar-g7hdo5.dyn.optonline.net] has joined #code |
| 11:08 | | Pink [user1@Nightstar-g7hdo5.dyn.optonline.net] has quit [Ping timeout: 121 seconds] |
| 13:15 | | abudhabi [abudhabi@Nightstar-7nkq9k.de] has joined #code |
| 13:15 | | mode/#code [+o abudhabi] by ChanServ |
| 13:30 | | celticminstrel [celticminst@Nightstar-ocfc15.dsl.bell.ca] has joined #code |
| 13:30 | | mode/#code [+o celticminstrel] by ChanServ |
| 13:52 | | celticminstrel is now known as celmin|away |
| 14:01 | | Reiv [NSkiwiirc@Nightstar-ih0uis.global-gateway.net.nz] has joined #code |
| 14:01 | | mode/#code [+o Reiv] by ChanServ |
| 15:14 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 15:14 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 15:41 | | Vorntastic [uid293981@Nightstar-6br85t.irccloud.com] has quit [[NS] Quit: Connection closed for inactivity] |
| 16:14 | | Kindamoody is now known as Kindamoody|afk |
| 16:53 | | Kindamoody|afk [Kindamoody@Nightstar-eubaqc.tbcn.telia.com] has quit [Ping timeout: 121 seconds] |
| 17:09 | | Emmy [Emmy@Nightstar-9p7hb1.direct-adsl.nl] has joined #code |
| 17:21 | <&[R]> | http://www.softpanorama.org/Commercial_linuxes/RHEL/index.shtml <-- of possible interest? |
| 18:10 | | Kimo|autojoin [Kindamoody@Nightstar-jtitq8.mobileonline.telia.com] has joined #code |
| 18:10 | | mode/#code [+o Kimo|autojoin] by ChanServ |
| 18:16 | | Kimo|autojoin [Kindamoody@Nightstar-jtitq8.mobileonline.telia.com] has quit [Client exited] |
| 19:23 | <&ToxicFrog> | The final version of the query, with all macros expanded, is 104 lines. |
| 20:11 | <&Reiver> | That is a pretty beefy query for routine work :) |
| 20:21 | <~Vornicus> | I think the meanest query I ever did was a thing that -- and I grant now that this was kind of a dumb way to do it -- figured out what notifications a user should get on a social network type thing |
| 20:28 | | * Reiver tries to decide between the six-level subquery monster and the Abomination they're still working with at work. Is not very happy with that one, but welp |
| 20:29 | <&Reiver> | It is, if you were to combine the three layes of views, approximately eight hundred lines long and involving at least seven subqueries ¬¬ |
| 20:30 | <&Reiver> | Most of these layers exist because we were not allowed in the context to do the /sensible/ thing which would be just to break out TSQL and start declaring a shedload of variables, then start combinatoring them together as appropriate for the higher level registers, nooo, it had to be pure, no exceptions, SQL, so we alias things together then glom them at the next level up, etc etc etc killmenow |
| 20:33 | <~Vornicus> | I love views. they are my best friend |
| 20:34 | <~Vornicus> | Sadly a lot of exporters *suck ass* at keeping them together |
| 20:46 | <&Reiver> | Yes :/ |
| 21:01 | <&[R]> | https://jqplay.org/ <-- I forget who, but someone here will find this of use |
| 21:39 | | Kimo|autojoin [Kindamoody@Nightstar-t72rpj.mobileonline.telia.com] has joined #code |
| 21:39 | | mode/#code [+o Kimo|autojoin] by ChanServ |
| 21:39 | | Kimo|autojoin [Kindamoody@Nightstar-t72rpj.mobileonline.telia.com] has quit [Connection closed] |
| 21:44 | | Kimo|autojoin [Kindamoody@Nightstar-eubaqc.tbcn.telia.com] has joined #code |
| 21:44 | | mode/#code [+o Kimo|autojoin] by ChanServ |
| 21:44 | | Kimo|autojoin is now known as Kindamoody |
| 21:44 | | KiMo|autorejoin [Kindamoody@Nightstar-eubaqc.tbcn.telia.com] has joined #code |
| 21:44 | | mode/#code [+o KiMo|autorejoin] by ChanServ |
| 21:44 | | Kimo|autojoin [Kindamoody@Nightstar-eubaqc.tbcn.telia.com] has joined #code |
| 21:44 | | mode/#code [+o Kimo|autojoin] by ChanServ |
| 21:45 | | KiMo|autorejoin [Kindamoody@Nightstar-eubaqc.tbcn.telia.com] has quit [Client exited] |
| 21:46 | | Kimo|autojoin [Kindamoody@Nightstar-eubaqc.tbcn.telia.com] has quit [Client exited] |
| 22:03 | | Vorntastic [uid293981@Nightstar-2dc.p8m.184.192.IP] has joined #code |
| 22:04 | | mode/#code [+qo Vorntastic Vorntastic] by ChanServ |
| 22:29 | <&ToxicFrog> | Reiver: it is beefy, and it takes like 8-10s to run |
| 22:30 | <&ToxicFrog> | But it will save a lot of manual work |
| 22:32 | <&ToxicFrog> | Tell it at least two of when the problem appeared at single-task, single-cell, and global scope, optionally give it a search window if you think the problem might have taken a while to manifest after a configuration push, and it gives you a list of suspect experiment IDs and what servers they affect. |
| 22:33 | <&ToxicFrog> | I've named it 'whodunnit'. |
| 22:35 | <&Reiver> | Nice! |
| 22:36 | <&ToxicFrog> | (in addition to the 104 lines of SQL -- less than that on disk, I think, but there's a lot of macroexpansion going on -- there's a bunch of bash wrapped around it to provide nicer UX) |
| 22:54 | | Emmy [Emmy@Nightstar-9p7hb1.direct-adsl.nl] has quit [Ping timeout: 121 seconds] |
| 23:12 | | Derakon [Derakon@Nightstar-f1lpvo.ca.comcast.net] has joined #code |
| 23:12 | | mode/#code [+ao Derakon Derakon] by ChanServ |
| 23:12 | <&Derakon> | Allow me to rant for a bit. I'll tell you when I'm done. |
| 23:13 | <&Derakon> | I'm trying to add button prompts to my game. These will show up in the middle of text. Fortunately, TextMesh Pro (the standard text display utility in Unity) allows you to embed sprites using special tags. |
| 23:13 | <&Derakon> | TextMesh Pro (Hereon abbreviated to TMP) requires your sprites to be in a sprite atlas to do this -- basically a single image that contains a bunch of sub-images. Reasonable enough for performance reasons... |
| 23:13 | <&Derakon> | I have 504 sprites. |
| 23:14 | <&Derakon> | Because there's one for each input type for a whole bunch of different controllers. |
| 23:14 | <&Derakon> | I can pack them into texture atlases and get metadata out saying "OK, I put the XBox 360 "A" button at this position", using tools like Free Texture Packer. |
| 23:15 | <&Derakon> | ...Unity does not have any idea how to read that data. When you set up a texture atlas in Unity, you use its tools to "slice" the atlas into individual images. |
| 23:15 | <&Derakon> | It can either do a grid slice (e.g. every image is 100x100, there's 6x5 cells, just chop them up), or automatic (it uses transparency to detect individual sprites and lassos them for you). |
| 23:16 | <&Derakon> | Free Texture Packer does not AFAICT have a "arrange these images in a grid layout" mode, and its automatic layout does not precisely match the automatic detection that Unity provides. |
| 23:16 | <&Derakon> | In any case, I have no way to automatically populate TMP's knowledge of where different sprites are. |
| 23:17 | <&Derakon> | It has a custom "asset" (a.k.a. YAML file) that says "this sprite is at this position with this size, and I'm giving it this auto-generated name". |
| 23:17 | <&Derakon> | So AFAICT I need to write a program that will take the metadata output by Free Texture Packer, read the YAML used by TMP, do a fuzzy match on position and size, and assign the correct name to each sprite that TMP knows about. |
| 23:18 | <&Derakon> | All so that I can automatically generate text to say "Press [XBox 360 A button] to pick up a part." |
| 23:18 | <&Derakon> | There, I think that's it. |
| 23:34 | | Kindamoody is now known as Kindamoody[zZz] |
| --- Log closed Sat Nov 09 00:00:26 2019 |