投稿時間:2022-06-16 20:25:38 RSSフィード2022-06-16 20:00 分まとめ(33件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
ROBOT	ロボスタ	ファミリーロボット「BOCCO emo」がフレイル予防をサポート 3社合同実証で体力年齢マイナス27歳の若返りを達成	https://robotstart.info/2022/06/16/bocco-emo-frail-prevention.html	ファミリーロボット「BOCCOemo」がフレイル予防をサポート社合同実証で体力年齢マイナス歳の若返りを達成シェアツイートはてブ「ロボティクスで、世界をユカイに。	2022-06-16 10:32:10
IT	ITmedia 総合記事一覧	[ITmedia News] 月面探査ロボット「SORA-Q」と同じサイズ、同じ動きの玩具、タカラトミーが発売へ	https://www.itmedia.co.jp/news/articles/2206/16/news197.html	itmedia	2022-06-16 19:35:00
IT	ITmedia 総合記事一覧	[ITmedia News] マネーフォワード、インボイス制度向け機能に対応　消費税申告機能を追加	https://www.itmedia.co.jp/news/articles/2206/16/news193.html	itmedia	2022-06-16 19:10:00
AWS	AWS Japan Blog	Amazon AthenaとAmazon QuickSightでAmazon Connectの問い合わせ追跡レコードを分析する Part2	https://aws.amazon.com/jp/blogs/news/analyze-amazon-connect-contact-lens-using-contact-trace-record-amazon-athena-and-amazon-quicksight-part-2/	amazonath	2022-06-16 10:56:38
AWS	lambdaタグが付けられた新着投稿 - Qiita	いろんなことに引っかかりながらAPI Gateway⇔Lambdaを試す	https://qiita.com/kiii142/items/66301d8472b349241920	apigateway	2022-06-16 19:12:39
python	Pythonタグが付けられた新着投稿 - Qiita	いろんなことに引っかかりながらAPI Gateway⇔Lambdaを試す	https://qiita.com/kiii142/items/66301d8472b349241920	apigateway	2022-06-16 19:12:39
AWS	AWSタグが付けられた新着投稿 - Qiita	【備忘録】AWS実装の要点まとめ	https://qiita.com/Cobochan-O/items/9151d7716b4d51fdd5f5	catalina	2022-06-16 19:46:34
AWS	AWSタグが付けられた新着投稿 - Qiita	いろんなことに引っかかりながらAPI Gateway⇔Lambdaを試す	https://qiita.com/kiii142/items/66301d8472b349241920	apigateway	2022-06-16 19:12:39
海外TECH	MakeUseOf	What Is a Three-Way Handshake and How Does It Work?	https://www.makeuseof.com/what-is-three-way-handshake-how-does-it-work/	communication	2022-06-16 10:45:13
海外TECH	MakeUseOf	5 Features We Want to See on the iPhone 14 Pro	https://www.makeuseof.com/features-we-want-iphone-14-pro/	apple	2022-06-16 10:31:04
海外TECH	MakeUseOf	Xbox Keystone Leak, DOOM in Everything, Save Scumming, Windows Keyboard Shortcuts, and High Resolution Wallpapers	https://www.makeuseof.com/xbox-keystone-doom-in-everything-save-scumming-windows-shortcuts-high-res-wallpapers/	Xbox Keystone Leak DOOM in Everything Save Scumming Windows Keyboard Shortcuts and High Resolution WallpapersWe bring you the latest news on Xbox Keystone explain some Windows keyboard shortcuts and where to find high resolution desktop wallpapers	2022-06-16 10:30:14
海外TECH	DEV Community	Using Google Sheets as your CMS	https://dev.to/kaspera/using-google-sheets-as-your-cms-1h1p	Using Google Sheets as your CMSSpreadsheets They are everywhere  Managers especially seem to love them which is why the world properly would stop functioning without them  Like some twisted version of Murphy s law it seems that anything that can fit into a spreadsheet eventually will end up in a spreadsheet This can result in abominations like a Microsoft Excel database for Covid results Well following in the spirit of using spreadsheets other ways than intended I thought what if we could use a Google Sheet as a CMS Hold on Hold on Lower your pitchforks and torches this is merely a proof of concept to see how it could work However there might be some use cases for this stick around to the end to find out So first thing first how do we do it in a performant way We could set up a script to generate a static site which is something other developers also have played around with before However we don t want to have to trigger a build each time we push a change in our sheet We want to be able to use SSR ISR or CSR in a performant way What we want to do is decouple our Google Sheets so that it only works as a CMS and not a database  Luckily decoupling data is where Enterspeed really shines So let s get to it Step Set up a Google SheetFirst start by creating a Google Sheet In our example we re going to make a list containing all the movies from the best movie series in the world  No not Marvel or Star Wars I m of course talking about the one and only Olsen Banden The Olsen Gang The list contains the following columns The number it has in the series Number The movies name Name Which year it was produced Year A link to the movie cover image Image A link to its IMDB page IMDB A short description Description All content above is shamelessly copied from IMDB com Now that we have all of our data it s time for step setting up a script that ingests all the data into Enterspeed Step Set up a Google Apps ScriptInside your Google Sheet click on Extensions and select Apps script First we create a function called ingestToEnterspeed Next we declare two const to make the code easier to read sheet which equals SpreadsheetApp getActiveSheet   this grabs our active sheet   sheetData which equals  sheet getDataRange getValues this grabs all the data from the active sheet Now we take our sheetData const and run a  forEach function We grab the index i of each so we can Skip the first row since this is the header Know which row number to grab data fromSince our row numbers unlike our index don t start at we declare a const called rowNumber which equals i Next we declare a const for the ingest URL to Enterspeed  ingestUrl The part after v will be our originId inside Enterspeed and needs to be unique  Since we re only going to be ingesting Olsen banden movies we will simply use olsen banden the movie s number in the series here found in column A We could also have made a function that grabs the sheet name and combines it with the row number instead to make it more dynamic The function we use to grab the cells content is  sheet getRange A rowNumber getValue   this takes the active sheet finds the defined column for the defined row number and gets the value Now we create an object called payload which specifies what we will send to Enterspeed In the object we need to define three properties A type in our case we simply call it movie A URL if we want it to be routable if not we can simply write null Properties which is our actual contentOur URL follows the same pattern as our originId olsen banden the movie number Inside the properties object we define all the data which we wish to use The name of the keys can be whatever you like to keep it simple we just matched the name of our columns Then we use the same function as before to grab the content from the cell we want  Once we have defined our data payload we need to make an options object which we will use in our fetch function  Create a method property and set it to post Then create a headers object where you define a x api key property Insert the API key for your data source which you have created inside Enterspeed Lastly create a payload property and insert JSON stringy payload Next for and giggles we can choose to log out each row inside Google Apps Script to see what s going on using Logger log Ingesting row Now it s time to ingest the data using the build in UrlFetchApp   Use the  fetch  method and set  ingestUrl  and  options as parameter  UrlFetchApp fetch ingestUrl options Click Save project and then click Run You should now be able to see your content inside Enterspeed Hooray As a bonus we can create a function that adds a menu item to your Google Sheets menu This makes it easier to ingest data from the sheet Google Apps Scripts even support triggers which means you can set it up to ingest at time driven events That s pretty neat Now that we got all of our data into Enterspeed it s time to create a schema that generates the view we wish to use Step Create a schema in EnterspeedOpen Enterspeed and create a new schema We re going to create a collection schema which generates a single view for all the movies Since we have ingested all of our rows individually with the URL property we also have the option to make separate pages for each movie However for now we will simply make a collection schema We start by setting up our triggers where we define which data source it should use and which source entity type the  type  we defined in our payload object earlier We then choose how we should be able to get the content this can be either via a handle or via a URL In our case we choose a handle called movies In the properties object is where we define the actual content We create a property called movies which have the type array In the input property which is where we define the items collection we want to work with we use the  lookup and the filter method to find source entities with the type movie For ease of use we set the collection iteration variable name to movie instead of the default item using the var property Under items which is used for mapping results we choose to grab all the data and wrap them in an object called movie We re able to grab all the data by using dynamic mapping That s it Then we save the schema and deploy it to the environment we wish All that s left now is to fetch the data from the frontend Step Fetching the dataNow to actually show the data  We fetch it using the Enterspeed Delivery API We call the URL and add the handle we wish to fetch here movies   In our headers we insert our Environment Client API key in the X Api key property Afterward we iterate over all the movies and insert them into a card component in this case we have used Bootstrap Voilà We have successfully used Google Sheets as a CMS but is this merely a proof of concept or Google Sheets as a CMS madness So could Google Sheets work as a CMS In my opinion yes Now I know what you re thinking   Madman You re a madman No man developer or client should use Google Sheets as a CMS But oh I ve chosen my words carefully P s if you don t get the reference  here you go Which CMS you should use all depends on the use case Should you use Google Sheets for a blog Properly not A full fledge company website Also no But say you are a small café that often switches up its menu and wants to display the dish of the day Or a small soccer club that wishes to showcase all their players Then yes it could definitely work Since we decouple the data from the actual Google Sheets it doesn t really matter performance wise where you edit your data Also Enterspeed allows you to transform and combine multiple data sources which means you could use Google Sheets only for a small section of your site e g your team section So the moral of the story is once you have decoupled your data it doesn t really matter how where you edit it I hope you enjoyed the article You can find all the code used here	2022-06-16 10:02:15
Apple	AppleInsider - Frontpage News	Apple renews 'Swagger' basketball drama for a second season	https://appleinsider.com/articles/22/06/16/apple-renews-swagger-basketball-drama-for-a-second-season?utm_medium=rss	Apple renews x Swagger x basketball drama for a second seasonApple TV has picked up its Swagger basketball series inspired by Kevin Durant for a second run Jason Rivera and Ozie Nzeribe in Swagger Swagger chronicles the life of Durant in youth basketball but is an ensemble show following players coaches and families in this world Read more	2022-06-16 10:24:45
Apple	AppleInsider - Frontpage News	Camo Studio iPhone-as-webcam app introduces new video overlays	https://appleinsider.com/articles/22/06/16/camo-studio-iphone-as-webcam-app-introduces-new-video-overlays?utm_medium=rss	Camo Studio iPhone as webcam app introduces new video overlaysCamo an app that lets iPhones be used as a webcam has released an update with a new drag and drop overlay feature for video calls recordings and livestreams Credit CamoVersion of the Camo Studio app which is made by U K developer Reincubate brings several new features to the iPhone as webcam application It s currently available as a free update to existing users Read more	2022-06-16 10:22:11
金融	金融庁ホームページ	無登録で金融商品取引業を行う者の名称等について更新しました。	https://www.fsa.go.jp/ordinary/chuui/mutouroku.html	金融商品取引業	2022-06-16 11:00:00
金融	金融庁ホームページ	金融審議会「市場制度ワーキング・グループ」（第18回）議事録について公表しました。	https://www.fsa.go.jp/singi/singi_kinyu/market-system/gijiroku/20220520.html	金融審議会	2022-06-16 11:00:00
ニュース	BBC News - Home	Dom Phillips and Bruno Pereira: Suspect leads police to human remains	https://www.bbc.co.uk/news/world-latin-america-61820607?at_medium=RSS&at_campaign=KARANGA	bruno	2022-06-16 10:42:49
ニュース	BBC News - Home	Lord Geidt quits: No 10 publishes resignation letter to PM	https://www.bbc.co.uk/news/uk-politics-61822998?at_medium=RSS&at_campaign=KARANGA	geidt	2022-06-16 10:44:13
ニュース	BBC News - Home	Kevin Spacey granted bail over sexual assault charges	https://www.bbc.co.uk/news/uk-61823521?at_medium=RSS&at_campaign=KARANGA	crown	2022-06-16 10:33:57
ニュース	BBC News - Home	Rwanda asylum plan: European court intervention was wrong, says Raab	https://www.bbc.co.uk/news/uk-61822584?at_medium=RSS&at_campaign=KARANGA	human	2022-06-16 10:25:13
ニュース	BBC News - Home	Renting: No-fault evictions to be banned in England	https://www.bbc.co.uk/news/uk-61817249?at_medium=RSS&at_campaign=KARANGA	benefit	2022-06-16 10:12:56
ニュース	BBC News - Home	Hospital waiting list 6.5 million in England	https://www.bbc.co.uk/news/health-61825071?at_medium=RSS&at_campaign=KARANGA	surgery	2022-06-16 10:16:59
ニュース	BBC News - Home	Beyoncé announces her first album in six years, Renaissance	https://www.bbc.co.uk/news/entertainment-arts-61825319?at_medium=RSS&at_campaign=KARANGA	renaissancethe	2022-06-16 10:26:20
ニュース	BBC News - Home	'Dom was one of the best - quiet but curious'	https://www.bbc.co.uk/news/world-latin-america-61825791?at_medium=RSS&at_campaign=KARANGA	brazil	2022-06-16 10:25:22
北海道	北海道新聞	食べログの「独禁法違反」を認定　不利益認識し計算手法を変更	https://www.hokkaido-np.co.jp/article/694384/	食べログ	2022-06-16 19:23:00
北海道	北海道新聞	ガンダムをトミカで再現　玩具２社がコラボ事業	https://www.hokkaido-np.co.jp/article/694379/	玩具	2022-06-16 19:18:00
北海道	北海道新聞	広島市長、会議初日スピーチ予定　ウィーンで核廃絶訴え	https://www.hokkaido-np.co.jp/article/694383/	広島市長	2022-06-16 19:22:00
北海道	北海道新聞	王鵬、先輩の琴ノ若らと１７番　佐渡ケ嶽部屋で申し合い	https://www.hokkaido-np.co.jp/article/694381/	佐渡ケ嶽	2022-06-16 19:21:00
北海道	北海道新聞	デジタル学び直し団体発足　グーグル主導、５０万人育成	https://www.hokkaido-np.co.jp/article/694380/	日本法人	2022-06-16 19:21:00
北海道	北海道新聞	韓国、法人・不動産税減税　初の経済政策	https://www.hokkaido-np.co.jp/article/694372/	経済政策	2022-06-16 19:09:00
北海道	北海道新聞	高木美帆、ＮＴ離れ活動へ　デビット氏師事を継続	https://www.hokkaido-np.co.jp/article/694371/	北京冬季五輪	2022-06-16 19:08:00
IT	週刊アスキー	プレイするたびに体験が変化！ロードトリップADV『Road 96』がPlayStationとXboxで本日発売	https://weekly.ascii.jp/elem/000/004/094/4094985/	digixart	2022-06-16 19:30:00
IT	週刊アスキー	JOJOの闘いをひと足先に体験！『ジョジョの奇妙な冒険 オールスターバトル R』期間限定体験版をPS Storeで配信開始	https://weekly.ascii.jp/elem/000/004/094/4094984/	JOJOの闘いをひと足先に体験『ジョジョの奇妙な冒険オールスターバトルR』期間限定体験版をPSStoreで配信開始バンダイナムコエンターテインメントは、PlayStationPlayStationNintendoSwitchXboxSeriesXSXboxOnePCSteam用ソフト『ジョジョの奇妙な冒険オールスターバトルR』にて、PlayStationStoreで期間限定早期体験版を年月日より配信開始。	2022-06-16 19:10:00