投稿時間:2023-01-26 11:16:21 RSSフィード2023-01-26 11:00 分まとめ(18件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
IT	ITmedia 総合記事一覧	[ITmedia Mobile] Y!mobileをオススメできる人、できない人【2023年1月】　家族で契約、毎月25GB以下なら断然お得	https://www.itmedia.co.jp/mobile/articles/2301/26/news100.html	itmediamobileymobile	2023-01-26 10:24:00
IT	ITmedia 総合記事一覧	[ITmedia News] 「アナログ7項目」の撤廃で法を一気に変える　デジタル副大臣が語る国の本気とは？	https://www.itmedia.co.jp/news/articles/2301/26/news076.html	itmedia	2023-01-26 10:20:00
IT	ITmedia 総合記事一覧	[ITmedia News] au PAY、請求書払いでのポイント還元廃止　4月から	https://www.itmedia.co.jp/news/articles/2301/26/news097.html	aupay	2023-01-26 10:17:00
IT	情報システムリーダーのためのIT情報専門サイト IT Leaders	日本オラクル、ガバメントクラウド移行支援の研修プログラムを自治体/パートナー向けに提供 | IT Leaders	https://it.impress.co.jp/articles/-/24360	日本オラクル、ガバメントクラウド移行支援の研修プログラムを自治体パートナー向けに提供ITLeaders日本オラクルは年月日、政府・地方公共団体のITシステムのガバメントクラウドへの移行を支援する施策を発表した。	2023-01-26 10:30:00
AWS	AWS for SAP	SAP and AWS Collaborate to Accelerate Demand and Digital Transformation for Customers	https://aws.amazon.com/blogs/awsforsap/sap-and-aws-collaborate-to-accelerate-demand-and-digital-transformation-for-customers/	SAP and AWS Collaborate to Accelerate Demand and Digital Transformation for CustomersThis was originally posted in the SAP News Center This post was jointly authored by Dan Finley global vice president and head of AWS Alliance at SAP RJ Bibby global SAP Alliance lead at Amazon Web Services SAP and Amazon Web Services AWS the world s most comprehensive and broadly adopted cloud platform are teaming to …	2023-01-26 01:10:47
js	JavaScriptタグが付けられた新着投稿 - Qiita	npm install -g {packageName}は古いと言われた	https://qiita.com/takuya_uemoto/items/6d6c4340f817954058e6	nodepackagee	2023-01-26 10:06:19
Azure	Azureタグが付けられた新着投稿 - Qiita	Azure Data Factory or Azure Synapse のパイプライン内で Key Vault シークレットを取得・利用する	https://qiita.com/ryoma-nagata/items/2bd321aa4ba345d21cc6	azure	2023-01-26 10:32:24
技術ブログ	Developers.IO	Amazon S3バケットを同期する際の検討ポイントをまとめてみた	https://dev.classmethod.jp/articles/s3-replication-best-practices/	amazons	2023-01-26 01:40:21
技術ブログ	Yahoo! JAPAN Tech Blog	ヤフー広告のAI広告審査システムCreativeTesterについて	https://techblog.yahoo.co.jp/entry/2023012630401867/?cpt_n=BlogFeed&cpt_m=lnk&cpt_s=rss	creativetester	2023-01-26 11:00:00
海外TECH	DEV Community	Supabase & Metamask Signed Authentication (Web3)	https://dev.to/59023g/supabase-metamask-signed-authentication-web3-53e1	Supabase amp Metamask Signed Authentication Web Supabase is a great tool But currently lacks the ability to natively use a Web Provider to authenticate This guide aims to provide a walkthrough so you ll be able to issue JSON web tokens to users who sign in with their Ethereum Wallet What you ll need Supabase accountJWT Key and Service KeySupabase public users tableA Client able to interact with Wallet Provider ethers js and MetaMaskServerless Function Endpoints api nonce api login api write I use Vercel This walkthrough assumes your user has already connected their wallet If you need help with that check out the ethers js documentation So once they ve connected the first thing we ll do behind the scenes in our client app code is make a POST request to the api nonce endpoint In it we ll include the just connected wallet address Supabase public users TableBefore we can get into the code we ll need to set up a new table in our Supabase project It s basically a copy of auth users Supabase s private built in Auth table This is necessary because Supabase does not allow you to query their Auth table by email or in our case Ethereum address address But why do we need to query it Well in order to manually sign a JWT auth token we need the user s id as it s stored in the auth users table So we ll need to store a copy ourselves We ll also store other user data as it comes up like a profile picture or email address Another value is the user s login nonce Which we ll get into in the next section Below you ll see what my public users table looks like with mock data Set Insert then Return NonceWhat s a nonce It s a one time use number we ll include in our api login request to add another layer of security This is where the api nonce endpoint comes into play And it s why we hit it first So once the server receives the request it ll generate a random nonce insert it to the proper public users database row then send the nonce back to the client Once we ve done all that then we ll have them sign message with this nonce Here s an idea what that endpoint would look like api nonceconst address req bodyconst nonce Math floor Math random await database from SUPABASE TABLE USER update auth genNonce nonce lastAuth new Date toISOString lastAuthStatus pending eq address address return res status json nonce Use the Nonce Sign a MessageThen once the client has received the nonce we ll then automatically prompt the user to sign a message in their wallet This message should include the address and nonce but can include whatever you want It s also usually a good idea from a UX perspective to inform the user this is off chain and costs no gas Not everyone is familiar with this concept If you ve used Opensea or most other Web apps I m sure you ve seen this On the client the code will look something like this client code prompt user to sign message in wallet const msg await state activeProvider send personal sign ethers utils hexlify ethers utils toUtfBytes message state address toLowerCase post sign message to api verify with nonce and address const verifyRequest await postData state config API URL api login signed msg nonce nonceRequest nonce address state address Then LoginNow for the fun part After the user has signed we hit the api login endpoint with their signed message and nonce Then we ll see if the user has an id yet in the public users table If not we ll invoke auth admin createUser to create a user in the auth users table which ll then return the id Once we have the id we ll insert it into our public users table along with any other information we need So in the future I can query to get an address s id I know it s a little awkward but it is a workaround Check out this code fragment from the server api login only run this code on server verify the signed message matches the requested address select from public user table where address matches verify the nonce included in the request matches what s already in public users table for that address if there s no public users id for that address then you need to create a user in the auth users table const data user error await supabase auth admin createUser email user email com user metadata address address insert response into public users table with id await supabase from SUPABASE TABLE USERS update auth genNonce newNonce update the nonce so it can t be reused lastAuth new Date toISOString lastAuthStatus success id user id same uuid as auth users table eq address address primary key lastly we sign the token then return it to clientNext we need to sign a token with our Supabase JWT then return it to the client This will allow us to create an RLS Policy so only a particular address can insert data to either the public users table as an updated profile for example Or to another table which contains off chain app data that only certain token holders can upload Whatever you d like It also introduces a concept of authenticated to your client app beyond just the standard wallet provider connection Another nice thing is the user won t have to sign a message everytime they enter your application They ll only need to do this again after their JWT expired Here s an example JWT creation api login const token jwt sign address address this will be read by RLS policy sub user id aud authenticated JWT expiresIn res status send token So now that the JWT token is on the client side we ll want to set up a Supabase RLS Policy for the public users table or any other table we want authenticated users to be able to write to Shout out to Grace Wang for the scoop on this This policy tells Postgres Supabase to decode the token then compare its address value with the row s column address If they re equal it ll allow the database write If not no luck We do this so only the logged in address can write to rows it owns And that s it Please let me know if you have questions or comments	2023-01-26 01:38:09
海外科学	NYT > Science	Ukraine’s Scientists Receive a Funding Lifeline From Abroad	https://www.nytimes.com/2023/01/25/science/ukraine-scientists-simons-foundation.html	biologists	2023-01-26 01:41:03
海外科学	NYT > Science	Biden Bans Roads, Logging in Alaska’s Tongass National Forest	https://www.nytimes.com/2023/01/25/climate/alaska-tongass-national-forest.html	Biden Bans Roads Logging in Alaska s Tongass National ForestThe U S Forest Service rule restricts development on more than nine million acres in North America s largest temperate rainforest reversing a Trump decision	2023-01-26 01:10:40
海外科学	BBC News - Science & Environment	Elms: England green farming subsidies detail unveiled	https://www.bbc.co.uk/news/science-environment-64399799?at_medium=RSS&at_campaign=KARANGA	environmental	2023-01-26 01:25:10
金融	ニッセイ基礎研究所	小・中学生のコロナ禍前後のマスクをつける頻度の変化	https://www.nli-research.co.jp/topics_detail1/id=73729?site=nli	任意の協力の下、調査会社のモニター会員を対象にして行った調査であること、子の年齢や性別について回収時に分布の調整等は行っていないこと、親が子の様子について回答した結果を用いていることから、本調査の分布は必ずしも日本全体の小・中学生の分布を示しているとは限らない点に注意が必要である。	2023-01-26 10:58:01
海外ニュース	Japan Times latest articles	Germany and U.S. to send battle tanks to help Ukraine fight off Russia	https://www.japantimes.co.jp/news/2023/01/26/world/germany-us-ukraine-tanks/	Germany and U S to send battle tanks to help Ukraine fight off RussiaSaying Ukraine now has a tank coalition Ukrainian President Volodymyr Zelenskyy praised the commitments and urged allies to provide large quantities of tanks quickly	2023-01-26 10:18:05
海外ニュース	Japan Times latest articles	England’s Launchbury says more players could move to Japan	https://www.japantimes.co.jp/sports/2023/01/26/rugby/launchbury-european-players/	toyota	2023-01-26 10:11:09
ニュース	BBC News - Home	Donald Trump to be allowed back onto Facebook and Instagram	https://www.bbc.co.uk/news/business-64408306?at_medium=RSS&at_campaign=KARANGA	president	2023-01-26 01:33:09
ニュース	BBC News - Home	Court bid to protect tenants from ‘ghost landlords’	https://www.bbc.co.uk/news/uk-64378930?at_medium=RSS&at_campaign=KARANGA	england	2023-01-26 01:35:43