<- Previous Log | Select Different Log | Next Log -> |
Searching from 2023-09-04 00:00:00 to 2023-09-04 23:59:59.999999. Query completed in 1.78 seconds [2023-09-04 01:24:42] <armagetron-bridge> 12discord:Kows (.sly)| what the [2023-09-04 01:24:42] <armagetronbridge> 12discord:Kows (.sly)| what the [2023-09-04 01:40:23] <-- Armanelgtron has quit (No Ping reply in 180 seconds.) [2023-09-04 01:40:23] <-- Armanelgtron has quit (No Ping reply in 180 seconds.) [2023-09-04 01:43:57] --> Armanelgtron has joined the channel [2023-09-04 01:43:57] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC" [2023-09-04 01:43:57] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC [2023-09-04 01:43:59] -!- weber.oftc.net set mode #armagetron +nt [2023-09-04 01:43:59] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC [2023-09-04 01:44:36] --> Armanelgtron has joined the channel [2023-09-04 01:44:37] -!- molybdenum.libera.chat set mode #armagetron +nt [2023-09-04 01:44:37] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC [2023-09-04 02:37:34] <-- Armanelgtron has quit (No Ping reply in 180 seconds.) [2023-09-04 02:38:15] <-- Armanelgtron has quit (No Ping reply in 180 seconds.) [2023-09-04 02:40:53] --> Armanelgtron has joined the channel [2023-09-04 02:40:54] -!- molybdenum.libera.chat set mode #armagetron +nt [2023-09-04 02:40:54] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC [2023-09-04 02:41:51] --> Armanelgtron has joined the channel [2023-09-04 02:41:51] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC" [2023-09-04 02:41:51] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC [2023-09-04 02:41:52] -!- weber.oftc.net set mode #armagetron +nt [2023-09-04 02:41:52] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC [2023-09-04 03:03:28] <Lucifer_arma> Postgres vs MySQL: With my cluster running MySQL, I was looking at having to buy some serious dedicated hardware just for the database so it could support two workers (raspberry pis running up to 8 total jobs) [2023-09-04 03:03:29] <armagetronbridge> 10irc:Lucifer_arma| Postgres vs MySQL: With my cluster running MySQL, I was looking at having to buy some serious dedicated hardware just for the database so it could support two workers (raspberry pis running up to 8 total jobs) [2023-09-04 03:03:42] <Lucifer_arma> with postgres, right now, I don't even need the cluster. [2023-09-04 03:03:43] <armagetronbridge> 10irc:Lucifer_arma| with postgres, right now, I don't even need the cluster. [2023-09-04 03:04:56] <Lucifer_arma> actually, I take that back. I need to write more UI so I can find out how many jobs are actually being queued up. [2023-09-04 03:04:56] <armagetronbridge> 10irc:Lucifer_arma| actually, I take that back. I need to write more UI so I can find out how many jobs are actually being queued up. [2023-09-04 03:05:14] <Lucifer_arma> but postgres is outperforming MySQL right now by several orders of magnitude :) [2023-09-04 03:05:14] <armagetronbridge> 10irc:Lucifer_arma| but postgres is outperforming MySQL right now by several orders of magnitude :) [2023-09-04 03:07:46] <Lucifer_arma> also, if you're using python's multiprocessing module, definitely don't use fork, use spawn. That's solved *so* many problems for me. I realize it's slower than fork, but at a certain point, the reliability is worth the price [2023-09-04 03:07:46] <armagetronbridge> 10irc:Lucifer_arma| also, if you're using python's multiprocessing module, definitely don't use fork, use spawn. That's solved *so* many problems for me. I realize it's slower than fork, but at a certain point, the reliability is worth the price [2023-09-04 05:49:39] --> monr0e has joined the channel [2023-09-04 06:08:04] <armagetron-bridge> 08discord:delinquent| Postgres is awesome. Gotta remember htat it folds down, not up, which has caught me out a few times when writing in table names. Other than that I think it's largely SQL compliant. Apparently upper-case table names are actually against postgres' best practice anyway soooooo [2023-09-04 06:08:04] <armagetronbridge> 08discord:delinquent| Postgres is awesome. Gotta remember htat it folds down, not up, which has caught me out a few times when writing in table names. Other than that I think it's largely SQL compliant. Apparently upper-case table names are actually against postgres' best practice anyway soooooo [2023-09-04 06:42:59] --> monr0e_ has joined the channel [2023-09-04 06:45:43] <-- monr0e has quit (Ping timeout: 240 seconds) [2023-09-04 06:46:30] -!- monr0e_ changed nick to monr0e [2023-09-04 09:55:27] <-- Armanelgtron has quit (No Ping reply in 180 seconds.) [2023-09-04 09:57:38] <-- Armanelgtron has quit (No Ping reply in 180 seconds.) [2023-09-04 09:59:34] --> Armanelgtron has joined the channel [2023-09-04 09:59:35] -!- molybdenum.libera.chat set mode #armagetron +nt [2023-09-04 09:59:35] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC [2023-09-04 10:00:11] --> Armanelgtron has joined the channel [2023-09-04 10:00:11] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC" [2023-09-04 10:00:11] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC [2023-09-04 10:00:13] -!- weber.oftc.net set mode #armagetron +nt [2023-09-04 10:00:13] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC [2023-09-04 10:16:19] <-- Armanelgtron has quit (No Ping reply in 180 seconds.) [2023-09-04 10:18:09] <-- Armanelgtron has quit (No Ping reply in 180 seconds.) [2023-09-04 10:20:07] --> Armanelgtron has joined the channel [2023-09-04 10:20:07] -!- silver.libera.chat set mode #armagetron +nt [2023-09-04 10:20:07] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC [2023-09-04 10:20:57] --> Armanelgtron has joined the channel [2023-09-04 10:20:57] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC" [2023-09-04 10:20:57] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC [2023-09-04 10:20:59] -!- weber.oftc.net set mode #armagetron +nt [2023-09-04 10:20:59] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC [2023-09-04 10:49:04] <-- Armanelgtron has quit (No Ping reply in 180 seconds.) [2023-09-04 10:52:10] <-- Armanelgtron has quit (No Ping reply in 240 seconds.) [2023-09-04 10:53:24] --> Armanelgtron has joined the channel [2023-09-04 10:53:24] -!- Topic for #armagetron is "Armagetron Advanced | http://www.armagetronad.org/ | Welcome to IRC" [2023-09-04 10:53:24] -!- Topic set by ChanServ!services@services.oftc.net on 2022-12-21 00:36:08 UTC [2023-09-04 10:53:25] -!- weber.oftc.net set mode #armagetron +nt [2023-09-04 10:53:25] -!- Channel #armagetron created on 2021-04-20 19:56:37 UTC [2023-09-04 10:53:27] --> Armanelgtron has joined the channel [2023-09-04 10:53:29] -!- molybdenum.libera.chat set mode #armagetron +nt [2023-09-04 10:53:29] -!- Channel #armagetron created on 2021-05-20 17:23:14 UTC [2023-09-04 19:08:11] <Lucifer_arma> I always use lowercase tablenames anyway, and all the capital letters in other databases annoy me :) [2023-09-04 19:08:11] <armagetronbridge> 10irc:Lucifer_arma| I always use lowercase tablenames anyway, and all the capital letters in other databases annoy me :) [2023-09-04 19:09:03] <Lucifer_arma> the postgres database driver for python also provides a way to batch execute updates. MySQL only offers batch inserts. [2023-09-04 19:09:03] <armagetronbridge> 10irc:Lucifer_arma| the postgres database driver for python also provides a way to batch execute updates. MySQL only offers batch inserts. [2023-09-04 19:10:28] <Lucifer_arma> it's time to get the cluster back up at full strength, but I need to write a couple of jobs real quick to add to it, because I'm close... [2023-09-04 19:10:28] <armagetronbridge> 10irc:Lucifer_arma| it's time to get the cluster back up at full strength, but I need to write a couple of jobs real quick to add to it, because I'm close... [2023-09-04 19:17:43] <-- monr0e has quit (Ping timeout: 240 seconds)View entire month