Times are UTC Toggle Colours
10:45:51 *** snail_UES_ has quit IRC 11:43:23 <peter1138> Urgh, do I use multiple columns to store item attributes, or store attributes in a separate table... 11:44:21 <peter1138> Latter is no doubt more extensible, but also probably more of a pain to work with :/ 11:49:41 <_dp_> store in json field :p 11:51:29 <peter1138> Yeah, I also want to be able to filter on attributes, and doing that with a separate table means I need to get a join involved, more hassle... 11:52:14 <peter1138> Database design brain says to use separate table, code-wise tells me to KISS. 12:38:42 *** jottyfan has joined #openttd 12:55:46 *** Kitrana has joined #openttd 12:58:55 <andythenorth> I designed a database once 12:59:00 <andythenorth> turned out I did it wrong 13:00:50 *** WormnestAndroid has joined #openttd 13:01:25 *** Kitrana1 has quit IRC 13:12:04 <peter1138> Easy to do. 13:57:19 *** sla_ro|master has quit IRC 14:23:09 <DorpsGek> [OpenTTD/OpenTTD] Ufiby commented on discussion #8397: Daylength https://git.io/Jus1L 14:23:50 *** WormnestAndroid has quit IRC 14:24:04 *** WormnestAndroid has joined #openttd 14:24:41 <peter1138> Oh dear, 12 attributes so far. 14:24:45 <supermop_Home> drawing a little busstop has now got me down a rabbit hole of trying to make my bus sprites look better 14:25:23 <supermop_Home> probably should stop before adding roof greeble 14:25:42 <peter1138> Bad database design decisions are being made :/ 14:29:57 <peter1138> Adding 12 columns seems a bad idea. 14:30:13 <peter1138> Adding a bitfield column seems a bad idea. 14:30:42 <peter1138> Add a separate table seems a bad idea. 14:30:50 <peter1138> Sleeps seems a good idea. 14:30:57 <peter1138> Multiple. 14:37:21 *** nielsm has joined #openttd 14:50:33 <supermop_Home> hmm. the 'eyeshadow' the put around bus windows.. maybe i can use the crash recolor for that 14:58:55 <andythenorth> peter1138 can't you do some magic ORM thing? 14:59:03 <andythenorth> and let the magic sort it out? 15:19:47 *** glx has joined #openttd 15:19:47 *** ChanServ sets mode: +v glx 15:48:20 <peter1138> andythenorth, ORM doesn't define how its stored. 15:48:37 <andythenorth> BUT IT'S MAGIC! 15:49:13 <peter1138> Uh huh... 15:49:23 <peter1138> 12:59 < andythenorth> turned out I did it wrong 15:49:28 <peter1138> Sounds about right :-) 15:49:53 * andythenorth reads the sqlalchemy docs 15:50:14 <andythenorth> oh yeah it's not magic 15:50:21 <andythenorth> still have to declare tables and keys and crap 15:50:23 <andythenorth> how boring 15:50:52 <andythenorth> I did a mysql once 15:51:07 <andythenorth> the entire rest of my life has been objects 16:02:20 <_dp_> sqlalchemy can make db schema 16:02:32 <_dp_> but it's basically just a pythonized sql anyway 16:37:43 *** andythenorth has quit IRC 16:58:53 *** Wormnest has joined #openttd 17:09:32 *** Flygon has quit IRC 17:15:09 <TrueBrain> seems OpenTTD will enjoy a 20% cut in the AWS bill, simply because they made the first TB of bandwidth free .. lol 17:15:36 *** Gustavo6046 has joined #openttd 17:28:11 *** sla_ro|master has joined #openttd 17:30:29 *** andythenorth has joined #openttd 17:50:46 <_dp_> viewport seems to be doing some dangerous pointer manipulation with pointers to vector data for last_child and last_foundation_child 17:50:58 <_dp_> while changing those vectors 17:51:48 <_dp_> dunno if it can actually segfault atm in some scenario but this whole thing looks like a disaster waiting to happe