Log for #openttd on 29th December 2021:
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
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

Powered by YARRSTE version: svn-trunk