投稿時間:2022-07-20 17:33:59 RSSフィード2022-07-20 17:00 分まとめ(43件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
フリーソフト	新着ソフトレビュー - Vector	累計100万部のベストセラー「億万長者ボード」の理論に基づいて「ナンバーズ3」の買い目を予想するソフト「億万長者シリーズ最新攻略法 ナンバーズ3が簡単に当たる！」	https://www.vector.co.jp/magazine/softnews/220119/n2201191.html?ref=rss	億万長者	2022-07-20 17:00:00
IT	ITmedia 総合記事一覧	[ITmedia PC USER] Microsoft Teamsでミーティング中にリアルタイムの共同編集が行える新機能「Excel Live」を追加	https://www.itmedia.co.jp/pcuser/articles/2207/20/news135.html	excellive	2022-07-20 16:45:00
IT	ITmedia 総合記事一覧	[ITmedia News] ああ、デスクツアーに誘われたい……でも来そうにないから自分デスクツアーをやってみた（その1）　こけおどしの背景を構築する	https://www.itmedia.co.jp/news/articles/2207/20/news033.html	自分	2022-07-20 16:39:00
IT	ITmedia 総合記事一覧	[ITmedia PC USER] アイ・オー、WD製USB 3.2外付けゲーミングSSD「WD_Black D30」の取り扱いを発表	https://www.itmedia.co.jp/pcuser/articles/2207/20/news132.html	itmediapcuser	2022-07-20 16:17:00
IT	ITmedia 総合記事一覧	[ITmedia ビジネスオンライン] 節電の夏到来、エアコンの使い方で最も多いのは？	https://www.itmedia.co.jp/business/articles/2207/20/news107.html	itmedia	2022-07-20 16:06:00
TECH	Techable（テッカブル）	入力文章に合うスライドデザインを提案する「イルシル」が便利そう	https://techable.jp/archives/182566	株式会社	2022-07-20 07:00:21
IT	情報システムリーダーのためのIT情報専門サイト IT Leaders	IIJ、「ラボ型PoC」でIoT事業の立ち上げと環境構築を支援、AzureのPaaSを活用 | IT Leaders	https://it.impress.co.jp/articles/-/23505	IIJ、「ラボ型PoC」でIoT事業の立ち上げと環境構築を支援、AzureのPaaSを活用ITLeadersインターネットイニシアティブIIJは年月日、「IIJPaaS活用ソリューションwithMicrosoftAzure」を提供開始した。	2022-07-20 16:17:00
AWS	AWS Japan Blog	Amazon SageMakerによる実験管理について解説する動画を公開しました！	https://aws.amazon.com/jp/blogs/news/ml-enablement-series-dark2/	mlenablementser	2022-07-20 07:36:47
Linux	Ubuntuタグが付けられた新着投稿 - Qiita	WSL2：「実行しようとした操作は、参照したオブジェクトの種類ではサポートされていません。」と表示されてUbuntuが立ち上がらない場合の対応方法	https://qiita.com/tabimoba/items/7c1c74f36102b1bd9c80	ubuntu	2022-07-20 16:46:40
技術ブログ	Developers.IO	RDS インスタンスを OS アップデートする時にダウンタイムか発生するか教えてください	https://dev.classmethod.jp/articles/tsnote-rds-os-update-down-time/	amzonrds	2022-07-20 07:50:11
技術ブログ	Developers.IO	[アップデート] AWS SSOがIAMのカスタマー管理ポリシーをサポートしました	https://dev.classmethod.jp/articles/aws-sso-supports-customer-managed-policies/	awssinglesignon	2022-07-20 07:28:32
海外TECH	DEV Community	Calling all beginners: solution to part II's homework	https://dev.to/joolsmcfly/calling-all-beginners-solution-to-part-iis-homework-b8i	Calling all beginners solution to part II x s homeworkHello coders In the previous episode of this beginners series I gave you an exercise based on the following initial data const purchases item socks amount date item jacket amount date item cap amount date item socks amount date item cap amount date item jacket amount date item socks amount date item socks amount date item jacket amount date item cap amount date item socks amount date Create a list of best and worst selling items of each month Best and worst are defined by the revenue they generated Expected result const topFlops top jacket flop cap top jacket flop cap top jacket flop socks Let s see how we could go about implementing a solution Step by step solutionFirst let s write in plain English what we need to do group purchases by month and itemsget first and last item of each month and make them top and flopSounds good Let s write our code outline const purchases omitted for readability const itemsMonthlyRevenue getItemsMonthlyRevenue purchases const topFlop getTopFlopFromMonthlyRevenue itemsMonthlyRevenue getItemsMonthlyRevenuegetItemsMonthlyRevenue needs to add one level compared to what we had in Part II s first exercise to store items monthly revenue const getItemsMonthlyRevenue purchases gt let monthlyRevenue purchases forEach function purchase const purchaseDate purchase date substring if monthlyRevenue purchaseDate undefined monthlyRevenue purchaseDate monthlyRevenue purchaseDate purchase item purchase amount monthlyRevenue purchaseDate purchase item return monthlyRevenue const purchases omitted for readability const itemsMonthlyRevenue getItemsMonthlyRevenue purchases console log JSON stringify itemsMonthlyRevenue null The main difference with Part II s first exercise is that monthlyRevenue purchaseDate is now an object so we need to make sure it s initialized before accessing it Let s run it and see what we get in the console Output socks jacket cap socks cap jacket socks jacket cap Excellent Onto getTopFlopFromMonthlyRevenue getTopFlopFromMonthlyRevenueconst getTopFlopFromMonthlyRevenue monthlyRevenue gt let topFlop const NAME IDX const REVENUE IDX for let month in monthlyRevenue step get an array of item monthlyRevenue const productsSales Object entries monthlyRevenue month step sort by revenue productsSales sort function p p return p REVENUE IDX lt p REVENUE IDX step fill the topFlop array object topFlop month flop productsSales NAME IDX top productsSales productsSales length NAME IDX return topFlop What s going on here Each month holds a list of items as keys and revenue as values and that s what we want to sort I make use of Object entries which returns an array of key value tuples Example console log monthlyRevenue outputs ​ socks ​ cap ​ jacket We can now sort that array and get the first and last element which will be out flop and top respectively Putting it all togetherconst getItemsMonthlyRevenue purchases gt let monthlyRevenue purchases forEach function purchase const purchaseDate purchase date substring if monthlyRevenue purchaseDate undefined monthlyRevenue purchaseDate monthlyRevenue purchaseDate purchase item purchase amount monthlyRevenue purchaseDate purchase item return monthlyRevenue const getTopFlopFromMonthlyRevenue monthlyRevenue gt let topFlop const NAME IDX const REVENUE IDX for let month in monthlyRevenue const productsSales Object entries monthlyRevenue month productsSales sort function p p return p REVENUE IDX lt p REVENUE IDX topFlop month flop productsSales NAME IDX top productsSales productsSales length NAME IDX return topFlop const purchases item socks amount date item jacket amount date item cap amount date item socks amount date item cap amount date item jacket amount date item socks amount date item socks amount date item jacket amount date item cap amount date item socks amount date const itemsMonthlyRevenue getItemsMonthlyRevenue purchases const topFlop getTopFlopFromMonthlyRevenue itemsMonthlyRevenue console log JSON stringify topFlop null Hope it helps you as a beginner to see how to tackle a task Happy coding ️	2022-07-20 07:38:53
海外TECH	DEV Community	🎮 Bringing live data to life with Digital Art & Unity	https://dev.to/optnc/bringing-live-data-to-life-with-digital-art-unity-25jf	Bringing live data to life with Digital Art amp Unity AboutAs you already know now we have amp share live data through APIsDocker imageWe wanted to create an immersive and Jaw Dropping experience with this live content We wanted to bring our data into life and jump inside it so we could finally be surrounded by our own data We chose to use Unity Game platform for that The pitch We are using Unity as a platform to visualize our data in a new dimension ️The artworks Create and bring a scene to lifeThe underlying concept is quite straight forward Each agency is a billiard ballWe get all our agencies and drop them on a circular pool table it creates more interactions Each ball continuously updates its own size then increasing its mass according to the real data by polling the APIEnjoy the show Deliver as a video gameFinally we did package the whole experience as a Video game so we can take a walk withing the artwork ExperimentationsWe also started to develop some other kinds of experiences To be doneExport as an Augmented Reality experience so we can enjoy the show in our world for example Display the show on a real table at the office or put collaborators in their own immersive experience Source codeThe code is open sourced so anyone can push experimentations further opt nc opt temps attente agences unity AboutA live experimenation around API integrations and Digital ART View on GitHub RessourcesMade with UnityUnity developer and creator advocacy teamYoutube dedicated playlist	2022-07-20 07:37:27
海外TECH	DEV Community	Pure CSS for incredible mouse follow effect	https://dev.to/chokcoco/pure-css-for-incredible-mouse-follow-effect-515b	Pure CSS for incredible mouse follow effectThe mouse follow effect as the name implies is that the element will follow the movement of the mouse and make the corresponding movement It probably looks something like this Generally speaking CSS is responsible for presentation and JavaScript is responsible for behavior The effect of mouse following is a behavior and JavaScript is usually needed to achieve it Of course the focus of this article is to introduce how to use CSS to simulate some mouse following behavior animation effects without JavaScript PrincipleTaking the above Demo as an example to use CSS to implement mouse follow the most important point is How to monitor where the current mouse is in real time OK in fact many CSS effects are inseparable from the word blindfold To monitor where the mouse is currently we just need to fill the page with elements We use elements to cover the entire page When hovering the color is displayed The core SCSS code is as follows lt div class g container gt lt div class position gt lt div gt lt div class position gt lt div gt lt div class position gt lt div gt lt div class position gt lt div gt divs lt div gt g container position relative width vw height vh position position absolute width vw height vh for i from through x i y i x position nth child i top y vh left x vw position nth child i hover background rgba We can get this effect Okay if the hover effect of each element is removed then the operation page at this time has no effect But at the same time through the hover pseudo we can probably know which interval on the page is on the page Let s continue let s add an element round ball to the page and position it absolutely in the middle of the page lt div class g ball gt lt div gt ball position absolute top left width vmax height vmax border radius transform translate Finally with the help of the sibling element selector we control the position of the blob element when hovering over the page actually hovering over a hundred hidden divs by the div we are currently hovering over for i from through x i y i x position nth child i hover ball top y vh left x vw At this point a simple pure CSS implementation of the mouse following effect has been achieved for your convenience take a look at the following image to understand If you want to view the complete demonstration you can click here CodePen Demo CSS to achieve mouse follow Existing problemsAs far as the above Demo is concerned there are still many flaws such as poor accuracyYou can only control the movement of the element to the space where the div is not the exact mouse position For this we can optimize by increasing the number of hidden divs For example to increase tiled divs to tiled divs Movement is not smooth enoughThe effect does not look silky enough and this may need to be optimized through a reasonable easing function and appropriate animation delay More attemptsHmm The principle is mastered so let s see what other interesting effects we can drum up using this technique CSS mouse follow button effectAt first I saw this effect on CodePen using SVG CSS JS and I thought using only CSS could I copy CodePen Demo Gooey mouse followWell the ideal is very rich but the reality is very hard Using CSS alone there are still many limitations But we can still use the methods described above to achieve mouse followUsing the CSS filter filter blur contrast to simulate element blending see this article CSS Filter Tips and Details You Didn t Know AboutOkay look at the bankruptcy version of the simulation using just CSS It s a bit too weird so you can tighten up the effect a bit by adjusting the colors the filter strength just trying everything to get a slightly better and similar effect CodePen Demo CSS mouse follow button effect Full screen mouse follow animationOK go ahead here s something a little flashier Well it s the flashy kind If we control not just one element but multiple elements The animation effects between the elements are then set to different transition delay sequential delay motion Wow it s exciting to think about Like this CodePen Demo mouse follow animation PURE CSS MAGIC MIXIf we could be a little more imaginative then we could collide a little more with This effect is the work of a Japanese CodePen author I really like Yusuke Nakaya source code Demo Only CSS Water Surface Mouse Follow IndicationOf course it is not necessary to indicate the movement of an element The technique of using a div to spread out the page to capture the current position of an element can also be used for other effects such as indicating mouse movement transition duration s for the default background spread div when hovering to the element background div change the transition duration s of the div currently hovered to and give the background color when hovering so that the div currently hovered to will be displayed immediatelyWhen the mouse leaves the div the transition duration of the div will change back to the default state that is transition duration s and the background color will disappear so that the background color of the div left will slowly transition to transparent causing the effect of a vignette CodePen Demo cancle transition FinallyMore wonderful CSS technical articles are summarized in my Github iCSS And maybe you will love my CodePen which has a large number of amazing CSS effects Well that s all for this article I hope it helps you	2022-07-20 07:35:22
海外TECH	DEV Community	The Django way ...	https://dev.to/oderofrancis/the-django-way--215a	The Django way Django web frameworkDjango is a web framework written in Python although it s not limited to Python that allows developers to build web applications more easily It has a great community of users and developers and it provides over pre defined actions in a model and actions in a view Django makes it very easy to write web applications that behave like websites but with much more power flexibility and security History of DjangoDjango started as a project developed by a Django web development company Stuck in Customs Stuck in Customs CEO Daniel Gultsch started the project to make things easier for his team Once Django was available Stuck in Customs would submit it to their community to get feedback Since the team had developed Django it became easy for them to develop The project quickly grew beyond a simple web application framework and Django s founders made a website for the Django community Soon over people downloaded the framework each day The number of Django contributors grew as well The Django community eventually became a legal entity the Django Software Foundation Django was originally released under the GNU General Public License GPL It is now licensed under the Apache License Django is flexible enough to fit any web application Django is modern It s based on a modern design pattern called “Model View Template MVT Django comes with a built in web server So unlike Django you don t need to install Apache Nginx or IIS etc in order to run Django Installing DjangoThe recommended way to install Django is to use pip Install it with pip install djangoOr if you don t have pip you can install it with easy install djangoInstalling Django creates a Django project so you ll need to create a virtualenv or run Python with prefix and then activate it Running DjangoPython projects run in a virtualenv by default Create a virtualenv for your project virtualenv djangoActivate the virtualenv source django bin activateThen run your project python manage py runserverThis will run Django s built in web server on port You can test your project by visiting http localhost Django comes with built in support for SSL All you have to do is tell Django which certificates to use for the server and clients and then run python manage py runserver h If you want to connect to your Django project from another computer either use SSH tunneling or run a local port forward Django comes with built in support for SSL Web PagesDjango includes built in support for templating And it s a lightweight template language so you can run Django locally without installing anything else Templates or just templates are files that define how your web page should look Django comes with two templates django template defaults and django template loaders seq By default django template defaults is an alias for django template loaders seq This plays an important role in MVT structure as Django framework efficiently handles and generates dynamically HTML web pages that are visible to the end user Thank you for your Time Let s meet next on the next section of creating Django application	2022-07-20 07:35:22
海外TECH	DEV Community	The Importance of AWS API Security	https://dev.to/roy8/the-importance-of-aws-api-security-4dcn	The Importance of AWS API Security Why API security is importantAPI security is thus crucial for preventing data breaches and protecting sensitive information In order to achieve effective API security organizations need to put in place robust authentication and authorization mechanisms as well as provide data encryption The potential consequences of poor API securityIf any of these steps are neglected the consequences can be severe For example if data is not properly encrypted it could be intercepted by an attacker and used for nefarious purposes Or if the API is not tested for vulnerabilities it could be exploited to gain access to sensitive information or systems API security is critical to protect data systems and even lives It is important to take all steps necessary to ensure the security of an API including authentication and authorization data encryption and vulnerability testing How to improve AWS API security Use IAM roles and policiesIAM roles and policies can help you control access to your AWS resources You can use IAM roles to grant permissions to users or services and you can use policies to specify what actions a user or service can take on your resources Use security groupsSecurity groups can help you control access to your AWS resources by defining which traffic is allowed to reach them You can create security groups that allow only certain types of traffic and you can assign them to your resources Use VPCsVirtual private clouds VPCs can help you isolate your AWS resources from the rest of the Internet By creating a VPC you can control which traffic is allowed to reach your resources and you can encrypt your data in transit Use multifactor authenticationMultifactor authentication MFA adds an extra layer of security to your AWS account With MFA enabled you ll need to provide both your username and password as well as a code from an MFA device in order to log in Encrypt your dataEncrypting your data can help protect it from being accessed by unauthorized individuals You can use AWS Key Management Service KMS to encrypt your data at rest and you can use SSL TLS to encrypt your data in transit The moral of the story is don t skimp on security especially when it comes to AWS APIs If you re not careful you could end up with a nasty bill from Amazon Star our Github repo and join the discussion in our Discord channel to help us make BLST even better Test your API for free now at BLST	2022-07-20 07:35:15
海外TECH	DEV Community	YugabyteDB cardinality estimation in the absence of ANALYZE statistics	https://dev.to/yugabyte/yugabytedb-cardinality-estimation-in-the-absence-of-analyze-statistics-1c1k	YugabyteDB cardinality estimation in the absence of ANALYZE statisticsYugabyteDB uses PostgreSQL query planner which is a cost based optimizer As of version the ANALYZE is still in beta and query planner relies on some heuristics for tables with no statistics Seasoned Oracle DBAs would call that RULE based optimizer Sounds too simplistic Remember that YugabyteDB is optimized primarily for OLTP and in the critical OLTP workloads you don t want an optimizer that is too creative I ll quickly compare with two databases one SQL Oracle Database and one NoSQL DynamoDB to explain that having the access path dependent on rules may be a good feature The major OLTP softwares I ve seen running on Oracle were using RULE or because this one is deprecated for a long time an equivalent by tweaking some cost adjustments to force indexes and nested loops whatever the cardinality estimation is With DynamoDB the lack of an intelligent cost based optimizer is what developers actually appreciate The cost of the query depends only on the type of query Scan Query or Get If you are familiar to DynamoDB you can translate shard sharding used in this post to partition partitioning used in NoSQL databases We need to be precise on the terms because on top of the sharding distribution YugabyteDB adds the PostgreSQL declarative partitioning to control the geo distribution or help lifecycle management The YugabyteDB heuristics are very similar and I ll describe them with the same idea Those are in yb scan c and I ll mention the constants used there I ll run the examples on a simple table with a unique index on a b which is actually the primary key and a non unique secondary index on c d drop table if exists demo create table demo a int b int primary key a b c int d int e int create index demo cd on demo c d In the absence of ANALYZE statistics YugabyteDB sets a default of one thousand rows define YBC DEFAULT NUM ROWS Table ScanA full table scan reads all rows the selectivity is the define YBC FULL SCAN SELECTIVITY so the estimation is rows explain select from demo QUERY PLAN Seq Scan on demo cost rows width row A quick note about cost the cost per tuple is YB DEFAULT PER TUPLE COST multiplied by cpu tuple cost which defaults to so per tuple with no startup cost This explains cost for rows Note that the predicates that are not on the key columns do not change the estimation here because all rows are scanned anyway even when the filtering is pushed down to the storage Set yb enable expression pushdown off explain select from demo where d QUERY PLAN Seq Scan on demo cost rows width Filter d rows Set yb enable expression pushdown on explain select from demo where d QUERY PLAN Seq Scan on demo cost rows width Remote Filter d rows In terms of DynamoDB calls this would be a Scan I m comparing only the distributed access patterns here everything else is different as YugabyteDB is distributed SQL ACID across all nodes whereas DynamoDB is distributed storage for NoSQL with per partition consistency In Oracle Rule Base Optimizer this the latest choice RBO Path Full Table Scan Single Hash QueryThe primary key has been defined as primary key a b which is equivalent to primary key a hash b asc yugabyte gt d demo Table public demo Column Type Collation Nullable Default a integer not null b integer not null c integer d integer e integer Indexes demo pkey PRIMARY KEY lsm a HASH b ASC demo cd lsm c HASH d ASC This means that the table is sharded on ranges of yb hash code a to distribute the rows across the cluster If a query filters on the hash part of a composite primary key we can expect many rows but less than the full table because this reads at most one shard The estimated cardinality for the heuristic cost model is rows out of which brings the selectivity to define YBC HASH SCAN SELECTIVITY YBC DEFAULT NUM ROWS so the estimation is rows explain select from demo where a QUERY PLAN Index Scan using demo pkey on demo cost rows width Index Cond a rows In terms of DynamoDB calls this would be a Query reading a collection from a single partition In Oracle Rule Base Optimizer this the latest choice of access by index RBO Path Range Search on Indexed Columns Single Key QueryYugabyteDB secondary indexes are global and can be unique or not Unique secondary index is the same as for the primary key But with non unique there is the possibility to query on a full key that returns multiple rows The estimated cardinality for the heuristic cost model is between a unique key and a partial key rows out of which brings the selectivity to define YBC SINGLE KEY SELECTIVITY YBC DEFAULT NUM ROWS so the estimation is rows explain select from demo where c and d QUERY PLAN Index Scan using demo cd on demo cost rows width Index Cond c AND d rows In terms of DynamoDB this is still a Query The difference is that in DDB you have to query the secondary index explicitly with follower reads In a SQL database you mention the table and the query planner will access the index when it is faster with strong consistency In Oracle Rule Base Optimizer this the latest choice of access by index RBO Path Indexes with equality Single Row GetThe previous case is for non unique secondary indexes only because an equality predicate on key columns will return at most one row on a primary key The estimated cardinality is then row out of which brings the selectivity to define YBC SINGLE ROW SELECTIVITY YBC DEFAULT NUM ROWS so the estimation is rows explain select from demo where a and b QUERY PLAN Index Scan using demo pkey on demo cost rows width Index Cond a AND b rows In terms of DynamoDB this would be a Get for a single item But here because it is SQL you don t have to mention which index Having an equality condition on the key columns go to the right structure In Oracle Rule Base Optimizer this the first choice when available RBO Path Single Row by Unique or Primary Key Why ANALYZE is still in beta in Here is a summary of what we have seen yugabyte gt explain select from demo QUERY PLAN Seq Scan on demo cost rows width yugabyte gt explain select from demo where a QUERY PLAN Index Scan using demo pkey on demo cost rows width Index Cond a yugabyte gt explain select from demo where c and d QUERY PLAN Index Scan using demo cd on demo cost rows width Index Cond c AND d yugabyte gt explain select from demo where a and b QUERY PLAN Index Scan using demo pkey on demo cost rows width Index Cond a AND b I mentioned that ANALYZE is in beta and you will have a warning when using it Let s add one million rows and ANALYZE yugabyte gt insert into demo select n n n n n from generate series n INSERT yugabyte gt analyze demo WARNING analyze is a beta feature LINE analyze demo HINT Set ysql beta features yb tserver gflag to true to suppress the warning for all beta features ANALYZENow the cardinality estimation follow the formulas above applying the selectivity calculated on rows but now on rows yugabyte gt explain analyze select from demo QUERY PLAN Seq Scan on demo cost rows width actual time rows loops yugabyte gt explain analyze select from demo where a QUERY PLAN Index Scan using demo pkey on demo cost rows width actual time rows loops Index Cond a yugabyte gt explain analyze select from demo where c and d QUERY PLAN Index Scan using demo cd on demo cost rows width actual time rows loops Index Cond c AND d yugabyte gt explain analyze select from demo where a and b QUERY PLAN Index Scan using demo pkey on demo cost rows width actual time rows loops Index Cond a AND b This is correct for Seq Scan selectivity and maybe the other queries on partial key or full non unique one However it over estimates the unique key one which always return one row You may ask why using the selectivity for it rather than a fixed value The reason is that this rule applies to a list of columns without looking at the predicate and is also used for where a and b gt which is closer to a Single Key Query That s the reason why ANALYZE is still in beta in preview branch you may have side effects on cost estimations when joining other tables The real use of ANALYZE d tables comes when the selectivity estimation is based on column statistics The model described above is simple and works for OLTP queries and some simple analytic ones More complex queries may need some hints to get the right plan yb enable optimizer statistics onIn version the stable branch that was released last week you can ANALYZE your tables still in beta and set yb enable optimizer statistics on so that the cardinality estimation depends on the column statistics rather than the heuristics I ll detail it in other posts but to show you that you can have accurate estimations here is the same as above in For my demo table the estimations are exact because I have the unique value for all columns of a row Then a single column estimate for an equality predicate is one Without a unique value the estimation would have been under the actual number because there are no statistics about the correlation between columns This will be fixed with the support of CREATE STATISTICS It is just a modelDon t forget that the optimizer estimations are just a model to choose at planning time the join order join methods and access paths for the execution There will always be some execution context that can change the actual cost The best to avoid issues with plan stability is to have a data model that fits the access patterns This is the reason why I m writing about those heuristics here even if they are superseded with optimizer statistics in the next versions Your data model should fit the following access patterns Single Row Gets should all have a index starting with their columns hash sharded The main access pattern for point queries should be the primary key It can read all columns with a single seek in the LSM Tree You can create unique secondary indexes for the others and add in INCLUDE the columns you want to query without an additional hop to the tableSingle Key Queries which return many rows should find their secondary index starting with the selective columns HASH for equality predicates only or ASC DESC for ranges This is where you should add the selected columns to the end of the index key or in an INCLUDE to make them covering indexes Those queries read many rows you don t want to add a remote call to the distributed table for each index entry Single Hash Queries queries should not necessitate additional indexes but use existing primary key or covering secondary indexes Their columns must be first in the indexed column order Table Scans are ok if you need most of the rows from one or more shards aka tablets and don t forget to enable yb enable expression pushdown to get filters pushed down to the storage But if the selectivity is high maybe you miss some range indexes on for those filters Look at the filter predicates in the execution plan	2022-07-20 07:26:18
海外TECH	DEV Community	This Keyword in Javascript	https://dev.to/webfaisalbd/this-keyword-in-javascript-506p	This Keyword in JavascriptIn javascript this means immediate parent context But when you use this keyword in arrow function then it does not mean in immediate parent context It means self context Just see the two code output and think the difference between them var title awesome var statement name MERN lang Javascript getDetails function name normal function return lets see this name name title getDetails gt name arrow function return let us see this name name title Run getDetails function statement getDetails output lets see MERN normal function awesome again run getDetails function statement getDetails output let us see arrow function arrow function awesome here output is arrow function arrow function twice so we understand that our this name keyword does not mean parent name MERN	2022-07-20 07:24:57
海外TECH	DEV Community	Let's build a Youtube clone with Nextjs and Tailwind-css🎉	https://dev.to/sadeedpv/lets-build-a-youtube-clone-with-nextjs-and-tailwind-css-3i9n	Let x s build a Youtube clone with Nextjs and Tailwind cssThis is the preview of what we are going to buildHere is the live preview of the site and the link to the GitHub repo This tutorial is part of a series and In this part we will concentrate only on the website s design SETUP STEP Start by creating a new Next js project if you don t have one set up already The most common approach is to use Create Next App npx create next app my projectcd my project STEP Install tailwindcss and its peer dependencies via npm and then run the init command to generate both tailwind config js and postcss config js STEP Add the paths to all of your template files in your tailwind config js file module exports content pages js ts jsx tsx components js ts jsx tsx theme extend plugins require tailwind scrollbar hide STEP Add the tailwind directives for each of Tailwind s layers to your styles globals css file tailwind base tailwind components tailwind utilities STEP Clean up the boilerplate code and run the commandnpm run devIf you get stuck at the above steps at any point refer to this doc Installing other dependenciesNow before we start we have a couple of dependencies to download axios next react react avatar react dom react icons react loading skeleton react player react tooltip tailwind scrollbar hide Add these to your package json file and run the command npm install Component structureNow inside the tag of the index js file we will have these lines of codes lt main gt lt div gt lt Header gt lt div className grid grid cols mt gt lt Sidebar gt lt Body gt lt div gt lt div gt lt main gt At the root directory there will be the components folder where we will be creating a new file Sidebar js Sidebar jsimport Items from Data Items function Sidebar return lt div className flex flex col justify between ml mr col span z shadow sm md ml md mr hidden gt lt ul className flex flex col justify between gap fixed overflow y scroll h gt Items amp amp Items map item index gt return lt li className flex items center text center gap transition none p cursor pointer hover text gray md p key index gt item icon lt span className font semibold pr hidden lg block gt item name lt span gt lt li gt lt ul gt lt div gt export default SidebarInside the components folder we will create a new folder called data and create the file Items js import BsHouse BsCompass BsController BsFilm BsClockHistory BsCollectionPlay BsHandThumbsUp BsLightbulb BsTrophy BsGraphUp BsMusicPlayer BsGear from react icons bs export const Items name Home icon lt BsHouse size gt name Explore icon lt BsCompass size gt name Trending icon lt BsGraphUp size gt name Subscriptions icon lt BsCollectionPlay size gt name Gaming icon lt BsController size gt name Films icon lt BsFilm size gt name History icon lt BsClockHistory size gt name Likes icon lt BsHandThumbsUp size gt name Learning icon lt BsLightbulb size gt name Sports icon lt BsTrophy size gt name Music icon lt BsMusicPlayer size gt name Settings icon lt BsGear size gt That will be it for this part See you soon with the next part	2022-07-20 07:20:23
海外TECH	DEV Community	What are Hooks in React JS	https://dev.to/vamsitupakula_/what-are-hooks-in-react-js-4ejc	What are Hooks in React JS What are hooks in React JS 🪝 Hooks are the new addition in React They let you use state and other react features without writing a class Using hooks in react class components are no longer needed How to use Hook in react To use any react hook you must import it from react library There are Three Main Hooks in React JS useState useEffect useContext useState HookThe React useState Hook allows us to track the state in a functional componentState generally refers to data or properties that need to be tracked in an application import useState from react we initialize useState by passing the default value into the function useState accepts an initial state and returns two valuesThe current stateFunction to change the state import useState from react function Fun const name setName useState state hook useState Example useEffect HookuseEffect hook allows you to perform side effects in your functional components What does side effects mean like fetching data from an API updating DOM timers etc useEffect two parameters in which second one is optional useEffect lt function gt lt dependency gt If you do not pass second parameter useEffect will run on every render If you pass an empty array useEffect will run only on first render If you pass any prop or state as dependency then useEffect will run on first render and every time when dependency changes useEffect Example	2022-07-20 07:14:34
海外TECH	DEV Community	How to Display Images from Cloneable Fields - P3 - with Elementor	https://dev.to/wpmetabox/how-to-display-images-from-cloneable-fields-p3-with-elementor-2mhh	How to Display Images from Cloneable Fields P with ElementorIn this tutorial we ll continue the series of displaying images from cloneable fields using Meta Box and another page builder Elementor So here we go Here is my example Video VersionBefore Getting StartedTo get started we need the Meta Box core plugin to have the framework for creating custom fields It s free so you can download it directly from wordpress org For the extensions they re in the Meta Box AIO If you haven t had it you can download and install each extension individually The list of extensions we need for this tutorial is as follows Meta Box Settings Page to create settings pages Meta Box Builder to have an intuitive UI to create custom fields in the backend Meta Box Group to organize custom fields into cloneable groups where we input images MB Elementor Integrator to connect and display custom fields created by Meta Box plugin in the Elementor s dynamic tags Finally make sure you have Elementor Pro which has integration with Meta Box Step Create a Settings PageNormally we ll use a custom post type to create multiple posts for brands But today I will do it in a more convenient and simple way creating a setting page The information about all the brands will be inputted into that page It means that all of them will be in one place only Go to Meta Box gt Settings Page gt Add New Since the settings page contains the image and name of each brand only there s no special setting for it I just changed the option name After publishing you ll see a new settings page named Brands appears as below Step Create Custom Fields for the Settings PageNow let s create custom fields Go to Meta Box gt Custom Fields gt Add New I ll add fields with the following structure FieldTypes of FieldIDBrand GroupGroupbrand groupBrand Logo UploadSingle Imagebrand logo uploadBrand NameTextbrand nameThis is a group with subfields inside It is also set to be cloneable to have more spaces to add different brands information In addition I set this group as collapsible to collapse the information of the group field After that open the Settings tab and choose the Location as the settings page that we ve created to apply the custom fields to it Back to the settings page you will see the created custom fields appear and the sub fields are contained in the group field Moreover to add another brand s information press the Add more button Now enter the brand s information in the fields and go to the next step Step Create a SkinGo to Elementor Theme Builder gt choose Meta Box Group Skin gt Add new skin Set the settings for the skin as you want Then add the Image element to display the brand logo To get the image from custom fields created by Meta Box go to the Dynamic Tags and find the Meta Box Field Since the custom field we created is on the settings page we choose the Meta Box Field in the Site section Then choose the name of the field you want to get the image from For the brand s title add a Text Editor element Once again go to the Dynamic Tags and find the Meta Box Field in the Site section and choose the Brand Name option After that I ll style both elements a little bit Step Display the Logo Section on the Home PageLet s edit the homepage with Elementor First I add a widget to the homepage to create a section that contains brand information Add a Heading for it and style it as you want Next to display the brands logos add the Meta Box Group element Set Object Type as Settings page because we ve just input the data into a settings page After that it will set the created latest group by default Change it to the right one that you want All the data from the group will be displayed but there is no styling For styling choose the skin that you ve created above Then it will turn to the new look with the style of the created skin Also you can configure the display of the brand section such as the number of columns and the spacing between them Next drag and drop the section to your desired position on the homepage Here is the result we ve got Last WordsAs you can see displaying the images from cloneable fields with Meta Box and Elementor is so simple and easy to do without coding If you have any questions and ideas leave comments below and don t forget to keep track of our channel for more helpful tutorials	2022-07-20 07:10:10
海外TECH	CodeProject Latest Articles	HTML5 Event Calendar/Scheduler	https://www.codeproject.com/Articles/732679/HTML-Event-Calendar-Scheduler	calendar	2022-07-20 07:42:00
医療系	医療介護 CBnews	大学院2年+指定科目修了者も言語聴覚士に-厚労省が受験資格見直しの省令案を公表	https://www.cbnews.jp/news/entry/20220720163026	厚生労働省	2022-07-20 16:45:00
金融	RSS FILE - 日本証券業協会	公社債投資家別条件付売買(現先)月末残高 （旧公社債投資家別現先売買月末残高）	https://www.jsda.or.jp/shiryoshitsu/toukei/jyouken/index.html	条件	2022-07-20 09:00:00
金融	RSS FILE - 日本証券業協会	公社債店頭売買高	https://www.jsda.or.jp/shiryoshitsu/toukei/tentoubaibai/index.html	店頭	2022-07-20 09:00:00
金融	ニッセイ基礎研究所	コロナ禍からの「移動」の再生について考える－不特定多数の大量輸送から、特定少数の移動サービスへ	https://www.nli-research.co.jp/topics_detail1/id=71814?site=nli	コロナ禍からの「移動」の再生について考えるー不特定多数の大量輸送から、特定少数の移動サービスへ目次ーはじめにーコロナ禍における移動の減少国内における移動回数の減少移動距離の短縮高齢者の移動の減少ー移動手段の変化公共交通の減少、パーソナルな移動手段へのシフトー人とモノの輸送や自走に関わる事業者への影響旅客運送業の低迷と自動車小売業の回復基調宅配貨物運送業の好調旅客運送事業者の経営悪化ー移動減少が個人と地域社会にもたらす影響移動の減少による地域の経済社会への影響高齢者の移動減少による身体機能低下リスク人間関係の疎遠化と孤独、孤立の増加ー「移動」に求められる要素の変化不特定多数から「特定少数」へ相乗りへの意識「安全」と「安心」の違いー今後の移動サービスを考えるー終わりに※本稿は年月日発行「基礎研レポート」を加筆・修正したものである。	2022-07-20 16:50:33
ニュース	BBC News - Home	Fire services stretched as blazes follow record 40C UK heat	https://www.bbc.co.uk/news/uk-62232654?at_medium=RSS&at_campaign=KARANGA	incidents	2022-07-20 07:28:11
ニュース	BBC News - Home	Tory leadership: MPs to hold final vote before run-off	https://www.bbc.co.uk/news/uk-politics-62232539?at_medium=RSS&at_campaign=KARANGA	members	2022-07-20 07:05:37
ニュース	BBC News - Home	What is the UK inflation rate and why is the cost of living rising?	https://www.bbc.co.uk/news/business-12196322?at_medium=RSS&at_campaign=KARANGA	inflation	2022-07-20 07:26:14
ビジネス	ダイヤモンド・オンライン - 新着記事	米大学で進む統合再編、コロナで経営難加速 - WSJ発	https://diamond.jp/articles/-/306768	統合	2022-07-20 16:25:00
北海道	北海道新聞	巡視船の実弾誤射「人為的ミス」　沖縄、車の窓にひび	https://www.hokkaido-np.co.jp/article/707984/	人為的ミス	2022-07-20 16:35:00
北海道	北海道新聞	大阪で２万２０００人感染見通し　新型コロナ、過去最多	https://www.hokkaido-np.co.jp/article/707975/	新型コロナウイルス	2022-07-20 16:20:10
北海道	北海道新聞	厚労省職員を書類送検、大阪府警　ＩＴ化補助金詐取疑い	https://www.hokkaido-np.co.jp/article/707977/	中小企業	2022-07-20 16:14:31
北海道	北海道新聞	札幌市営地下鉄で人身事故　南北線全区間で運転停止	https://www.hokkaido-np.co.jp/article/707980/	人身事故	2022-07-20 16:17:00
北海道	北海道新聞	道南在住２８３人感染　函館は２１０人　新型コロナ	https://www.hokkaido-np.co.jp/article/707976/	道南	2022-07-20 16:05:00
ニュース	Newsweek	戦いを拒んで帰国し、迫害されるロシアの少数民族兵士	https://www.newsweekjapan.jp/stories/world/2022/07/post-99150.php	今回のケースが報道される前にも、ブリヤート共和国出身のロシア軍兵士人がウクライナでの戦闘を拒否して帰国していたことが、反戦団体によって報告された。	2022-07-20 16:14:35
IT	週刊アスキー	楽天モバイル、初めての契約で合計8000ポイント還元の新キャンペーン	https://weekly.ascii.jp/elem/000/004/098/4098630/	rakutenunlimitvii	2022-07-20 16:55:00
IT	週刊アスキー	バハムートや光の戦士にまつわる新たな物語が楽しめる！『FFオリジン』の追加ミッション「竜王バハムートの試練」が配信開始	https://weekly.ascii.jp/elem/000/004/098/4098621/	バハムートや光の戦士にまつわる新たな物語が楽しめる『FFオリジン』の追加ミッション「竜王バハムートの試練」が配信開始スクウェア・エニックスは、本日年月日にPlayStationPlayStationXboxSeriesXSXboxOnePCEpicGamesStore向けソフト『STRANGEROFPARADISEFINALFANTASYORIGIN』にて、追加ミッション「竜王バハムートの試練」の配信を開始した。	2022-07-20 16:40:00
IT	週刊アスキー	イタリアンテイストの低アルコールドリンクを飲みにいこう！　西新宿にあるオービカ モッツァレラバーで低アルコールドリンク4種&夏の食材を贅沢に使ったメニューを販売	https://weekly.ascii.jp/elem/000/004/098/4098583/	食材	2022-07-20 16:30:00
IT	週刊アスキー	夏の「丸亀うどん弁当」は「豚しゃぶ」「いわし天」「なす天おろし」のさっぱりトリオ	https://weekly.ascii.jp/elem/000/004/098/4098546/	丸亀製麺	2022-07-20 16:15:00
マーケティング	AdverTimes	ラッパー神門がマスクの内側にある高校生たちの想いを歌う、カロリーメイトWebムービー公開	https://www.advertimes.com/20220720/article390316/	youtube	2022-07-20 07:44:13
マーケティング	AdverTimes	アイフル、宣伝部長に寺坂氏（22年7月19日付）	https://www.advertimes.com/20220720/article390192/	部長	2022-07-20 07:20:49
マーケティング	AdverTimes	大阪コピーライターズ・クラブ「OCC賞」募集開始、審査委員長は直川隆久氏	https://www.advertimes.com/20220720/article390277/	作品募集	2022-07-20 07:01:38