投稿時間:2023-07-07 03:16:27 RSSフィード2023-07-07 03:00 分まとめ(20件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
IT	気になる、記になる…	ソニーの新型ワイヤレスイヤホン｢WF-1000XM5｣は生産に問題発生で遅れている模様	https://taisy0.com/2023/07/07/173758.html	発表	2023-07-06 17:16:04
AWS	AWS Compute Blog	Validating attestation documents produced by AWS Nitro Enclaves	https://aws.amazon.com/blogs/compute/validating-attestation-documents-produced-by-aws-nitro-enclaves/	Validating attestation documents produced by AWS Nitro EnclavesThis blog post is written by Paco Gonzalez Senior EMEA IoT Specialist SA AWS Nitro Enclaves offers an isolated hardened and highly constrained environment to host security critical applications Think of AWS Nitro Enclaves as regular Amazon Elastic Compute Cloud Amazon EC virtual machines VMs but with the added benefit of the environment being highly constrained …	2023-07-06 17:42:12
python	Pythonタグが付けられた新着投稿 - Qiita	AWS Lambdaでrequestsが使えない=> cannot import name 'DEFAULT_CIPHERS' from 'urllib3.util.ssl_'	https://qiita.com/HLHHS11/items/c26f1632a141a1dcc7a7	AWSLambdaでrequestsが使えないgtcannotimportnamexDEFAULTCIPHERSxfromxurllibutilsslxPythonで開発したAWSLambdaをデプロイしたら以下のエラーが出て動きませんでした。	2023-07-07 02:31:37
海外TECH	MakeUseOf	How to Make a Spaceflight Reservation With Virgin Galactic	https://www.makeuseof.com/virgin-galactic-reservation/	reservations	2023-07-06 17:30:18
海外TECH	DEV Community	Chapter 3 Query Processing: Join Operations in PostgreSQL	https://dev.to/salarzaisuhaib/chapter-3-query-processing-join-operations-in-postgresql-4iia	Chapter Query Processing Join Operations in PostgreSQLIn Relational databases combining data from multiple tables is done by Join operations which play a very important function in this regard PostgreSQL provides a variety of Join Operations to take care of different join conditions In this blog post which is a summary of the book The Internals of PostgreSQL Chapter Part we will discuss three important join operations in PostgreSQL Nested Loop JoinMaterialized Nested Loop Join Indexed Nested Loop Join Nested Loop Join In PostgreSQL the nested loop join acts as the fundamental join operation which is able of dealing with any kind of join conditions despite the fact that there are many other efficient variations The nested loop join is adaptable for many join conditions and does not need a start up operation Multiplying the sizes of the inner and outer tables is directly proportional to the run cost The run cost equation takes into consideration the tuple costs CPU costs and scanning costs of inner and outer tables Materialized Nested Loop Join As scanning the whole inner table for each outer table tuple is an expensive process PostgreSQL offers materialized nested loop join to reduce the collective scanning cost of the inner table This variation scans the inner table only one time and the executor writes the inner table tuples in work memory or temporary files Eliminating the need of scanning the inner table for each tuple of the outer table Materialized nested loop join reduces the overall scanning cost Before carrying out the join operation the executor writes the inner table tuples in memory or temporary files Temporary tuple storage module for materializing tables creating batches and much more is internally offered by PostgreSQL To give an exact and accurate estimation cost of the whole join operation materialized nested loop join cost estimation takes in variables like start up cost run cost and rescan cost Indexed Nested Loop Join When there is an index of the inner table offering the straightforward look up of the tuples satisfying the join condition for matching each tuple of the outer table the variation is known as indexed nested loop join This variation offers a process on the basis of a single loop of the outer table which enhances the performance of join operations Indexed Nested Loop Join uses the index search on the inner table tuples instead of the sequential scanning fulfilling the join condition Indexed Nested Loop Join increases the join operation performance as it directly looks up for tuples this is crucial when managing large datasets Indexed Nested Loop Join cost estimation takes in the variables like lookup costs and scanning cost of the outer table which ensures accurate join operation s cost ConclusionTo ensure optimal query processing in PostgreSQL efficient join operations are important Understanding the join operations help users such as developers db administrators to choose most suitable approach for their specific use case To conclude this blog we discussed various join operations each of which offers uniques properties and its advantages ensuring efficient data processing and using these join operations with PostgreSQL makes it more efficient	2023-07-06 17:36:10
海外TECH	DEV Community	How to check if a tab is active in React	https://dev.to/eraywebdev/how-to-check-if-a-tab-is-active-in-react-1o0l	How to check if a tab is active in ReactBefore diving into the specifics of how to detect active tab engagement I d like to share a real world web scenario where this was a use case Imagine a user toggling between two different tabs each operating on the same wallet but different networks For instance one decentralized finance DeFi application could be running on Arbitrum while the other functions on Ethereum In such cases a casual alert indicating a network mismatch from MetaMask could lead to users prematurely closing your website Therefore it s crucial to discern whether the user is actively viewing your tab before deploying any alert regarding network discrepancies To address this challenge we turn our attention to one particularly handy DOM event visibilitychange This event allows us to detect changes in the visibility state of the tab i e whether it s in focus or in the background So how do we implement this in a React application It is as straightforward as it gets To ensure the user is actively viewing the tab when an alert is initiated you can listen to the visibilitychange event and check the document visibilityState property The following demonstrates a simplified example import useCallback useEffect useState from react const useIsTabActive gt const isTabVisible setIsTabVisible useState true const handleVisibilityChange useCallback gt setIsTabVisible document visibilityState visible useEffect gt document addEventListener visibilitychange handleVisibilityChange return gt document removeEventListener visibilitychange handleVisibilityChange return isTabVisible export default useIsTabActive By incorporating this simple check into your web applications you can significantly improve your user experience Not only does it prevent unnecessary alerts when a user is not actively engaging with your application but it also respects their attention and focus leading to a more professional and user centric application Stay tuned for further discussions on improving user experience in web applications in upcoming posts	2023-07-06 17:07:10
海外TECH	DEV Community	Placements | HackerRank | MSSQL	https://dev.to/ranggakd/placements-hackerrank-mssql-8a7	Placements HackerRank MSSQL The ProblemIn this SQL problem we re given three tables Students Friends and Packages The Students table contains two columns ID the student s ID and Name the student s name The Friends table contains two columns ID the student s ID andFriend ID ID of the ONLY best friend of the student The Packages table contains two columns ID the student s ID andSalary offered salary to the student in thousands per month Here s a visual representation of these three tables The task is to write an SQL query that outputs the names of those students whose best friends got offered a higher salary than them The names should be ordered by the salary amount offered to the best friends It s also guaranteed that no two students received the same salary offer ExplanationConsider the following input The expected output should be SamanthaJuliaScarletHere s why Samantha Julia and Scarlet s best friends all got offered a higher salary than they did while Ashley s best friend did not The SolutionHere I present two SQL solutions with slightly different approaches Each has its own strengths weaknesses and applicability Direct Join ApproachThe first source code uses direct JOIN operations to link the necessary data from all tables SELECT s nameFROM Students s JOIN Friends f ON s ID f IDJOIN Packages p ON p ID s IDJOIN Packages p ON p ID f Friend IDWHERE p Salary lt p SalaryORDER BY p SalaryIn this approach we are directly joining the Students Friends and Packages tables based on the respective IDs After joining the tables we filter out the students whose salary from p is less than their friend s salary from p and finally order the result by their friend s salary This is a straightforward and easy to understand method Subquery Join ApproachThe second solution uses subqueries to pre filter the tables before joining SELECT s NameFROM SELECT s ID s Name p Salary FROM Students s JOIN Packages p ON s ID p ID sJOIN SELECT f ID p Salary Friend Salary FROM Friends f JOIN Packages p ON f Friend ID p ID s ON s ID s IDWHERE s Salary lt s Friend SalaryORDER BY s Friend SalaryHere instead of joining all the tables at once we are creating two subqueries s and s to pre join the Students and Packages tables and Friends and Packages tables respectively Then we join these two subquery results on the ID filter the rows where the student s salary is less than their friend s salary and order the result by the friend s salary This approach can be a bit more efficient if there s a significant size difference between the tables as it reduces the size of the data before the join operation ConclusionBoth methods are effective in solving this problem with the difference mainly lying in their performance and scalability with varying table sizes Depending on the actual data distribution and size the subquery join approach might offer better performance due to reduced data size during joins You can find the original problem at HackerRank For more insightful solutions and tech related content feel free to connect with me on my Beacons page all the links on my beacons ai page	2023-07-06 17:07:00
Apple	AppleInsider - Frontpage News	Daily deals July 6: Amazon Prime Day gift card offer, $800 off M1 MacBook Pro, more	https://appleinsider.com/articles/23/07/06/daily-deals-july-6-amazon-prime-day-gift-card-offer-800-off-m1-macbook-pro-more?utm_medium=rss	Daily deals July Amazon Prime Day gift card offer off M MacBook Pro moreToday s hottest deals include off an Insignia Class F Series Smart HD Fire TV off an Amazon Fire HD tablet up to off OtterBox cases and accessories up to off Aduro tech products and more Save on a M MacBook ProThe AppleInsider crew searches the web for top notch bargains at ecommerce stores to develop a list of amazing deals on popular tech gadgets including discounts on Apple products TVs accessories and other items We post the top deals daily to help you save money Read more	2023-07-06 17:31:50
海外TECH	Engadget	The best Android phones for 2023	https://www.engadget.com/best-android-phone-130030805.html?src=rss	The best Android phones for Unlike the iOS ecosystem where Apple is the only game in town one of the best things about the Android phone market is the wide range of different devices and manufacturers to choose from That said when it actually comes time to upgrade that wealth of options can make it a bit more difficult to choose the right handset for you If you re looking for a new phone and don t know where to start we ve got you covered with a selection of the best Android phones for every budget What to look for in a new Android phonePerformanceWhen it comes to picking our favorite Android phones the main things we look for are pretty straightforward good performance both compute and AI a nice display solid design sharp cameras long battery life and a significant commitment to ongoing software support For performance not only do we look at benchmarks and other metrics but we also evaluate phones based on responsiveness Regardless of whether you re reading scrolling through social media or playing a game no one wants a device that feels sluggish DisplaySam Rutherford EngadgetWhen it comes to displays we generally prefer OLED panels that can produce rich saturated colors with at least nits of brightness though many of our top mid range and high end phones can hit nits or more And more recently most of our favorite devices also support screens with fast refresh rates of Hz or Hz which adds an extra level of smoothness and fluidity DesignNow we will admit there is a bit of subjectivity when deciding which phones look the best but there are other design aspects like dust and water resistance or screen durability that can make a big difference to long term survival It s also important to consider things like support for wireless charging power sharing aka reverse wireless charging and UWB connectivity which can have an impact on how your phone interacts with your other devices CamerasObviously for photos we re looking for sharp colorful shots in both bright and low light conditions And we want video clips with high dynamic range rich audio and smooth image stabilization Extra cameras for ultra wide and telephoto lenses are a plus It s also important to consider features like dedicated night modes support for various video recording resolutions and additional photo modes like timelapse slow motion and more Battery and softwareFinally in terms of battery life we re looking for all day longevity on devices that also delivered great results on our local video rundown test at least hours on a charge but more is obviously better Wireless charging capabilities have become almost ubiquitous over the past few years and most of our top picks have this extra perk Finally with people holding onto their phones longer than ever we like to see companies commit to at least three years of software support upgrades and regular security updates The Best Android PhonesBest Android phone overall Google Pixel ProThe Pixel Pro and the standard Pixel might not be the absolute fastest phones on the market but what they lack in pure performance they make up for with thoughtful software Thanks to Google s Tensor G chip the Pixel series features powerful AI and machine learning capabilities that support things like on device language recognition and real time translation You also get gorgeous OLED displays and the best overall camera quality of any smartphone available today And with the price tag of the standard Pixel starting at just Google s latest flagship is an incredible value too The main differences between the two are that the Pixel Pro has a larger inch screen and features a third rear camera with a x optical zoom But regardless of whether you prefer a smaller or larger device you can t really go wrong with either the Pixel or Pixel Pro Read our Full Review of the Google Pixel Pro Best mid range Android phone OnePlus For those who want a phone with a big screen excellent cameras and great performance but for less than a traditional flagship the OnePlus strikes a good balance between budget phones and more premium devices In a lot of ways the OnePlus is like a more affordable Galaxy S Not only do you get a similar inch Hz display it also features a speedy Snapdragon Gen chip and a big mAh battery Meanwhile thanks to OnePlus blazing watt wired charging it juices up faster than any phone from Google or Samsung And on the camera side the company s ongoing partnership with Hasselblad has resulted in notable improvements in image quality The main shortcomings of the OP are that its IP rating for dust and water resistance falls short of what you get from competing devices and the camera s x optical zoom lens feels a bit on the short side But with OnePlus adding wider carrier compatibility and committing four years of OS upgrades and five years of security patches the OP is a well equipped option that costs significantly less than its rivals Read our Full Review of OnePlus Best budget Android phone Google Pixel aThe Pixel a delivers everything we look for in a great affordable Android phone New features include a faster Tensor G chip a smoother Hz display and for the first time on one of Google s A series phones support for wireless charging And with a refreshed design with IP water resistance it looks and feels like the standard Pixel but for less You also get great support thanks to five years of security updates and at least three years of software updates The Pixel a s only shortcomings are rather small and include a lack of a dedicated zoom lens and no support for mmWave G unless you purchase a slightly more expensive model from Verizon Read our Full Review of the Google Pixel aBest premium Android phone Samsung Galaxy S UltraWith a starting price of the Galaxy S Ultra is very expensive but it has excellent performance and practically everything you could ever want or need in a smartphone It has a huge inch OLED display with a Hz adaptive refresh rate a total of five cameras main ultra wide x zoom x zoom and a selfie shooter and a built in S Pen for drawing and note taking It also features a huge mAh battery that delivers some of the longest runtime we ve seen on any phone And with Samsung s renewed commitment to software support you can expect a minimum of four major OS upgrades and five years of regular security patches Read our Full Review of Samsung Galaxy S UltraBest foldable Android phone Samsung Galaxy Z Fold While the Galaxy Z Flip is arguably the most stylish and compact phone on the market the bigger and more expensive Z Fold is like three devices in one which makes it a unicorn among mobile devices When you just need to respond to a text or look up an address quickly its inch exterior cover screen makes that a cinch But when you want to sit down to watch a movie or play a game you can open up the Fold to reveal a stunning inch flexible display As a foldable phone it s compact when you need it to be while providing an immersive viewing experience on a large screen when you don t And thanks to support for stylus input you even can use one of Samsung s S Pens designed specifically for the Fold to quickly draw or jot down a note On top of all that its OLED display makes the Z Fold great for reading books and comics And unlike practically any other non Samsung foldable the Fold also has an IP rating for dust and water resistance In a lot of ways this thing is the Swiss Army knife of phones Sure it s a bit bulky and at it s not what anyone would call affordable But this Samsung phone s ability to serve as a phone a tablet an e reader and more depending on the situation puts the Z Fold in a category of its own Read our Full Review of Samsung Galaxy Z Fold This article originally appeared on Engadget at	2023-07-06 17:28:19
海外科学	NYT > Science	Heat Records Broken Across Earth	https://www.nytimes.com/2023/07/06/climate/climate-change-record-heat.html	across	2023-07-06 17:06:03
海外TECH	WIRED	How Threads Could Kill Twitter	https://www.wired.com/story/threads-app-twitter-rival-meta/	twitter	2023-07-06 17:52:15
海外科学	BBC News - Science & Environment	High-status ancient Spanish tomb held 'Ivory Lady'	https://www.bbc.co.uk/news/science-environment-66112424?at_medium=RSS&at_campaign=KARANGA	status	2023-07-06 17:29:11
ニュース	BBC News - Home	Wimbledon school crash: Girl, 8, dies after car hits building	https://www.bbc.co.uk/news/uk-england-london-66120958?at_medium=RSS&at_campaign=KARANGA	london	2023-07-06 17:35:35
ニュース	BBC News - Home	Doreen Lawrence says decision not to charge police 'a disgrace'	https://www.bbc.co.uk/news/uk-66127025?at_medium=RSS&at_campaign=KARANGA	stephen	2023-07-06 17:53:53
ニュース	BBC News - Home	Lukashenko: No heroes after Wagner mutiny, Belarus leader tells BBC	https://www.bbc.co.uk/news/world-europe-66122337?at_medium=RSS&at_campaign=KARANGA	wagner	2023-07-06 17:31:39
ニュース	BBC News - Home	Week of strikes to disrupt Tube services, RMT says	https://www.bbc.co.uk/news/business-66127959?at_medium=RSS&at_campaign=KARANGA	tube	2023-07-06 17:49:20
ニュース	BBC News - Home	Wimbledon 2023 results: Liam Broady beats Casper Ruud, Katie Boulter through	https://www.bbc.co.uk/sport/tennis/66115993?at_medium=RSS&at_campaign=KARANGA	Wimbledon results Liam Broady beats Casper Ruud Katie Boulter throughBritish number five Liam Broady causes one of the biggest shocks at this year s Wimbledon with a remarkable five set win over Norwegian fourth seed Casper Ruud	2023-07-06 17:24:18
ニュース	BBC News - Home	UK to sanction Iran after credible threats from regime	https://www.bbc.co.uk/news/uk-66119534?at_medium=RSS&at_campaign=KARANGA	cleverly	2023-07-06 17:15:30
ニュース	BBC News - Home	The Ashes 2023: Mark Wood takes 5-34 but third Test poised after Mitchell Marsh ton	https://www.bbc.co.uk/sport/cricket/66125249?at_medium=RSS&at_campaign=KARANGA	The Ashes Mark Wood takes but third Test poised after Mitchell Marsh tonA rapid Mark Wood stars for England but Mitchell Marsh s ton means the third Ashes Test is in the balance after a gripping first day	2023-07-06 17:48:18
ニュース	BBC News - Home	Wimbledon 2023 Highlights: GB's Liam Broady beats Casper Ruud in a five-set thriller	https://www.bbc.co.uk/sport/av/tennis/66126841?at_medium=RSS&at_campaign=KARANGA	Wimbledon Highlights GB x s Liam Broady beats Casper Ruud in a five set thrillerWatch as Britain s Liam Broady beats Norwegian fourth seed Casper Ruud in one of the biggest shocks at this year s Wimbledon with a remarkable five set win on Centre Court	2023-07-06 17:54:13