投稿時間:2021-04-16 06:25:55 RSSフィード2021-04-16 06:00 分まとめ(26件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
AWS	AWS	AWS for Aerospace and Satellite	https://www.youtube.com/watch?v=namlZpQ6W_k	AWS for Aerospace and SatelliteBe inspired Follow pioneer astronaut Peggy Whitson as she gains first hand insights from Major Gen Clint Crosier Ret on how AWS helps space customers take research and discovery to the next level Explore how NASA s Mars Mission Maxar Technologies Fireball International and Capella Space use AWS to help astronauts scientists and everyday heroes do their jobs better Understand how AWS is innovating for customers to make the future of space a reality Learn more AWS Aerospace and Satellite AWS Space Accelerator for startups AWS Ground Station AWS Public Sector Blog Subscribe More AWS videos More AWS events videos AWS AWSGroundStation​	2021-04-15 20:40:17
python	Pythonタグが付けられた新着投稿 - Qiita	京都の衛星画像を機械学習で解析した比較 - 平成6年Win3.1,Visual Basic2.0と令和3年Win10,Python3.8	https://qiita.com/dg4101/items/2968864714fe72b0d7bf	解析画像の比較クラスタではありませんが、令和年の解析では京都競馬場もはっきりと見分けることができます。	2021-04-16 05:35:39
js	JavaScriptタグが付けられた新着投稿 - Qiita	[JavaScript] オブジェクトの値で配列をソートする	https://qiita.com/nekohan/items/837efbff1c67d4cb4a41	JavaScriptオブジェクトの値で配列をソートするオブジェクトを格納した配列に対してオブジェクトの特定のプロパティを基準にソートする方法を紹介します。	2021-04-16 05:46:59
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	【Nuxt.js】動的ルーティングをgenerate時に反映させたい	https://teratail.com/questions/333499?rss=all	【Nuxtjs】動的ルーティングをgenerate時に反映させたい前提・実現したいことNuxtjsnbspnbspmicroCMSで、投稿したコンテンツをAPIで取得し、静的ページとして生成したいです。	2021-04-16 05:31:50
海外TECH	Ars Technica	US government strikes back at Kremlin for SolarWinds hack campaign	https://arstechnica.com/?p=1757269	firms	2021-04-15 20:17:39
海外TECH	DEV Community	Windows Users Warned: A new Windows Desktop Vulnerability found.	https://dev.to/manishfoodtechs/windows-users-warned-a-new-windows-desktop-vulnerability-found-2g3d	Windows Users Warned A new Windows Desktop Vulnerability found Desktop Window Manager s vulnerability Kaspersky researchers have found a zero day vulnerability CVE in a Microsoft Windows component called Desktop Window Manager DWM They said The vulnerability our advanced exploit prevention technology discovered is an elevation of privilege vulnerability That means a program can trick Desktop Window Manager into giving it access that it shouldn t have In this case the vulnerability allowed the attackers to execute arbitrary code on victims machines ーit essentially gave them full control over the computers CVE is an out of bounds OOB write vulnerability in dwmcore dll which is part of Desktop Window Manager dwm exe Due to the lack of bounds checking attackers are able to create a situation that allows them to write controlled data at a controlled offset using DirectComposition API How to get your pc safe Download this pc patch	2021-04-15 20:19:24
海外TECH	DEV Community	Reach Your Goals with the CodeNewbie Challenge (#CNC2021) 🎉	https://dev.to/devteam/reach-your-goals-with-the-codenewbie-challenge-cnc2021-mha	Reach Your Goals with the CodeNewbie Challenge CNC It s an exciting day for early career developers and people learning to code The CodeNewbie Community has announced the relaunch of their beloved CodeNewbie Challenge with updated resources and a stronger focus on community support If you ever find yourself needing help when it comes to Starting to Code Coding More Writing More or Getting a Job the CodeNewbie Challenge CNC is for you The five week challenge is conducted through routine emails that package up manageable weekly missions suggested reading material from other community members helpful worksheets and exercises lots of support and self care tips This potent combo will help you make real satisfying progress towards your goals Ready to challenge yourself to reach your biggest early career coding goals Sign up and view FAQs and additional info here We hope you ll join us ーyou ve got this ️	2021-04-15 20:14:51
海外TECH	DEV Community	What is SQL - Part 3	https://dev.to/marcegarba/what-is-sql-part-3-4ica	What is SQL Part Viewing updating and deleting data in tablesThis is part of a four part article which explains SQLPart Part Part Part Retrieving data using the SELECT clauseAs mentioned before relations tables sets are an unordered collection of rows or tuples Let s retrieve all the content in table products SELECT FROM products SELECT This means brings all the columns it could also be written as SELECT id nameFROM productsList of tables to operate on In this case we re talking about table productsHere s a possible result idnameSport shoes ASuit CSport watch BWhy possible Because there is no specific ordering of rows it all depends on how the DB system stores the rows the order in which rows were INSERTed and others OrderingIn order to establish a specific order we must use the ORDER clause SELECT id nameFROM productsORDER BY id idnameSport shoes ASport watch BSuit CIn reverse order by name SELECT id nameFROM productsORDER BY name DESC idnameSuit CSport watch BSport shoes AThe ORDER clause may list more than one column or expression in this simple case it doesn t make much sense FilteringLet s see how to limit the number of rows based on filtering conditions SELECT FROM productsWHERE id idnameSport watch BSELECT FROM productsWHERE name LIKE Sport ORDER BY id ASCidnameSport shoes ASport watch BHere a combination of WHERE and ORDER BY clauses WHERE name LIKE Sport means all rows where name starts with Sport The symbol maps from zero to any number of charactersIf the symbol were used that would mean exactly one character which would bring zero rows as ORDER BY id ASC ASC for ascending which is the default in the clause FunctionsSQL offers a number of standard functions and in fact there are two types of functions Common functions which apply to expressions in rowsAggregate and Window functions which apply to more than one row at a time Row functionsSELECT id id AS double id upper name AS upper nameFROM productsORDER BY id iddouble idupper nameSPORT SHOES ASPORT WATCH BSUIT CSeveral things to notice here Expressions like id and functions like upper name the AS key word is used to give names to the expressions if it were not used the calculated columns would have default names which vary depending on the DB system used Aggregate and window functionsSELECT COUNT AS countFROM products countSELECT id product COUNT AS number of sales SUM amount AS sum amountFROM salesGROUP BY productORDER BY product id productnumber of salessum amountHere aggregate functions COUNT SUM are usedNotice the resulting rows and content Aggregate functionsCOUNT counts the number of rows according to the GROUP BY criterionSUM amount calculates the sum of column amount according to the GROUP BY criterionAVG x calculates the averageMAX x MIN x obtains the maximum or minimum valueThere are other aggregate functions in standard SQLThe list of columns in the SELECT when using grouping functions should either Be the result of an aggregate expressionBe named in the GROUP BY clauseIf this is not the case the query should failIf it doesn t fail for some DB engines that s an issue since it s not easy to spot a failed SELECTPostgreSQL is very strict which is a great thing not so with other DB products Filtering grouped rulesInstead of using the WHERE clause for filtering on aggregated expressions HAVING has to be used SELECT id product COUNT AS number of sales SUM amount AS sum amountFROM salesGROUP BY productHAVING COUNT lt ORDER BY product id productnumber of salessum amount Combining results from more than one tableBy using the JOIN clause more than one table can be invoked in the SELECT statement Here is an example SELECT s id product p name COUNT AS number of sales SUM s amount AS sum amountFROM sales s JOIN products p ON s id product p idGROUP BY s id product p nameHAVING COUNT lt ORDER BY s id product A few changes to notice FROM JOIN ON FROM used to name one table JOIN names the second tableON establishes the way both tables are relatedTable name aliases sales s and products p this is not necessary but instead of typing sales id product product name and sales amount aliases help us to shorten the sentencesIf the column names are unique among the invoked tables there is no strict need to preface the column with the table or alias names although it s a good practice In fact if in the future one of the column names are repeated what worked so far will stop to do so as the DB engine wouldn t know what table the column referrer tothe GROUP BY clause needs to include p name otherwise an error should be triggered again not all DB engines do so Types of JOIN INNER JOIN Rows from both tables must be present the default LEFT JOIN Rows from the left side table must exist for columns in the right side table missing NULL values are usedRIGHT JOIN If rows from the left side table do not exist NULL values are used insteadCROSS JOIN Cartesian product from both tables are retrieved as long as the ON clause is fulfilledAs an example of a CROSS JOIN which is not much used look at this simple SELECT SELECT p id AS id product p name AS name product s id AS id seller s name AS name sellerFROM products p sellers sORDER BY id product id seller Simply naming the tables without any filtering condition is equivalent to a CROSS JOIN id productname productid sellername sellerSport shoes AJohn S Sport shoes ALuisa G Sport shoes AMary T Sport watch BJohn S Sport watch BLuisa G Sport watch BMary T Suit CJohn S Suit CLuisa G Suit CMary T This SELECT is just an example of a CROSS JOIN result Updating table contents with UPDATEThe UPDATE sentence is used for updating rowsAn example follows UPDATE sellersSET name María T WHERE id After this change look at the table contents SELECT FROM sellersORDER BY id idnameJohn S Luisa G María T Important points Limit the UPDATE with a WHERE otherwise the update will impact all rows in a table all of them in one transactionNot all updates are guaranteed to success for instance in the schema with all constraints in place this UPDATE will fail UPDATE sellersSET id WHERE id If you try this you ll see that it fails as there are relational integrity constraints which prevent tables sellers and products to update their PK if there is at least one row in the sales table that point to those values as is the case in the example hereSee the error with PostgreSQL ERROR update or delete on table sellers violates foreign key constraint sales seller fkey on table sales DETAIL Key id is still referenced from table sales See it with MariaDB ERROR Cannot delete or update a parent row a foreign key constraint fails course sales CONSTRAINT sales ibfk FOREIGN KEY id seller REFERENCES sellers id Deleting table contents with DELETEThe DELETE DML sentence is used to remove rows from tablesHere s an example DELETEFROM salesWHERE quantity BETWEEN AND After deleting these rows the contents of the table are SELECT id product id seller date quantity amountFROM salesORDER BY id product id seller id productid sellerdatequantityamount As is the case with the failed UPDATE and constraints are in place certain DELETE queries will failFor instance DELETEFROM salesWHERE id If the FOREIGN KEY constraints established in part for table sales had the ON UPDATE CASCADE ON DELETE CASCCADE neither the UPDATE nor the DELETE would fail For the UPDATE it would modify the values of the foreign keys in table salesFor the DELETE it would also remove rows from the sales table To be continued in Part	2021-04-15 20:01:44
海外TECH	Engadget	Disney's latest MCU series accounted for 495 million minutes of streaming in one week	https://www.engadget.com/the-falcon-and-the-winter-soldier-streaming-premiere-stats-203512547.html	disney	2021-04-15 20:35:12
海外TECH	CodeProject Latest Articles	Thread Synchronization Between Worker Threads	https://www.codeproject.com/Articles/5300017/Thread-Synchronization-Between-Worker-Threads	functions	2021-04-15 20:33:00
海外科学	NYT > Science	C.D.C. Panel Keeps Pause on Use of J&J Vaccine, Weighing Risks	https://www.nytimes.com/2021/04/14/health/cdc-johnson-vaccine-pause.html	C D C Panel Keeps Pause on Use of J amp J Vaccine Weighing RisksAn advisory committee debated the very few cases of a rare blood disorder and worried about the suspension s effect on global needs for a one shot easy to ship vaccine	2021-04-15 20:42:11
海外科学	NYT > Science	In Coinbase’s Rise, a Reminder: Cryptocurrencies Use Lots of Energy	https://www.nytimes.com/2021/04/14/climate/coinbase-cryptocurrency-energy.html	In Coinbase s Rise a Reminder Cryptocurrencies Use Lots of EnergyThe company s stock market arrival establishes Bitcoin and other digital currencies in the traditional financial landscape It also elevates a technology with astonishing environmental costs	2021-04-15 20:07:33
海外科学	NYT > Science	NFTs Are Shaking Up the Art World. Are They Also Fueling Climate Change?	https://www.nytimes.com/2021/04/13/climate/nft-climate-change.html	gases	2021-04-15 20:16:32
ニュース	BBC News - Home	Slavia Prague 0-4 Arsenal (1-5 on agg): Gunners reach Europa League semi-finals	https://www.bbc.co.uk/sport/football/56713057	Slavia Prague Arsenal on agg Gunners reach Europa League semi finalsArsenal impressively sweep aside Slavia Prague to reach the Europa League semi finals with a fine away victory in the second leg	2021-04-15 20:51:19
ビジネス	ダイヤモンド・オンライン - 新着記事	税務調査で狙われやすい「クラウド会計3つの落とし穴」、元国税専門官が解説 - 最強の節税	https://diamond.jp/articles/-/267943	国税専門官	2021-04-16 05:25:00
ビジネス	ダイヤモンド・オンライン - 新着記事	公示地価・路線価決定の「裏力学」、不動産鑑定士の忖度と属人性で決まっていた!? - 最強の節税	https://diamond.jp/articles/-/267942	不動産鑑定士	2021-04-16 05:20:00
ビジネス	ダイヤモンド・オンライン - 新着記事	「日本生命が地銀株売却」で噴き出すマグマ、地銀「信金くら替え」シナリオも - 橋本卓典の銀行革命	https://diamond.jp/articles/-/268353	中小企業	2021-04-16 05:15:00
ビジネス	ダイヤモンド・オンライン - 新着記事	爆売れ「節税用海外不動産」に国税庁がメス！過去取得分もアウトの規制が4月から開始 - 最強の節税	https://diamond.jp/articles/-/267941	不動産会社	2021-04-16 05:10:00
ビジネス	ダイヤモンド・オンライン - 新着記事	「コロナ赤字」の高島屋とJ.フロント、復活に向けた戦略を検証する - ＤＯＬ特別レポート	https://diamond.jp/articles/-/268576	感染拡大	2021-04-16 05:05:00
ビジネス	電通報 | 広告業界動向とマーケティングのコラム・ニュース	動物園はコロナ禍をどう乗り越え、どう進化するのか？	https://dentsu-ho.com/articles/7734	dentsu	2021-04-16 06:00:00
LifeHuck	ライフハッカー［日本版］	水泳中でも音楽が楽しめる骨伝導MP3プレイヤー【今日のライフハックツール】	https://www.lifehacker.jp/2021/04/lht_beker-bone-conduction-waterproof-mp3-player.html	beker	2021-04-16 06:00:00
北海道	北海道新聞	世界の記憶、各国承認制に　ユネスコが新制度	https://www.hokkaido-np.co.jp/article/533801/	世界の記憶	2021-04-16 05:12:00
北海道	北海道新聞	国民投票法改正　論点は依然残っている	https://www.hokkaido-np.co.jp/article/533768/	国民投票法	2021-04-16 05:05:00
ビジネス	東洋経済オンライン	アパレル｢デジタル人材強化｣の厳しい現実 ネット通販関連の求人需要は増え続けている | 専門店･ブランド･消費財 | 東洋経済オンライン	https://toyokeizai.net/articles/-/422449?utm_source=rss&utm_medium=http&utm_campaign=link_back	東洋経済オンライン	2021-04-16 05:40:00
ビジネス	東洋経済オンライン	東芝､車谷体制｢突然の終止符｣の先に待つ混沌 ｢モノ言う株主｣との長い対立の果てに | IT･電機･半導体･部品 | 東洋経済オンライン	https://toyokeizai.net/articles/-/423165?utm_source=rss&utm_medium=http&utm_campaign=link_back	最高経営責任者	2021-04-16 05:20:00
ビジネス	東洋経済オンライン	セブン&アイ､異例決算で見えた｢お荷物｣の明暗 中計の発表を再び延期､決算説明会はなし | 百貨店・量販店・総合スーパー | 東洋経済オンライン	https://toyokeizai.net/articles/-/423215?utm_source=rss&utm_medium=http&utm_campaign=link_back	東洋経済オンライン	2021-04-16 05:10:00