#editorial | Logs for 2022-01-09
« return
[00:16:44] <Bytram> mysql> SELECT SUM(payment_net) AS Net, 100.0 * SUM(payment_net) / 7000.00 AS GoalPercent, MAX(ts), MAX(spid), NOW() FROM subscribe_payments WHERE ts > '2020-12-31' ;
[00:16:44] <Bytram> +---------+-------------+---------------------+-----------+---------------------+
[00:16:46] <Bytram> | Net | GoalPercent | MAX(ts) | MAX(spid) | NOW() |
[00:16:48] <Bytram> +---------+-------------+---------------------+-----------+---------------------+
[00:16:50] <Bytram> | 7052.12 | 100.7445714 | 2022-01-06 13:52:20 | 1752 | 2022-01-09 00:15:16 |
[00:16:52] <Bytram> +---------+-------------+---------------------+-----------+---------------------+
[00:16:54] <Bytram> 1 row in set (0.00 sec)
[00:16:56] <Bytram> mysql> SELECT SUM(payment_net) AS Net, 100.0 * SUM(payment_net) / 7000.00 AS GoalPercent, MAX(ts), MAX(spid), NOW() FROM subscribe_payments WHERE ts > '2020-12-31' AND ts < '2022-01-01' ;
[00:16:59] <Bytram> +---------+-------------+---------------------+-----------+---------------------+
[00:17:01] <Bytram> | Net | GoalPercent | MAX(ts) | MAX(spid) | NOW() |
[00:17:03] <Bytram> +---------+-------------+---------------------+-----------+---------------------+
[00:17:05] <Bytram> | 6738.27 | 96.2610000 | 2021-12-31 19:42:43 | 1747 | 2022-01-09 00:16:09 |
[00:17:07] <Bytram> +---------+-------------+---------------------+-----------+---------------------+
[00:17:09] <Bytram> 1 row in set (0.01 sec)
[00:17:11] <Bytram> mysql>
[00:26:49] <Bytram> Updating Beg-o-Meter
[00:27:46] <Bytram> mysql> SELECT SUM(payment_net) AS Net, 100.0 * SUM(payment_net) / 3500.00 AS GoalPercent, MAX(ts), MAX(spid), NOW() FROM subscribe_payments WHERE ts > '2022-01-01' ;
[00:27:46] <Bytram> +--------+-------------+---------------------+-----------+---------------------+
[00:27:48] <Bytram> | Net | GoalPercent | MAX(ts) | MAX(spid) | NOW() |
[00:27:50] <Bytram> +--------+-------------+---------------------+-----------+---------------------+
[00:27:52] <Bytram> | 313.85 | 8.9671429 | 2022-01-06 13:52:20 | 1752 | 2022-01-09 00:27:22 |
[00:27:54] <Bytram> +--------+-------------+---------------------+-----------+---------------------+
[00:27:56] <Bytram> 1 row in set (0.00 sec)
[00:27:58] <Bytram> mysql>
[00:37:25] <Bytram> Update completed!
[01:21:08] <Bytram> g'nigt
[12:32:08] <janrinok> =submit https://arstechnica.com
[12:32:12] <systemd> ✓ Sub-ccess! "03Facebook’s Data Center Plans Rile Residents in the Netherlands" (10p) -> https://soylentnews.org
[12:32:36] <janrinok> =submit https://arstechnica.com
[12:32:38] <systemd> ✓ Sub-ccess! "03Remarkably, NASA Has Completed Deployment of the Webb Space Telescope" (13p) -> https://soylentnews.org
[12:33:06] <janrinok> =submit https://arstechnica.com
[12:33:11] <systemd> ✓ Sub-ccess! "03Astronomers Discover a Strange Galaxy Without Dark Matter" (6p) -> https://soylentnews.org
[12:34:34] <janrinok> =submit https://arstechnica.com
[12:34:43] <systemd> ✓ Sub-ccess! "03Entangled Microwave Photons May Give 500x Boost to Radar" (16p) -> https://soylentnews.org
[12:39:06] <janrinok> =submit https://www.cnet.com
[12:39:07] <systemd> ✓ Sub-ccess! "03NASA's James Webb Space Telescope Successfully Unfolds its Massive Mirror" (9p) -> https://soylentnews.org
[12:39:51] <janrinok> =submit https://www.cnet.com
[12:39:53] <systemd> ✓ Sub-ccess! "03Facebook Parent Meta's Head of Communications Exits Company" (1p) -> https://soylentnews.org
[12:41:14] <janrinok> =submit https://www.cnet.com
[12:41:16] <systemd> ✓ Sub-ccess! "03Long-distance Wireless Charging Could Power Your Smart Home" (14p) -> https://soylentnews.org
[12:43:08] <janrinok> =submit https://edition.cnn.com
[12:43:11] <systemd> ✓ Sub-ccess! "03Dogs Know When You're Speaking a Different Language -- and Talking Nonsense" (6p) -> https://soylentnews.org
[12:44:55] <janrinok> =submit https://techxplore.com
[12:45:01] <systemd> ✓ Sub-ccess! "03A Silicon Photonic-electronic Neural Network That Could Enhance Submarine Transmission Systems" (29p) -> https://soylentnews.org
[12:45:35] <janrinok> =submit https://techxplore.com
[12:45:37] <systemd> ✓ Sub-ccess! "03Citizen Science, Supercomputers and AI" (33p) -> https://soylentnews.org
[12:46:36] <janrinok> =submit https://techxplore.com
[12:46:39] <systemd> ✓ Sub-ccess! "03Researchers Develop First Fully 3D-printed, Flexible OLED Display" (15p) -> https://soylentnews.org
[12:47:52] <janrinok> =submit https://www.engadget.com
[12:47:54] <systemd> ✓ Sub-ccess! "03Ford Tries to Fight F-150 Lightning Scalpers by Banning Resales" (3p) -> https://soylentnews.org
[12:48:19] <janrinok> =submit https://www.engadget.com
[12:48:21] <systemd> ✓ Sub-ccess! "03Google and Ford Want to Bring Small Radar to More Devices" (4p) -> https://soylentnews.org
[12:49:18] <janrinok> =submit https://www.engadget.com
[12:49:20] <systemd> ✓ Sub-ccess! "03PayPal Confirms It's Exploring the Launch of its Own Stablecoin" (3p) -> https://soylentnews.org
[14:24:25] * Bytram 2nds: ( https://soylentnews.org )
[14:30:44] * Bytram 2nds: ( https://soylentnews.org )
[14:31:36] <janrinok> thank you
[15:14:26] <Bytram> those 2 are done. gtg. Back in a few hours!
[15:14:58] <janrinok> np
[15:15:03] <janrinok> have a good one
[18:15:15] * Bytram 2nds: ( https://soylentnews.org )
[18:17:39] <janrinok> welcome back
[18:18:10] <Bytram> janrinok: ty! G'day!
[18:18:58] * Bytram mimics an Australian who does not know what time it is
[18:18:59] <janrinok> well, for me it is good evening and I have just enjoyed a nice steak - it is something I like very much but should only eat occasionally
[18:20:19] <Bytram> Understood! I enjoyed a couple hamburgers yesterday
[18:22:12] * Bytram looks at ( https://soylentnews.org )
[18:28:41] <janrinok> I think that my 'dog' story is a bit weak, but it made me think and smile, so I have kept it in the queue.
[18:33:40] <Bytram> done!
[18:33:59] <Bytram> *I* liked the dog story!
[18:34:52] <Bytram> laundry
[18:43:50] <Bytram> =yt see how researchers determined dogs can tell the difference between languages
[18:43:51] <systemd> https://youtube.com - Dogs can differentiate between languages, study shows (01:39; 2,605 views; 👍76 👎[hidden by butthurt Google employees])
[18:47:09] <janrinok> are you still in that Quantum story?
[18:48:34] <Bytram> no. See "done!" above ;)
[18:49:01] <janrinok> yeah but I was still getting the 100% matching warning so I thought I would check...
[18:49:57] <Bytram> BSTS (Better safe than sorry)!
[18:50:05] <Bytram> =)
[18:50:22] <Bytram> I am out of the story
[18:50:49] <janrinok> thx - just finished
[18:51:39] <janrinok> It is still showing you in there but I took you at your word!
[18:55:17] <Bytram> k
[18:55:28] <Bytram> teamwork++
[18:55:28] <Bender> karma - teamwork: 311
[18:56:26] * Bytram will likely be likely be updating the dog story
[18:56:58] <janrinok> ... now that you have watched the video!
[18:59:07] <Bytram> has to enable ~10 blocked links to see the original so I could compare it to what I found on YouTube
[19:10:46] <janrinok> I'm just learning about views in SQL
[20:34:36] <Bytram> Was a long time ago when I learned about (and last used) VIEWs
[20:36:38] <Bytram> ISTR they were neat abstractions; useful for partitioning what different users/groups could look at.
[20:53:54] * Bytram stuffed the story queue for a bit =)