投稿時間:2023-01-13 04:16:26 RSSフィード2023-01-13 04:00 分まとめ(23件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
js	JavaScriptタグが付けられた新着投稿 - Qiita	JavaScript 基礎 変数とデータ型まで	https://qiita.com/Mizut452/items/2952d328440a615cc3eb	const	2023-01-13 03:41:33
海外TECH	MakeUseOf	How to Use Google Home Routines	https://www.makeuseof.com/how-to-use-google-home-routines/	routines	2023-01-12 18:45:16
海外TECH	MakeUseOf	The 7 Best Python Libraries and Tools for Web Scraping	https://www.makeuseof.com/best-python-libraries-and-tools-for-web-scraping/	python	2023-01-12 18:30:01
海外TECH	MakeUseOf	How to Fix High on Life Crashing on Windows	https://www.makeuseof.com/high-on-life-crashing-windows/	windows	2023-01-12 18:15:02
海外TECH	DEV Community	Optimizing Mastodon Performance: Finding and Fixing its N+1 Queries	https://dev.to/appmap/optimizing-mastodon-performance-finding-and-fixing-its-n1-queries-57ni	Optimizing Mastodon Performance Finding and Fixing its N QueriesN queries happen in a variety of ways out of sight to many developers who are using an ORM With the level of abstraction that ORMs provide it can be easy for developers to accidentally incorporate a query that is executed on each result of the previous query ORMs can make development faster and more secure but the automatic generation of SQL queries can make it hard to predict the code s performance when it gets deployed Developers can be unaware their functions even query the database and a simple feature like checking user permissions could lead to querying for the same exact data multiple times Active Record is a Ruby on Rails framework used to easily save and retrieve objects from a database in programming frameworks It automatically generates SQL statements to do this ORMs like Active Record can make it easier for developers to write database backed applications but they can also make it harder to understand exactly how their code makes database queries In this final part of our Mastodon Series you ll learn how to analyze your AppMaps to uncover and fix an N SQL query in an active code base In the previous posts you have learned How you can install AppMap into MastodonHow to visualize Mastodon code internalsHow to run the Mastodon rspec tests How to automatically generate OpenAPI docs for MastodonIn our previous post you learned how AppMap uses the runtime code data to automatically generate accurate OpenAPI documentation AppMap contains all the relevant HTTP request information including status codes headers and the session operations and AppMap builds complete and accurate OpenAPI documentation by analyzing how the code executes This same AppMap data can be used in other ways for example in this post you ll learn how to use AppMap Analysis to locate and fix a performance issue Since the AppMaps shows function calls SQL queries exceptions and more they can be analyzed to find design flaws that contributes to performance and security issues Design related security flaws are rising in the OWASP Top in recent years Runtime data helps us to uncover design flaws that are contributing to slow performance such as an N query Generate Code Analysis FindingsWith our rspec tests passing and our AppMaps created back in Part findings are now shown in the section of our VSCode extension titled “Runtime Analysis Since AppMap records the runtime application behavior it analyzes the output of those recordings and scans for code behavior issues that you can t find with a static analyzer AppMap can scan for a variety of Performance Security Scalability and Maintainability issues These rules are extensible for developers to create and contribute to the open source community On the left side of the VS Code extension you can see a section called “Runtime Analysis This is where AppMap will display the results of the analysis scan This scan should happen within seconds of AppMaps being created or updated When clicking on any one of the lines of code referenced in the findings a new tab will open with additional details about the event including links to the relevant CWE The findings page will also show the stack trace leading up to the event and a list of the AppMaps this flaw is present in By navigating to the base controller in Mastodon AppMap identifies this line of code Line as making a database call via User find when the doorkeeper token variable is false But by looking closer at the stack trace AppMap shows line is the caller function which checks to see if the current user is known and properly validated This is correctly reported by AppMap as an N query L LA simple fix would be to just fetch current user once in require user or to memoize it in the current user function AppMap visualizes this function and the repeated SQL queries Understanding the Before and AfterBefore implementing the code change save the original AppMap in a “Baseline collection so that AppMap can visually compare the before and after impact of the change This code is found in AppMaps and they are listed on the specific findings page Now select one of these AppMaps right click them and choose the option to “Save To Collection Collections can be used to create copies of AppMaps which is useful for saving the current code behavior as a baseline before you implement code changes From there we can click lt create gt to create a new collection of AppMaps or select a previously created collection to add to After copying that AppMap to a new collection you ll see it included within the list of existing AppMaps It s important to note that this makes a copy of the AppMap in the state it was in when it was added to the Collection After updating the code and the AppMap the collection will still contain the previous version of the code Implementing the Performance FixThis poorly performing code is improved by breaking out the user validation into its own function so it will not repeatedly query the database for the same information Identify Out of Date AppMapsAfter making this code change either committed to your project or not AppMap will display both the baseline and other maps that are listed as out of date because we ve changed the functions these maps had previously recorded AppMap knows when the underlying code has been changed and can notify when the AppMaps no longer match the code Open the Command Palette in VS Code View gt Command Palette OR Shift ⌘ P on Mac OR Ctrl Shift P on Windows and search for the option to “Copy Out of Date Tests You can choose to copy the file names into the clipboard and paste them into the rspec command After successfully running only the tests needed to update our AppMaps the baseline AppMap will continue to be out of date and the other AppMaps will be updated It s important to note that when you make a code change to a function recorded in the “Baseline AppMap that AppMap will always display as “out of date since it will always represent the original test case run Generating Sequence Diagram DiffsAnother feature of AppMap is the ability to automatically create sequence diagrams of your code s runtime behavior This can be extremely useful information to include in a pull request or a code review to help other members of your team understand how the code behavior has changed Since a baseline AppMap exists prior to our code change AppMap can create a sequence diagram diff of the before and after Assuming the local VS Code environment is configured to support sequence diagram creation AppMap will be able to both generate a sequence diagram or compare two sequence diagrams To generate the sequence diagram diff right click on the latest version of the AppMap and select “Compare Sequence Diagrams Hit enter twice then select the original baseline AppMap saved in our Baseline collection From here a new browser window will open showing a sequence diagram diff visualizing the change in behavior of the code from before and after our changes The red items in sequence diagram will indicate code behavior that has been removed and green items will show new code paths created Now the changes in the sequence diagram show the code is not longer making similar repeated SQL queries By reducing these unnecessary queries the speed of this code function has increased SummaryIn this post you ve learned how to find and fix a performance issue in the Mastodon code base using AppMap The automated code analysis will work for other projects written in languages other than Ruby like Java Python and JavaScript TypeScript To get started finding potential issues in your code base download and install the AppMap VS Code Extension or the JetBrains Marketplace in your code editor and follow the similar instructions taken in this project For more language specific information check out the AppMap documentation or join the AppMap Community Slack to ask a developer for more information	2023-01-12 18:34:06
海外TECH	DEV Community	Introducing @The_Cloud_Dev and @TheCSSDev ☁️🎨	https://dev.to/devteam/introducing-theclouddev-and-thecssdev-3j7e	Introducing The Cloud Dev and TheCSSDev ️There are now two new ways to keep up with the best DEV Community posts on your favorite topics We ve just launched The Cloud Dev and TheCSSDev as Twitter feeds If you re still consuming content over on the Bird App and these are topics of interest to you we encourage you to follow along And if you know of any Mastodon servers on these topics drop them in the commentsーI m already looking forward to getting these feeds syndicated to the Fediverse Internally these are what we call Satellite Feeds In contrast to our main Twitter feed Satellite Feeds are more likely to promote up and coming authors product launches project updates feature logs and dev journals The Cloud Dev populates based on the tags cloud serverless kubernetes docker ec gcp and azure TheCSSDev populates based on the tag css Don t you love when things are simple That s all for now See you on social	2023-01-12 18:15:05
Apple	AppleInsider - Frontpage News	HumanCentric Workflow Desk review: a fantastic, albeit pricey standing desk	https://appleinsider.com/articles/23/01/12/humancentric-workflow-desk-review-a-fantastic-albeit-pricey-standing-desk?utm_medium=rss	HumanCentric Workflow Desk review a fantastic albeit pricey standing deskEffortlessly switch between standing and sitting while you work with the attractive and easy to use Workflow Desk The human body is designed to move which can be difficult if you ve got a desk job That s why we re big fans of height adjustable desks ーthey encourage you to move throughout your workday That s why we re looking at HumanCentric s Workflow Desk a higher end hardwood desk designed to look great while keeping you active even if you never leave your computer Read more	2023-01-12 18:26:25
海外TECH	Engadget	SBF thought it was a good idea to start a Substack	https://www.engadget.com/sam-bankman-fried-sbf-substack-ftx-183945643.html?src=rss	SBF thought it was a good idea to start a SubstackSam Bankman Fried is in a world of trouble He s facing up to years in prison if he s convicted of federal fraud and conspiracy charges And yet the embattled founder of collapsed crypto exchange FTX ーwho has pleaded not guilty and is out on a million bond while awaiting trial ーfigured it d be a great idea to write about his perspective on the saga in a Substack newsletter In his first post which is ostensibly about the collapse of FTX International Bankman Fried aka SBF claims that “I didn t steal funds and I certainly didn t stash billions away SBF notes that FTX US which serves customers in America “remains fully solvent and should be able to return all customers funds He added that FTX International still has billions of dollars in assets and that he is “dedicating nearly all of my personal assets to customers SBF who once had a net worth of approximately billion said at the end of November that he had in his bank account though he pledged to give almost all of his personal shares in Robinhood to customers The post covers much of the same ground that SBF has gone over in the myriad interviews he gave between FTX s collapse in November and his arrest last month He discusses the multiple crypto market crashes in and a tweet from Binance CEO Changpeng Zhao that sparked a run on FTX s FTT token and prompted the implosion of his exchange SBF also writes about how he was pressured to file for Chapter bankruptcy protection for FTX Meanwhile he notes that many of the numbers he cites in the post are approximations since he has been locked out of FTX s systems by those overseeing its bankruptcy proceedings What s more interesting is what SBF doesn t address He does not mention the fact that FTX co founder Zixiao quot Gary quot Wang and former Alameda Research CEO Caroline Ellison pleaded guilty to fraud charges and are cooperating with prosecutors SBF has continued to give interviews and tweet about the situation while he s out on bail That s despite the complaint filed against him by the Securities and Exchange Commission citing his tweets and comments he made in an interview in early December Perhaps this whole Substack thing will turn out to be a mistake too	2023-01-12 18:39:45
金融	RSS FILE - 日本証券業協会	協会員の異動状況等	https://www.jsda.or.jp/kyoukaiin/kyoukaiin/kanyuu/index.html	異動	2023-01-12 18:41:00
ニュース	BBC News - Home	Rishi Sunak facing major Tory rebellion over internet safety law	https://www.bbc.co.uk/news/uk-politics-64247034?at_medium=RSS&at_campaign=KARANGA	children	2023-01-12 18:39:51
ニュース	BBC News - Home	Brexit: Protocol deal no guarantee of Stormont return, says Irish PM	https://www.bbc.co.uk/news/uk-northern-ireland-64241176?at_medium=RSS&at_campaign=KARANGA	ireland	2023-01-12 18:15:36
ニュース	BBC News - Home	A&E nurse: Most challenging I've seen in 30 years	https://www.bbc.co.uk/news/health-64242333?at_medium=RSS&at_campaign=KARANGA	bolton	2023-01-12 18:27:54
ニュース	BBC News - Home	Fifa Best Awards 2022: England Lionesses and Lionel Messi lead nominees	https://www.bbc.co.uk/sport/football/64254793?at_medium=RSS&at_campaign=KARANGA	Fifa Best Awards England Lionesses and Lionel Messi lead nomineesArgentina forward Lionel Messi and England trio Leah Williamson Beth Mead and Keira Walsh are among the nominees for the Fifa Best Awards	2023-01-12 18:36:18
ビジネス	ダイヤモンド・オンライン - 新着記事	岸田政権で解散巡る発言が続々、攻めに転じた最高権力者の真意 - 永田町ライヴ！	https://diamond.jp/articles/-/315912	岸田文雄	2023-01-13 03:50:00
ビジネス	ダイヤモンド・オンライン - 新着記事	【社説】日米防衛同盟の強化 - WSJ PickUp	https://diamond.jp/articles/-/315978	wsjpickup	2023-01-13 03:45:00
ビジネス	ダイヤモンド・オンライン - 新着記事	労災や心の病気から回復したのに会社が「復職拒否」したときの対処法とは - 弁護士ドットコム発	https://diamond.jp/articles/-/315979	労災や心の病気から回復したのに会社が「復職拒否」したときの対処法とは弁護士ドットコム発うつ病など精神疾患を理由に休職する人も多いですが、復職をめぐって会社とトラブルになったという相談が弁護士ドットコムにも複数寄せられています。	2023-01-13 03:40:00
ビジネス	ダイヤモンド・オンライン - 新着記事	米企業の人員削減、ブルーカラーにも波及するか - WSJ PickUp	https://diamond.jp/articles/-/315977	wsjpickup	2023-01-13 03:35:00
ビジネス	ダイヤモンド・オンライン - 新着記事	「座りすぎ」は万病のもと！禅僧が教える「姿勢の整え方」 - 仕事も人生もうまくいく整える力	https://diamond.jp/articles/-/315343	枡野俊明	2023-01-13 03:30:00
ビジネス	ダイヤモンド・オンライン - 新着記事	CEOとCEO以外の違い - 最高経営責任者（CEO）の経営観	https://diamond.jp/articles/-/314483	CEOとCEO以外の違い最高経営責任者CEOの経営観「経営観は、人生観・世界観とともにリベラルアーツ自由に生きる技術を形成する、われわれ人間が確立すべき概念である。	2023-01-13 03:25:00
ビジネス	ダイヤモンド・オンライン - 新着記事	「気の利いた感想」が言える人になる、たった1つの方法 - VISION DRIVEN 直感と論理をつなぐ思考法	https://diamond.jp/articles/-/313074		2023-01-13 03:20:00
ビジネス	ダイヤモンド・オンライン - 新着記事	生まれ変わったかのように「脳を最高に幸福な状態」にするための習慣・ベスト3 - ストレスフリー超大全	https://diamond.jp/articles/-/314854	生まれ変わったかのように「脳を最高に幸福な状態」にするための習慣・ベストストレスフリー超大全生まれ変わったかのように「脳を最高に幸福な状態」にするための習慣とは、いったい何なのか。	2023-01-13 03:15:00
ビジネス	ダイヤモンド・オンライン - 新着記事	「頭が良くなるネットサーフィン」の、たった1つのコツ - 99％はバイアス	https://diamond.jp/articles/-/314865	突破	2023-01-13 03:10:00
ビジネス	ダイヤモンド・オンライン - 新着記事	【91歳の医師が明かす】 誰もがリスクを抱える「認知症」…近所で楽しんで予防になること - 91歳の現役医師がやっている 一生ボケない習慣	https://diamond.jp/articles/-/313991	【歳の医師が明かす】誰もがリスクを抱える「認知症」…近所で楽しんで予防になること歳の現役医師がやっている一生ボケない習慣「あれいま何しようとしてたんだっけ」「ほら、あの人、名前なんていうんだっけ」「昨日の晩ごはん、何食べんたんだっけ」……若い頃は気にならなかったのに、いつの頃からか、もの忘れが激しくなってきた。	2023-01-13 03:05:00