投稿時間:2022-10-14 01:22:38 RSSフィード2022-10-14 01:00 分まとめ(34件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
IT	気になる、記になる…	【セール】Kindleストアで｢KADOKAWA ニコニコカドカワ祭り2022｣の新たなセールがスタート − 紙の書籍が対象のセールも同時開催	https://taisy0.com/2022/10/14/163595.html	amazon	2022-10-13 15:30:05
IT	気になる、記になる…	音楽認識アプリ｢Shazam｣、｢Apple Music｣の3ヶ月間無料コードを配布中（2023年2月15日まで）	https://taisy0.com/2022/10/14/163590.html	applemusic	2022-10-13 15:12:26
IT	ITmedia 総合記事一覧	[ITmedia News] ソニー、広角単焦点レンズの新VLOGCAM発表　実売8万3000円前後	https://www.itmedia.co.jp/news/articles/2210/14/news074.html	itmedia	2022-10-14 00:01:00
AWS	AWS Government, Education, and Nonprofits Blog	22 new or updated open datasets on AWS: New polar satellite data, blockchain data, and more	https://aws.amazon.com/blogs/publicsector/22-new-updated-open-datasets-aws-new-polar-satellite-imagery-blockchain-data-more/	new or updated open datasets on AWS New polar satellite data blockchain data and moreThe AWS Open Data Sponsorship Program makes high value cloud optimized datasets publicly available on AWS The full list of publicly available datasets are on the Registry of Open Data on AWS and are now also discoverable on AWS Data Exchange This quarter AWS released new or updated datasets including Amazonia imagery Bitcoin and Ethereum data and elevation data over the Arctic and Antarctica Check out some highlights	2022-10-13 15:51:20
AWS	AWS - Webinar Channel	Analytics Deep Dive: Observability, ETL, Big Data and Governance with AWS - AWS Virtual Workshop	https://www.youtube.com/watch?v=1D6L4ur6wSE	Analytics Deep Dive Observability ETL Big Data and Governance with AWS AWS Virtual WorkshopIn this hands on workshop you ll learn how to implement observability with Amazon OpenSearch Service run big data workloads on Amazon EMR serverless use AWS Glue for ETL and secure your data with AWS Lake Formation Learning Objectives Objective Use PPL query with Amazon OpenSearch Service to set up observability Objective Run big data workloads on EMR Studio Objective Leverage Tag Based Access Control TBAC with AWS Lake Formation To learn more about the services featured in this talk please visit	2022-10-13 15:11:01
python	Pythonタグが付けられた新着投稿 - Qiita	ブロックチェーンのProof of WorkをPythonでやってみた	https://qiita.com/masahironoumi/items/b8cb8b36919e7f071cfb	nonce	2022-10-14 00:56:18
python	Pythonタグが付けられた新着投稿 - Qiita	TechFUL　難易度3「次の素数」	https://qiita.com/My_me_admin/items/73e32f249e9bcbfda3b4	techful	2022-10-14 00:14:16
AWS	AWSタグが付けられた新着投稿 - Qiita	AWS クラウドプラクティショナー合格までのメモ（更新中）	https://qiita.com/ia2/items/9b28e2de4a49a68057a7	udemy	2022-10-14 00:18:33
Git	Gitタグが付けられた新着投稿 - Qiita	"git commit"でコミットメッセージを保存する際に毎回叩く":wq"とはなんなのか。	https://qiita.com/shuhei_m/items/0277611114ad24309381	gitcommit	2022-10-14 00:36:33
海外TECH	MakeUseOf	What Is Unsplash+? Everything You Need to Know	https://www.makeuseof.com/what-is-unsplash-plus/	unsplash	2022-10-13 15:45:18
海外TECH	MakeUseOf	What Is Atlas Earth and Is It a Scam?	https://www.makeuseof.com/what-is-atlas-earth-is-it-a-scam/	atlas	2022-10-13 15:45:18
海外TECH	MakeUseOf	What Is Depop? Everything You Need to Know About the Resale App	https://www.makeuseof.com/what-is-depop/	popular	2022-10-13 15:30:14
海外TECH	DEV Community	Is CosmosDB a new SQL database? Is CitusDB a distributed SQL database? Did Hyperscale vanished in the Hyperspace?	https://dev.to/yugabyte/is-cosmosdb-a-new-sql-database-is-citusdb-a-distributed-sql-did-hyperscale-vanished-in-the-hyperspace-472d	Is CosmosDB a new SQL database Is CitusDB a distributed SQL database Did Hyperscale vanished in the Hyperspace “Azure Cosmos DB is a fully managed NoSQL database for modern app development is what I ve read from the documentation However Azure Cosmos DB for PostgreSQL has just been announced like a new service in Azure PostgreSQL is supposed to be a SQL database right I ll test that in this series of posts where I run the simplest SQL schema the old EMP DEPT showing what any Relational Database for OLTP should support unique constraints and foreign keys There s a free trial with no credit card required and a days limit ️In the Recommended APIs NoSQL is recommended but PostgreSQL is there I didn t find immediately how to connect The Connectivity Method has a copy button but it puts Public access allowed IP addresses in my clipboard which is not very useful No worry all is in the Connection String pane Nothing new this is Hyperscale Citus This “Azure Cosmos DB for PostgreSQL is actually CitusDB This new service is a marketing rename from Hyperscale I ve been working a lot with Oracle Database Renaming features by marketing is not new We can see it from the link which is an HTTP redirect to Distributed tablesGreat I didn t test CitusDB yet in this blog post series about SQL features on distributed databases Let s create the same sample schema citus gt CREATE TABLE dept deptno integer NOT NULL dname text loc text description text CONSTRAINT pk dept PRIMARY KEY deptno CREATE TABLEcitus gt CREATE TABLE emp empno integer generated by default as identity start with NOT NULL ename text NOT NULL job text mgr integer hiredate date sal integer comm integer deptno integer NOT NULL email text other info json CONSTRAINT pk emp PRIMARY KEY empno CONSTRAINT emp email uk UNIQUE email CONSTRAINT fk deptno FOREIGN KEY deptno REFERENCES dept deptno CONSTRAINT fk mgr FOREIGN KEY mgr REFERENCES emp empno CREATE TABLEI start to distribute the tables following the CitusDB documentation citus gt SELECT create distributed table dept deptno create distributed table row citus gt SELECT create distributed table emp empno ERROR cannot distribute relation empDETAIL Distributed relations must not use GENERATED AS IDENTITY citus gt Ok this standard SQL feature exists in PostgreSQL since version it is also in YugabyteDB even with PostgreSQL compatibility by the way but not it is not supported in CitusDB Let s try with serial citus gt drop table emp DROP TABLEcitus gt CREATE TABLE emp empno serial NOT NULL ename text NOT NULL job text mgr integer hiredate date sal integer comm integer deptno integer NOT NULL email text other info json CONSTRAINT pk emp PRIMARY KEY empno CONSTRAINT emp email uk UNIQUE email CONSTRAINT fk deptno FOREIGN KEY deptno REFERENCES dept deptno CONSTRAINT fk mgr FOREIGN KEY mgr REFERENCES emp empno citus gt SELECT create distributed table emp empno ERROR cannot create foreign key constraintDETAIL Foreign keys are supported in two cases either in between two colocated tables including partition column in the same ordinal in the both tables or from distributed to reference tablescitus gt Another problem very similar to what I have seen in the first post of this series we cannot have referential integrity between distributed tables In this example dept is a good candidate for a broadcasted reference table but OLTP system of records have relationships like ORDERS ITEMS ACCOUNT TRANSACTION CUSTOMER PAIEMENT Let s continue with this limitation of not distributing the parent table Foreign key limited to reference tablesI change the parent table dept table to not distribute it as it is not supported for referential integrity and try to distribute the child table emp citus gt SELECT undistribute table dept true NOTICE creating a new table for public deptNOTICE moving the data of public deptNOTICE dropping the old public deptNOTICE renaming the new table to public dept undistribute table row citus gt SELECT create reference table dept NOTICE local tables that are added to metadata automatically by citus but not chained with reference tables via foreign keys might be automatically converted back to postgres tablesHINT Executing citus add local table to metadata public emp prevents this for the given relation and all of the connected relations create reference table row citus gt SELECT create distributed table emp empno ERROR cannot create constraint on emp DETAIL Distributed relations cannot have UNIQUE EXCLUDE or PRIMARY KEY constraints that do not include the partition column with an equality operator if EXCLUDE Ok same problem as with many New SQL sharded databases that are not Distributed SQL anything that involves cross shard transactions is unsupported Foreign keys and Unique constraints cannot be created There s no global integrity enforced by the database This is annoying in OLTP system of records where there is in addition to the generated primary key multiple natural keys Those need to be validated to avoid duplicates especially on highly available databases whre transactions may be retried Let s drop all those constraints to see if we can go further citus gt alter table emp drop constraint emp email uk ALTER TABLEcitus gt alter table emp drop constraint fk mgr ALTER TABLEcitus gt SELECT create distributed table emp empno create distributed table row Good this works But I had to get rid about foreign key except to the mostly static reference tables that can be distributed and all unique secondary indexes No Serializable alternativeWithout Foreign key if the application wants to avoid data corruption in a scalable way it needs to run in Serializable isolation level Here is what could be a race condition one user dropping a manager after checking it has no employees another user adding an employee citus gt add the boss in department citus gt insert into dept deptno values INSERT citus gt insert into emp empno ename deptno mgr values boss null INSERT citus gt begin transaction isolation level serializable BEGINcitus gt add an employee referring to the bosscitus gt insert into emp empno ename deptno mgr values employee INSERT connect a concurrent sessioncitus gt psqlpsql server citus gt begin transaction isolation level serializable BEGINcitus gt check if boss has employeescitus gt select from emp empno ename job mgr hiredate sal comm deptno email other info boss row citus gt remove the boss as it has no employeescitus gt delete from emp where empno DELETE citus gt commit COMMIT back to session one commiting its transactioncitus gt qcitus gt commit COMMIT final state one employee with inexistent bosscitus gt select from emp empno ename job mgr hiredate sal comm deptno email other info employee row This is a surprising result no error but orphan child This should not happen with serializable isolation level We should not have to read the documentation to know that an successful command actually did nothing I can find it in the list of CitusDB limitations limitations I also see “No support for tuple locks there so no need to test for other alternatives to foreign keys Locking whole tables is not a solution Being Distributed and PostgreSQL compatible is not easy There are not a lot of players in this area which like YugabyteDB support all global constraints referential integrity isolation levels like PostgreSQL does Actually I know only YugabyteDB doing that but please comment if you think there are others CitusDB like many sharded databases is good for datawarhouses They partition the data first and distribute the queries to a few shards possibly each replicated with a primary standby This is sharding on top of monolithic SQL databases Distributed SQL like YugabyteDB on the opposite provide all SQL features on top of a distributed and replicated storage which is seen as one global database with global ACID transactions I detailed this architecture in	2022-10-13 15:01:45
Apple	AppleInsider - Frontpage News	Apple Card Daily Cash can be shunted to high-yield savings soon	https://appleinsider.com/articles/22/10/13/apple-card-daily-cash-can-be-shunted-to-high-yield-savings-soon?utm_medium=rss	Apple Card Daily Cash can be shunted to high yield savings soonApple has announced that Apple Card users will shortly be able to transfer their Daily Cash balance into a special interest accumulating Goldman Sachs savings account Source AppleReferred to as just Savings the new account is to be a high yield Goldman Sachs one with no fees and no requirements such as minimum balances or deposits Read more	2022-10-13 15:28:54
Apple	AppleInsider - Frontpage News	Sandmarc releases Titanium Edition band for Apple Watch Ultra	https://appleinsider.com/articles/22/10/13/sandmarc-releases-titanium-edition-band-for-apple-watch-ultra?utm_medium=rss	Sandmarc releases Titanium Edition band for Apple Watch UltraSandmarc a company known for its photography accessories has launched a titanium band for Apple Watch Ultra Sandmarc Titanium Edition bandSandmarc s new Apple Watch band is made from commercially pure grade titanium resistant to corrosion and oxidation The company says that it s a lightweight band for on the go adventures The color has been designed to match the Apple Watch Ultra finish Read more	2022-10-13 15:01:54
Apple	AppleInsider - Frontpage News	Daily deals Oct. 13: $100 off M2 MacBook Air, $150 off Sennheiser Momentum headphones, up to $400 off Canon cameras, more	https://appleinsider.com/articles/22/10/13/daily-deals-oct-13-100-off-m2-macbook-air-150-off-sennheiser-momentum-headphones-up-to-400-off-cannon-cameras-more?utm_medium=rss	Daily deals Oct off M MacBook Air off Sennheiser Momentum headphones up to off Canon cameras moreThursday s best deals include off an LG inch TV prices as low as for iPads and MacBooks in a Woot scratch and dent sale and much more Best deals October AppleInsider checks online stores daily to uncover discounts and offers on hardware and other products including Apple devices smart TVs accessories and other items The best offers are compiled into our regular list for our readers to use and save money Read more	2022-10-13 15:09:08
Apple	AppleInsider - Frontpage News	Microsoft 365 fully absorbing long-time Office branding	https://appleinsider.com/articles/22/10/13/microsoft-365-fully-absorbing-long-time-office-branding?utm_medium=rss	Microsoft fully absorbing long time Office brandingAfter decades of service Microsoft is taking steps to fully absorb the Microsoft Office branding under the Microsoft umbrella across all platforms Word Excel and PowerPoint ceased to be separate apps for iPhone users in when Microsoft brought a single unified Office app to the iPhone That was followed by the iPad version in ーbut for now the MacOS and Windows versions are still called Office Starting in November the company is finishing its Microsoft rebrand to encompass all platforms that the software suite runs on Read more	2022-10-13 15:39:06
海外TECH	Engadget	Signal is winding down plaintext SMS support in its Android app	https://www.engadget.com/signal-android-sms-155002588.html?src=rss	Signal is winding down plaintext SMS support in its Android appSignal is removing the option to send and receive SMS messages in its Android app Folks who currently use Signal as their default SMS app will receive alerts advising them to switch to a different one You ll be able to export your SMS messages and import them into another app as long as the other one supports that option The change won t happen overnight quot You will have several months to transition away from SMS in Signal to export your SMS messages to another app and to let the people you talk to know that they might want to switch to Signal or find another channel if not quot Signal wrote in a blog post Signal said it included SMS support in the first place to make it easier to use ーyou wouldn t have to convince friends to start using Signal before exchanging messages with them from the app While the move may be inconvenient for those who have been using Signal for the bulk of their messaging the company spelled out some practical reasons for the change For one thing SMS messages don t have end to end encryption Also given the shifting prices of data and text plans over the years it may actually be more expensive to send an SMS message than a Signal one these days quot We ve heard repeatedly from people who ve been hit with high messaging fees after assuming that the SMS messages they were sending were Signal messages only to find out that they were using SMS and being charged by their telecom provider quot Signal s blog post reads quot This is a terrible experience with real consequences quot The third reason Signal gave is that it wants to avoid folks getting confused between SMS and Signal messages in the app It said that making these distinct has quot serious UX and design implications quot Furthermore Signal said dropping SMS support will free up resources to work on other projects and features It made the decision following a data breach at its verification partner Twillio Signal said the incident exposed around of its users phone numbers and SMS codes It s unclear whether the call to end SMS support is directly connected to the breach	2022-10-13 15:50:02
海外TECH	Engadget	Sony's ZV-1F is its most affordable vlogging camera yet	https://www.engadget.com/sony-zv-1f-vlogging-camera-announcement-152737815.html?src=rss	Sony x s ZV F is its most affordable vlogging camera yetSony has unveiled the ZV F its third and most affordable vlogging camera designed for creators as a quot step up quot from smartphones Priced at just it s slotted below the ZV compact and mirrorless ZV E with a kit lens and has a Type Exmor megapixel sensor K video and features that help novice users get up to speed quickly nbsp While using a similar Type sensor to the ZV it trades that models mm zoom for a wide angle mm equivalent prime lens That extra field of view plus the fully articulating display could actually make it better for vlogging or selfies than the ZV ーallowing folks to better fit themselves into the frame nbsp SonyHowever it also makes it less versatile for shooting products other people and so on though you can do a digital zoom of x in p and about x in K It has no built in stabilization instead relying on electronic stabilization that imposes a x crop making the mm lens about mm nbsp You can shoot K at up to fps the same as the ZV and p at up to an impressive fps with bit video in all modes That s done by the quot slow and quick quot setting which also supports x hyperlapse capture in HD However unlike most other Sony models the ZV F has contrast detect only autofocus rather than phase detect that s generally faster and more accurate nbsp SonyLike the other vlogging models the ZV F has a quot product showcase quot feature that lets you place a product in front of the camera and quickly get focus It also has the same bokeh switch that lets you defocus the background with the click of a button A nod to TikTok or Snapchat creators is the Shot Mark feature that lets you grab a or second clip and send it to a smartphone through Sony s app nbsp On the audio side it has a directional microphone that offers good quality sound with forward bias that isolates your voice even outdoors It also includes a removable quot deadcat quot to reduce wind noise nbsp Other features include a single UHS slot an ISO range of to vertical shooting and a front facing tally light that shows when you re recording Sony says it weighs just grams just a bit more than the gram iPhone It arrives on October th for nbsp	2022-10-13 15:27:37
Cisco	Cisco Blog	Asbah: How access to clean and affordable drinking water is transforming communities	https://blogs.cisco.com/csr/asbah-how-access-to-clean-and-affordable-drinking-water-is-transforming-communities	cisco	2022-10-13 16:00:03
海外TECH	CodeProject Latest Articles	Event Sourcing on Azure Functions	https://www.codeproject.com/Articles/5205463/Event-Sourcing-on-Azure-Functions	functions	2022-10-13 15:27:00
海外科学	NYT > Science	A South Pacific Penguin Dumps One of Its Potential Chicks	https://www.nytimes.com/2022/10/12/science/erect-crested-penguin-antipodes-egg.html	A South Pacific Penguin Dumps One of Its Potential ChicksOn the Antipodes Islands in the South Pacific researchers observed a strange parenting move in erect crested penguins ーlaying an egg that s doomed to die	2022-10-13 15:35:48
海外科学	NYT > Science	‘Kind of Awkward’: Doctors Find Themselves on a First-Name Basis	https://www.nytimes.com/2022/10/13/health/doctors-first-names.html	Kind of Awkward Doctors Find Themselves on a First Name BasisWhile many physicians may avoid discussing the subject a study showed that who gets addressed with the honorific “Dr may depend on gender degree and specialty	2022-10-13 15:06:53
海外科学	NYT > Science	The 2022 Living Planet Index Is Out. Here’s How to Understand It.	https://www.nytimes.com/2022/10/12/climate/living-planet-index-wildlife-declines.html	The Living Planet Index Is Out Here s How to Understand It The latest update to an important assessment found that populations had declined by an average of percent since But that might not mean what you think	2022-10-13 15:59:37
金融	RSS FILE - 日本証券業協会	株券等貸借取引状況（週間）	https://www.jsda.or.jp/shiryoshitsu/toukei/kabu-taiw/index.html	貸借	2022-10-13 15:30:00
金融	RSS FILE - 日本証券業協会	株主コミュニティの統計情報・取扱状況	https://www.jsda.or.jp/shiryoshitsu/toukei/kabucommunity/index.html	株主コミュニティ	2022-10-13 15:30:00
ニュース	BBC News - Home	Kwarteng sidesteps questions on mini-budget U-turn	https://www.bbc.co.uk/news/uk-politics-63244805?at_medium=RSS&at_campaign=KARANGA	position	2022-10-13 15:31:30
ニュース	BBC News - Home	Nurse accused of murder 'cared deeply about babies'	https://www.bbc.co.uk/news/uk-england-merseyside-63244376?at_medium=RSS&at_campaign=KARANGA	court	2022-10-13 15:43:16
ニュース	BBC News - Home	Rwanda three-week removals plan revealed	https://www.bbc.co.uk/news/uk-63248214?at_medium=RSS&at_campaign=KARANGA	court	2022-10-13 15:37:02
ニュース	BBC News - Home	Gary Lineker tweet broke impartiality rules, says BBC complaints unit	https://www.bbc.co.uk/news/entertainment-arts-63248314?at_medium=RSS&at_campaign=KARANGA	presenter	2022-10-13 15:49:25
ニュース	BBC News - Home	Emma Hayes: Chelsea manager has emergency hysterectomy because of endometriosis	https://www.bbc.co.uk/sport/football/63246126?at_medium=RSS&at_campaign=KARANGA	Emma Hayes Chelsea manager has emergency hysterectomy because of endometriosisChelsea manager Emma Hayes says she expects to make a full recovery but will take time away from the club as she recovers from surgery	2022-10-13 15:14:21
ニュース	BBC News - Home	Gijon Open: Andy Murray beats Pedro Cachin in three sets	https://www.bbc.co.uk/sport/tennis/63247731?at_medium=RSS&at_campaign=KARANGA	cachin	2022-10-13 15:47:17
ニュース	BBC News - Home	Wasps & Worcester: Premiership and RFU call for more financial transparency from clubs	https://www.bbc.co.uk/sport/rugby-union/63241246?at_medium=RSS&at_campaign=KARANGA	Wasps amp Worcester Premiership and RFU call for more financial transparency from clubsPremiership Rugby and the Rugby Football Union call for more financial transparency in the wake of Wasps and Worcester s plight	2022-10-13 15:32:58
Azure	Azure の更新情報	General availability: Azure Monitor predictive autoscale for Azure Virtual Machine Scale Sets	https://azure.microsoft.com/ja-jp/updates/general-availability-azure-monitor-predictive-autoscale-for-azure-virtual-machine-scale-sets/	General availability Azure Monitor predictive autoscale for Azure Virtual Machine Scale SetsPredictive autoscale manages and scales your virtual machine scale sets by observing and learning from historical CPU usage patterns	2022-10-13 15:10:24