| AbleBacon | mpDrive->getLoc().list[i]->stats.getVal()->val; sometimes i wish object oriented programming was never invented |
| GeDaMo | Only sometimes? :P |
| rindolf | AbleBacon: https://en.wikipedia.org/wiki/Law_of_Demeter |
| AbleBacon | oh my god this Law of Demeter is exactly the opposite of what we're doing |
| patientplatypus | does anyone know how to programmatically create a subtable in postgres? |
| rindolf | patientplatypus: not off hand |
| rindolf | patientplatypus: is there an sql syntax for that? |
| rindolf | AbleBacon: heh |
| GeDaMo | Would a subtable be like a view? |
| patientplatypus | errr.... |
| patientplatypus | i want to basically make a tree of tables |
| patientplatypus | like a json object |
| rindolf | patientplatypus: sound like it would stand against the normalisation rules |
| AbleBacon | what urge would possess you to make something as evil as a tree of tables? |
| AbleBacon | i understand the desire to do something to see if it can be done, but us mortals should not meddle in the workings of sorcery |
| patientplatypus | I'm making dnd in sql |
| GeDaMo | You might want to look up Common Table Expressions |
| rindolf | patientplatypus: the game? |
| patientplatypus | yeah |
| rindolf | patientplatypus: ah |
| patientplatypus | its a challenging problem |
| AbleBacon | LOL I'm picturing players taking their turns by submitting database queries with their requests |
| patientplatypus | but it would be useful to be able to use a tree structure |
| patientplatypus | I'm just making the game sheet |
| GeDaMo | There's at least one game like that |
| patientplatypus | if i get that working that would be a hat trick |
| rindolf | patientplatypus: you can encode trees using a table or two |
| patientplatypus | hmmm |
| AbleBacon | ADD "MOVE, 1" TO TABLE "MOVE_QUEUE_$PLAYER_NAME" |
| GeDaMo | AbleBacon: https://schemaverse.com/ |
| AbleBacon | i always feel like SQL people are screaming |
| patientplatypus | AHHHHH |
| AbleBacon | "Compete against other players using raw SQL commands to command your fleet." picard never had to do this |
| rindolf | patientplatypus: https://duckduckgo.com/?q=sql+tree&ia=qa |
| AbleBacon | "CAPTAIN, we've lost control of our primary command instruments! all commands to the ship will have to be issued via MICROSOFT sql queries" |
| AbleBacon | "... number one, give the order to abandon ship." |
| rindolf | AbleBacon: heh |
| patientplatypus | i may just use lots of tables without the tree - looks overly complicated |
| rindolf | patientplatypus: what? |
| GeDaMo | Why do you need trees of tables? |
| patientplatypus | oh well....i was thinking trees but it just looks like this would be sort of sucky |
| Myrl-saki | AbleBacon: I'd be screaming too if I had to write SQL for a living. |
| rindolf | patientplatypus: every purpose should have a single table |
| AbleBacon | "you adopted capslock for internet arguments... i was born with capslock" |
| GeDaMo | I remember computers before lowercase was invented :P |
| CashDash123 | How is a game like flappy bird ported to so many systems? |
| CashDash123 | I mean what makes it so easy to port? |
| CashDash123 | I mean it's been ported to the snes,gba,etc |
| AbleBacon | "captain, our systems are down! we can only match enemy ships for targeting using regex!" "... number one, issue the command ".*"" "but sir there are civi-" "i give up" |
| jrslepak | CashDash123: how complex is the game itself? |
| CashDash123 | no very jrslepak but how was the source code obtained or was it reverse engineered? |
| AbleBacon | CashDash123, the logic behind the game is very simple. if it was written in, say, C++ there's probably a C++ compiler for all of those systems. the only thing that would change really is how to display the graphics |
| AbleBacon | ah--birds were the key to the game's breakthrough into success i see |
| AbleBacon | unless the birds are just a RED HERRING! |
| AbleBacon | wait--is a herring a fish? |
| AbleBacon | or a bird? |
| wedr_ | Yeah, the Inverse Laws of Game Design, the shorter the jump distance, the more popular it gets via word of mouth |
| CashDash123 | AbleBacon, the addiction of beating a high score lead to its popularity |
| wedr_ | herring is a fish yes |
| wedr_ | a type of tuna |
| rindolf | AbleBacon: heh |
| wedr_ | salmon, not tuna |
| AbleBacon | then we need to invent "flappy herring" |
| AbleBacon | avoid sharks and other sea creatures idk |
| wedr_ | For a warning, I think it's called red harring. |
| wedr_ | Or haerring |
| AbleBacon | no, "red flag" is a warning. "red herring" is something that distracts you from the real thing |
| AbleBacon | shoot i don't know any more |
| wedr_ | red herring is a fish. |
| wedr_ | :/ |
| wedr_ | red Sirens, maybe? |
| jrslepak | it's also an idiom whose meaning is as AbleBacon described |
| wedr_ | In Norse mythology, Sirens are blue. |
| wedr_ | Or was it Greek? |
| wedr_ | So red Sirens is like the shiny Pokemon that distracts you in real life. |
| AbleBacon | all those poor kids getting hit by cars looking at their phones hunting for pokemon |
| wedr_ | True, Pokemon Go caused kids to get hit more often |
| jrslepak | the best solution is to play it on the bus :-P |
| AbleBacon | you don't want to go on the bus in America |
| AbleBacon | it is not a nice place |
| jrslepak | I was just there a few hours ago |
| GeDaMo | Does America only have one bus? :| |
| jrslepak | haha |
| jrslepak | it seems that way some evenings |
| CashDash123 | Leads me to question of how were games ported back in the day when you would have to downgrade a game to run on a system? |
| GeDaMo | A lot of hard work |
| CashDash123 | kinda like how lets say you have developed a dreamcast game while also having a Linux and windows port |
| CashDash123 | how does that work or even in reverse |
| GeDaMo | The game engine may have to be partly rewritten but the content (graphics etc.) should be reusable |
| CashDash123 | I mean I was thinking in a similar vain to Elysian Shadows which I'm pretty sure was designed around the dreamcast |
| CashDash123 | Which was tweaked most likely |
| CashDash123 | that or I may also get an Idea by reading quora |
| GeDaMo | Hmmm ... there's a #dreamcastdev channel |
| horny-sama | GeDaMo: I thought dreamcast was stuff before I was born. Surprised that people still dev for it |
| GeDaMo | There's a also an #elysian_shadows channel but only one person in it |
| GeDaMo | People still develop for a lot of old systems |
| CashDash123 | It's been chronicled on youtube since they were in high school in 2007 |
| CashDash123 | horny-sama, The Dreamcast due to it's discontinuation date makes it more common to have a system without protection from playing burned cdr's though it's bad for the laser |
| AbleBacon | "bad for the laser"--a likely story |
| patientplatypus | OK |
| patientplatypus | I'm confused |
| CashDash123 | AbleBacon, well it was designed for GD-ROM |
| AbleBacon | how could it damage the laser, though? |
| AbleBacon | lasers don't have any moving parts! |
| patientplatypus | so here's my question: if i have a table with a, b, c, d, e and I want each of those 5 letters to reference 5 different tables A, B, C, D, E how would I do this in postgresql? I can link tables by foreign/primary key but I cant see how they actually reference the value its linking to |
| patientplatypus | so |
| GeDaMo | Why do you have 5 different tables? |
| patientplatypus | in dnd you have paladin, fighter, etc. I want each of those items to link to a table that contains their statistics. So one table with class names, several linked tables with different statistics |
| grouse | GeDaMo, gotta have redundant table in case bobby drops them ;) |
| GeDaMo | Why can't this be in one table? |
| AbleBacon | all classes have strength, intelligence, etc. you should have one table for shared characteristics of all classes |
| patientplatypus | because each class is entirely different from another |
| AbleBacon | oh i see what you're saying |
| patientplatypus | well like wizard and fighter are so different that the tables need to be totally separate |
| patientplatypus | the way sql seems to want to work is that it just replicates tables in a single customer/many purchases type pattern |
| patientplatypus | does anyone have any suggestions? I'm totally lost and have been staring at this for a while |
| GeDaMo | I'm having difficulty visualising your DB structure |
| patientplatypus | so one table for classes (fighter, wizard, etc) |
| patientplatypus | each class will have its one table - fighter table, wizard table, paladin table |
| patientplatypus | with their own special statistics on each |
| GeDaMo | What fields do these tables have? |
| patientplatypus | each table will have entirely different fields (this is the problem- if they were similar it would not be an issue). so fighter has swords and fighting, and wizard would have spells etc |
| patientplatypus | i need what is essentially some sort of tree/json like hierarchy but in sql |
| patientplatypus | ltree seems very confusing |
| patientplatypus | what do you mean beaky? |
| GeDaMo | What do these tables represent? Are they like D&D character sheets? |
| horny-sama | CashDash123: gd-rom? |
| GeDaMo | Yeah, IRC will do that to you :| |
| CashDash123 | horny-sama, It was Sega's specialized cd I think the reason the burned cd exploit had to do something with an exploit with the mil-cd format |
| CashDash123 | though |
| horny-sama | Is it safe to assume that gd-rom is out of production |
| CashDash123 | https://en.wikipedia.org/wiki/GD-ROM horny-sama |
| horny-sama | CashDash123: did not say if it is out of production or not |
| CashDash123 | I don't think anyone can press there games to GD-Rom any more. |
| CashDash123 | I don't actually even own a dreamcast I just learned a bit about it |
| CashDash123 | long ago |
| horny-sama | good luck with whatever you are doing |
| horny-sama | sounds cool |
| CashDash123 | I figured it out hombre is pressed to mil-cd's |
| xeno | why would anyone wanna press things onto GD-Ros any more? |
| xeno | or why am I asking? |
| CashDash123 | don't quote me on that |
| CashDash123 | quote |
| horny-sama | xeno: I think CashDash123 is doing some dreamcast dev |
| CashDash123 | horny-sama, I'm not |
| horny-sama | CashDash123: so just quest for knowledge? |
| xeno | horny-sama: yeah, but why? |
| CashDash123 | It would just be a good place to get an Idea of how a game is ported |
| xeno | horny-sama: it's like the worst waste of time |
| horny-sama | xeno: different people have different hobby |
| xeno | yeah I know |
| AbleBacon | oh no... we're resorting to "scrum" meetings every morning. things must be getting really desperate. |
| CashDash123 | I mean how games are made for old consoles really is interesting |
| horny-sama | AbleBacon: ? |
| AbleBacon | at my work |
| AbleBacon | and they pay me and all i have to do is not die |
| GeDaMo | https://upload.wikimedia.org/wikipedia/commons/b/bd/Scrum-1.JPG |
| horny-sama | AbleBacon: in other words, you are their basic bitch |
| CashDash123 | horny-sama, You could say that,and I really wanted a dreamcast a long time ago |
| AbleBacon | it's not a giant wrestling orgy; it's a management technique |
| GeDaMo | Why not both? :D |
| horny-sama | AbleBacon: just hope you made your fuck you money soon so you can quit |
| horny-sama | lol |
| Rounin | AbleBacon: Your team just needs to move their organization to Sloth® so that all of their personal data can be sold to advertisers |
| Rounin | Then you'll be truly efficient |
| Rounin | And of course SourceHubâ„¢ to organize your Packer images |
