投稿時間:2022-02-20 18:22:00 RSSフィード2022-02-20 18:00 分まとめ(25件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
IT	気になる、記になる…	Appleの整備済み商品情報 2022/2/20	https://taisy0.com/2022/02/20/152332.html	apple	2022-02-20 08:57:29
AWS	lambdaタグが付けられた新着投稿 - Qiita	【Serverless Framework】Lambda爆速開発	https://qiita.com/ymktmk_tt/items/9fff2e4c8846e1ff4449	【ServerlessFramework】Lambda爆速開発なぜServerlessFrameworkなのか私自身、LambdaのコードをGitで管理するためにTerraformGitHubActionsでCICD構築していましたがデプロイに時間がかかり開発効率が非常に悪いことやTerraformの記述量が多くなってシンプルに管理できないことがデメリットに感じていました。	2022-02-20 17:43:32
python	Pythonタグが付けられた新着投稿 - Qiita	『ソフィーのアトリエ』の調合をグラフ理論で考察してみる	https://qiita.com/hiragi-kaede/items/d366932cf9f1963cde92	networkxのspringlayoutという力学モデルを利用した点の配置アルゴリズムで定めたのですがそちらについて詳しくはこちら、装飾品や爆弾といった、調合した完成品を再び材料にして調合ができないものが外側に、カテゴリ水を持つなど、調合した完成品を材料として調合を行いやすいものが内側に集まっているようなのは面白い点ですね。	2022-02-20 17:45:49
python	Pythonタグが付けられた新着投稿 - Qiita	python ルーティング　まとめ	https://qiita.com/_NNN_/items/c51b7b242b6dbd8b671b	つの処理を追加しましたので、それぞれ次のように入力して表示を試してみます。	2022-02-20 17:27:37
python	Pythonタグが付けられた新着投稿 - Qiita	pythonのdebパッケージを作る	https://qiita.com/kanon700/items/9b35f4fb1aeecbc77ab0		2022-02-20 17:15:33
python	Pythonタグが付けられた新着投稿 - Qiita	AIによる自動応答機能付き「名言Bot」	https://qiita.com/jw-automation/items/cc7168e0f95fe0738014	というのも、これだけ様々な情報が意識せずとも目に飛び込んでくる日々の中で、日を振り返った時に、「どれだけ自分の頭を使って集中して思考が出来たのか」「自分の思考を言語化したり、自己との対話で自己認識を高めたりといった事メタ認知がどれだけできたか」という事を考えると、相当意識的にやろうとしないと、かなり難しくなっているなと感じたためです。	2022-02-20 17:05:02
js	JavaScriptタグが付けられた新着投稿 - Qiita	JavaScript83_基本データ型の変換	https://qiita.com/merikento/items/81258f8dda51617aa489	JavaScript基本データ型の変換ここで基本データ型を参照データ型Objectに変換するための方法を紹介する。	2022-02-20 17:10:13
AWS	AWSタグが付けられた新着投稿 - Qiita	【Serverless Framework】Lambda爆速開発	https://qiita.com/ymktmk_tt/items/9fff2e4c8846e1ff4449	【ServerlessFramework】Lambda爆速開発なぜServerlessFrameworkなのか私自身、LambdaのコードをGitで管理するためにTerraformGitHubActionsでCICD構築していましたがデプロイに時間がかかり開発効率が非常に悪いことやTerraformの記述量が多くなってシンプルに管理できないことがデメリットに感じていました。	2022-02-20 17:43:32
AWS	AWSタグが付けられた新着投稿 - Qiita	AIによる自動応答機能付き「名言Bot」	https://qiita.com/jw-automation/items/cc7168e0f95fe0738014	というのも、これだけ様々な情報が意識せずとも目に飛び込んでくる日々の中で、日を振り返った時に、「どれだけ自分の頭を使って集中して思考が出来たのか」「自分の思考を言語化したり、自己との対話で自己認識を高めたりといった事メタ認知がどれだけできたか」という事を考えると、相当意識的にやろうとしないと、かなり難しくなっているなと感じたためです。	2022-02-20 17:05:02
AWS	AWSタグが付けられた新着投稿 - Qiita	S3でアクセス不可になった時の解消方法	https://qiita.com/mo12ino/items/6c21f0aba95efad3c92e	Sでアクセス不可になった時の解消方法SでダッシュボードでACLが見れなくなったり、そのオブジェクトがアクセス不能になったことがあり、その解消方法を記録しておく。	2022-02-20 17:03:01
Docker	dockerタグが付けられた新着投稿 - Qiita	python ルーティング　まとめ	https://qiita.com/_NNN_/items/c51b7b242b6dbd8b671b	つの処理を追加しましたので、それぞれ次のように入力して表示を試してみます。	2022-02-20 17:27:37
Ruby	Railsタグが付けられた新着投稿 - Qiita	Rails 環境構築	https://qiita.com/YukiLulu0229/items/c58de85b21afe7a4cb95		2022-02-20 17:27:27
海外TECH	DEV Community	Google Ranking Algorithm 🤔	https://dev.to/dhanushnehru/google-ranking-algorithm-2c07	Google Ranking Algorithm Did you know Why does facebook rank no for gsvrnppl in Google Because gsvrnppl is Facebook typed every to the right of the keyboard keysf a c e b o o kGoogle may have considered mistyping happened amp would have built an algorithm for this For more insights consider lets stay connected via Twitter	2022-02-20 08:43:53
海外TECH	DEV Community	How to Implement Many-to-Many Relationships in Relational Databases	https://dev.to/erikwhiting88/how-to-implement-many-to-many-relationships-in-relational-databases-3311	How to Implement Many to Many Relationships in Relational DatabasesNearly any data model of non negligible complexity will include at least one if not several many to many relationships This relationship emerges when given two tables A and B instances of A could have many instances of B and instances of B could have many instances of A Successfully implementing this relationship is a bit of stumbling block for people new to working with or building databases However the strategy for implementing this relationship in relational databases is important to understand Believe it or not it s also not all that complicated Once you ve implemented this relationship a few times the strategy becomes rather intuitive However I remember this concept being one of the hardest ones for me and my classmates to finally understand when it was introduced in second year of undergrad Hopefully this article will help you internalize the many to many relationship like I eventually did What is the Many to Many Relationship The many to many mm relationship is a relationship that occurs in data modeling when two entities are related but neither belong to the other and both can have many instances of each other Here are some examples of many to many relationships a pet can have many owners and owners can have many petsa language can be spoken by many people and a person can speak many languagesa class can have many students and a student can be in many classesa venue can have many visitors and a visitor can visit many venuesTo better understand the many to many relationship let s briefly talk about the one to many relationship to see how the mm differs a country can have many cities but a city can only be in one countrya car company can make many car models but each car model is made by only one companyIn each of these examples note that there is a sense of one entity belonging to another Modeling One to Many in the DatabaseOne to many relationships are easy to model in the database For example consider the country city example The country India has many cities such as Mumbai Hyderabad and Kolkata but Kolkata only belongs to the country of India So in the database we probably have a Country table that looks like this Country table with Id and Name columnsAnd the City table plus relationship to the Country table would look like this Country City relationshipThis is simple enough and we can query for all cities in a country by simply writing something like SELECT City Name FROM City JOIN Country ON Country Id City CountryId WHERE Country Name India and we d get a result set including Mumbai Hyderabad Kolkata and more But this kind of modeling is easy and we ve only used it as an example to better understand our next section modeling the many to many relationship Modeling Many to Many in the DatabaseNow let s consider the more complex many to many relationship Specifically let s consider the instance of many people speaking many languages For example we might have a Person table and Language table like so Person and Language tablesNow suppose we have two people Erik and Lina Erik speaks English and Spanish Lina speaks English and Arabic This is what we mean by many to many relationships Lina speaks many languages English and Arabic and English is spoken by many people Erik and Lina So how do we relate the Person and Language tables to list out all of the languages a person speaks or all of the people that speak a language The answer is to create a new table the associative table The associative table sits between the two entities in a many to many relationship and actually has a one to many relationship with each That is given tables A and B and an associative table C A has many Bs through C and B has many As through C put another way A has many Cs B has many Cs but C has one A and one B Note The associative table are also sometimes called association bridge intermediary join junction crosswalk or linking table and there s probably many more names for it I learned the term “associative table in undergrad and I think that s its official name in relational theory so that s what we ll stick with in this article Let s make this more concrete by creating an associative table for the Person and Language relationship It s common practice to name association tables as an amalgamation of the tables they join so we ll call our associative table PersonLanguage I d create such a table with the following SQL CREATE TABLE PersonLanguage Id INT IDENTITY PRIMARY KEY PersonId INT FOREIGN KEY REFERENCES Person Id LanguageId INT FOREIGN KEY REFERENCES Language Id Notice that we specified two foreign keys on this table PersonId and LanguageId pointing to the Person and Language tables respectively The table structure now looks like this Now there will be a record in the PersonLanguage table for every language an individual Person speaks As a result there will also be a record in the PersonLanguage table for every person that speaks a Language If we want to see the list of languages Lina speaks we could run the following query SELECT l nameFROM PersonLanguage plJOIN Person p ON p id pl PersonIdJOIN Language l ON l Id pl LanguageIdWHERE p name Lina and we d get results like ResultsLikewise if we want a list of all the people that speak English we could run a query like this SELECT p nameFROM PersonLanguage plJOIN Person p ON p id pl PersonIdJOIN Language l ON l Id pl LanguageIdWHERE l name English This would give us the following results Results Extending the Associative TableThe above examples show the most basic implementation of building associative tables to break up many to many relationships The example PersonLanguage associative table above only has two columns besides its own ID column for pointing to Person and Language records We can actually add columns to this table as well and capture interesting information For example what if we wanted to record which language was a person s mother tongue In other words if Erik grew up speaking English and learned Spanish later but Lina grew up speaking Arabic and learned English later how would we capture that Thanks to the associative table the answer is pretty easy We just have to add a column to PersonLanguage that indicates if the Language record captured is the Person record s primary language In T SQL I d run the following ALTER statement ALTER TABLE PersonLanguage ADD PrimaryLanguage BITand set the PrimaryLanguage value to for languages the person learned from birth By capturing this data on the associative table we can now write a query to generate a report of every person and their mother tongue like so SELECT p name AS Person l Name AS Primary Language FROM PersonLanguage plJOIN Person p ON p id pl PersonIdJOIN Language l ON l Id pl LanguageIdWHERE pl PrimaryLanguage and we d get results like ResultsThat is just one example of how to extend the functionality of our database with associative tables ConclusionIn this brief article we learned how to break up many to many relationships in relational databases The general approach is to place an associative table between the two tables and have a one to many relationship with them Then we saw how we can use associative tables to capture nuanced data and create interesting reports This is an important concept to understand in any kind of software or data engineering work that uses relational databases As always I hope this was helpful to you and don t be afraid to contact me with any questions you might have	2022-02-20 08:27:30
海外TECH	DEV Community	Multiple menu drop-downs with vanilla js	https://dev.to/wyattmarshalldev/multiple-menu-drop-downs-with-vanilla-js-29d5	Multiple menu drop downs with vanilla jsI looked all over online to find a solution to multiple drop down menus in a navigation header but most of the solutions I found in tutorials involved duplicating a Javascript function that targets the individual ID of the parent container for the drop down A couple issues I found with this If each drop down has it s own function then more than one drop down can be open at the same time Clicking anywhere else on the page to close the drop down was tricky and confusing Now I know this is super simple to implement with something like Alpine js which in all reality I d probably use in the real world instead but I wanted to make this work with Vanilla JS so this was the solution I came up with If anyone has feedback I d really appreciate it	2022-02-20 08:27:21
海外TECH	DEV Community	Team Boma Coding Skills Training	https://dev.to/teambomareport/team-boma-coding-skills-training-4d9e	Team Boma Coding Skills TrainingTEAM BOMA CODING SKILLS This is to inform all Team Boma members that our programming training for HTML CSS JAVASCRIPT PHP AND MYSQL will commence on Wednesday rd Feb Register Login to your dashboard to rgister your desired courses Our available programming courses is in two plan Free planPaid planThe free plan basically deals with front end developer The paid plan is specifically meant for members who have interest in learning back end server side with just a sum of ₦ only Both the free and paid plans have specific online text editor for easy practising Each of the plan will be awarded with a certificate after the training Registration procedure All new members can register at previous member needn t to register again After successfull registration both the previous and new members can now login at Members can access their dashboard menu at the top left And then locate Team Boma Coding Skills at their dashboard menu and click on Course Registration to register their desired courses All paid courses can only be registered after successfull payment Members can update their selected courses if needed to select or unselect as the case maybe All Members who registered for paid courses can generate their receipt and keep it for references Registered Members should join the WhatsApp group provided at their dashboard All other needed and necessary instructions will be comminunicated to members during their course of training Best Regards TEAM BOMAsupport teamboma com	2022-02-20 08:20:13
海外TECH	DEV Community	Random Number Generator	https://dev.to/goonlinetools/random-number-generator-24cc	Random Number GeneratorThe Random Number Generator Tool generates unique random numbers This tool supports unlimited number generation Which means you can generate multiple numbers at a single time During this random number generation process it does not consume the device s internet What is random number generation Random number generation is a process by which often by means of a random number generator a sequence of numbers or symbols that cannot be reasonably predicted better than by random chance is generated How to generate random numbers Follow the steps given below to generate random numbers First open GoOnlineTools comSearch random number generatorClick on generate random number buttonScroll down a little bit to see generated numberRandom Number Generator is available in multiple languages English Random Number GeneratorSpanish Generador de numeros aleatoriosIndonesian Acak Angka	2022-02-20 08:18:52
海外TECH	DEV Community	Responsive Instagram Home Page	https://dev.to/adhnanshereef/responsive-instagram-home-page-nfh	Responsive Instagram Home Page Responsive Instagram Home PageIt s a Responsive Instagram Home Page Template using HTML and CSS It was created for web developers to create a full stack Instagram web application without having to design it Find the difference between original Instagram and this	2022-02-20 08:17:46
海外TECH	DEV Community	CI/CD CodePipeline Cross Account Deployment	https://dev.to/entest/cicd-codepipeline-cross-account-deployment-5e9d	CI CD CodePipeline Cross Account Deployment Cross Account CI CD PipelineSometimes we need to run the Pipeline in an account but deploy product into another account for Further sepratation between development and production envionmentProtect production environmentFor customer in another accountThis note follows the reference workshop here aws blog ci cd pipeline cross accountworkshop ci cid pipeline cross accountTodoPython CDK versionCloudFormation version Roles and policies created with CloudFormation Architecture Setup CDK projectcreate an empty directorymkdir cdk test cicd pipelineinit cdk projectcdk init language typescript Create a CodeCommit by a repository stackcreate lib repository stack tsimport aws codecommit from aws cdk lib import App Stack StackProps from aws cdk lib export class RepositoryStack extends Stack constructor app App id string props StackProps super app id props new aws codecommit Repository this CodeCommitRepo repositoryName repo this account Create a lambda stack for testing purposecreate lib lambda stack tsimport Stack StackProps from aws cdk lib import Construct from constructs import aws lambda from aws cdk lib const path require path export class LambdaStack extends Stack constructor scope Construct id string props StackProps super scope id props new aws lambda Function this CdkTsLambdaFunctionTest runtime aws lambda Runtime PYTHON handler handler handler code aws lambda Code fromAsset path join dirname lambda Build and check CDK generated stacks usr bin env nodeimport source map support register import as cdk from aws cdk lib import CdkTsCicdPipelineStack from lib cdk ts cicd pipeline stack import RepositoryStack from lib repository stack import LambdaStack from lib lambda stack const app new cdk App new CdkTsCicdPipelineStack app CdkTsCicdPipelineStack new LambdaStack app CdkTsLambdaStack new RepositoryStack app CdkTsRepositoryStack build and check stacksnpm install npm run buildcdk lsshould see multiple stackCdkTsCicdPipelineStackCdkTsLambdaStackCdkTsRepositoryStackDeploy a stack and test outputcdk deploy CdkTsLambdaStack Application StackThis is a smple lambda function with code from local assset folder The important thing is that CodeBuild will output DevApplicationStack template json in the artifact bucketCodeBuild will output ProdApplicationStack template json in the artifact bucketCloudFormation running in the production account need to access the artifact bucket in the dev environment that is why we need roles below This is the application stack which is a simple lambda api import aws lambda from aws cdk lib import aws apigateway from aws cdk lib import App Stack StackProps from aws cdk lib import as path from path export interface ApplicationStackProps extends StackProps readonly stageName string export class ApplicationStack extends Stack lambad code from public readonly lambdaCode aws lambda CfnParametersCode constructor constructor app App id string props ApplicationStackProps super app id props lambda code this lambdaCode aws lambda Code fromCfnParameters create a lambda function const lambda function new aws lambda Function this CdkTsLambdaApplicationFunction props stageName runtime aws lambda Runtime NODEJS X handler index handler code this lambdaCode environment STAGE NAME props stageName create an api gateway new aws apigateway LambdaRestApi this CdkTsApiGatewayRestApi props stageName handler lambda function endpointExportName CdkTsLambdaRestApiEndpoint props stageName deployOptions stageName props stageName lambda version alias function codedeploy CodePipeline StackThe CodePipeline lives in the dev account The CodePipeline need to deploy things into the production account Need to assume role which setup from the production account This role enables creating resources inside the productiona account const prodDeploymentRole aws iam Role fromRoleArn this ProdDeploymentRole arn aws iam product account id role CloudFormationDeploymentRole mutable false and this role enables accessing the S artifact from the production accountconst prodCrossAccountRole aws iam Role fromRoleArn this ProdCrossAccountRole arn aws iam product account id role CdkCodePipelineCrossAcccountRole mutable false CodeBuildBuild the lambda code Build the application stackstageName Build actions new aws codepipeline actions CodeBuildAction actionName Application Build project lambdaBuild input sourceOutput outputs lambdaBuildOutput new aws codepipeline actions CodeBuildAction actionName CDK Synth project cdkBuild input sourceOutput outputs cdkBuildOutput CodeDeployDeploy the application stack into the dev environmentstageName Deploy Dev actions new aws codepipeline actions CloudFormationCreateUpdateStackAction actionName Deploy templatePath cdkBuildOutput atPath DevApplicationStack template json stackName DevApplicationDeploymentStack adminPermissions true parameterOverrides props devApplicationStack lambdaCode assign lambdaBuildOutput sLocation extraInputs lambdaBuildOutput Deploy the application stack into the production environmentstageName Deploy Prod actions new aws codepipeline actions CloudFormationCreateUpdateStackAction actionName Deploy templatePath cdkBuildOutput atPath ProdApplicationStack template json stackName ProdApplicationDeploymentStack adminPermissions true parameterOverrides props prodApplicationStack lambdaCode assign lambdaBuildOutput sLocation deploymentRole prodDeploymentRole cfnCapabilities CfnCapabilities ANONYMOUS IAM role prodCrossAccountRole extraInputs lambdaBuildOutput Note to add the inline policy to the assume rolepipeline addToRolePolicy new aws iam PolicyStatement actions sts AssumeRole resources arn aws iam product account id role Note the KMS key which encrypt the S artifact bucketnew CfnOutput this ArtifactBucketEncryptionKeyArn value key keyArn exportName ArtifactBucketEncryptionKey Policy CodePipelineCrossAccountRoleThis allow the ProductionAccount when deploying CloudFormation can access the S ArtifactBucket where code for the Lambda function is stored Version Statement Action cloudformation iam PassRole Resource Effect Allow Action s Get s Put s ListBucket Resource arn aws s artifact bucket DEV ACCOUNT ID arn aws s artifact bucket DEV ACCOUNT ID Effect Allow Action kms DescribeKey kms GenerateDataKey kms Encrypt kms ReEncrypt kms Decrypt Resource KEY ARN Effect Allow Policy CloudFormationDeploymentRoleThis allow the CloudFormation in the ProductionAccount can create resources when deploying stacks developed from the develop account Version Statement Action iam PassRole Resource arn aws iam PROD ACCOUNT ID role Effect Allow Action iam GetRole iam CreateRole iam AttachRolePolicy Resource arn aws iam PROD ACCOUNT ID role Effect Allow Action lambda Resource Effect Allow Action apigateway Resource Effect Allow Action codedeploy Resource Effect Allow Action s GetObject s GetBucket s List Resource arn aws s artifact bucket DEV ACCOUNT ID arn aws s artifact bucket DEV ACCOUNT ID Effect Allow Action kms Decrypt kms DescribeKey Resource KEY ARN Effect Allow Action cloudformation CreateStack cloudformation DescribeStack cloudformation GetStackPolicy cloudformation GetTemplate cloudformation SetStackPolicy cloudformation UpdateStack cloudformation ValidateTemplate Resource arn aws cloudformation us east PROD ACCOUNT ID stack ProdApplicationDeploymentStack Effect Allow Connect to AWS CodeCommit by HTTPSGoto AWS IAM console and download credential to access AWS CodeCommitgit config global credential helper aws codecommit credential helper git config global credential UseHttpPath true	2022-02-20 08:16:17
海外TECH	DEV Community	The best remote company of 2021	https://dev.to/shman/the-best-remote-company-of-2021-2h10	The best remote company of was hard for everyone well honestly wasn t any better But for remote work it was a revolution Some companies stood up for the challenge and lead by example They started continue to use remote work async work style without cutting corners lowering pay etc I think we should show them some love in return That s why you can now vote for the best remote company of There is no big corporation or monetary prize behind it Let s show them gratitude as a community of remote workers Voting is open until March You can vote here	2022-02-20 08:07:49
海外ニュース	Japan Times latest articles	The fates of Ukraine and Taiwan aren’t necessarily linked	https://www.japantimes.co.jp/opinion/2022/02/20/commentary/japan-commentary/taiwan-ukraine-differences/	taiwan	2022-02-20 17:25:46
ニュース	BBC News - Home	Ferry fire: Missing Euroferry Olympia passenger found alive off Corfu	https://www.bbc.co.uk/news/world-europe-60451869?at_medium=RSS&at_campaign=KARANGA	stern	2022-02-20 08:01:11
北海道	北海道新聞	道南で１４４人感染　新型コロナ	https://www.hokkaido-np.co.jp/article/647985/	新型コロナウイルス	2022-02-20 17:09:00
マーケティング	AdverTimes	東京海上日動あんしん生命保険、社長に川本氏（22年4月1日付）	https://www.advertimes.com/20220220/article377354/	東京海上日動あんしん生命保険	2022-02-20 08:26:28
マーケティング	AdverTimes	JAL、デジタルイノベーション本部長に野田氏（22年4月1日付）	https://www.advertimes.com/20220220/article377351/	日本航空	2022-02-20 08:05:12