投稿時間:2022-03-26 11:10:16 RSSフィード2022-03-26 11:00 分まとめ(16件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
TECH	Engadget Japanese	119ヶ国語を素早く文字と音声に変換。スマホリングにもなるAI高速ミニ翻訳機	https://japanese.engadget.com/smart-translator-015545032.html		2022-03-26 01:55:45
IT	ITmedia 総合記事一覧	[ITmedia ビジネスオンライン] 「子どもに就いてほしくないなあ」と感じる職業、1位は？	https://www.itmedia.co.jp/business/articles/2203/26/news038.html	itmedia	2022-03-26 10:30:00
TECH	Techable（テッカブル）	京都府内のごみ拾い活動を見える化！ ごみ拾いSNS「ピリカ」を活用したプロジェクト始動へ	https://techable.jp/archives/175655	movement	2022-03-26 01:00:30
AWS	AWSタグが付けられた新着投稿 - Qiita	（備忘録）AWS認定試験テキストSAP本のデモ(IAMロール、クロスアカウントアクセス)	https://qiita.com/zono_0/items/03d98c75bf286882b6d8	備忘録AWS認定試験テキストSAP本のデモIAMロール、クロスアカウントアクセスはじめに年月日にヤマムギ様主催にて開催されたヤマムギvolAWS認定試験テキストSAP本のデモIAMロール、クロスアカウントアクセスでのAWS学習内容について、自分への備忘録としてまとめてみました。	2022-03-26 10:11:50
Docker	dockerタグが付けられた新着投稿 - Qiita	Docker Composeを用いてLaravel環境構築	https://qiita.com/NNKK1234/items/95faa0fc1d5901f9e8d2	Laravel環境を構築するコンテナを作成・起動する以下のコマンドを実行することで、Laravel環境が構築され、Laravelプロジェクトも作成されます。	2022-03-26 10:01:51
海外TECH	DEV Community	Connecting to PlanetScale with a PDO Object in PHP	https://dev.to/iamluisj/connecting-to-planetscale-with-a-pdo-object-in-php-2h09	Connecting to PlanetScale with a PDO Object in PHP What is PlanetScale PlanetScale is a MySQL compatible serverless database platform I think of it as GitHub for databases You can use it to host your database create branches and preview the impact that merging your changes will do to your database Okay so how do I connect to it using PHP The recommended way to connect to a Planetscale database is to use the mysqli class mysqli mysqli init mysqli gt ssl set NULL NULL etc ssl cert pem NULL NULL mysqli gt real connect ENV HOST ENV USERNAME ENV PASSWORD ENV DATABASE mysqli gt close The title says WITH PDO I tend to prefer using PDO objects as a personal preference Using PDO with SSL requires us to also setup additional options when instantiating the handle dsn mysql host host dbname database port user dbP options array PDO MYSQL ATTR SSL CA gt etc ssl certs ca certificates crt PDO MYSQL ATTR SSL VERIFY SERVER CERT gt false try db new PDO dsn user dbP options db gt setAttribute PDO ATTR ERRMODE PDO ERRMODE EXCEPTION echo Connected successfully catch PDOException error msg error gt getMessage echo msg Let s break down the options we used to turn SSL on PDO MYSQL ATTR SSL CA gt path to cert pem This sets the file path to the SSL certificate authorityIn some cases the MYSQL ATTR SSL CA may need to be set to etc ssl cert pem depending on the OS your server is running Your best bet if you aren t sure would be to use this function openssl get cert locations default cert file You may run into an error like openssl s client no cipher match which is why we use this option PDO MYSQL ATTR SSL VERIFY SERVER CERT gt false Settings the options variableTo be more concise I prefer to use the int values for the options array So my options look like this It is equivalent to what you see above options array gt etc ssl cert pem gt false Final code snippetHere is what I use to connect my PHP app to PlanetScale dsn mysql host hostURL dbname databaseName port user dbP options array gt etc ssl cert pem gt false try db new PDO dsn user dbP options db gt setAttribute PDO ATTR ERRMODE PDO ERRMODE EXCEPTION echo Connected successfully catch PDOException error msg error gt getMessage echo error msg I hope you found this helpful If you did or you have a question drop a comment below or ping me on twitter helloLuisJ	2022-03-26 01:16:17
海外TECH	DEV Community	npx gitignore	https://dev.to/nickytonline/npx-gitignore-5087	npx gitignoreI ve done this a few times on a live stream and there is always someone unaware of this so I wanted to share Assuming you have Node js installed on your machine you can run npx gitignore your language e g npx gitignore node and it will generate a gitignore file for you for the given language Here s a clip from my stream today showing it in action Maybe you ll find it useful in your next project Photo by Gabriel Heinzer on Unsplash	2022-03-26 01:04:06
海外科学	BBC News - Science & Environment	Solar farms: Can expansion overcome Tory MPs' concerns?	https://www.bbc.co.uk/news/uk-politics-60878403?at_medium=RSS&at_campaign=KARANGA	local	2022-03-26 01:27:51
ニュース	BBC News - Home	Russia targets east Ukraine, says first phase over	https://www.bbc.co.uk/news/world-europe-60872358?at_medium=RSS&at_campaign=KARANGA	overthe	2022-03-26 01:33:17
ニュース	BBC News - Home	Ukraine war: WHO says attacks on hospitals are increasing daily	https://www.bbc.co.uk/news/health-60866669?at_medium=RSS&at_campaign=KARANGA	facilities	2022-03-26 01:25:56
ニュース	BBC News - Home	Solar farms: Can expansion overcome Tory MPs' concerns?	https://www.bbc.co.uk/news/uk-politics-60878403?at_medium=RSS&at_campaign=KARANGA	local	2022-03-26 01:27:51
北海道	北海道新聞	＜デジタル発＞冬季パラリンピック、道産子選手なぜ少ない？	https://www.hokkaido-np.co.jp/article/660642/	選手	2022-03-26 10:36:13
北海道	北海道新聞	「アンビシャス」北海道を元気に　女性７人組音楽ユニット２７日に１周年ライブ　札幌観光大使にも就任	https://www.hokkaido-np.co.jp/article/661398/	観光大使	2022-03-26 10:28:13
北海道	北海道新聞	「もののけ姫」、仏で大織物に　無形文化遺産、完成披露	https://www.hokkaido-np.co.jp/article/661473/	無形文化遺産	2022-03-26 10:26:00
北海道	北海道新聞	原発職員交代のめど立たず　チェルノブイリ	https://www.hokkaido-np.co.jp/article/661460/	国際原子力機関	2022-03-26 10:10:00
デザイン	Webクリエイターボックス	Twitter 人気のつぶやき 3/19〜3/25 2022	https://www.webcreatorbox.com/twitter/twitter-0319-0325-2022	firstappearedonweb	2022-03-26 01:55:24