投稿時間:2021-07-20 16:47:47 RSSフィード2021-07-20 16:00 分まとめ(70件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
TECH	Engadget Japanese	HUAWEI WATCH 3の日本発売が7月30日→8月以降に延期	https://japanese.engadget.com/huawei-064500939.html	huaweiwatch	2021-07-20 06:45:00
TECH	Engadget Japanese	ルイ・ヴィトンから35万円の光るポータブルスピーカー ホライゾン ライト・アップ	https://japanese.engadget.com/louis-vuitton-horizon-light-up-speaker-063000152.html	ttonhorizonlightupspeaker	2021-07-20 06:30:00
TECH	Engadget Japanese	AirPodsの充電は？ iPhone 12用Apple純正MagSafeバッテリーパックを速攻レビュー	https://japanese.engadget.com/apple-magsafe-061634742.html	airpods	2021-07-20 06:16:34
TECH	Engadget Japanese	iOS 14.6にゼロクリック脆弱性が存在、政府が人権活動家の監視に利用していたとの報告	https://japanese.engadget.com/i-message-zeroclick-exploit-spyware-060053761.html	android	2021-07-20 06:00:53
IT	ITmedia 総合記事一覧	[ITmedia Mobile] Huaweiが7月29日に次期フラグシップ「P50」シリーズを発表へ	https://www.itmedia.co.jp/mobile/articles/2107/20/news112.html	huawei	2021-07-20 15:08:00
IT	情報システムリーダーのためのIT情報専門サイト IT Leaders	KandaQuantum、業務で発生するタスクを適切な従業員に割り当てるツール「calqtask」を開発 | IT Leaders	https://it.impress.co.jp/articles/-/21800	業務で生じるタスク仕事を入力することによって、そのタスクを処理するべき人材を適切に割り当てられる。	2021-07-20 15:20:00
python	Pythonタグが付けられた新着投稿 - Qiita	ADX2 別プロセスで原音再生	https://qiita.com/tatmos/items/f2a6ecc2eacc983a3f11	そこで、再生処理を別プロセスに投げてしまうことで、キャンセルできるようにします。	2021-07-20 15:57:48
python	Pythonタグが付けられた新着投稿 - Qiita	python 画像処理 No module	https://qiita.com/kaito_111/items/8f0720499081612dfbe6	pipinstallimutils	2021-07-20 15:43:54
python	Pythonタグが付けられた新着投稿 - Qiita	超初心者がPythonで5分足チャートからMACDを計算してグラフに表示してみた	https://qiita.com/yamaji_daisuke/items/691f1822044087c1ab6d	超初心者がPythonで分足チャートからMACDを計算してグラフに表示してみた参考MACDの計算部分以外は以下とほぼ一緒コードimportpandasaspdimportdatetimeimportmplfinanceasmpfdfpdreadcsvtemphistoricaldataUSDJPYcsvnrowsdfcolumnsDateOpenHighLowCloseVolumedfDatepdtodatetimedfDatedfsetindexDateinplaceTruedfpdDataFrameruleTdfOpendfOpenresamplerulefirstdfClosedfCloseresamplerulelastdfHighdfHighresamplerulemaxdfLowdfLowresampleruleminmacdpdDataFramemacdClosedfClosemacdEMAdfCloseewmspanmeanmacdEMAdfCloseewmspanmeanmacdMACDmacdEMAmacdEMAmacdSignalmacdMACDewmspanmeanmacdheadmacdplotmpfmakeaddplotmacdMACDSignalmpfplotdftypecandlemavmpfplotdftypecandleaddplotmacdplotdatetimeformatYmdHMxrotationstyleyahoosavefigdictfnamefiguresdrawmacdpngdpiグラフ説明移動平均線と同時に表示したい場合は以下のようにするsmapdDataFramesmaSMAdfCloserollingwindowmeansmaSMAdfCloserollingwindowmean中略smaplotmpfmakeaddplotsmaSMASMAmpfplotdftypecandleaddplotsmaplotmacdplotdatetimeformatYmdHMxrotationstyleyahoosavefigdictfnamefiguresdrawmacdpngdpi一緒に表示したグラフは以下。	2021-07-20 15:42:54
python	Pythonタグが付けられた新着投稿 - Qiita	pyATSを触るためにCMLでtestbedファイルを用意してみた	https://qiita.com/HMASAYUKI/items/6f3a98893ee7710ddcb7	これでCMLのAPIが操作できるのでtestbedファイルを作成していきましょうLabsgtGETlabslabidpyatstestbedのAPIを使います。	2021-07-20 15:24:50
python	Pythonタグが付けられた新着投稿 - Qiita	画像生成の話 -フォトリアリスティックなGIRAFFEを読んでみる-	https://qiita.com/akaiteto/items/bf6691883dd744f31765	これが、最終的に一枚のシーンに合計された出力結果となります。	2021-07-20 15:37:41
python	Pythonタグが付けられた新着投稿 - Qiita	XGBoost・LightGBM・CatBoostの比較検証	https://qiita.com/matsu0130/items/52a0269924401b109d97	勾配ブースティングを用いたXGBoostやLightGBM、CatBoostといった手法はかなり強力でkaggleでも人気の手法です。	2021-07-20 15:25:47
python	Pythonタグが付けられた新着投稿 - Qiita	超初心者がPythonで5分足チャートから移動平均線を計算してグラフに表示してみた	https://qiita.com/yamaji_daisuke/items/45bcaebf3cb8ab6bfb27	超初心者がPythonで分足チャートから移動平均線を計算してグラフに表示してみたSMASimpleMovingAgerage。	2021-07-20 15:08:15
python	Pythonタグが付けられた新着投稿 - Qiita	超初心者がPythonでHistData.comから取得した1分足データを5分足データに変換してみた	https://qiita.com/yamaji_daisuke/items/7f9d137ad3e557df0535	超初心者がPythonでHistDatacomから取得した分足データを分足データに変換してみた分足だとグラフ化の際にデータ数が多すぎてみづらかったので分足にする。	2021-07-20 15:02:27
js	JavaScriptタグが付けられた新着投稿 - Qiita	CakePHP4 javascript document.getElementがnullになる時の解消	https://qiita.com/taaachezi/items/5831b68601305807bff2	解消したので備忘録として投稿します。	2021-07-20 15:59:33
js	JavaScriptタグが付けられた新着投稿 - Qiita	Kintoneのポータルにアプリを指定したソート順で表示する	https://qiita.com/ricorico/items/da106730355450b35116	Kintoneのポータルにアプリを指定したソート順で表示するポータルにアプリを全部表示させたいポータル画面の内容をアプリで管理しようclassicappの使い方kintoneのポータルカスタマイズ紹介上記をもとに無事アプリをポータルに表示することができました。	2021-07-20 15:16:38
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	「VirtualBox VMが予期しない理由で終了しました」とエラーを吐く	https://teratail.com/questions/350449?rss=all	「VirtualBoxVMが予期しない理由で終了しました」とエラーを吐く前提・実現したいこと何度かVMをクローンamp除去をしていたら、突然エラーを吐くようになった。	2021-07-20 15:57:33
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	python classをテンプレートとして他のクラスを作成する方法	https://teratail.com/questions/350448?rss=all	pythonclassをテンプレートとして他のクラスを作成する方法python初学者の大学生です。	2021-07-20 15:53:28
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	colaboratoryでのみするAttributeErrorを解決したい	https://teratail.com/questions/350447?rss=all	colaboratoryでのみするAttributeErrorを解決したい手書き数字の分類を本で勉強中の初心者です。	2021-07-20 15:52:48
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	プログラミングの超初心者です。	https://teratail.com/questions/350446?rss=all	askopenfilename	2021-07-20 15:46:09
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	初項から第n項までのフィボナッチ数列を作成する。	https://teratail.com/questions/350445?rss=all	初項から第n項までのフィボナッチ数列を作成する。	2021-07-20 15:45:59
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	git logの「：」とは？	https://teratail.com/questions/350444?rss=all	gitlogの「」とは「gitnbsplog」を打った際に、一番最後の行に「」が出てきます。	2021-07-20 15:45:01
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	Amazon Linux release 2 でのMysql8.0の起動について	https://teratail.com/questions/350443?rss=all	AmazonLinuxreleaseでのMysqlの起動について前提・実現したいことECインスタンスにMysqlをインストール・起動しようとしたところ、起動の段階でエラーにより失敗しました。	2021-07-20 15:41:48
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	入力データの取得を行いたい	https://teratail.com/questions/350442?rss=all	入力画面へデータ入力後、入力データ確認ページで入力内容の確認を行うシステムにしたいと考えております。	2021-07-20 15:38:22
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	wordpressにて、Woocommerceプラグインで設定されたページを編集したい	https://teratail.com/questions/350441?rss=all	wordpressにて、Woocommerceプラグインで設定されたページを編集したい前提・実現したいことWordpressにて、Woocommerceのプラグインを使用してショップを開設しようとしています。	2021-07-20 15:37:48
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	AWS CLIでサブネットを作成する際にエラーが表示される	https://teratail.com/questions/350440?rss=all	AWSCLIでサブネットを作成する際にエラーが表示されるAWSCLIでインスタンスを作成する際にエラーが出ます。	2021-07-20 15:36:36
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	WordPressのMW WP FORMで確認画面をカスタマイズしたい	https://teratail.com/questions/350439?rss=all	WordPressのMWWPFORMで確認画面をカスタマイズしたいWordPressのプラグインMWnbspWPnbspFORMを使用しています。	2021-07-20 15:35:31
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	合計金額を予約完了後にindexに表示したい	https://teratail.com/questions/350438?rss=all	合計金額を予約完了後にindexに表示したい前提・実現したいこと現在railsの学習の一環としてユーザーが部屋の登録、予約を行える機能を実装している最中で最後に実装したいこととして合計金額を予約完了ボタン押下後にindexに表示したいと考えているのですがうまくいかず困っています。	2021-07-20 15:28:29
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	FFT後に正規化、交流成分2倍をしても振幅が改善されませんでした	https://teratail.com/questions/350437?rss=all		2021-07-20 15:20:43
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	avatar画像の切り替えができない	https://teratail.com/questions/350436?rss=all	avatar画像の切り替えができない前提・実現したいことdefaulticonをavatar画像をinputする時に切り替えたいのですが条件分岐が組めずdefault画像が映りませんinput画像は表示されます。	2021-07-20 15:20:03
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	JavaScript・Ajaxを用いた非同期通信のチャット機能を実装したい	https://teratail.com/questions/350435?rss=all	JavaScript・Ajaxを用いた非同期通信のチャット機能を実装したい前提・実現したいこと①チャット機能において、JavaScript・Ajaxを使用した非同期通信を実装したいのですが、「チャットしたユーザー名のチャット画面における未定義」だと思われるエラー文が出ます度リロードすると送信した文章が表示されます。	2021-07-20 15:12:18
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	Linux（Ubuntu）の拡張属性について教えてください。	https://teratail.com/questions/350434?rss=all	LinuxUbuntuの拡張属性について教えてください。	2021-07-20 15:10:35
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	SqlplusのユーザーId とパスワードがわからない	https://teratail.com/questions/350433?rss=all	SqlplusのユーザーIdとパスワードがわからないOraclenbspDatabasenbspcをインストールし、sqlplusでOracleサーバーに接続したいのですが、OraclenbspDatabasenbspcは仮想アカウントを使用するため、sqlplusnbspユーザーIDパスワードのユーザーIdとパスワードに何を入力すればいいかわかりません。	2021-07-20 15:09:55
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	init()の{body}を省略できない	https://teratail.com/questions/350432?rss=all	initのbodyを省略できないinitの宣言の下のを省略する方法イニシャライザを変数宣言を簡略化するために用いようとして、構造体の中にイニシャライザを宣言しました。	2021-07-20 15:07:19
Ruby	Rubyタグが付けられた新着投稿 - Qiita	【Ruby】mapメソッドを使ったリファクタリング	https://qiita.com/hmae12/items/196eb6540d01c7866e87	【Ruby】mapメソッドを使ったリファクタリングポイント空の配列を用意して、他の配列をループ処理した結果を空の配列に詰め込んでくような処理の大半は、mapメソッドに置き換えることができる。	2021-07-20 15:29:58
AWS	AWSタグが付けられた新着投稿 - Qiita	【AWS構築手順】④S3・Route53・DNSの障害対策(メモ・備忘録)	https://qiita.com/perlverity/items/5365ecba6441ea2ce8e1	【AWS構築手順】④S・Route・DNSの障害対策メモ・備忘録AWS構築完成全体像第回までの記事はこちら。	2021-07-20 15:59:05
Ruby	Railsタグが付けられた新着投稿 - Qiita	herokuでアプリを修正して更新するとき	https://qiita.com/falconao/items/ebc259274276811e36c7	herokuでアプリを修正して更新するときherokuでアプリを公開しているものを更新するときまずherokuは「gitと連携して、gitに保存した内容をデプロイ」している。	2021-07-20 15:12:00
海外TECH	DEV Community	Best 5 Startup Ideas For Developers And Programmers	https://dev.to/motivatedman/best-5-startup-ideas-for-developers-and-programmers-4a37	Best Startup Ideas For Developers And ProgrammersWe can t survive without cash so everyone has to struggle for it Some go for jobs and some do business but everyone has to work somehow Developers have two options either to go for a job or choose to start a business Starting a business should be ones ultimate goal and one can start working on it anytime Even kids there are some practical businesses for kids that they can start in the early ages But I am never against doing jobs Because a job is a place where you learn and grow If you re a new developer who hasn t worked with companies then it s far better to work for them because they will teach you in a year that you will learn in a decade yourself But if you re done with doing jobs and now you have realized that you should give yourself a chance to start your startup then here are some easy to start startup ideas for you Before we get started let me guide you on a significant business tip According to SturdyBusiness of the new businesses fail in the first years and the primary reason for the failure is lack of knowledge Once you are ready to start your business it s far better to learn to start an online business from an expert There could be many things to consider even before you start your business Let s explore easy to start startup ideas for developers programmers now Start a software houseIf you can create software then it s a great opportunity for you to start a software company The advantage is that you alone can start with even at your home it will be a sole proprietorship company Later on once you re getting more offers you can hire others to join you You should keep in mind that great things take time and hence it will take a little time to grow and get clients organically but if you do it properly you will become a leading company in your industry Create a cryptocurrencyMany things have changed with time Years ago Gold and Silver had been currencies of the world and later on paper currency replaced it Now the cryptocurrency market has become the world s largest company in terms of investments That means people have realized that Crypto is the future currency of earth If you are a developer you have a great chance to create a cryptocurrency for yourself or for someone else It won t take much time to understand how to do it A friend of mine created it easily But creating it for others could be a great option because in crypto it s not only introducing a currency surely you can do that easily but many other things You can t handle everything alone until you have separate investments for your company So there are two options either to find people who could market your currency and give it security etc or do it for companies both methods work Technical writerIf you re a developer and you are good at writing naturally It s a great opportunity to become a technical writer Technical writers are those who help people understand complex programs and software It s not over yet Companies spend billions of dollars on content marketing each year so you could be an asset for companies as a co worker You can start a marketing company where you shall produce content for them On the other hand technical writers are in high demand on freelancing platforms it s great to start with Once you work with some companies surely you could build long lasting relationships with companies that will help you grow your business massively Start your own blogFrankly speaking it s one of the best businesses that I believe everyone can start easily I don t want to exaggerate that as you will start your blog today you will start earning from it But it s a fact that sooner or later you will find a reason to quit your job The reason behind my strong belief is that as you keep working on your blog it becomes your long lasting asset that never ends I recently received an email from an Asian blogger who is generating dollars a month from his blog That s a huge amount Before you give it a shot please keep in mind as becoming a developer or programmer took your time learning it blogging has also its basics to learn Don t get in it without learning the basics of it  For example every blogger needs to understand SEO search engine optimization surely it won t be harder for you because you re already good at many things But other than technical SEO On Page SEO has its significance On page will take your week to become master of it so if you go for it it won t stop you keep growing YouTube vLogBack in YouTube was started as an entertainment platform No one knew that it would become the biggest visual search engine in the world with the largest database Now people Youtube many things especially technical things So as you re good at technical things you can start your channel where you can discuss software and many other complex stuff Even laptops affiliates are one of the best affiliates that you can start on your channel You can review the best laptops on your channel and it will soon be getting traffic This can bring you a lot of money by monetizing your content Top ways to earn from Youtube videos are Adsense and affiliate links or sponsored videos But once again Youtube has also its pattern to rank videos for search queries Once you re ready to jump in give it a little time to understand the basic things	2021-07-20 06:44:57
海外TECH	DEV Community	Writing a JavaScript Code	https://dev.to/stuffsuggested/writing-a-javascript-code-209o	Writing a JavaScript CodeWe are used to writing JavaScript code for a long time But we are not updated enough to use an optimized way of coding for JavaScript With the optimized method of coding we can be on top of the things which is related to optimized code With Shorthand methods lots of things become easy for developers Like Error tracking Code management line of Codes etc Here the list of javascript shorthandsJavascript Shorthand for if with multiple OR conditionsJavascript Shorthand for if with multiple And amp amp conditionsJavascript Shorthand for checking null undefined and empty values of variableJavascript Shorthand for switch case to select from multiple optionsJavascript Shorthand for functions for single line functionJavascript Shorthand for conditionally calling functions Javascript Shorthand for To set the default to a variable using ifJavascript Shorthand for if…else statementsJavascript Shorthand for traditional for loops to fetch a value from arrayJavascript Shorthand for typecasting Converting string to number Shorthand for if with multiple OR conditionsif car audi car BMW car Tesla code In a traditional way we used to write code in the above pattern but instead of using multiple OR conditions we can simply use an array and includes Check out the below example if audi BMW Tesla grapes includes car code Shorthand for if with multiple And amp amp conditionsif obj amp amp obj tele amp amp obj tele stdcode console log obj tele stdcode Use optional chaining to replace this snippet console log obj tele stdcode Shorthand for checking null undefined and empty values of variableif name null name undefined name let second name The simple way to do it is const second name Shorthand for switch case to select from multiple optionsswitch number case return Case one case return Case two default return Use a map objectconst data Case one Case two Access it usingdata num Shorthand for functions for single line function function example value return value Use the arrow functionconst example value gt value Shorthand for conditionally calling functionsfunction height console log height function width console log width if type heigth height else width Simple way type heigth height width Shorthand for To set the default to a variable using ifif amount null amount if value undefined value console log amount console log value Just Writeconsole log amount console log value Shorthand for if…else statementslet label if amt gt label profit else label loss Replace it with a ternary operatorconst label amt gt profit loss Shorthand for traditional for loops to fetch a value from arrayconst arr for let i i lt arr length i console log arr i Replace for with forEachconst arr arr forEach val gt console log val Shorthand for typecasting Converting string to numberconst num parseInt const num parseFloat simply use operatorconst num const num	2021-07-20 06:34:15
海外TECH	DEV Community	Css Selectors for Input Ranges	https://dev.to/stacksjar/css-selectors-for-input-ranges-4obb	Css Selectors for Input RangesIn this post we are going to check Css Selectors for input ranges This selectors would not be known by many of us We all use input elements in our projects and must be aware of input type number this defines a field for entering number This allows in restricting user to enter any other character other than numbers When we use the tag input and give its type attribute value of number as belowThis input box comes with the buttons on the right side which we can use to increase or decrease the number entered in the input We can set the min and max values for the number to be entered in the input as belowThis will restrict the user to enter only numbers that are between and as we have specified in the min and max attributes of the input Now we can use the CSS Selector to detect if the user has not entered between the specified min and max values and apply css for the same html cssinput in range border px solid green input out of range border px solid red The above css code will check all the values entered in the Input Box If the number entered in the input box is not between the range specified by min and max values it changes the color of input box to red If the number entered is between the min and max values it will change the input box s color to green This was the usage of in range and out of range css selectors hope you find this usefull Checkout Complete Article Here Psuedo Selectors for Inputs in Css	2021-07-20 06:22:28
海外TECH	DEV Community	I Recreated my VSCode Theme 🔥	https://dev.to/shaan71845/i-recreated-my-vscode-theme-33p6	I Recreated my VSCode Theme Hi guys So couple of months back I wrote a blog I created a VSCode theme describing about the VS Code theme called Martian Night that I made Fast forward to present I am here to announce that I recreated my VS Code theme But wait what do I mean by recreate Actually the thing is I wanted to update my theme but for some reasons I was unable to release an update on the marketplace so I had to unpublish the previous one and again publish the new one What s new in this Theme There are lot of things which are new in this theme Previously I had used only colours for the syntax but now I tried to introduce more colours to the syntax Also I introduced three variants of the theme Normal Bold amp italics Normal Bold ItalicsAlso I changed the previous boring logo into something new Why did I upgrade The previous one had a lot of issues like lack of colours high contrast colours and no italics or bold fonts used This is because I was pretty new to creating VS code theme that time so I decided to improve my theme hence I created this one How can you try it Below are some relevant links for you to try Install it from here Marketplace GitHub Repo Feel free to leave a on the repo Feedbacks and comments are appreciated Thank you	2021-07-20 06:03:49
海外TECH	DEV Community	Migrating to Redshift RA3 nodes	https://dev.to/aws-builders/migrating-to-redshift-ra3-nodes-fn7	Migrating to Redshift RA nodes What is RA RA is the latest family of Redshift node types launched at re Invent The other node types are Dense Storage DS and Dense Compute DC The primary difference with RA is that it has a completely separate storage layer called Redshift Managed Storage RMS RMS uses high performance SSDs for your hot data and Amazon S for cold data In addition it uses high bandwidth networking built on the AWS Nitro System to reduce the time taken for data to be offloaded to and retrieved from Amazon S With the DC and DS node types storage is tightly coupled to the compute nodes using EBS volumes attached to each individual node Why move to RA There are a number of reasons to consider migrating your existing cluster to the RA node types and I have listed what I believe are the main ones Decoupled StorageEvery organization is different but the main reason for ours to migrate to RA was to take advantage of the increased storage to compute ratio For every raxl or raxl node you add to the your cluster you get access to TB storage capacity Plus you only pay for what you consume You are not paying for the full TB every month By migrating one dsxl node to raxl nodes we have increased our storage capacity by from TB to TB While storage is still actually coupled to a compute node there is so much of it that it has effectively become decoupled This table lists the difference in technical specifications between dsxl node and raxl nodes Node Type vCPUMemoryStorageI OSlicesdsxl GiBTB HDD GB sraxl GiBTB RMS GB sIt may look like you are taking a reduction in vCPU and Memory but that hasn t had any noticeable impact on the performance of our clusters Our typical queries are running in the same time or slightly faster The combination of newer hardware and SSDs makes up for this apparent reduction With the DS and DC node types storage is tightly coupled to vCPU and memory To purchase more storage you also have to purchase the attached vCPU and memory The pushes up the cost of purchasing TB storage for these node types to between and per month depending on purchase plan With RA storage is priced separately to vCPU and memory and TB of RMS costs per month regardless of purchase plan In our case we had previously expanded a cluster from to dsxl nodes purely for storage requirements When we migrated to raxl we were able to reduce what should have been nodes using a ratio to nodes Operational OverheadThe increased storage to compute ratio means that you can now scale storage and compute separately With our previous node dsxl cluster we were bound to TB Storage capacity on the cluster bounced between and used depending on the time of year Working with our business customers to keep used storage capacity below at peak times of activity was a fulltime job This added more overhead to IT and the business teams taking time away from value creation Not having to chase business users to delete data from the cluster has been a relief for both the technical and business teams If you are purchasing RIs on a or even year term having different renewal dates on different nodes within the same cluster complicates your cost management Nodes will come up for renewal at different times of the year and it also makes any future plans you may have for your cluster size have more complicated Imagine you started with a node cluster purchased on a year term years in you realize that you need to increase your cluster size to nodes so you purchase more nodes on a year term Effectively you have now extended the lifetime of your cluster to years And when the original nodes come up for renewal what do you do Extend for another or years There is no RI plan for RMS so this reduces complexity here AvailabilityIf you are running a two node cluster for availability purposes you may be able to scale down to a smaller RA cluster In our case we were able to resize a node dsxl cluster to node raxl cluster It gives us the same availability profile with TB storage New FeaturesOther reasons to upgrade to RA nodes are that a number of features are only and will only be available on this node type The new storage model is making possible a number of new features that couldn t be supported on the DC and DS node types AQUA As outlined RMS stores all data on S and then moves data to an SSD layer when requested by compute layer AQUA pushes more predicates down to RMS and reduces data movement between storage and compute layers The first iteration of AQUA supports scan and aggregation operations when they contain at least one predicate that contains a LIKE or SIMILAR TO expression This should greatly enhance query performance where you have these types of queries We recently turned it on but most of our queries do not match this profile and we have seen very little benefit However we hope that AWS will add more support for other expressions in the future and we are now best place to take advantage of any future optimizations Data sharing This feature allows you to share live data stored on RMS between different Redshift clusters For example you can have one cluster that writes your data to RMS and separate clusters for consuming that data Cross AZ Cluster Relocation Up to now Redshift was hosted entirely in a single AZ A failure in the host AZ would mean you would have to restore a snapshot to a new cluster in a separate AZ generally via a bespoke process However RMS is not bound to a single AZ Therefore in case of a failure you will only need to restore your compute nodes in a separate AZ AWS is making this a setting in the backup details called Cluster relocation Enabling this feature allows Redshift to relocate your cluster when certain AZ level issues arise Some existing features may work more effectively with RA and RMS specifically We are currently re testing concurrency scaling with RA as we expect this should work differently with RA Storage TieringWith the restricted storage capacity of the DS and DC nodes one storage saving pattern that could be applied is to offload the older data on the cluster to S and expose them in Redshift using the Spectrum service Storing TB of data in S Standard class would cost per month Storing this data in RMS would only cost slightly more at per month However this ignores the operational cost of supporting a bespoke solution using Spectrum If you choose a different S storage class the Spectrum pattern may be more cost effective For example if you went for Standard Infrequent Access the price would be almost halved to However be careful with Standard IA storage class Data stored in Standard IA costs more to access and your costs could quickly exceed Standard if you access it too frequently A GET request against Standard IA costs times more than against Standard This can add up quickly I would say that RMS offers an easy way to take advantage of S storage pricing without any of the operational overhead of explicitly archiving data to S PricingPricing is a tricky beast here On demand and yr terms are almost the same even when you include storage cost However if you compare year terms for dsxl nodes versus raxl prices are more expensive for the newer hardware Node Type On DemandyryrStorage TB dsxl per Hour raxl per Hour Cost Difference Pricing for backup storage is also different For DS and DC clusters the charge is only applied to the amount of manual snapshot storage above the amount of provisioned storage on the cluster All manual snapshots taken for RA clusters are billed as backup storage at standard Amazon S rates However automated snapshots are priced the same All of these pricing scenarios are based on the theory that you upgrade on ratio In theory if you replace dsxl with raxl nodes it will cost you more over a year term This ignores the main benefit of the decoupled compute and storage that upgrading to RA provides In practice we were able to reduce the number of nodes we were using and our monthly Redshift costs dropped by Other cost savings with reduced operational overhead are harder to quantify but worth taking into account if assessing a move to RA Migration BackgroundThe migration process is straightforward The only technical decision you need to make is whether you wish to use elastic or classic resize Classic resize provisions a new cluster and copies the data from the original cluster to the new cluster Elastic resize works by changing or adding nodes to your existing cluster Elastic resize is the AWS recommended approach and they have improved it a lot recently especially with the ability to change node types It is also the fastest way to add and remove nodes Classic resize can take several hours or days depending on the size and configuration of your cluster The main reason to use classic over elastic resize is if the new cluster configuration isn t possible with an elastic resize Elastic resize is an opinionated option and only allows you to add or remove nodes within certain parameters For example For dcxlarge dsxlarge raxlarge or raxlarge node types you can change the number of nodes to half the current number or double the current number of nodes A node cluster can be resized to or nodes The easiest way to check what cluster size is available via elastic resize is to check within the console Go to Actions gt Resize Elastic resize recommended is chosen by default Scroll down to the Nodes dropdown and you can see the number of nodes you can upgrade to For more information AWS have a good page with the details you ll need on resizing your cluster ExecutionAt the time of our upgrade we were able to choose elastic resize for of our larger clusters Elastic resize was not available as an option for moving from a node dsxl cluster to node raxl cluster so we went with classic resize for those However that option is now available via the console Original Node TypeNew Node TypeElastic vs ClassicData SizeTime dsxl raxlElastictb minutes dsxl raxlElastictb minutes dsxl raxlClassictb hours dsxl raxlClassictb hoursAs you can see from the table above there is a huge difference in execution times of elastic versus classic resize While there may be reasons to use classic an elastic resize makes the entire upgrade simple and quick One thing to note is that while we were able to run both elastic resizes in parallel the classic resizes cannot run in parallel If you kick off a second classic resize it will wait until the first completes before executing It will be in read only mode while waiting so you may want to only kick off nd resize after the st resize completes Post migrationAs stated previously the migration to RA did not bring a massive lift in performance It is a very stable and easy migration that brings a lot of benefits to reduce your operational and management load in relation to Redshift That stability was apparent in the Redshift CloudWatch Dashboard where we saw large drops in our Read and WriteIOPS combined with a drop in Read and WriteLatency but no major changes overall This was expected with the move to RMS plus a slight increase in CPU Utilisation SummaryUpgrading your Redshift cluster to RA node types simplifies the management of your cluster This is primarily enabled through the massive increase in storage available per node This increase in storage comes without any trade off in performance We are months after the upgrade and the best word I can use to describe our experience is stability The upgrades on our largest clusters took minutes using an elastic resize The upgrade required no code changes and had no impact on our customers From AWS we see all the new features being enabled on RA first The new storage architecture enables new features that would not be possible in the older node types and such features will never be available on the DC or DS node types	2021-07-20 06:00:52
Apple	AppleInsider - Frontpage News	Save $110 on Apple's M1 13-inch MacBook Pro (16GB, 512GB), plus $50 off AppleCare	https://appleinsider.com/articles/21/07/16/save-110-on-apples-m1-13-inch-macbook-pro-16gb-512gb-plus-50-off-applecare?utm_medium=rss	Save on Apple x s M inch MacBook Pro GB GB plus off AppleCareJuly MacBook Pro discounts are going on now with our exclusive coupon knocking to off the latest inch line Pick up the upgraded model with GB of RAM and a GB SSD for with optional AppleCare marked down to Apple Authorized Reseller Adorama is hosting the exclusive deals which deliver bonus coupon savings on every M MacBook Pro configuration with promo code APINSIDER including this upgraded spec with GB of RAM and a GB SSD that s discounted to To activate the savings you must shop through this special pricing link and enter the code with full step by step instructions below According to the AI Price Guide which tracks the cheapest M MacBook Pro prices across leading resellers this is the most aggressive discount available on the high end spec with units in stock in the Silver finish and on special order in Space Gray The same APINSIDER code also knocks off AppleCare bringing the cost of the extended protection plan down to Read more	2021-07-20 06:09:39
海外TECH	Engadget	Google extends Pixel 4 XL's repair warranty for a year in some countries	https://www.engadget.com/google-pixel-4-x-ls-repair-warranty-extension-063237385.html?src=rss	Google extends Pixel XL x s repair warranty for a year in some countriesGoogle will fix your Pixel XL phone for free for up to a year after your warranty expires provided you live in the US Singapore Canada Japan and Taiwan The tech giant has launched an extended repair program for the larger version of its flagship device which features motion gesture support and built in radar Google stopped selling the Pixel and the Pixel XL from its own store in August but they re still available from retail partners until supplies last While this program can get you free repairs if you re in one of the eligible countries it only covers specific power related issues In particular the issues must be related to not being able to switch on your phone and to having trouble charging with an adapter or a wireless charger If your phone keeps restarting or shutting down without you doing it or if your battery drains significantly faster than before you could get free repair under the program as well In Canada Japan and Taiwan you could even get a free replacement That said you can t get a free repair or replacement if you purchased your device from Australia France Germany Ireland Italy Spain or the UK even if you re in one of the eligible countries Make sure to check Google s FAQ page for more information on how you can take advantage of the program in your location In the US you d have to bring your device to a uBreakiFix location or access Google s repair center website to start the process	2021-07-20 06:32:37
ラズパイ	Raspberry Pi	Mega six-screen cyberdeck	https://www.raspberrypi.org/blog/mega-six-screen-cyberdeck/	Mega six screen cyberdeckHoly cyberdecks Redditor Holistech aka Sören Gebbert really leaned in to the more is more idiom when building this big orange cyberdeck using three Raspberry Pis Why use just one screen to manipulate enemy cyberware and take down your cyberpunk foes when you can have six From four to six We first came across Sören s The post Mega six screen cyberdeck appeared first on Raspberry Pi	2021-07-20 06:32:47
海外TECH	CodeProject Latest Articles	zip.hpp: Zip Viewer and Extractor Library for IoT	https://www.codeproject.com/Articles/5308465/zip-hpp-Zip-Viewer-and-Extractor-Library-for-IoT	environments	2021-07-20 06:57:00
海外科学	NYT > Science	Caring for the Wildlife That Stray Into the Suburbs	https://www.nytimes.com/2021/07/20/science/suburbs-wildlife-deer-owls.html	animal	2021-07-20 06:30:14
海外科学	NYT > Science	Can A.I. Grade Your Next Test?	https://www.nytimes.com/2021/07/20/technology/ai-education-neural-networks.html	education	2021-07-20 06:30:06
医療系	医療介護 CBnews	RSウイルス感染拡大、患者報告数9週連続増加-五輪開催地の東京は「2003年以来最も高い値」	https://www.cbnews.jp/news/entry/20210720145855	国立感染症研究所	2021-07-20 16:00:00
金融	ニッセイ基礎研究所	新型コロナ　テレワークの人間関係－新たなストレスは仕事のパフォーマンスにどう影響しているか?	https://www.nli-research.co.jp/topics_detail1/id=68325?site=nli	こうしてみると、テレワークでのストレスの変化をみるときには、職場で感じていたストレスの軽減に加えて、テレワークならではの新たなストレスにも注意する必要がありそうだ。	2021-07-20 15:08:21
金融	ニッセイ基礎研究所	新型コロナワクチン接種後の消費行動や働き方の予測－約半数が外出行動を再開、約７割がマスク着用等が習慣化	https://www.nli-research.co.jp/topics_detail1/id=68301?site=nli	目次ーはじめにワクチン接種が加速しコロナ禍の出口が見える中で、生活者の予測や期待感はーワクチン接種後の予測約半数がコロナ前の外出行動を再開、約割がマスク着用等が習慣化ー属性別ワクチン接種後の予測女性や若者、高齢層で消費再開、管理職でテレワーク浸透の見方外出型消費行動女性や若者、コロナ禍で外出自粛傾向の強い高齢層でコロナ前の行動再開に期待生活様式・価値観等不安の強い女性や重篤化リスクの高い高齢層でマスク着用等習慣化の見方働き方家事・育児負担の大きな女性や管理職以上でテレワークの浸透に肯定的ーおわりに苦境に立つ業種の救済につながるような需要喚起策を月下旬から、新型コロナウイルスのワクチン接種が職域でも開始されたことで、医療従事者や高齢者に続き、現役世代でも接種者が増えている。	2021-07-20 15:05:06
ニュース	@日本経済新聞 電子版	デジタル人民元、記者が使ってみた　設定・支払い簡単 https://t.co/Omcnoyb9J3	https://twitter.com/nikkei/statuses/1417366128045662213	設定	2021-07-20 06:09:52
ニュース	@日本経済新聞 電子版	北海道、国に「まん延防止」を再要請へ　独自対策は延長 https://t.co/ptxrQrUmUL	https://twitter.com/nikkei/statuses/1417365108041285637	防止	2021-07-20 06:05:49
海外ニュース	Japan Times latest articles	Olympic Village COVID-19 infection bubble already ‘broken,’ health expert says	https://www.japantimes.co.jp/news/2021/07/20/national/olympic-village-covid-19-infection-bubble-already-broken-health-expert-says/	Olympic Village COVID infection bubble already broken health expert saysOn Monday the organizing committee disclosed that COVID cases had been confirmed among people related to the Olympics in July	2021-07-20 15:27:31
海外ニュース	Japan Times latest articles	More companies pull out of Tokyo Olympics opening ceremony	https://www.japantimes.co.jp/news/2021/07/20/business/corporate-business/olympics-no-show/	event	2021-07-20 15:19:32
ニュース	BBC News - Home	Tony Blair's Irish Famine message not signed off by him, archive papers show	https://www.bbc.co.uk/news/uk-57894210	private	2021-07-20 06:11:00
ニュース	BBC News - Home	Tokyo Olympics: Trap shooter Kirsty Hegarty on her journey to the Games	https://www.bbc.co.uk/sport/av/olympics/57865476	Tokyo Olympics Trap shooter Kirsty Hegarty on her journey to the GamesTrap shooter Kirsty Hegarty tells BBC Sport NI all about trap shooting and a surprising addition to her Team GB kit which got her rather excited	2021-07-20 06:11:57
ビジネス	電通報 | 広告業界動向とマーケティングのコラム・ニュース	ispace、2022年の打ち上げに向けフライトモデルの組み立てを開始	https://dentsu-ho.com/articles/7849	hakutor	2021-07-20 15:26:59
LifeHuck	ライフハッカー［日本版］	人生を好転させるミーニング・ノートとは～書き出せば行動が変わる	https://www.lifehacker.jp/2021/07/238514memo-tomoeyamada_1.html	山田智恵	2021-07-20 16:00:00
GCP	Google Cloud Platform Japan 公式ブログ	Kaggle コンペ: 野球がファンを魅了する要因を機械学習で明らかに	https://cloud.google.com/blog/ja/products/ai-machine-learning/using-machine-learning-to-deconstruct-baseball-fandom/	これが、メジャーリーグベースボールが選手のデジタルエンゲージメント予測を目的としたKaggleコンペで投げかけている課題の背後にある動機です。	2021-07-20 07:00:00
北海道	北海道新聞	シリア政権軍、攻撃再開　北西部、戦闘本格化の恐れ	https://www.hokkaido-np.co.jp/article/569173/	反体制派	2021-07-20 15:14:00
北海道	北海道新聞	米、量的緩和縮小へ議論本格化　ＦＲＢ、インフレ対応も	https://www.hokkaido-np.co.jp/article/569169/	中央銀行	2021-07-20 15:04:00
IT	週刊アスキー	MMORPG『BLESS UNLEASHED PC』各クラス共通で使える「スキルとコンボの使い方」紹介動画を公開！	https://weekly.ascii.jp/elem/000/004/063/4063340/	blessunleashedpc	2021-07-20 15:55:00
IT	週刊アスキー	地域のライフスタイルを彩るフロアにリニューアル　京急百貨店7階に9月よりユニクロなどがオープン	https://weekly.ascii.jp/elem/000/004/063/4063327/	京急百貨店	2021-07-20 15:50:00
IT	週刊アスキー	元アート作家の菓子店に行ってみよう！ 都筑にて「ninni（ニンニ）」がオープン	https://weekly.ascii.jp/elem/000/004/063/4063322/	ninni	2021-07-20 15:40:00
IT	週刊アスキー	スシロー「夏の三大ネタ祭」大とろが今だけ110円！ 松阪牛、神戸牛も登場！	https://weekly.ascii.jp/elem/000/004/063/4063301/	祭り	2021-07-20 15:30:00
IT	週刊アスキー	ロジクールより、曲面デザインを備える「ERGO K860 エルゴノミック スプリット キーボード」が登場	https://weekly.ascii.jp/elem/000/004/063/4063338/	ergok	2021-07-20 15:10:00
IT	週刊アスキー	新生錬金術JRPG『最果てのクオリア』がSteamストアにて体験版を配信開始	https://weekly.ascii.jp/elem/000/004/063/4063339/	steam	2021-07-20 15:10:00
ニュース	THE BRIDGE	オーダーメイドインソール「HOCOH（ホコウ）」開発、ANRIとアシックスのCVCから資金調達	http://feedproxy.google.com/~r/SdJapan/~3/HxUEXhHkB-U/japan-healthcare-funding-from-anri-asics-ventures	調達金額は非開示。	2021-07-20 06:00:48
GCP	Cloud Blog JA	Kaggle コンペ: 野球がファンを魅了する要因を機械学習で明らかに	https://cloud.google.com/blog/ja/products/ai-machine-learning/using-machine-learning-to-deconstruct-baseball-fandom/	これが、メジャーリーグベースボールが選手のデジタルエンゲージメント予測を目的としたKaggleコンペで投げかけている課題の背後にある動機です。	2021-07-20 07:00:00