#Soylent | Logs for 2019-01-30
« return
[00:00:51] <Bytram> #g baryonic matter
[00:00:52] <MrPlow> https://en.wikipedia.org - "Nearly all matter that may be encountered or experienced in everyday life is baryonic matter, which includes atoms of any sort, ..."
[00:01:16] <Bytram> #g dark matter
[00:01:17] <MrPlow> https://en.wikipedia.org - "Dark matter is a hypothetical form of matter that is thought to account for approximately 85% of the matter in the universe, and about a quarter of its total energy ..."
[00:46:30] <Bender> [SoylentNews] - Novel Cancer Fighting Technique Shows Promise - http://sylnt.us - you-say-MuTaTo,-I-say-MuTayTo
[01:05:21] -!- arti|work has quit [Quit: My Mac has gone to sleep. ZZZzzz…]
[02:27:50] <Bender> [SoylentNews] - Intel Considers Building a New $11 Billion Fab in Israel - http://sylnt.us - fab-ulous
[03:54:44] <Bytram> #g eye saccade
[03:54:44] <MrPlow> https://en.wikipedia.org - "A saccade is a quick, simultaneous movement of both eyes between two or more phases of fixation in the same direction. In contrast, in smooth pursuit ..."
[04:05:37] <Bender> [SoylentNews] - ASML Plans to Ship 30 Extreme Ultraviolet Lithography (EUV) Scanners in 2019 - http://sylnt.us - it-would-be-sweet-if-they-could-make-Necco-wafers
[05:03:05] <Bytram> ~translate Aeropuerto
[05:07:37] -!- arti|work [arti|work!~textual@fhv-836-375-856-960.socal.res.rr.com] has joined #Soylent
[05:17:24] -!- arti|work has quit [Quit: My Mac has gone to sleep. ZZZzzz…]
[05:36:46] <Bender> [SoylentNews] - AMD Financial Results; Released from Wafer Supply Agreement with Global Foundries for 7nm and Beyond - http://sylnt.us - bet-AMD-is-feeling-a-bit-more-chipper
[06:19:15] -!- jman has quit [Ping timeout: 248 seconds]
[06:32:22] -!- jman [jman!~root@136.49.wnz.nq] has joined #Soylent
[07:16:31] <Bender> [SoylentNews] - Here's How to See Black Panther for Free During Black History Month - http://sylnt.us - Pink-Panther,-Black-Panther,-what's-next?-Fuchsia?
[08:47:40] <Bender> [SoylentNews] - Should an API be Copyrightable? - http://sylnt.us - chickens-coming-home-to-roost
[09:49:47] <FatPhil> Anyone got some SQL smarts? I'm feeling particularly derpy this morning...
[09:51:38] <FatPhil> I'd like to list all rows in a table that have non-unique values for one field.
[09:54:11] <FatPhil> doable with a nested query. fuck it, that works, no point fretting over finding another way.
[10:12:06] <FatPhil> OK, trickier - how do I find all values in a range that don't exist as field values?
[10:15:50] <Bender> [SoylentNews] - Fried Food Linked to Heightened Risk of Early Death Among Older US Women - http://sylnt.us - just-ask-the-colonel
[11:21:34] <TheMightyBuzzard> FatPhil, how you mean on that last one?
[11:29:49] <FatPhil> I have a table of <id,name>, and I know id is in 1..127, but I only have 94 rows - how do I find which ids are missing, apart from just looking down the list spotting gaps.
[11:47:00] <Bender> [SoylentNews] - Missing Galaxies? Now There’s Too Many! - http://sylnt.us - mini-halos-are-for-really-small-angels
[12:24:05] <Bytram> coffee++
[12:24:05] <Bender> karma - coffee: 4575
[12:25:58] <Bytram> FatPhil: depends on the DB engine, but there's usually a way to create a temporary table -- syntax completely eludes me atm -- but something like this, maybe?
[12:26:39] <Bytram> ultimate idea is to do a nested query
[12:28:28] <Bytram> select foo_col from foo_table, bar_table where foo_index not in bar_table.bar_col
[12:29:00] <Bytram> then the question becomes how can I populate bar_table.bar_col with values 1..127 ??
[12:59:38] <cmn32480> coffee++
[12:59:38] <Bender> karma - coffee: 4576
[13:12:31] <Bytram> indeed
[13:12:33] <Bytram> coffee++
[13:12:33] <Bender> karma - coffee: 4577
[13:16:07] <Bender> [SoylentNews] - Ultra-Slow Earthquake South of Istanbul - http://sylnt.us - if-an-earthquake-happens-and-no-one-feels-it
[13:34:31] <Bytram> =submit https://www.cnet.com Maybe they took a cue from <a href="https://www.youtube.com/watch?v=T3XwTq_BPKM">these guys</a>?
[13:34:33] <upstart> Submitting "iRobot's Terra cuts the grass while you relax"...
[13:34:55] <upstart> Sub-ccess! https://soylentnews.org
[13:42:25] <Bytram> time for me to get ready for my day... have the late shift tonight but got some errands to take care of before work. Hope you all have a great day!
[14:20:36] <FatPhil> Bytram: this just about does the job - it identifies the start of a run of missing ids.
[14:20:40] <FatPhil> select ext_id+1 from ext_styles where ext_id not in (select ext_id-1 from ext_styles) group by ext_id;
[14:57:24] <Bender> [SoylentNews] - PG&E Files for Bankruptcy. Here’s Why That Could Mean Bigger Electricity Bills - http://sylnt.us - using-larger-fonts
[15:08:05] * TheMightyBuzzard shurgs
[15:08:31] <TheMightyBuzzard> sounds like you got it before i got back to the computer
[15:17:34] -!- fyngyrz_ [fyngyrz_!~fyngyrz@66.171.jo.vll] has joined #Soylent
[15:17:34] -!- fungus has quit [Read error: Connection reset by peer]
[15:17:43] -!- fungus_ [fungus_!~ben@66.171.jo.vll] has joined #Soylent
[15:18:09] -!- fyngyrz has quit [Read error: Connection reset by peer]
[15:21:15] -!- fyngyrz_ has quit [Read error: Connection reset by peer]
[15:24:51] -!- fungus_ has quit [Ping timeout: 248 seconds]
[15:33:20] -!- fungus [fungus!~ben@66.171.jo.vll] has joined #Soylent
[15:38:42] -!- fyngyrz [fyngyrz!~fyngyrz@Soylent/Staff/Editor/fyngyrz] has joined #Soylent
[15:38:42] -!- mode/#Soylent [+v fyngyrz] by Aphrodite
[15:45:05] -!- arti|work [arti|work!~textual@kpku-40-80-465-497.west.biz.rr.com] has joined #Soylent
[16:28:35] <Bender> [SoylentNews] - Study Shows How LSD Alters Directed Connectivity Within Brain Pathways in Humans - http://sylnt.us - the-chicken-crossed-the-road-to-do-LSD
[17:57:43] <Bender> [SoylentNews] - Lowering Blood Pressure Reduces Risk of Cognitive Impairment - http://sylnt.us - intense-pressure-control
[19:03:07] -!- Sulla [Sulla!~8cd35204@140.211.gj.y] has joined #Soylent
[19:03:43] <Sulla> I have a question on what is/is not an acceptable submission to make for an article, rather than as a journal
[19:07:09] <Bender> [SoylentNews] - The 5G Protocol May Still Be Vulnerable to IMSI Catchers - http://sylnt.us - off-the-grid-is-the-only-way
[19:11:19] <Sulla> nevermind, will take my own advice and do as a journal
[19:30:10] -!- Sulla has quit [Quit: Web client closed]
[19:44:05] -!- Web_weasel [Web_weasel!~Stefan@haxp83-042-067-156.range88-597.btcentralplus.com] has joined #Soylent
[20:32:59] <FatPhil> this ain't doing my liver any good... open bar at a local brewpub celebrating their third birthday.
[20:33:14] <FatPhil> the 13% barley wine is superb....
[20:46:54] <Bender> [SoylentNews] - Vandals Damage Joshua Tree National Park During Government Shutdown - http://sylnt.us - blame-it-on-the-guy-with-a-blue-ox?
[22:16:35] <hopdevil> =submit https://mobile.reuters.com
[22:16:37] <upstart> Submitting "Special Report: Inside the UAE’s secret hacking team of U.S. mercenaries"...
[22:16:59] <hopdevil> i worked at the villa once..
[22:16:59] <upstart> Sub-ccess! https://soylentnews.org
[22:23:44] -!- Web_weasel has quit [Read error: Connection reset by peer]
[22:28:11] <Bender> [SoylentNews] - The Future of Space-Based Astronomy May Depend on Two Large Ground-Based Telescopes - http://sylnt.us - BIG-eyes-on-the-sky
[23:46:14] <Bender> [SoylentNews] - How Pervasive is Google in our Online Life? - http://sylnt.us - ubik-dept