投稿時間:2023-01-19 13:25:14 RSSフィード2023-01-19 13:00 分まとめ(28件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
ROBOT	ロボスタ	小中学生向けの科学雑誌『子供の科学』がロボット体験モニターを募集中 ロボットと1カ月過ごして楽しかった出来事を報告しよう	https://robotstart.info/2023/01/19/kodomonokagaku-robot-monitor.html		2023-01-19 03:16:53
IT	ITmedia 総合記事一覧	[ITmedia PC USER] MSI、170Hz駆動に対応した曲面27型WQHDゲーミング液晶ディスプレイ	https://www.itmedia.co.jp/pcuser/articles/2301/19/news121.html	gcqpe	2023-01-19 12:14:00
IT	ITmedia 総合記事一覧	[ITmedia ビジネスオンライン] 2022年秋ドラマ満足度ランキング　3位『silent』、2位『エルピス―希望、あるいは災い―』、1位は？	https://www.itmedia.co.jp/business/articles/2301/19/news101.html	filmarks	2023-01-19 12:09:00
IT	ITmedia 総合記事一覧	[ITmedia ビジネスオンライン] ファミマ、「地域対抗！シュークリーム王決定戦」の結果発表　目指すは「わくわく働けるお店」の実現	https://www.itmedia.co.jp/business/articles/2301/19/news118.html	itmedia	2023-01-19 12:07:00
IT	ITmedia 総合記事一覧	[ITmedia News] 電動キックボード、7月1日から免許不要に　条件は最高速度20km以下など　時速6km以下なら歩道も走行	https://www.itmedia.co.jp/news/articles/2301/19/news117.html	itmedia	2023-01-19 12:02:00
python	Pythonタグが付けられた新着投稿 - Qiita	Cupyの環境構築[Windows10]	https://qiita.com/SHRNAK/items/e6d6d78f7459d6887ef1	windows	2023-01-19 12:37:05
python	Pythonタグが付けられた新着投稿 - Qiita	【Python】Pythonでディレクトリ（フォルダ）を作成する方法（os.makedirs）	https://qiita.com/takuma-1234/items/4cf00f4b15a68d36b663	osmakedirs	2023-01-19 12:25:24
Git	Gitタグが付けられた新着投稿 - Qiita	Git fatal: destination path 'ファイル名' already exists and is not an empty directory.を解決	https://qiita.com/aogangcun/items/3b087645d22ff6052a72	ationpathredeliveryappa	2023-01-19 12:34:23
Git	Gitタグが付けられた新着投稿 - Qiita	git fetchについて	https://qiita.com/72_mikan/items/267a802171f798b76695	gitfetch	2023-01-19 12:02:31
技術ブログ	Developers.IO	AWS SAM CLIのvalidate経由でcfn-lintが実行できるようになりました	https://dev.classmethod.jp/articles/update-aws-sam-cli-add-cfn-lint-check/	validateawsserve	2023-01-19 03:08:08
海外TECH	DEV Community	Building A (Really) Simple Blog with Google Sheets as the Database	https://dev.to/daviduzondu/building-a-really-simple-blog-with-google-sheets-as-the-database-4db4	Building A Really Simple Blog with Google Sheets as the DatabaseBefore we get into it here is a preview of what we are going to be building today Google Sheets is a powerful tool that can be used to store and organize data it can technically be used as a database for a blog However it is not advisable to use Google Sheets as a database for a blog because it is not ACID compliant ️WarningACID is an acronym that stands for Atomicity Consistency Isolation and Durability which are the four key properties of a database that ensures data integrity and reliability Google Sheets as a spreadsheet application does not offer the same level of data integrity and reliability as a traditional database that is ACID compliant In this easy to follow step by step tutorial I will be showing you an easy way to build a very simple blog with Google Sheets as the database We will be creating a custom API which will allow us to fetch data from our spreadsheet manipulate that data and display them on our page Who can follow this tutorial Basically anyone with some basic understanding of JavaScript and how the Fetch API works Project SetupFirst we ll need a text editor Notepad is a great option if you are low on system resources and a Google Account obviously Setting up your main API and connecting it to Google SheetsHead over to docs google com and sign in with your Google Account if you are prompted to do so Click on the navigation menu on the top right hand side of the page and select Sheets You will be directed to a page where you can click the icon to create a new sheet Once the new sheet is created we will need to get the spreadsheet ID Getting the spreadsheet ID is fairly simple If the URL to your spreadsheet is gid then your spreadsheet ID is AxVnqOgcuhrrPtVWIEiQRMAgYILuReg xBQ Navigate to the A cell and type in the word Title After doing that click on B and type in the word Content Alright so far all we have now is a spreadsheet and a column for the title another column for the content Now we are going to create an API that will allow us to retrieve data from our spreadsheets and return an array of objects Each object should contain the keys Title Content and an id On the menu bar click on the Extensions button and select Apps Script You will be redirected to a new tab with a code editor Add the following function to your code function getSheetData var sheet SpreadsheetApp getActiveSheet var data sheet getDataRange getValues var jsonData for var i i lt data length i var row data i var obj for var j j lt row length j obj sheet getRange j getValue row j obj id i jsonData push obj return jsonData The getSheetData function retrieves all the data from the active sheet in the spreadsheet converts it to an array of objects with each object representing a row of data from the sheet It uses two nested loops to iterate through the data the outer loop iterates through each row and the inner loop iterates through each cell of the row The outer loop uses the index i to reference the current row and the inner loop uses the index j to reference the current cell of the current row The sheet getRange j getValue function is used to get the header value of the current column which is used as the key of the object Now we need a function that receives the GET request calls the getSheetData function and uses the ContentService createTextOutput method to create a text output with the JSON data and convert it using JSON stringify The setMimeType method is used to set the MIME type of the response to application json so that the browser knows to interpret the response as JSON So go ahead and add the following function to your code function doGet e var jsonData getSheetData return ContentService createTextOutput JSON stringify jsonData setMimeType ContentService MimeType JSON Your final code should look something like this function getSheetData var sheet SpreadsheetApp getActiveSheet var data sheet getDataRange getValues var jsonData for var i i lt data length i var row data i var obj for var j j lt row length j obj sheet getRange j getValue row j obj id i jsonData push obj return jsonData function doGet e var jsonData getSheetData return ContentService createTextOutput JSON stringify jsonData setMimeType ContentService MimeType JSON Deploying our APIClick on the Deploy button in the top menuA dialog box should appear on the screen Click on the Settings icon and select Web App Click on the icon again and select Library In the Execute the app as field select your Google account In the Who has access to the app field select Anyone Click on the Deploy button A dialog box will appear with the Current web app URL which you can use to access your web app The web app URL is the API link NoteIf this is your first time using Apps Script you might get a menu that says The Web App requires you to authorize access to your data Click on Authorise access A window will open for you to sign in with your Google Account You will be presented with a warning screen that tells you that Google has not verified the web app Click the Advanced link and click the Go to project unsafe link You will then be presented with an authorization screen where you must click Allow in order to proceed When you deploy a Google Apps Script as a web app it will be accessible via a unique URL The format of this URL is determined by the configuration of the deployment By default the URL will be in the following format SCRIPT ID exec Where SCRIPT ID is a unique identifier for your script The SCRIPT ID can be found in the Apps Script editor by clicking on the Project settings button in the top right corner of the window it will be in the top right corner of the page under the Project ID header Setting up another API for the number of rowsFor this project we will need another API that will tell us the number of rows in the spreadsheet Since each row represents a single blogpost the total number of blogposts is simply the number of rows in the spreadsheet So if our spreadsheet contains three rows it means that there are two blogposts because each cell in the firstrow contains the title of each column Just we did previously head over to Extensions gt Apps Script On the side bar navigate to files and click the icon to create a new file Name the file length gs or whatever you feel like Paste the following code in the editor function doGet e     var spreadsheet   SpreadsheetApp openById SHEET ID   var sheet   spreadsheet getActiveSheet   var rowCount   sheet getLastRow   return ContentService createTextOutput rowCount This script that is triggered when a GET request is sent to the script s endpoint The function doGet e is the entry point of the script and it is automatically triggered when the script is accessed via a GET request e is an object that contains information about the request This script uses the SpreadsheetApp class from the Google Apps Script API to access a specific spreadsheet identified by its ID Then it opens the spreadsheet by its ID using SpreadsheetApp openById SHEET ID and retrieves the active sheet using getActiveSheet method After that it retrieves the number of rows in the sheet using getLastRow method Finally it returns the number of rows as the response to the GET request using ContentService createTextOutput rowCount Populating our spreadsheet cellsNow we are done with our APIs it is time to start inputting some data in the spreadsheet The Title column is where we store the title of our blogpost and the Content column is where we store the actual content You are free to include HTML tags in your content column One really cool thing about Google Sheets is that we do not have to worry about saving our data because everything is synced with your Google Drive account automatically Setting up our frontendSetting up our frontend is fairly simple You can use Vanilla JavaScript or a framework of your choice however I am going to use Vanilla JavaScript in this tutorial The numberOfPosts function is responsible for fetching the number of posts via our second API while the render function is responsible for fetching the actual post with the help of our main API Here is the JavaScript Code And here is the CSSAnd finally here is the HTML Why would anyone want to do this Because Google Sheets is easy to use and accessible from anywhere has advanced features such as data validation conditional formatting and pivot tables Google Sheets is also a good option for small projects or teams with limited resources Github Repository	2023-01-19 03:35:24
海外ニュース	Japan Times latest articles	Funds plan relentless pressure on BOJ as they eye full surrender	https://www.japantimes.co.jp/news/2023/01/19/business/financial-markets/boj-policy-shift-inevitable-investors-say/	bears	2023-01-19 12:07:28
ニュース	BBC News - Home	Julian Sands: British actor identified as hiker missing in southern California	https://www.bbc.co.uk/news/world-us-canada-64327393?at_medium=RSS&at_campaign=KARANGA	weather	2023-01-19 03:00:58
ビジネス	ダイヤモンド・オンライン - 新着記事	米年末商戦の不振鮮明、理由はどこに - WSJ発	https://diamond.jp/articles/-/316389	年末商戦	2023-01-19 12:08:00
GCP	Google Cloud Platform Japan 公式ブログ	Opinary による Cloud Run を活用した高速なレコメンデーションの生成	https://cloud.google.com/blog/ja/topics/developers-practitioners/opinary-generates-recommendations-faster-cloud-run/	CloudRunサービスから他のサービスへリクエストを送信し、同時にその結果を待つことは、多くの費用がかかるということがわかりました。	2023-01-19 03:30:00
GCP	Google Cloud Platform Japan 公式ブログ	Google Cloud のドキュメントを最大限に活用するためのヒント	https://cloud.google.com/blog/ja/topics/developers-practitioners/tips-get-most-out-google-cloud-documentation/	前のスクリーンキャストでご覧いただいたように、上部のアクションバーにあるサポートアイコンを使用してチュートリアルを開始リンクを選択すると、いくつかのインタラクティブなチュートリアルにアクセスできるようになります。	2023-01-19 03:10:00
IT	週刊アスキー	鳥羽周作シェフ監修、幸楽苑のベジタブル餃子！ 動物由来の素材を使わない「ビーガン餃子」	https://weekly.ascii.jp/elem/000/004/121/4121109/	幸楽苑ホールディングス	2023-01-19 12:45:00
IT	週刊アスキー	44年の歴史に幕……渋谷宇田川町「ウェンディーズ・ファーストキッチン渋谷センター街店」1月22日に閉店	https://weekly.ascii.jp/elem/000/004/121/4121107/	宇田川町	2023-01-19 12:40:00
IT	週刊アスキー	なか卯の親子丼が炭火で香ばしくパワーアップ！ 「炭火焼き親子丼」	https://weekly.ascii.jp/elem/000/004/121/4121106/	炭火焼き	2023-01-19 12:35:00
IT	週刊アスキー	丸亀製麺「鴨ねぎうどん」、冬の味覚の鴨と甘みを増した焼きねぎを楽しむ一杯	https://weekly.ascii.jp/elem/000/004/121/4121093/	一部店舗	2023-01-19 12:30:00
IT	週刊アスキー	暗号資産取引所「Coinbase」が1年半で日本市場から撤退	https://weekly.ascii.jp/elem/000/004/121/4121088/	coinbase	2023-01-19 12:20:00
IT	週刊アスキー	「夢の玉子タワー」（9枚のせ）も実現可能！ 大阪王将「ふわとろ玉子 1枚増量券」プレゼントキャンペーン	https://weekly.ascii.jp/elem/000/004/121/4121092/	大阪王将	2023-01-19 12:20:00
マーケティング	AdverTimes	『週刊朝日』、休刊へ　23年5月末で	https://www.advertimes.com/20230119/article409299/	aeradot	2023-01-19 03:10:36
海外TECH	reddit	Grizzlies (31-13) sneak by Cavaliers 115-114 Post Game Thread [1/18/23]	https://www.reddit.com/r/memphisgrizzlies/comments/10fqzxm/grizzlies_3113_sneak_by_cavaliers_115114_post/	Grizzlies sneak by Cavaliers Post Game Thread submitted by u sms to r memphisgrizzlies link comments	2023-01-19 03:18:16
海外TECH	reddit	How is this allowed ?	https://www.reddit.com/r/japanlife/comments/10fqq8e/how_is_this_allowed/	How is this allowed My taxi tightly scotch taped the latch inside to open the door I understand taxis want to control when you open the door But in case of a fire inside the passenger is plainly barbecued submitted by u Practical Lady to r japanlife link comments	2023-01-19 03:05:23
ニュース	THE BRIDGE	賃貸不動産を長期滞在・宿泊施設に転換し利回り最大化、リアテクノロジーズが3.9億円をシリーズB調達	https://thebridge.jp/2023/01/reah-technologies-series-b-round-funding	賃貸不動産を長期滞在・宿泊施設に転換し利回り最大化、リアテクノロジーズが億円をシリーズB調達マンションなど住居用不動産を、賃貸および宿泊施設としてハイブリッド運用するサービスを提供するリアテクノロジーズは、シリーズBラウンドで億円を調達したことを明らかにした。	2023-01-19 03:00:47
GCP	Cloud Blog JA	Opinary による Cloud Run を活用した高速なレコメンデーションの生成	https://cloud.google.com/blog/ja/topics/developers-practitioners/opinary-generates-recommendations-faster-cloud-run/	CloudRunサービスから他のサービスへリクエストを送信し、同時にその結果を待つことは、多くの費用がかかるということがわかりました。	2023-01-19 03:30:00
GCP	Cloud Blog JA	Google Cloud のドキュメントを最大限に活用するためのヒント	https://cloud.google.com/blog/ja/topics/developers-practitioners/tips-get-most-out-google-cloud-documentation/	前のスクリーンキャストでご覧いただいたように、上部のアクションバーにあるサポートアイコンを使用してチュートリアルを開始リンクを選択すると、いくつかのインタラクティブなチュートリアルにアクセスできるようになります。	2023-01-19 03:10:00