| --- Log opened Sun Jun 14 00:00:35 2015 |
| 00:07 | | macdjord is now known as macdjord|fude |
| 01:43 | | Alek [omegaboot@Nightstar-03ja8q.il.comcast.net] has quit [Ping timeout: 121 seconds] |
| 02:03 | | simon_ [simon@Nightstar-sjjvb1.dk] has joined #code |
| 02:04 | < simon_> | so, I should of course have looked for JS solutions to visual diffs rather than C# ones. the MediaWiki algorithm is available as a stand-alone script and is pretty damn cool: http://cacycle.altervista.org/wikEd-diff-tool.html |
| 02:38 | <~Vornicus> | yeah, anything where you've got to do formatting and stuff of anything vaguely textlike, html/css/js are your go-tos |
| 02:44 | | Alek [omegaboot@Nightstar-03ja8q.il.comcast.net] has joined #code |
| 02:44 | | mode/#code [+o Alek] by ChanServ |
| 02:49 | <@[R]> | simon_: <3 * 10000000000 |
| 02:49 | <@[R]> | I've been freaking looking for a JS-based diff forever. |
| 02:53 | <@macdjord|fude> | [R]: True, for any 32 bit intger. |
| 03:00 | | macdjord|fude is now known as macdjord |
| 03:15 | | macdjord is now known as macdjord|GreyGoo |
| 03:18 | | Alek [omegaboot@Nightstar-03ja8q.il.comcast.net] has quit [[NS] Quit: *twitches*] |
| 03:32 | | Alek [omegaboot@Nightstar-03ja8q.il.comcast.net] has joined #code |
| 03:32 | | mode/#code [+o Alek] by ChanServ |
| 04:05 | <&Derakon> | Neat little video about a neural net trained to play a level of Super Mario World. https://www.youtube.com/watch?v=qv6UVOQ0F44 |
| 04:08 | <&Derakon> | (Note the approach used is only applicable to that specific level and basically consists of rules like "if there is a block on this part of the screen, press jump") |
| 04:26 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [Connection closed] |
| 04:55 | <@celticminstrel> | Oh huh. I just discovered that HTTP response headers announce your Apache/PHP/Python versions. |
| 04:59 | | Derakon is now known as Derakon[AFK] |
| 04:59 | | catadroid` [catalyst@Nightstar-pcp6ei.dab.02.net] has joined #code |
| 04:59 | | catadroid [catalyst@Nightstar-sg8r5k.dab.02.net] has quit [Connection closed] |
| 05:50 | < simon_> | Derakon[AFK], there are also some pretty cool code execution exploits made in mario: https://www.youtube.com/watch?v=OPcV9uIY5i4 , https://www.youtube.com/watch?v=vAHXK2wut_I |
| 05:58 | | catadroid [catalyst@Nightstar-3tno8d.dab.02.net] has joined #code |
| 06:01 | | catadroid` [catalyst@Nightstar-pcp6ei.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 06:08 | | Checkmate [Z@Nightstar-pdi1tp.customer.tdc.net] has quit [Ping timeout: 121 seconds] |
| 07:30 | | Kindamoody[zZz] is now known as Kindamoody |
| 07:51 | | celticminstrel [celticminst@Nightstar-uelp1m.dsl.bell.ca] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!] |
| 08:33 | | Vash [Vash@Nightstar-uhn82m.ct.comcast.net] has quit [Connection closed] |
| 09:03 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Connection closed] |
| 09:45 | | kourbou [kourbou@Nightstar-deqg8j.fbx.proxad.net] has joined #code |
| 09:47 | | Meatyhandbag [sebastianfe@Nightstar-krd.cme.73.97.IP] has joined #code |
| 10:41 | | macdjord|GreyGoo is now known as macdjord |
| 10:48 | | macdjord is now known as macdjord|slep |
| 11:26 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
| 11:33 | | VirusJTG_ [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
| 11:33 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [Connection closed] |
| 11:37 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
| 11:37 | | VirusJTG_ [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [Connection closed] |
| 11:38 | < VirusJTG> | well shit, my mouse just died |
| 11:38 | < catadroid> | :< |
| 11:39 | < VirusJTG> | well, I was going to go out for breakfast any way. looks like I'll pick up a new mouse while out |
| 11:39 | < catadroid> | I seeeeee |
| 11:39 | < catadroid> | I'm going to take a shower |
| 11:40 | < catadroid> | don't worry I'll bring it back after |
| 11:40 | < VirusJTG> | ahh how kind of you |
| 11:43 | < catadroid> | no worries |
| 11:56 | | Kindamoody is now known as Kindamoody|afk |
| 12:00 | <&ToxicFrog> | Shower sounds like a good idea. |
| 12:00 | | * ToxicFrog follows suit |
| 12:02 | | kourbou is now known as kourbou|foodz |
| 12:22 | | * catadroid follows ToxicFrog |
| 12:28 | | catadroid` [catalyst@Nightstar-iop5tl.dab.02.net] has joined #code |
| 12:31 | | catadroid [catalyst@Nightstar-3tno8d.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 12:33 | | catadroid` [catalyst@Nightstar-iop5tl.dab.02.net] has quit [[NS] Quit: Bye] |
| 12:33 | | catadroid [catalyst@Nightstar-iop5tl.dab.02.net] has joined #code |
| 12:33 | | catadroid` [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has joined #code |
| 12:33 | | catadroid` [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has quit [Connection closed] |
| 12:37 | | * ToxicFrog invites catadroid into the shower with him :D |
| 12:37 | | catadroid [catalyst@Nightstar-iop5tl.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 12:38 | | catadroid [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has joined #code |
| 12:39 | | kourbou|foodz is now known as kourbou |
| 15:09 | | Checkmate [Z@Nightstar-484uip.cust.comxnet.dk] has joined #code |
| 15:09 | | mode/#code [+o Checkmate] by ChanServ |
| 15:12 | | kourbou [kourbou@Nightstar-deqg8j.fbx.proxad.net] has quit [Connection closed] |
| 15:45 | | catalyst [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has joined #code |
| 15:48 | | JustLurk [justbob@ServerAdministrator.Nightstar.Net] has joined #code |
| 15:48 | | JustBob [justbob@Nightstar.Customer.Dissatisfaction.Administrator] has quit [NickServ (RECOVER command used by JustLurk)] |
| 15:48 | | JustLurk is now known as JustBob |
| 15:48 | | mode/#code [+o JustBob] by ChanServ |
| 15:53 | | celticminstrel [celticminst@Nightstar-uelp1m.dsl.bell.ca] has joined #code |
| 15:53 | | mode/#code [+o celticminstrel] by ChanServ |
| 17:44 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 17:44 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 18:14 | | catalyst [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has quit [[NS] Quit: ] |
| 18:23 | | catadroid` [catalyst@Nightstar-ms8eh5.dab.02.net] has joined #code |
| 18:23 | | catadroid [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has quit [Connection closed] |
| 18:23 | | catadroid [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has joined #code |
| 18:26 | | catadroid`` [catalyst@Nightstar-9mv54c.dab.02.net] has joined #code |
| 18:27 | | catadroid` [catalyst@Nightstar-ms8eh5.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 18:29 | | catadroid [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has quit [Ping timeout: 121 seconds] |
| 18:36 | | ErikMesoy [Erik@Nightstar-s1tt9g.80-203-16.nextgentel.com] has quit [[NS] Quit: Leaving.] |
| 18:49 | | kourbou_ [kourbou@Nightstar-deqg8j.fbx.proxad.net] has joined #code |
| 18:49 | | kourbou_ is now known as kourbou |
| 18:54 | < Turaiel> | So I'm modifying a database schema that I created a while back and I'm trying to remember why I included a content hash column for images that are uploaded. Would anyone know why I might've done that? :P |
| 18:55 | <@Tamber> | De-duplication of images, I'd presume. |
| 18:55 | < catadroid``> | flagrent disregard for content type? |
| 18:55 | | catadroid`` is now known as catadroid |
| 18:56 | < Turaiel> | I guess it could be for de-dupe, but the use case probably wouldn't have any duplicates |
| 19:10 | <@gnolam> | URL generation? |
| 19:11 | | ErikMesoy [Erik@Nightstar-ki97ss.customer.cdi.no] has joined #code |
| 19:11 | < Turaiel> | Probably not. It very well may have been de-duplication |
| 19:30 | | Vash [Vash@Nightstar-uhn82m.ct.comcast.net] has joined #code |
| 19:30 | | mode/#code [+o Vash] by ChanServ |
| 19:39 | | Meatyhandbag [sebastianfe@Nightstar-krd.cme.73.97.IP] has quit [Connection closed] |
| 19:51 | < ErikMesoy> | In the process of moving house I have come across a book on object-oriented software design from 1990, talking about "The Software Crisis" in the opening. |
| 19:51 | < ErikMesoy> | It seems at once dated and timeless. |
| 19:52 | < ErikMesoy> | The crisis being that software has to do big important complex tasks and people have trouble writing such software well. |
| 19:52 | < ErikMesoy> | This has pretty much become the permanent state of affairs, hasn't it :/ |
| 19:52 | | Derakon[AFK] is now known as Derakon |
| 19:53 | <@Tamber> | Pretty much. |
| 19:54 | | Meatyhandbag [sebastianfe@Nightstar-s1n.1br.73.97.IP] has joined #code |
| 20:30 | | * abudhabi finds that his laptop can't handle too many Google web apps running simultaneously. |
| 20:30 | < abudhabi> | I had like Gmail, Docs and two Maps up, and it choked. |
| 20:37 | < Meatyhandbag> | sorry guys |
| 20:37 | < Meatyhandbag> | fell asleep at my computer desk |
| 20:44 | | kourbou [kourbou@Nightstar-deqg8j.fbx.proxad.net] has quit [[NS] Quit: Tip about keeping secrets: It's easier if you don't know them.] |
| 20:52 | | Kindamoody|afk is now known as Kindamoody |
| 21:05 | | Checkmate [Z@Nightstar-484uip.cust.comxnet.dk] has quit [Ping timeout: 121 seconds] |
| 21:52 | | catadroid` [catalyst@Nightstar-9mv54c.dab.02.net] has joined #code |
| 21:52 | | catadroid [catalyst@Nightstar-9mv54c.dab.02.net] has quit [A TLS packet with unexpected length was received.] |
| 22:12 | | Checkmate [Z@Nightstar-pdi1tp.customer.tdc.net] has joined #code |
| 22:12 | | mode/#code [+o Checkmate] by ChanServ |
| 22:48 | | Kindamoody is now known as Kindamoody[zZz] |
| 22:54 | < Turaiel> | Anyone care to review a database schema for me? |
| 22:57 | <@macdjord|slep> | Turaiel: I'm not an expert, but I can give it a gander, if you'd like. |
| 22:58 | < Turaiel> | Cool. http://i.imgur.com/gTL01TT.png |
| 22:58 | < Turaiel> | I mostly just want to know if I've done something dumb |
| 23:00 | <@macdjord|slep> | Turaiel: Well, you've remembered to give everything a numeric ID field named 'ID'; that's a good start. |
| 23:01 | <@macdjord|slep> | One thing I'd suggest: it's my convention that a foreign key is /always/ named 'tablename_id', unless you have multiple keys to the same table and need to distinguish them. |
| 23:03 | <@macdjord|slep> | For instance, the item-artist table: it's got a foreign key into artists, and another into... which tabke? |
| 23:03 | | macdjord|slep is now known as macdjord |
| 23:05 | | * macdjord prod Turaiel |
| 23:05 | < Turaiel> | Whoops |
| 23:05 | < Turaiel> | Hi |
| 23:06 | < Turaiel> | item_id goes to both comics and fanart though |
| 23:07 | <@macdjord> | Okay, don't do that. |
| 23:07 | <@macdjord> | Have two tables, one comic-artist, and the other fanart-atrist. |
| 23:11 | <@macdjord> | ... can you explain what you're trying to record here? |
| 23:16 | | * macdjord prod Turaiel again |
| 23:17 | < Turaiel> | I'm sorry, someone distracted me >.< |
| 23:17 | < Turaiel> | Images is also like that |
| 23:18 | < Turaiel> | It's a webcomic website DB |
| 23:18 | <@macdjord> | Yeah, explain what data you are trying to represent here? |
| 23:18 | <@macdjord> | Okay... |
| 23:19 | < Turaiel> | Let me explain the purpose of each table |
| 23:22 | < Turaiel> | Users is obvious. Fanart is for the associated section of the website. I guess it could be merged into comics with a type flag. |
| 23:23 | < Turaiel> | Images is shared between fanart and comics. It's contains metadata about images associated with each item. This is carried over from a previous design where comics and fanart could have multiple images associated with them. |
| 23:23 | < Turaiel> | Arcs are chapters in the comic. Simple. |
| 23:23 | <@macdjord> | Hang on - artists are comic artists, user are regular-joe readers, right? |
| 23:23 | < Turaiel> | Users are admin(s) |
| 23:23 | <@macdjord> | Ah. |
| 23:23 | < Turaiel> | The public can't log in |
| 23:24 | <@macdjord> | So, what's the commection between comic and user represent, then? |
| 23:24 | < Turaiel> | Users post content |
| 23:25 | < Turaiel> | Each piece of content is associated with the user that posted it. This is also designed to be expanded into a general image search system. |
| 23:26 | <@macdjord> | So, why a seperate artist and user table? Are you expecting things to be poseted by people that are not the artist? |
| 23:27 | < Turaiel> | Like I said, it's designed to be expanded later |
| 23:28 | < Turaiel> | For example, I could go in there and post something at some point without having to log in as the artist's user account |
| 23:28 | < Turaiel> | I'm mostly trying to prevent it from causing problems by being too specifically designed later |
| 23:28 | < Turaiel> | I don't want to have to go back and modify all the existing records because of a table modification |
| 23:32 | <@macdjord> | What's the relation between fanart and image? One-to-one, or one-to-many? |
| 23:33 | <@macdjord> | And between images and comics? |
| 23:34 | < Turaiel> | One-to-many for both, many on the image side |
| 23:34 | < Turaiel> | The crows feet indicate that |
| 23:35 | <@macdjord> | If a comic consis of multiple images, I would expect them to be a sequence, no? |
| 23:36 | < Turaiel> | Yeah, though I think it can be one-to-one now due to the design change |
| 23:36 | < Turaiel> | comics now have a parent column which indicates it is part of a set |
| 23:37 | <@macdjord> | Okay, so: break up item-artist into two seperate tables, fanart-artist and comic-artist. |
| 23:38 | <@macdjord> | Give images two fields, fanart_id and comic_id, and add a constraint that only one of them can be non-null. |
| 23:39 | < Turaiel> | I'm not sure if that's necessary |
| 23:40 | <@macdjord> | You have an image, with item_id = 61232. Does that mean comic #61232, or fanart #61232? |
| 23:40 | < Turaiel> | That is a valid point |
| 23:45 | <@macdjord> | If you for one image per comic/fanart, make both those fields unique. If you allow multiple ones, then also add a field 'int index', and add unique(fanart_id, index) and unique(comic_id, index). Also add a constraint that if index != 0, then (fanart_id, index-1) or (comic_id, index - 1) must exist. |
| 23:49 | < Turaiel> | Hm. I remember learning about constraints but I never really thought they'd be necessary in this schema. Outside of unique, that is. |
| 23:51 | | Alek [omegaboot@Nightstar-03ja8q.il.comcast.net] has quit [Ping timeout: 121 seconds] |
| --- Log closed Mon Jun 15 00:00:49 2015 |