投稿時間:2021-10-31 02:15:55 RSSフィード2021-10-31 02:00 分まとめ(16件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	chrome拡張で特定のページのボタンを自動クリック	https://teratail.com/questions/367023?rss=all	chrome拡張で特定のページのボタンを自動クリック前提・実現したいこと指定の時間になったら指定のページに遷移し、そのページの指定したボタンをクリックする機能を作成中です。	2021-10-31 01:40:56
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	ボタンをClickしたときに画面を表示したいですが	https://teratail.com/questions/367022?rss=all	ボタンをClickしたときに画面を表示したいですがJavaScriptでHTMLのボタンidmyBtnをクリックしたときに、ポップアップ画面idjspopupを出したいですが、なぜか常に表示されています。	2021-10-31 01:31:41
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	負荷の少ないSQL文を書きたいのですが…	https://teratail.com/questions/367021?rss=all	負荷の少ないSQL文を書きたいのですが…SQLの書き方がおかしくて負荷が掛かる書き方になっていないか教えて欲しいです前提MySQL団体テーブル※団体に関する情報を扱うテーブル作品テーブル※団体が発表している作品に関する情報を扱うテーブル抽出条件や欲しい結果団体テーブル、作品テーブル両方に各種条件を指定します。	2021-10-31 01:12:41
海外TECH	MakeUseOf	The 5 Best Trello Power-Ups to Maximize Your Team Collaboration	https://www.makeuseof.com/best-trello-power-ups-to-maximize-team-collaboration/	The Best Trello Power Ups to Maximize Your Team CollaborationMany Trello users overlook Trello Power Ups but they add a whole new level of functionality Here are the best ones for improving team collaboration	2021-10-30 16:45:11
海外TECH	MakeUseOf	5 Ways to Fix the “Can't Reach This Page” Error on Microsoft Edge	https://www.makeuseof.com/ways-to-fix-page-error-microsoft-edge/	Ways to Fix the “Can x t Reach This Page Error on Microsoft EdgeHere are five ways to fix the “Can t Reach This Page error in Microsoft Edge in case you ever experience the error on the browser	2021-10-30 16:30:21
海外TECH	DEV Community	Fauna and FQL for Firestore users	https://dev.to/asyncbanana/fauna-and-fql-for-firestore-users-4ch3	Fauna and FQL for Firestore usersFauna and Firestore are very similar databases both offering instant scalability and fairly easy ways of querying but there are still some key differences In this article we will look at those differences and how to migrate from Firestore to Fauna and Fauna s query language FQL You might want to migrate because of Fauna s querying language flexibility or multi region capabilities Even if you don t know whether you want to migrate yet this article will provide some information on the differences BackgroundFirestore is a database created by Google in It is the successor to the two previous databases Firebase Realtime DB and Cloud Datastore It is grouped within the Firebase category group offering integration with different Firebase services although it is also offered through Google Cloud Firestore s primary selling points are that it is easy to use even without a server and has real time capabilities It also offers simple pricing based on reads data storage and writes Fauna is a database developed in by a few ex Twitter engineers to solve scalability problems with existing NoSQL databases Fauna offers a simple query language called FQL along with a GraphQL service if you do not want to learn another query language Fauna also can be used easily without a backend and is focused on doing that while remaining as scalable as possible Firestore and Fauna have a number of similar features and a few key differences They both abstract over cloud machines to provide a simple way of using them and even abstract over cross region replication They also both offer client side SDK s and real time capabilities Their query languages are a bit different as Fauna has a more comprehensive setup that allows you to do certain computations on the database through their query language This can increase speeds by mitigating the need for round trip queries Firestore s query language primarily consists of CRUD functions Another key difference is that Fauna is more flexible with querying capabilities and scalability Now that you know the background of each database and how they differ let s go more in depth Comparison Query LanguageNow that we ve highlighted a few differences in the query languages let s look more closely at those differences With Firestore there are two different styles of querying data function chaining and data passing via parameters Before the V update Firestore s SDK primarily used function chaining For example a basic read query might look like this const data await db collection cities doc SF get data The example above accesses the main database object then the collection and document by chaining the method functions That is still how it works if you use the server side SDK However in a more recent version of the client side web SDK there is a way to query by passing options as parameters instead const data await getDoc doc db collectionName documentName data Fauna only has one universal SDK and one querying style which resembles a more powerful version of the Firestore V SDK To perform operations you nest different functions within other functions For example to read a document you can do this const data await db query q Get q Ref q Collection collectionName documentName dataEach function is namespaced under q There are many more than just the ones used in that example For a full list you can look at Fauna s cheat sheet Fauna also provides a GraphQL API as mentioned before but I will not go over that for brevity Both query languages are pretty easy to use and you can do most things you need with both although Fauna s offers more ways of running things on the database to prevent roundtrips IndexesIndexes are one place where Firestore and Fauna differ quite a bit Firestore opts for an approach where it automatically creates indexes for all fields in a document and allows for querying using those indexes under the hood without worrying about them For indexes that include multiple fields you have to manually create a compound query This approach makes it easy to query but can end up costing the user more as Firestore creates indexes even when they are not needed which takes more storage space In contrast Fauna makes you manually create indexes although it offers an easy to use dashboard and FQL function for creating indexes Fauna also offers more capabilities for indexes like cross collection indexes Transactions amp ConsistencyBoth Firestore and Fauna offer strongly consistent database operations Fauna uses Calvin which allows it to replicate data globally with strong consistency Firestore does not use as advanced of a replication system although it still does offer strong consistency The biggest difference for consistent transactions is that as mentioned before Fauna allows you to do more things on the database directly This makes it so that you can reduce time when data could change in the process of your server responding to data So Fauna is definitely better in this case in terms of reliably running consistent transactions out of the box but both work fairly well in this case PricingPricing for Firestore and Fauna are similar in some ways but very different in others They both price by reads writes and storage although Fauna also prices compute operations which are operations done on their servers Both offer free tiers so you can try either without paying anything Firestore costs pricing varies based on the region you are using For a typical single region configuration Firestore costs per million documents read per million documents written to and per gigabyte of storage For a multi region configuration Firestore costs per million documents read per million documents written to and per gigabyte of storage Because Fauna is global by default it has more consistent pricing although Fauna multiplies all costs by x if you are storing all data in Europe and x if you are storing some in Europe Fauna costs per million documents read per million documents written to per million compute operations and per gigabyte of storage As you can see from above their costs are fairly close Fauna can be more expensive on the surface level but it is only sometimes more expensive This is because Fauna offers features like built in compression and often cheaper querying Ultimately you will need to do more research based on your own needs to figure out which is cheaper LimitsBoth databases have some limits for throughput and size For Firestore there are multiple limits on documents One is that documents must be megabyte or less and can not be changed more than once per second Another is that no more than write operations can be executed on the database per second and those write operations cannot collectively contain more than megabytes of data Also nested data in document maps have a max depth of although you can get around that by turning it into a JSON string There are many other limits shown on their Limits page but those are the most relevant for most people Fauna also has limits albeit less Document sizes are capped at megabytes transaction sizes are capped at megabytes and index entries have to stay below bytes For more information you can look at their Limits page Comparison ConclusionFauna and Firestore are very related in many ways but differ importantly in others Both are easy to use although Fauna can be more powerful If you have previously used Firestore and are interested in Fauna read on for an intro to FQL Fauna Query Language designed for previous Firestore users Intro to FQL from FirestoreAs you saw in the query language section of the comparison there can be quite a few differences between the two database s way of querying especially if you are used to the used to the function chaining Firestore SDK Luckily FQL is fairly intuitive so you should not have much trouble learning it A basic FQL query is just db query with nothing passed to it To do things with queries you pass different functions to the query function like q Get or q Create and to pass the right information to those operations like what document you nest functions like q Ref and q Collection This might sound verbose for someone used to someone used to Firestore s way of just running get on a document but it can be more elegant and you can do more Creating DocumentsFauna offers a function q Create that allows for creating documents like Firestore s add function You simple pass a collection and data and it will return a reference to the new document as well as the new document s data const result await db query q Create q Collection collectionName data field fieldValue fruit bananas Get reference to resultconsole log result ref Get new result dataconsole log result data The equivalent with Firestore would beconst result await addDoc collection db collectionName field fieldValue fruit bananas Get reference to resultconsole log result This works for creating a document without specifying an ID but you can also update an existing document by using q Ref with a collection and id instead of q Collection Getting DocumentsThis is pretty simple to implement if you just are getting a document by ID and collection name const data await db query q Get q Ref q Collection collectionName documentName dataAs you can see there is a query function that contains a get query with a ref passed to it This is equivalent toconst data await db collection collectionName doc documentName get data orconst data await getDoc doc db collectionName documentName data Setting Updating DocumentsFauna offers two built in methods for this q Replace for destructive replacing and q Update for updating specific fields without changing the whole document This equates to the Firestore set and update functions await db query q Replace q Ref q Collection collectionName documentName data field fieldValue fruit still bananas await db query q Update q Ref q Collection collectionName documentName data fruit still bananas This is equivalent to v web or Nodeawait db collection collectionName doc documentName set field fieldValue fruit still bananas await db collection collectionName doc documentName update fruit still bananas v webawait setDoc doc db collectionName documentName field fieldValue fruit still bananas await updateDoc doc db collectionName documentName fruit still bananas Currently if you want to emulate the behavior of set with merge true which creates a document if it does not exist yet you can use run a query that checks if a document exists and creates it if it does not using q If Deleting DocumentsDeleting a document with Fauna is just like getting a document but with q Delete instead of q Get await client query q Delete q Ref q Collection collectionName documentName This equates to v web or nodeawait db collection collectionName doc documentName delete v webawait updateDoc doc db collectionName documentName ConclusionFauna is a great alternative to Firestore with a more powerful query API and other advantages They are very similar databases and it is easy to migrate to Fauna from Firestore I hope this article has enlightened you on the differences between Fauna and Firestore as well as how FQL code translates to Firestore code and thanks for reading	2021-10-30 16:42:22
海外TECH	Engadget	2021 MacBook Pro teardown reveals easy-to-remove batteries	https://www.engadget.com/ifixit-2021-mac-book-pro-teardown-163032306.html?src=rss	MacBook Pro teardown reveals easy to remove batteriesApple may have given us a glimpse of what the new and inch MacBook Pros insides look like but it had a surprise waiting for the folks at iFixit nonetheless The iFixit team said removing batteries from recent MacBook Pros required quot infinite patience a bottle of isopropyl alcohol and an optional bottle of human friendly alcohol quot They expected the same from this generation of laptops but were pleasantly surprised by the presence of pull tabs instead when they tore down the new MacBook Pros The outer battery cells have noticeable pull tabs that you can well pull to detach them from their adhesive underneath Even the central battery cells have pull tabs ーthey re just harder to find inside the laptop chassis beneath the trackpad iFixit was able able to confirm that the laptops will recognize and work with battery replacements just fine In addition most of the laptops ports except for the SD card reader and the HDMI port are modular That means they can be easily and cheaply replaced if they suddenly break or malfunction Conversely the laptops keyboard will still be hard to replace but hey at least the days of Apple s butterfly keyboard are now over You can watch iFixit s teardown process in the video below and it also has more photos of the laptops insides on its website if you want to have a better look at their components iFixit also took apart Apple s polishing cloth in case you re wondering what makes it more expensive that its typical counterparts	2021-10-30 16:30:32
海外TECH	Engadget	Patreon may let you reward creators with crypto	https://www.engadget.com/patreon-crypto-creator-coins-161355243.html?src=rss	Patreon may let you reward creators with cryptoPatreon doesn t let creators offer crypto coins for the sake of profit but that might change before long TechCrunchreports Patreon executives Jack Conte and Julian Gutman said at The Information s latest summit that the company was quot evaluating quot the use of crypto including a previously hinted at possibility of allowing quot creator coins quot that fans can buy to show support You could invest in creators and reap rewards if they hit the big time or access special content reserved for coin owners Conte wouldn t say if Patreon had staff devoted to crypto projects but did say the company was quot thinking about it quot The company had discussed the possibility of allowing creator coins during an online September discussion but it was sidelined as the company grappled with the implications of Mastercard s tougher adult content standards Gutman added that Patreon was quot interested quot in studying the potential benefits of NFTs and related technologies for creators looking to sustain a business NFTs have boosted the value of digital art sometimes leading to sales worth millions but there are also widespread concerns about the highly speculative nature of the market and the blockchain based technology s environmental impact It wouldn t be surprising if Patreon embraced coins NFTs or both Patreon has fared well despite early pandemic jitters and raised million just a year ago but there s little doubt the service is trying to court as many creators as possible A new stance on crypto might entice content producers who currently have to go elsewhere if they want to dabble in the technology	2021-10-30 16:13:55
海外TECH	Engadget	ICYMI: Apple’s new MacBook Pros have (nearly) everything you’d want	https://www.engadget.com/icymi-apples-new-macbook-pros-have-nearly-everything-youd-want-160049252.html?src=rss	ICYMI Apple s new MacBook Pros have nearly everything you d wantThis week we tested out new flagship smartphones high powered laptops and much improved earbuds Devindra Hardawar reviewed the latest and inch MacBook Pros and reports back that they provide almost everything one could want out of a powerful laptop Billy Steele spent time listening to the third generation AirPods and concluded they sound much better than the previous version And Cherlynn Low used Google s Pixel and Pro and found that the camera heavy handsets have a lot more to offer including a great starting price The new MacBook Pros have a ton of power and ports Devindra Hardawar EngadgetDevindra Hardawar says the and inch MacBook Pros are precisely what media professionals have been waiting for speedy M Pro and Max processors a comfortable keyboard serious battery life and great speakers They also feature most of the crucial ports MacBooks have been missing for years including finally an SD card reader though the laptops are thicker and heavier as a result And of course all that comes with a high starting price of Devindra was particularly impressed by the Liquid Retina XDR displays which come close to K resolutions and have mini LED backlighting to produce up to nits of brightness He was also pleased to find support for Hz refresh rates and by the benchmark testing in which both MacBook Pros blew away competing Windows PCs However while the laptops were able to speedily convert a K video clip to p Devindra doesn t think they d make the best gaming machines ーtrying to load Borderlands produced an unplayable mess Overall though he says these computers have practically everything one especially a creative professional would want in a powerful notebook ーas long as you can stomach the price tag The third gen Airpods have a better fit and more featuresBilly Steele EngadgetApple s latest AirPods have been almost completely redesigned from the previous version the buds themselves have a new look courtesy of the contoured shape which reduces weight and features a tapered silhouette and an angle to increase comfort Billy Steele says the company s efforts to build better AirPods have paid off the new buds are more comfortable and and have much better audio quality with bigger and more immersive sound that remained open and airy That s thanks to a custom driver paired with a high dynamic range amplifier as well as the new H chip and the inward facing mic Billy says these changes made the AirPods something he actively wanted to listen to music with The new AirPods also have an IPX rating so they ll survive sweaty workouts or small splashes They can also detect skin which combined with the built in accelerometer makes for more accurate pausing and extends battery life The new chip means you can listen to tracks in Dolby Atmos on Apple Music and the spatial audio is available with dynamic head tracking to change the position of the audio when you turn your head However the latest AirPods still lack active noise cancellation and Transparency mode as these features are still reserved for the pricier AirPods Pro While Billy acknowledges that these earbuds aren t for everyone he says they continue to offer Apple users features that are well integrated with iPhone iPad and Mac Google s Pixel and Pro are excellent phones with great prices nbsp David Imel for EngadgetCherlynn Low says the newest Google phones ーthe Pixel and Pro ーare the most intriguing phones that the company has made in years Featuring the first Google mobile processor Tensor the two handsets also have improved camera hardware lovely OLED screens speedy refresh rates Hz for the Pro Hz for the and decent speakers Cherlynn says the best feature is the surprisingly low starting price ーonly ーwhich makes some of the drawbacks more forgivable One of the issues she had with the phones was the laggy under screen fingerprint sensor which requires the display to be on before it unlocked ーa process that she says doesn t need to have two steps She was more impressed by the new voice keyboard which did an excellent job of transcribing speech and the additional camera features The sensors are sharper and bigger with larger pixels producing bright clean photos ーand special camera features like Magic Eraser and Face Unblur give users a lot of control over their photos The Pixel and Pro excelled in our battery tests too lasting hours and hours respectively Overall Cherlynn calls the handsets a superb return to form showing off Google s strengths in the software and photography departments	2021-10-30 16:00:49
ニュース	BBC News - Home	Fishing row: Turbulence has hit relations with France, PM says	https://www.bbc.co.uk/news/uk-59101193?at_medium=RSS&at_campaign=KARANGA	boris	2021-10-30 16:23:47
ニュース	BBC News - Home	Haverfordwest: One in hospital after River Cleddau rescue operation	https://www.bbc.co.uk/news/uk-wales-59102136?at_medium=RSS&at_campaign=KARANGA	operationone	2021-10-30 16:44:03
ニュース	BBC News - Home	Stansted Airport reopens after suspicious package evacuation	https://www.bbc.co.uk/news/uk-england-essex-59103435?at_medium=RSS&at_campaign=KARANGA	stansted	2021-10-30 16:41:25
ニュース	BBC News - Home	Manchester City 0-2 Crystal Palace: Wilfried Zaha & Conor Gallagher spoil Pep Guardiola's 200th Premier League game	https://www.bbc.co.uk/sport/football/59019330?at_medium=RSS&at_campaign=KARANGA	Manchester City Crystal Palace Wilfried Zaha amp Conor Gallagher spoil Pep Guardiola x s th Premier League gameCrystal Palace upset man Manchester City to spoil Pep Guardiola s th Premier League match as manager at Etihad Stadium	2021-10-30 16:20:14
ニュース	BBC News - Home	Brighton come from 2-0 down for superb draw at Liverpool	https://www.bbc.co.uk/sport/football/59019334?at_medium=RSS&at_campaign=KARANGA	Brighton come from down for superb draw at LiverpoolBrighton come from two goals down to secure a deserved point and deny Liverpool a place at the top of the table in an incident packed game at Anfield	2021-10-30 16:16:14
ニュース	BBC News - Home	Covid-19 in the UK: How many coronavirus cases are there in my area?	https://www.bbc.co.uk/news/uk-51768274?at_medium=RSS&at_campaign=KARANGA	cases	2021-10-30 16:19:18
海外TECH	reddit	DWG KIA vs. T1 / 2021 World Championship - Semi-Final / Post-Match Discussion	https://www.reddit.com/r/leagueoflegends/comments/qj59f0/dwg_kia_vs_t1_2021_world_championship_semifinal/	DWG KIA vs T World Championship Semi Final Post Match DiscussionWORLDS KNOCKOUT STAGE Official page Leaguepedia Liquipedia Live Discussion Eventvods com New to LoL DWG KIA T DWG KIA move on to the Finals and will face the winner of EDward Gaming vs Gen G T have been eliminated from the tournament DK Leaguepedia Liquipedia Website Twitter Facebook YouTube T Leaguepedia Liquipedia Website Twitter Facebook YouTube MATCH DK vs T Winner DWG KIA in m Game Breakdown Runes Bans Bans G K T D B DK aphelios nami graves thresh jinx k H I H O B C T yuumi syndra twisted fate ziggs rakan k None DK vs T Khan lucian TOP jayce Canna Canyon lee sin JNG poppy Oner ShowMaker leblanc MID ryze Faker Ghost jhin BOT miss fortune Gumayusi BeryL maokai SUP leona Keria MATCH T vs DK Winner T in m Game Breakdown Runes Bans Bans G K T D B T ryze twisted fate jarvan iv miss fortune ziggs k H C O O B DK yuumi aphelios lucian gwen kennen k I H O T vs DK Canna yasuo TOP graves Khan Oner lee sin JNG xin zhao Canyon Faker lissandra MID leblanc ShowMaker Gumayusi jhin BOT draven Ghost Keria rakan SUP alistar BeryL MATCH DK vs T Winner T in m Game Breakdown Runes Bans Bans G K T D B DK aphelios nami graves gwen rakan k H M H I C T yuumi lee sin twisted fate leona jayce k C B C B DK vs T Khan lucian TOP kennen Canna Canyon jarvan iv JNG xin zhao Oner ShowMaker syndra MID ryze Faker Ghost miss fortune BOT jhin Gumayusi BeryL maokai SUP zilean Keria MATCH DK vs T Winner DWG KIA in m Game Breakdown Runes Bans Bans G K T D B DK aphelios nami graves jinx ziggs k H O H I M B T yuumi lee sin twisted fate kennen irelia k None DK vs T Khan gragas TOP jayce Canna Canyon qiyana JNG jarvan iv Oner ShowMaker leblanc MID ryze Faker Ghost jhin BOT lucian Gumayusi BeryL rakan SUP lulu Keria MATCH T vs DK Winner DWG KIA in m Game Breakdown Runes Bans Bans G K T D B T leblanc jarvan iv ryze qiyana kassadin k H H B DK lee sin yuumi twisted fate lulu thresh k C I M M E T vs DK Canna kennen TOP graves Khan Oner xin zhao JNG talon Canyon Faker azir MID zoe ShowMaker Gumayusi aphelios BOT ziggs Ghost Keria zilean SUP rakan BeryL Patch This thread was created by the Post Match Team submitted by u adzr to r leagueoflegends link comments	2021-10-30 16:40:48