投稿時間:2021-10-05 06:29:33 RSSフィード2021-10-05 06:00 分まとめ(33件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
TECH	Engadget Japanese	2011年10月5日、アップルの共同設立者スティーブ・ジョブズ氏が亡くなりました：今日は何の日？	https://japanese.engadget.com/today-203005471.html	逝去	2021-10-04 20:30:05
IT	ITmedia 総合記事一覧	[ITmedia News] FacebookのInstagramを含むすべてのサービスに障害　社内でのBGP更新が原因と専門家	https://www.itmedia.co.jp/news/articles/2110/05/news074.html	ITmediaNewsFacebookのInstagramを含むすべてのサービスに障害社内でのBGP更新が原因と専門家Facebookの一連のサービスが日本時間の月日午前時分ごろからグローバルでダウンしている。	2021-10-05 05:50:00
IT	ITmedia 総合記事一覧	[ITmedia News] Apple、「Apple Watch Series 7」の予約を10月8日21時から開始　発売は10月15日	https://www.itmedia.co.jp/news/articles/2110/05/news072.html	applewatchseries	2021-10-05 05:18:00
AWS	AWS Partner Network (APN) Blog	Build, Test, and Deploy a Containerized Application on AWS Graviton2 Using CircleCI	https://aws.amazon.com/blogs/apn/build-test-and-deploy-a-containerized-application-on-aws-graviton2-using-circleci/	Build Test and Deploy a Containerized Application on AWS Graviton Using CircleCIOrganizations turn to Arm based servers when looking for a cost effective way to improve performance for their common workloads like microservices application servers and databases To give developers the option to run code on Arm based instances in their CI CD pipelines without maintaining infrastructure on their own CircleCI added new Arm based resource classes based on Graviton as an option for all users	2021-10-04 20:20:09
AWS	AWS	Cerner: Enabling early disease prediction with AWS Machine Learning | Amazon Web Services	https://www.youtube.com/watch?v=4wtleqKwTX8	Cerner Enabling early disease prediction with AWS Machine Learning Amazon Web ServicesAWS machine learning empowers healthcare and life science organizations to make sense of their health data with purpose built health AI services and the most comprehensive machine learning platform See how Cerner is using AWS machine learning and Amazon SageMaker to predict disease conditions and identify those at risk of having an opioid use disorder to better diagnose and treat patients Learn more Amazon HealthLake Machine learning for healthcare and life sciences Subscribe More AWS videos More AWS events videos ABOUT AWSAmazon Web Services AWS is the world s most comprehensive and broadly adopted cloud platform offering over fully featured services from data centers globally Millions of customers ーincluding the fastest growing startups largest enterprises and leading government agencies ーare using AWS to lower costs become more agile and innovate faster AWS AmazonWebServices CloudComputing MachineLearning	2021-10-04 20:17:12
python	Pythonタグが付けられた新着投稿 - Qiita	Geopyで2点間の距離を測定する方法	https://qiita.com/TaiyoF/items/40b34c2d13b1d22a2beb	特定の緯度経度同士の距離を出す方法は巷にあふれているのですが、複数の位置情報データを利用した算出方法を見つけられなかったため、記事を書くことにしました。	2021-10-05 05:53:24
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	Javascript mousemoveの座標が別のイベントで元に戻ってしまう。	https://teratail.com/questions/362808?rss=all	Javascriptmousemoveの座標が別のイベントで元に戻ってしまう。	2021-10-05 05:37:44
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	C言語で、bit全探索のシフト部分がうまく書けません。	https://teratail.com/questions/362807?rss=all	の部分をコメントアウトすると、ABCDの文字列が列挙されますので、シフト演算の作法が間違っているのではないかと思うのですが。	2021-10-05 05:21:29
海外TECH	Ars Technica	Facebook, Instagram, WhatsApp, and Oculus are down. Here’s what we know [Updated]	https://arstechnica.com/?p=1800566	route	2021-10-04 20:22:55
海外TECH	Ars Technica	Windows 11: The Ars Technica review	https://arstechnica.com/?p=1798423	requirements	2021-10-04 20:00:34
海外TECH	DEV Community	Facebook is down, discuss...	https://dev.to/ben/facebook-is-down-discuss-2elo	Facebook is down discuss I m curious about what comes to mind Whether it is software related or otherwise what does today s outage evoke for you What s the worst case scenario for Facebook	2021-10-04 20:57:23
海外TECH	DEV Community	💆‍♀️ 💆‍♂️ PostgreSQL query optimization for Gophers: It's much easier than it sounds!	https://dev.to/koddr/postgresql-query-optimization-for-gophers-it-s-much-easier-than-it-sounds-24nf	‍ ️‍ ️PostgreSQL query optimization for Gophers It x s much easier than it sounds IntroductionHello amazing DEV people Today I will show you a wonderful query optimization technique for Postgres that I often use myself This approach to optimization can save you from a long and tedious transfer of your project to another technology stack such as GraphQL Intrigued Here we go Table of contentsProblem statementA quick solution to the problemOptimize this Problem statementWe ll take query optimization as an example of a simple task for any developer Let s imagine that we have the task of creating a new endpoint for the REST API of our project which should return Data on the requested project by its alias Array of all tasks that relate to the requested project in descending order by creation date Number of tasks as a separate response attribute Here you can immediately see one quick solution ーmake several queries for each of the models in the database for the project and for related tasks for that project Well let s look at it in more detail ️Note I will give all the code samples in Go with Fiber web framework since this is my main language amp framework for backend development at the moment ↑Table of contents A quick solution to the problemOkay here is our controller for the endpoint app controllers project controller go GetProjectByAlias func for getting one project by given alias func GetProjectByAlias c fiber Ctx error Catch project alias from URL alias c Params alias Create database connection db err database OpenDBConnection if err nil return err Get project by ID project err db GetProjectByAlias alias if err nil return err Get all tasks by project ID tasks err db GetTasksByProjectID project ID if err nil return err Return status OK return c JSON fiber Map status fiber StatusOK project project lt tasks count len tasks lt tasks tasks lt As you can see this controller fully meets the conditions of our task all three points of the original problem ーIt will work ーYes of course ーWould such code be optimal ーProbably not…We call alternately the functions GetProjectByAlias and GetTasksByProjectID which creates additional latency and wastes additional resources of both the server API and the PostgreSQL database itself It s all because queries in DB most likely look like this For Project model SELECT FROM projectsWHERE alias varcharLIMIT For Task model SELECT FROM tasksWHERE project id uuidORDER BY created at DESCSince the Go language created for speed and efficient use of server resources such a waste of resources is simply unacceptable for any self respecting Go developer Let s fix that in the next section ↑Table of contents Optimize thisSo how do we optimize this Of course by reducing the number of queries to the database But then how do we get all the necessary tasks for the project and their number This is helped by the wonderful built in aggregate function jsonb agg that have appeared in PostgreSQL v and are constantly being improved from version to version Furthermore we will be using COALESCE function with FILTER condition to correctly handle an empty value when the project may have no tasks And immediately count the number of tasks through the COUNT function ️Note See more info about COALESCE here SELECT p COALESCE jsonb agg t FILTER WHERE t project id IS NOT NULL AS tasks COUNT t id AS tasks countFROM projects AS p LEFT JOIN tasks AS t ON t project id p idWHERE p alias varcharGROUP BY p idLIMIT It s a little difficult to understand the first time isn t it Don t worry you ll figure it out Here s an explanation of what s going on here Output all the data about the found project We got only one project which has a unique alias we are looking for Using the LEFT JOIN function we only joined the sample of tasks that have a connection to the project by ID We grouped all the data by project ID We did an aggregation of all obtained tasks using the aggregation function jsonb agg filtering it all by project ID For projects that have no tasks we provided a display in the form of an empty list We used the COUNT function to calculate the number of tasks in the project Next we just need to prepare the output of all the data obtained from the database Let s add the appropriate structures to the Project and Task models A simplified structure with a description of each project task app models task model go GetProjectTasks struct to describe getting tasks list for given project type GetProjectTasks struct ID uuid UUID db id json id Alias string db alias json alias Description string db description json description And additional structures for the Project model app models project model go ProjectTasks struct to describe getting list of tasks for a project type ProjectTasks GetProjectTasks struct from Task model GetProject struct to describe getting one project type GetProject struct ID uuid UUID db id json id CreatedAt time Time db created at json created at UpdatedAt time Time db updated at json updated at UserID uuid UUID db user id json user id Alias string db alias json alias ProjectStatus int db project status json project status ProjectAttrs ProjectAttrs db project attrs json project attrs Fields for JOIN tables TasksCount int db tasks count json tasks count Tasks ProjectTasks db tasks json tasks ️Note The ProjectTasks type needed to correctly output a list of all the tasks in the project Let s fix controller app controllers project controller go GetProjectByAlias func for getting one project by given alias func GetProjectByAlias c fiber Ctx error Catch project alias from URL alias c Params alias Create database connection db err database OpenDBConnection if err nil return err Get project by ID with tasks project err db GetProjectByAlias alias if err nil return err Return status OK return c JSON fiber Map status fiber StatusOK project project lt The final optimized query result for our new endpoint should look like this status project id abd ebc de b eefb created at T Z updated at T Z user id bf c ac cd dbd alias dvcxyufwsuwmn project status project attrs title Test title description Test description category test tasks count tasks id ea e efab alias dcbdb description Task one That s how gracefully and easily we used all the power of built in Postgres function and pure SQL to solve a database query optimization problem Wow how great is that ↑Table of contents Photos and videos byHannah Busing P S If you want more articles like this on this blog then post a comment below and subscribe to me Thanks	2021-10-04 20:52:02
海外TECH	DEV Community	What is the future of social media?	https://dev.to/meatboy/what-is-the-future-of-social-media-trust-3jmg	What is the future of social media As you can see currently Facebook Instagram and several other services related to FB are down A lot of services has sign in with the Facebook feature so people lost temporary access Do you think people change their minds after this incident Also there is a lot of services that rely on Facebook Social media agencies automation SaaS es for posting ads and so on Facebook also has a PR problem because of Facebook Files which reveals the company corrupt users for profit source the verge knows how toxic some of its services are etc On the other hand it s a huge corporation full of mastermind people behind directors and CXOs with billions of dollars to spend What is your opinion about Facebook and the overall state of social media How do you see the future of social media	2021-10-04 20:30:46
海外TECH	DEV Community	Git & GitHub workflow 101 cheatsheet	https://dev.to/_arnoldho/git-github-workflow-101-cheatsheet-jj	Git amp GitHub workflow cheatsheetIn the spirit of learning in public I am writing my own Git cheatsheet I am still new so if I got any of the terminologies wrong please correct me This cheatsheet is going to be really basic and assumes that you only make changes and commit in the master branch In the future I will discuss more about branches There are two main ways of getting a git repo in your local machine and then pushing it onto GitHub These are Fetching a repo from GitHub make the changes and push it back to GitHubCreate a new directory locally initialise git track the changes and push it up to GitHubThe first way is more common we can do it using the workflow below git clone lt the SSH key for your repository gt This fetches the GitHub repo to your local machine and starts the tracking process You will now make some changes to files inside the repo Once you re done you wanna check what are the changesgit status git status tell you what are the modified files as well as new files you ve createdgit add lt file names gt git add adds the files you want to commit on the stage you don t have to add all the files that are changed onto the stage for example you might actually have made a change in one of the files and you prefer the previous version in that case you don t have to git add the change You would probably want to check the git status again to make sure you have added all the correct filesgit status Now you would be able to see all the tracked and untracked files Check for any errors before committinggit commit m add meaningful commit message this will add a commit message and take a snapshot of your repository with the change you wish to document Once you ve done that you might want to check git status againgit status double and triple checking is always good now your command prompt should tell you that there is no untracked files This is all good for you but if you want to collaborate with others and for others to also see the changes you ve made you d want to push this commit to GitHub Assuming that you ve been working on the master branch you will do the followinggit push origin master This pushes the changes in the master branch to the remote called origin which should be your GitHub repo Sometimes you re branch is not master and your remote is not origin you can use the format git push lt remote name gt lt branch name gt Now this will become a pull request ready to be merged into the main assuming that there are no conflictsMaking a repo locally and then pushing it on GitHub is less common but we will go through it nonetheless First you want to make the folder cd into it and then initialise version control using gitmkdir lt folder name gt This creates a new foldercd lt folder name gt This moves your current position into the foldergit init This initalises git Please do this only in a folder for a specific project don t do something like this in your user directory because you will be tracking EVERY SINGLE CHANGE in that directory If you track your user directory this will soon become very messy Once you ve initalised git you can start making changes in your repository and save them the same way you do above So I will skip through the explantions git statusgit add lt folder and file names gt git statusgit commit m add meaningful commit messages git status Now we want to push this onto GitHub again for collaboration But you might have noticed that we don t have a remote to push this to because everything we did was local So now you have to go into your GitHub and create a new repo once you ve done that you can get the SSH key of that repo Now you tell git the remote you re using git remote add origin lt SSH Key of the repo you just created gt After this step you just push your changes to the GitHub repo the same way you did before as git now knows where your remote is git push origin masterAnd these are the two ways you can work locally and then push changes onto GitHub One useful tool is git log this basically give you a log of all the commits It will show you important information like Who made the changeWhen was the change madeWhat is the changeYou can then use that to debug codes or roll back to previous versions of codes I will talk more about how to do that in the future For now this is it Hope this is useful This only covers the basics of the basics There are so many other powerful things git can do like creating new branches pulling new changes from GitHub and many more I will cover those in later blogposts Happy coding	2021-10-04 20:28:14
海外TECH	DEV Community	Creating an Infinitely Zooming image (for ANTI-divtober 😉)	https://dev.to/inhuofficial/creating-an-infinite-loop-for-anti-divtober-2jb2	Creating an Infinitely Zooming image for ANTI divtober divtober is a time for CSS artists to come out and play They have to create a different piece of CSS art each day to showcase their CSS artistry and skill There are already some fantastic entries such as this one from alvaromontoro Ceiling fan entry for divtober Alvaro Montoro・Oct ・ min read codepen divtober css art anti divtober I don t have any skill But I am still going to participate in my own way Those of you who follow me already know I don t do CSS art or single div stuff so I am going to join the challenge but do everything except create single div CSS art So what are the challenges Lynn Fisher lynnandtonic October is already going to be busy busy but let s do this divtober a singlediv com divtober PM Sep Daything to createFanWatchQuickLoopTiredHungryToxicGrowingHomonymOrganisedSliceSqueakCamouflageFancyFloatSnowStackShineNostalgiaJourneyMagicCritterLoudSmellyDipSpiceFilmDotsFruitContrastSpooky Day entryThe first days are fan watch quick and loop So I did a fan watching a concert that is part of a quick infinite loop You re sillyYeah I know You should check out the truly skilled people at f liveHave a great week everyone keep an eye out for my next entry	2021-10-04 20:19:38
Apple	AppleInsider - Frontpage News	iPhone 13 review: Still the iPhone for the rest of us	https://appleinsider.com/articles/21/10/04/iphone-13-review-still-the-iphone-for-everyone?utm_medium=rss	iPhone review Still the iPhone for the rest of usThis year s iPhone isn t revolutionary but it will wind up as the most popular iPhone model The new iPhone in PRODUCT RedIn this review we re primarily focusing on the iPhone itself For those interested in the smaller iPhone mini you can check out that review and those interested in the iPhone Pro or iPhone Pro Max we have a dedicated review for them as well Read more	2021-10-04 20:11:31
海外科学	NYT > Science	Nobel Prize in Medicine Awarded to David Julius and Ardem Patapoutian	https://www.nytimes.com/2021/10/04/health/nobel-prize-medicine-physiology-temperature-touch.html	Nobel Prize in Medicine Awarded to David Julius and Ardem PatapoutianDavid Julius and Ardem Patapoutian were honored for their discoveries about how heat cold and touch can initiate signals in the nervous system	2021-10-04 20:48:26
海外科学	NYT > Science	How Accurate Are At-Home Covid Tests?	https://www.nytimes.com/2021/09/29/health/at-home-covid-tests-accuracy.html	levels	2021-10-04 20:37:49
海外科学	NYT > Science	Protected Too Late: U.S. Officials Report More Than 20 Extinctions	https://www.nytimes.com/2021/09/28/climate/endangered-animals-extinct.html	Protected Too Late U S Officials Report More Than ExtinctionsThe animals and one plant had been listed as endangered species Their stories hold lessons about a growing global biodiversity crisis	2021-10-04 20:41:45
海外TECH	WIRED	How to Get the Most Important New Features in Windows 11	https://www.wired.com/story/most-important-things-microsoft-announcement-windows-11-android-apps	desktop	2021-10-04 20:35:00
ニュース	BBC News - Home	Facebook, Whatsapp and Instagram suffer outage	https://www.bbc.co.uk/news/technology-58793174?at_medium=RSS&at_campaign=KARANGA	facebook	2021-10-04 20:53:23
ニュース	BBC News - Home	Sarah Everard murder: Met launches standards review to 'rebuild public trust'	https://www.bbc.co.uk/news/uk-england-london-58724412?at_medium=RSS&at_campaign=KARANGA	murder	2021-10-04 20:27:36
ニュース	BBC News - Home	Drivers clash with Insulate Britain protesters	https://www.bbc.co.uk/news/uk-england-london-58787144?at_medium=RSS&at_campaign=KARANGA	blackwall	2021-10-04 20:13:46
ニュース	BBC News - Home	Salah is better than Messi and Ronaldo - Sutton	https://www.bbc.co.uk/sport/football/58795996?at_medium=RSS&at_campaign=KARANGA	chris	2021-10-04 20:39:32
ニュース	BBC News - Home	Catalans' Tomkins named Man of Steel	https://www.bbc.co.uk/sport/rugby-league/58790798?at_medium=RSS&at_campaign=KARANGA	award	2021-10-04 20:52:32
ニュース	BBC News - Home	Rio Paralympic gold medallist Robinson announces swimming retirement	https://www.bbc.co.uk/sport/disability-sport/58796790?at_medium=RSS&at_campaign=KARANGA	bronze	2021-10-04 20:18:41
ビジネス	ダイヤモンド・オンライン - 新着記事	投資の儲け数千万円が数カ月でゼロ！『さおだけ屋』著者の会計士が明かす天国と地獄 - 株投資 入門＆実践	https://diamond.jp/articles/-/283469	公認会計士	2021-10-05 05:25:00
ビジネス	ダイヤモンド・オンライン - 新着記事	IT業界で「新人でも爆速成長」できる職種・仕事はズバリこれ！【IT業界インサイダー座談会2】 - 不要？生き残る？ ITベンダー＆人材 大淘汰	https://diamond.jp/articles/-/283450	選び方	2021-10-05 05:20:00
ビジネス	ダイヤモンド・オンライン - 新着記事	新聞業界騒然、老舗輪転機メーカーに買収仕掛けたファンドの狙い - Diamond Premium News	https://diamond.jp/articles/-/283827	新聞業界騒然、老舗輪転機メーカーに買収仕掛けたファンドの狙いDiamondPremiumNews新聞の発行を支える輪転機メーカー最大手の東京機械製作所が買収騒動で揺れている。	2021-10-05 05:15:00
ビジネス	ダイヤモンド・オンライン - 新着記事	低リスクがウリ、バランスファンドの「不都合な真実」とは？【買ってはいけない投資商品2】 - 株投資 入門＆実践	https://diamond.jp/articles/-/283468	不都合な真実	2021-10-05 05:10:00
ビジネス	ダイヤモンド・オンライン - 新着記事	独立系金融アドバイザー・IFAの見極め方、大半は元証券営業マンで回転売買狙い - 資産1億円 本気で目指すFIRE	https://diamond.jp/articles/-/282764	営業マン	2021-10-05 05:05:00
北海道	北海道新聞	国内初ロボットアームの保守車両　ＪＲ西が開発、架線工事を補助	https://www.hokkaido-np.co.jp/article/596514/	開発	2021-10-05 05:12:00
ビジネス	東洋経済オンライン	三菱電機､調査報告書があぶり出した｢特殊体質｣ ｢言ったもん負け｣の文化を指摘する社員も | IT･電機･半導体･部品 | 東洋経済オンライン	https://toyokeizai.net/articles/-/460264?utm_source=rss&utm_medium=http&utm_campaign=link_back	三菱電機	2021-10-05 05:30:00