投稿時間:2021-09-04 02:17:11 RSSフィード2021-09-04 02:00 分まとめ(23件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
AWS	AWS News Blog	Decoding the Social Effects Of Media with Machine Learning	https://aws.amazon.com/blogs/aws/decoding-the-social-effects-of-media-with-machine-learning/	Decoding the Social Effects Of Media with Machine LearningWhat if media were optimized to benefit people This thought provoking question is at the core of Harmony Labs mission A nonprofit organization headquartered in New York City Harmony Labs strives to better understand the impact of media on society and build communities and tools to reform and transform media systems As Brian Wanieswki Executive Director …	2021-09-03 16:30:42
AWS	AWS Partner Network (APN) Blog	Integrating Third-Party Firewall Appliances with VMware Cloud on AWS Using VMware Transit Connect	https://aws.amazon.com/blogs/apn/integrating-third-party-firewall-appliances-with-vmware-cloud-on-aws-using-vmware-transit-connect/	Integrating Third Party Firewall Appliances with VMware Cloud on AWS Using VMware Transit ConnectAs customers continually move towards hybrid cloud architectures it has become increasingly important to address network security requirements for having a centralized security inspection solution between VMware Cloud on AWS and the native AWS environment on premises data centers and the internet Through this post learn how to integrate preferred third party firewall solutions with VMware Cloud on AWS by leveraging the VMware Transit Connect feature	2021-09-03 16:58:37
js	JavaScriptタグが付けられた新着投稿 - Qiita	Rails 無限スクロール（gem、ライブラリ無し）	https://qiita.com/223yuta/items/3be7fb632f3ef49d008e	しかし、実装内容が複雑になってくると、gemやライブラリの利用方法を学んで実装するよりも、自分で記述した方が早い場合もあるのかなと思いました。	2021-09-04 01:14:29
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	javaでボタンタップ時にアニメーションが呼ばれない	https://teratail.com/questions/357661?rss=all	androidstdio	2021-09-04 01:41:45
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	就活用ポートフォリオのソースコードをGithubに公開するリスクについて	https://teratail.com/questions/357660?rss=all	就活用ポートフォリオのソースコードをGithubに公開するリスクについてgithub初心者の者です。	2021-09-04 01:41:28
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	【自作サーバー】Apacheが起動しているのにサーバーにアクセスできない	https://teratail.com/questions/357659?rss=all	【自作サーバー】Apacheが起動しているのにサーバーにアクセスできない特定の人のみが利用できるプライベートサーバーを自分で作ろうとしているのですが、インターネット経由でサーバーにアクセスしようとすると下記のエラーが表示されます。	2021-09-04 01:29:51
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	シューティングゲームの弾を高速で移動させると障害物をすり抜けてしまいます	https://teratail.com/questions/357658?rss=all	シューティングゲームの弾を高速で移動させると障害物をすり抜けてしまいます弾の速度がある程度早い場合、一定の確率で衝突判定がされず障害物をすり抜けてしまいます。	2021-09-04 01:15:18
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	VisualStudioからのpython利用について	https://teratail.com/questions/357657?rss=all	python	2021-09-04 01:00:20
Ruby	Railsタグが付けられた新着投稿 - Qiita	Gemとは何か	https://qiita.com/Hashimoto-Noriaki/items/f06ff0673dab2c6cee37	パッケージは便利な機能がまとまったものです。	2021-09-04 01:40:33
Ruby	Railsタグが付けられた新着投稿 - Qiita	Rails 無限スクロール（gem、ライブラリ無し）	https://qiita.com/223yuta/items/3be7fb632f3ef49d008e	しかし、実装内容が複雑になってくると、gemやライブラリの利用方法を学んで実装するよりも、自分で記述した方が早い場合もあるのかなと思いました。	2021-09-04 01:14:29
海外TECH	DEV Community	Another SQL cheat sheet	https://dev.to/jmau111/another-sql-cheat-sheet-4ja5	Another SQL cheat sheet DisclaimerBe aware it s not an exhaustive list Click items with an arrow on the left to get details Concepts Structured Query Language SQL It s the most widely used language for managing data in relational databases The language is easy to learn declarative and very convenient to manipulate datasets SQL for what SQL can be helpful to execute queries create data schemes manipulate records and retrieve data It s often used along with a programming language to power applications PostgreSQL It s an open source object relational database management system RDBMS MySQL It s the most widely used relational database management system It runs as a server and you can use it to create databases and give their access to multiple users Columns vs rows In a database All information is stored in tables Each table is divided into rows and columns Columns are specific attributes that allow for grouping data e g id first name last name age Rows are records e g Kobe Bryant Views A view is a virtual table based on the result of an SQL query It s a pretty convenient feature that allow you to run advanced queries in pre sorted results ACID vs BASE ACID means atomicity consistency isolation and durability and BASE stands for “Basically Available soft state and eventual consistency Each approach has its advantages and drawbacks depending on what you want to achieve NoSQL The NoSQL model states that not all applications need a relational database Redis Elasticsearch or MongoDB are practical examples of NoSQL systems You can read this post to understand the difference with SQL Logical operators AND Multiple conditions in WHERE clauses that are all verified OR Multiple conditions in WHERE clauses where at least one condition is verified LIKE Compare a value to similar values using wildcard operators BETWEEN Search between max and min values EXISTS Search if a row is in a table IN Determine if a value is in a specified list of literal values NOT Negate logical operator e g NOT EXISTS NOT BETWEEN NOT IN and so on Comparison Operators Equal Not equal lt gt Not equal gt Greater than gt Equal or greater than lt Lower than lt Lower than or equal gt Not greater than lt Not lower than Basic commands Create database CREATE DATABASE my database Create table CREATE TABLE my table my column my column definition other column other column definition Alter table ALTER TABLE my table ADD my column my column definition Empty table TRUNCATE my table Select data in table SELECT my column FROM my table Select data conditionally SELECT my column other columnFROM my tableWHERE my column some valueAND other column other value Insert data in table INSERT INTO my table my column other column VALUES my value other value Update data in table UPDATE my tableSET my column my valueWHERE other column other value Drop table DROP my table Delete data table DELETE FROM my tableWHERE CONDITION Aliasing SELECT my column AS mycol FROM my table Counting elements SELECT COUNT my column FROM my table A little more advanced commands Kill doublons in select SELECT DISTINCT id FROM Players Sum values in column SELECT SUM salary FROM Players Sort data SELECT last name age FROM PlayersGROUP BY age ORDER BY last name Not equal SELECT first name last name FROM Players WHERE age lt gt Create view CREATE VIEW my view ASSELECT id first name last name ageFROM Players Select data from a view SELECT FROM my view Drop view DROP VIEW my view PRIMARY KEY constraintsA primary key is unique identifier for each records in a table Its value cannot be NULL It s often combined with AUTO INCREMENT to generate it automatically CREATE TABLE Players id INT PRIMARY KEY NOT NULL AUTO INCREMENT last name varchar NOT NULL first name varchar age int UNIQUE constraintsA UNIQUE constraint forces the use of different values in a column CREATE TABLE Players id int NOT NULL last name varchar NOT NULL first name varchar age int UNIQUE id INTERSECTIONSELECT FROM table AINTERSECTSELECT FROM table BINTERSECT allows you to get results that match the first query and the second query and only that UNIONSELECT FROM table AUNIONSELECT FROM table BUNION is a basic command that allows for combining several queries and concatenate results In the example above you get results that match the first query or the second query or both JOINYou can consolidate information from several different tables with a SQL JOIN INNER JOIN Join two tables where a condition is true in the two tables SELECT FROM table AINNER JOIN table B ON table A id table B pid LEFT JOIN Return all records from the table on the left even if the condition is not true in the second table SELECT FROM table ALEFT JOIN table B ON table A id table B pid RIGHT JOIN Return all records from the table on the right even if the condition is not true in the first table SELECT FROM table ARIGHT JOIN table B ON table A id table B pid FULL JOIN and FULL OUTER JOIN Join two tables where a condition is true at least in one table SELECT FROM table AFULL JOIN table B ON table A id table B pid SELF JOIN Join a table with itself It s useful when there are hierarchical relationships between records SELECT child id child name parent nameFROM People as childLEFT OUTER JOIN People AS parent ON child parent id parent id CROSS JOIN Join each line of a table with each line of a second table SELECT FROM table ACROSS JOIN table B NATURAL JOIN Join two tables when they have at least one column with the same name SELECT FROM table ANATURAL JOIN table B UNION JOIN Join union SQL IndexesIndexes are incredibly helpful to decrease execution time for SQL selects and WHERE clauses It s pretty much like the index at the end of a book where you can find all pages related to a specific topic Creating or dropping indexes does not affect data CREATE INDEX my index ON my table You can create an index on a specific column CREATE INDEX my index ON my table my column Be careful though indexes are not meant for small tables or frequently updated columns Large operations involving updates and inserts can be significantly slower	2021-09-03 16:42:46
Apple	AppleInsider - Frontpage News	Apple hires ex-Mercedes engineers for 'Apple Car' Special Projects Group	https://appleinsider.com/articles/21/09/03/apple-hires-ex-mercedes-engineers-for-apple-car-special-projects-group?utm_medium=rss	Apple hires ex Mercedes engineers for x Apple Car x Special Projects GroupPresumed to be for the Apple Car two former Mercedes engineers have been hired by Apple officially to work in the Special Projects Group Mercedes Benz has adde Apple Music to infotainment system Image Credit DaimlerApple is already believed to have poached Porsche s vice president of chassis development Dr Manfred Harrer to work on the Apple Car Now a new report says that two more high profile Mercedes engineers have been recruited Read more	2021-09-03 16:52:18
Apple	AppleInsider - Frontpage News	Best Deals Sept. 3 - $25 off HomePod mini, early Labor Day sales, more!	https://appleinsider.com/articles/21/09/03/best-deals-september-3---early-labor-day-sales-25-off-homepod-mini-and-more?utm_medium=rss	Best Deals Sept off HomePod mini early Labor Day sales more Friday s best deals include early Labor Day sales off Roborock robot vacuum off Anker wireless charger off HomePod mini and more Deals Friday September Shopping online for the best discounts and deals can be an annoying and challenging task So rather than sifting through miles of advertisements check out this list of sales we ve hand picked just for the AppleInsider audience Read more	2021-09-03 16:53:03
海外TECH	Engadget	'Battlefield Mobile' beta is coming to Android devices this fall	https://www.engadget.com/battlefield-mobile-beta-details-163325750.html?src=rss	x Battlefield Mobile x beta is coming to Android devices this fallSince April we ve known EA has been working on a standalone mobile version of its popular Battlefield games it plans to release sometime in This week the publisher shared new details on the upcoming title To start EA plans to begin beta testing Battlefield Mobile this fall with “a series of smaller playtests quot involving players in Indonesia and the Philippines who own Android devices “As we continue with testing we ll expand the size of these tests and add new regions the company said over on its community website The initial beta test will only feature a single map called Grand Bazaar and the franchise s signature Conquest game mode EA promised to share more details about other maps and modes closer to Battlefield Mobile s release date In the meantime the company confirmed the game would be a free to play title that will “only include cosmetic items You ll earn some of those through optional seasonal battle passes Battlefield Mobile won t support crossplay between any console or PC versions of the Battlefield franchise since it is “being built specially for mobile If you live in Indonesia or the Philippines you can pre register on the Google Play Store to get more information about the upcoming beta tests	2021-09-03 16:33:25
海外TECH	CodeProject Latest Articles	Multiplatform AvaloniaUI .NET Framework Programming Basic Concepts in Easy Samples	https://www.codeproject.com/Articles/5311995/Multiplatform-AvaloniaUI-NET-Framework-Programming	avaloniaui	2021-09-03 16:55:00
海外科学	NYT > Science	Carolyn Shoemaker, Hunter of Comets and Asteroids, Dies at 92	https://www.nytimes.com/2021/09/01/science/space/carolyn-shoemaker-dead.html	Carolyn Shoemaker Hunter of Comets and Asteroids Dies at After her children left for college she unexpectedly became astronomy s record setting spotter of unidentified objects hurtling through the cosmos	2021-09-03 16:46:29
海外TECH	WIRED	Apple Backs Down on Its iPhone Photo-Scanning Plans	https://www.wired.com/story/apple-icloud-photo-scan-csam-pause-backlash	devices	2021-09-03 16:58:34
金融	金融庁ホームページ	資金決済法に基づく払戻手続実施中の商品券の発行者等一覧を更新しました。	https://www.fsa.go.jp/policy/prepaid/index.html	資金決済法	2021-09-03 17:00:00
ニュース	BBC News - Home	Covid jabs not recommended for most 12-15 year olds	https://www.bbc.co.uk/news/health-58438669?at_medium=RSS&at_campaign=KARANGA	children	2021-09-03 16:45:37
ニュース	BBC News - Home	Covid-19: Jabs for healthy 12 to 15-year-olds not recommended and Australia-UK vaccine swap	https://www.bbc.co.uk/news/uk-58440649?at_medium=RSS&at_campaign=KARANGA	coronavirus	2021-09-03 16:21:57
ニュース	BBC News - Home	New Zealand PM Ardern says supermarket stabbing was 'terrorist attack'	https://www.bbc.co.uk/news/world-asia-58405213?at_medium=RSS&at_campaign=KARANGA	auckland	2021-09-03 16:03:45
ニュース	BBC News - Home	Covid: What Israel tells us about the way out of the pandemic	https://www.bbc.co.uk/news/health-58432776?at_medium=RSS&at_campaign=KARANGA	covid	2021-09-03 16:28:04
ニュース	BBC News - Home	Fifa opens disciplinary proceedings after racial abuse of England players	https://www.bbc.co.uk/sport/football/58432092?at_medium=RSS&at_campaign=KARANGA	Fifa opens disciplinary proceedings after racial abuse of England playersFifa is investigating racist abuse aimed at England players during Thursday s World Cup qualifier win over Hungary in Budapest	2021-09-03 16:44:42