投稿時間:2022-01-09 12:13:56 RSSフィード2022-01-09 12:00 分まとめ(16件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
TECH	Techable（テッカブル）	タイプミスなど25項目をチェック！ AI文章校正ツール「Shodo」無料版リリース	https://techable.jp/archives/170546	shodo	2022-01-09 02:00:09
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	Rのコンジョイント分析での直行表作成におけるエラー	https://teratail.com/questions/377277?rss=all	Rのコンジョイント分析での直行表作成におけるエラー前提・実現したいこと大学の課題でRによるコンジョイント分析を行っています。	2022-01-09 11:53:55
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	Arduinoのクラス作成の方法を教えていただきたいです	https://teratail.com/questions/377276?rss=all	Arduinoのクラス作成の方法を教えていただきたいですArduinoでのクラス作成・質問の内容Arduinoでクラスを作成して、LEDアレイを用いた演出に使うコードを組んでいたのですが、以下のエラーメッセージが発生しました。	2022-01-09 11:51:42
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	[Django] allauth のメール認証の件名に入ってしまうドメインを除去したい	https://teratail.com/questions/377275?rss=all	allauthを用いて新規登録時にメールを送るように設定をしているのですが、件名の先頭にexamplecomが入ってしまいます。	2022-01-09 11:09:45
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	MikanOS 開発環境の構築について	https://teratail.com/questions/377274?rss=all		2022-01-09 11:06:43
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	MySQLで片方のテーブルにしか存在しないデータを抽出したい	https://teratail.com/questions/377273?rss=all	クイズテーブルには、それぞれのユーザーが以前クイズで回答した単語の成績が追加されています。	2022-01-09 11:02:15
AWS	AWSタグが付けられた新着投稿 - Qiita	Minioを用いてAWSアカウントなしでS3接続（javaSDK)を確認する方法	https://qiita.com/shirochu0911/items/ae0c7ffa87b58d72dcc3	今後も、現場での知識や気になった技術などの投稿をしていきたいと思います。	2022-01-09 11:33:39
AWS	AWSタグが付けられた新着投稿 - Qiita	awsをterraformで構築するには(基本編)	https://qiita.com/IshinShibata/items/4dbf9bfa46b353fc2df5	awsをterraformで構築するには基本編プロバイダーを決めるterraformrequiredversiongtrequiredprovidersawsgtproviderawsaccesskeyvarawsaccesskeysecretkeyvarawssecretkeyregionvarawsregion変数定義terraformtfvarsにてawsaccesskeyxxxxxxxxawssecretkeyxxxxxxxxawsregionxxxxxxxxvariablestfの中でvariableawsaccesskeytypestringvariableawssecretkeytypestringvariableawsregiontypestringresourceの定義あとは例えばawsalbtfみたいなファイルを作ってファイルは分割しなくても動くが、基本分割した方が綺麗だし、わかりやすい、リソースの定義をする。	2022-01-09 11:02:51
AWS	AWSタグが付けられた新着投稿 - Qiita	VPC-S3の環境で、不正なデータ送信をAlarmする環境を、CloudFormationで構築する	https://qiita.com/a_b_/items/f1d53b70ea7f675e2049	VPCSの環境で、不正なデータ送信をAlarmする環境を、CloudFormationで構築するはじめに以前作成した、VPCの内部から不正なデータ送信のアラームを送信する環境と、Sの不正アクセスを検出する環境を、一つにしたCloudFormationを作成しました。	2022-01-09 11:02:02
Docker	dockerタグが付けられた新着投稿 - Qiita	Minioを用いてAWSアカウントなしでS3接続（javaSDK)を確認する方法	https://qiita.com/shirochu0911/items/ae0c7ffa87b58d72dcc3	今後も、現場での知識や気になった技術などの投稿をしていきたいと思います。	2022-01-09 11:33:39
海外TECH	DEV Community	How to Connect a React App to a Notion Database	https://dev.to/alexeagleson/how-to-connect-a-react-app-to-a-notion-database-51mc	How to Connect a React App to a Notion DatabaseAll code from this tutorial as a complete package is available in this repository If you find this tutorial helpful please share it with your friends and colleagues For more like it you can subscribe on Youtube or follow me on Twitter Table of ContentsWhat is Notion IntroductionProject SetupCreating a Notion DatabaseCreating the ServerQuerying the ServerCreating a Notion IntegrationQuerying the DatabaseConnecting the AppWrapping Up What is Notion Before we jump in I want to explain quickly a little bit what Notion is It s basically an organizational tool that runs in the cloud and supports multiple user collaboration at the same time It can be used for anything from organizing daily tasks keeping track of school schedules to managing the documentation of large enterprise projects Basically if you want to organize any kind of information Notion is a great tool for that Similar products you might be familiar with would be something like Confluence Evernote or OneNote IntroductionRecently I discovered that Notion provides an API to read and modify data on your Notion workspace They also have fantastic support for simple databases even relational ones so I thought it would be fun to try a little app that could use Notion as a quick and dirty CMS and I had a lot of fun doing it so I thought I would write up a little tutorial to share the process with others I want to be clear that I am absolutely not advocating for the use of Notion as a real database for a production application I do not know anything about the actual speed and performance of querying it at any scale and I also wouldn t trust any critical data on a service that isn t specifically designed to offer a reliability guarantee However for fun little projects I think it s a great option especially for front end developers who don t have a lot of existing knowledge about databases and just want to get their feet wet It can also be a great way to collaborate with less technical folks and allow them the flexibility that Notion offers for creating content and giving developers the ability to directly reference that content in code So without further delay let s play around with it Project SetupThe structure of our project will be React App gt Node server gt Notion databaseThe reason we need the Node server is because if we were to query directly from our React app we would have to expose our Notion account credentials and secret database ID Anything on the client side is always visible to the user By querying on the server we can keep the credentials there out of reach of the front end and only provide the database table data itself to the front end We ll begin by creating the project directory and React app We re using Create React App here as it s still the simplest way to get an instant React project up and running with minimal complexity mkdir react node notioncd react node notionnpx create react app latest sample app template typescriptcd sample appnpm run startMake sure you are able to see the example React app on http localhost before you continue Creating a Notion DatabaseNext we are going to create our Notion workspace and database Navigate to You can create an account or login with an existing Google or Apple account Notion is free to use for an individual Next we ll create a page where our database will live My database is going to help me keep track of stuff I want to learn in Click anywhere on the My Cool Project page and type page You ll have te option of creating a new page Create one and give it an icon Open your new page You can give it a cover image at the top CLick anywhere on the blank page and type database You re going to select Table Database Inline The first column should be a unique value our primary key I m simply going to name that column key The second column I will name label and the third column I will name url The key column will be of type title by default but you will need to set the label column to text and the url column to url I ve made the column headers lowercase on purpose since we will be referring to them with Javascript properties when we query which are traditionally lowercase I will be using this database to keep track of the things I want to learn and a URL link to the resource to learn them This is super simple but you can come up with anything as complex as you want we re mostly just here to give an example of how to query this data and display it in an app or anywhere you like really Populate the DB with whatever data suits you best Here s mine Creating the ServerWe re next going to spin up a super simple Node server to serve the data All we need is the http module and the Notion client library from NPM Let s begin with just the server and confirm we can query the data before we add the Notion integration Go back to the root directory react node notion before running these commands mkdir servercd servernpm init ynpm install D typescript types nodenpx tsc initmkdir srctouch src server tsIn case you aren t creating your files from the command line the above instructions will install the necessary packages and create a server directory and an src directory inside with a server ts file Your full directory structure for the entire project should look like ├ーsample app│└ー React app files └ーserver ├ーsrc │└ーserver ts ├ーtsconfig json ├ーpackage lock json └ーpackage jsonYour server ts file will look like server src server tsimport http from http const host localhost const port const server http createServer req res gt Avoid CORS errors res setHeader Access Control Allow Origin res setHeader Content Type application json switch req url Will respond to queries to the domain root like http localhost case res writeHead res end JSON stringify data success break Only supports the route default res writeHead res end JSON stringify error Resource not found server listen port host gt console log Server is running on http host port Your npx tsc init command will have created a tsconfig json file All the defaults are fine you just need to add one value tsconfig json outDir dist That will output the result of the tsc command into a dist folder with a JS file that you can run Give it a try by running npx tsc amp amp node dist server js That says run typescript and then use Node to run the resulting Javascript file it creates in the output folder Querying the ServerNavigate back to the sample app directory and open the src directory We can delete App css and the logo svg file We ll update the index css with some super simple CSS based off this minimalist style sample app src index csshtml max width ch padding em em margin auto line height font size em h h h h h h margin em em p ul ol margin bottom em color ddd font family sans serif Now we update the contents of App tsx Remove all the default content inside the file including the imports and replace it with the following sample app src App tsxfunction App return lt div gt lt h gt Things to Learn lt h gt lt button type button onClick gt fetch http localhost then response gt response json then payload gt console log payload gt Fetch List lt button gt lt div gt export default App We use the Fetch API to query the simple server we just wrote that we made listen on port and respond on the root domain route So that means to reach that endpoint we need to query http localhost Save and run your app then press the Fetch List button Open the dev console with F and you will see Notice the data success response there in the console Great Our React app is connected to our server and we can query basic data Let s get Notion hooked up Creating a Notion IntegrationBefore you can query data from your Notion account you need to create an integration that has the necessary permissions You can configure integrations to have different permissions like read write insert depending on who you are sharing the integration secret with Go to the following URL And click the big New Integration button on the left You can configure and name your integration how you like For mine I only want to be able to read content from my database so I am only giving it read permissions and no access to user data After you have created the integration you will be provided with a secret that gives access to your integration Keep this handy as we will need it soon In addition to the secret we also need to configure the database itself to be allowed to be read Go back to your Things to Learn database or whatever you wrote At the upper right corner of your database page is a Share button Click it and then click the Invite button You will have the ability to invite your new integration that you created to have access to this database It will still be private and hidden from the general public The two values you need to query this database from your Node app are the Notion secret which you already have and the database ID The database ID you can get from the URL when you are looking at your database The URL will look something like this In the above example your database id is the aaaaaaaaaaaaaaaaaaaaaa part before the question mark You now have everything you need to query the data Back to the Node server Querying the DatabaseWe are going to need a secure place to store our Notion secret and database ID If we put them in our code they will become visible to anyone who checks the source when we push to a remote repository To get around this we will store our credentials in a env file Inside your server directory create two new files note that both of them are hidden files that are prefix with a before the filename server envNOTION SECRET secret xxxxxxxxxxxxxxxxxxxxxx NOTION DATABASE ID aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa Where the dummy values above are replaced by the values you took from Notion Remember your secret key does need the secret prefix in front of it We also want to create a gitignore file server gitignore envdistnode modulesThis will tell git not to push your secret env file our your automatically generated dist folder when you commit While we re at it let s add a start script for our server that does the tsc build and runs the JS output server package json scripts start tsc amp amp node dist server js Alright Now that that is taken care of we just need two packages One is the official Notion client for Node and the other is dotenv library that will made it super simple to read your secret and database id values from that env file npm install notionhq client dotenvNote that I have locked Notion client to as the API may change since this is a relatively new product and I would like this tutorial to work for anyone who uses it in the future You can try running the latest build however you may need to refer to their documentation and make corrections if anything has changed Now we re going to update our server ts file We ll do it all at once but I ll add lots of comments to explain everything server src server tsrequire dotenv config import http from http import Client from notionhq client This is Typescript interface for the shape of the object we will create based on our database to send to the React app When the data is queried it will come back in a much more complicated shape so our goal is to simplify it to make it easy to work with on the front endinterface ThingToLearn label string url string The dotenv library will read from your env file into these values on process env const notionDatabaseId process env NOTION DATABASE ID const notionSecret process env NOTION SECRET Will provide an error to users who forget to create the env file with their Notion data in itif notionDatabaseId notionSecret throw Error Must define NOTION SECRET and NOTION DATABASE ID in env Initializing the Notion client with your secretconst notion new Client auth notionSecret const host localhost const port Require an async function here to support await with the DB queryconst server http createServer async req res gt res setHeader Access Control Allow Origin switch req url case Query the database and wait for the result const query await notion databases query database id notionDatabaseId We map over the complex shape of the results and return a nice clean array of objects in the shape of our ThingToLearn interface const list ThingToLearn query results map row gt row represents a row in our database and the name of the column is the way to reference the data in that column const labelCell row properties label const urlCell row properties url Depending on the column type we selected in Notion there will be different data available to us URL vs Date vs text for example so in order for Typescript to safely infer we have to check the type value We had one text and one url column const isLabel labelCell type rich text const isUrl urlCell type url Verify the types are correct if isLabel amp amp isUrl Pull the string values of the cells off the column data const label labelCell rich text plain text const url urlCell url Return it in our ThingToLearn shape return label url If a row is found that does not match the rules we checked it will still return in the the expected shape but with a NOT FOUND label return label NOT FOUND url res setHeader Content Type application json res writeHead res end JSON stringify list break default res setHeader Content Type application json res writeHead res end JSON stringify error Resource not found server listen port host gt console log Server is running on http host port Should be good We ll start the server with the new script we made in package json npm run start Connecting the AppA quick jump back into the React app and hit that Fetch Data button again If everything went well you will be greeted with the content of your database in your browser console You ve now got the data in your React app you can do whatever you want with it We could probably wrap up the tutorial here but let s make one final step of turning the data into an actual list of links sample app src App tsximport useState from react Copy the payload shape interface from our server We want to copy rather than import since we we won t necessarily deploy our front end and back end to the same placeinterface ThingToLearn label string url string function App A state value will store the current state of the array of data which can be updated by editing your database in Notion and then pressing the fetch button again const thingsToLearn setThingsToLearn useState lt ThingToLearn gt return lt div gt lt h gt Things to Learn lt h gt lt button type button onClick gt fetch http localhost then response gt response json then payload gt Set the React state with the array response setThingsToLearn payload gt Fetch List lt button gt Map the resulting object array into an ordered HTML list with anchor links Using index as key is harmless since we will only ever be replacing the full list lt ol gt thingsToLearn map thing idx gt return lt li key idx gt lt a href thing url target blank rel noopener noreferrer gt thing label lt a gt lt li gt lt ol gt lt div gt export default App And with that a click of the fetch button and we get a nice list of things to do which reflects the state of our Notion database and creates links to the relevant pages Go ahead try changing some text in your DB and hitting the button again Wrapping UpWell that s pretty neat Now that you know how to do this what cool projects can you think to build Remember that all code from this tutorial as a complete package is available in this repository Please check some of my other learning tutorials Feel free to leave a comment or question and share with others if you find any of them helpful How to use Node js to backup your personal filesIntroduction to Docker for Javascript DevelopersLearnings from React Conf How to Create a Dark Mode Component in ReactHow to Analyze and Improve your Create React App Production Build How to Create and Publish a React Component LibraryHow to use IndexedDB to Store Local Data for your Web App Running a Local Web ServerESLintPrettierBabelReact amp JSXWebpack The BasicsWebpack Loaders Optimizations amp Bundle AnalysisIf you find this tutorial helpful please share it with your friends and colleagues For more like it you can subscribe on Youtube or follow me on Twitter	2022-01-09 02:23:44
金融	ニュース - 保険市場TIMES	ソニー損保、「2022年　新成人のカーライフ意識調査」結果を発表	https://www.hokende.com/news/blog/entry/2022/01/09/120000	ソニー損保、「年新成人のカーライフ意識調査」結果を発表運転免許保有率はソニー損害保険株式会社以下、ソニー損保は年月日、「年新成人のカーライフ意識調査」の結果を発表した。	2022-01-09 12:00:00
海外ニュース	Japan Times latest articles	‘Amazing milestone’ as NASA fully deploys Webb telescope in space	https://www.japantimes.co.jp/news/2022/01/09/world/science-health-world/james-webb-telescope-unfold/	Amazing milestone as NASA fully deploys Webb telescope in spaceIts infrared technology will allow it to see the first stars and galaxies that formed billion years ago giving astronomers new insight into the	2022-01-09 11:16:20
ニュース	BBC News - Home	The Ashes: Joe Root receives another low blow	https://www.bbc.co.uk/sport/av/cricket/59925994?at_medium=RSS&at_campaign=KARANGA	The Ashes Joe Root receives another low blowNot for the first time this Ashes series Joe Root receives a low blow from a delivery by an Australian bowler as Pat Cummins hits him in all too familiar place	2022-01-09 02:21:54
北海道	北海道新聞	＜社説＞道内も感染拡大　医療体制の点検万全に	https://www.hokkaido-np.co.jp/article/631436/	感染拡大	2022-01-09 11:20:04
IT	週刊アスキー	セブンイレブンに帯広の名店「ぶたはげ」監修の「豚丼」	https://weekly.ascii.jp/elem/000/004/079/4079866/	炭火焼き	2022-01-09 11:45:00