投稿時間:2023-07-31 05:21:58 RSSフィード2023-07-31 05:00 分まとめ(23件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
python	Pythonタグが付けられた新着投稿 - Qiita	Xarrayによるモダンなデータ解析(3) DataArray編	https://qiita.com/wm-ytakano/items/564476a1e378a3bd7060	dataarray	2023-07-31 04:13:30
海外TECH	MakeUseOf	Two Innocent-Looking Apps Are Slowing Down Your Windows 11 PC	https://www.makeuseof.com/windows-11-chat-widget-app-performance-hit/	Two Innocent Looking Apps Are Slowing Down Your Windows PCThe Chat and Widget icons on your Windows PC may seem lightweight but there s proof that they can take a toll on your system s resources	2023-07-30 19:15:23
海外TECH	DEV Community	Writing SQL Queries in Apache Age: A Comprehensive Tutorial for Data Analysis and Transformation	https://dev.to/mubeensiddiqui/writing-sql-queries-in-apache-age-a-comprehensive-tutorial-for-data-analysis-and-transformation-4f9b	Writing SQL Queries in Apache Age A Comprehensive Tutorial for Data Analysis and TransformationIntroduction Apache Age the powerful open source project that combines the capabilities of PostgreSQL and Apache Hadoop offers an excellent SQL interface for big data analytics SQL Structured Query Language is a widely used language for data manipulation and analysis In this tutorial we will explore the art of crafting SQL queries in Apache Age to perform data analysis and transformations Whether you re a seasoned SQL expert or a beginner eager to explore the world of big data this guide will equip you with the knowledge and skills needed to harness the full potential of Apache Age Prerequisites Before we dive into the exciting world of SQL queries in Apache Age it s essential to have a basic understanding of SQL and some familiarity with Apache Age s installation and setup Connecting to Apache Age To start our SQL journey we need to connect to an Apache Age instance You can install Apache Age on your local machine or connect to a remote instance Connect to Apache Age on localhost with default credentialspsql h localhost p U age d age Creating a Sample Dataset Let s create a sample dataset to work with For this tutorial we ll use a hypothetical e commerce dataset containing information about customers products orders and order items The sample dataset will be distributed across Hadoop s HDFS but Apache Age allows you to interact with it using SQL seamlessly Basic SELECT Queries The SELECT statement is the backbone of SQL allowing us to retrieve data from a database In Apache Age we can execute SELECT queries as if we were working with a regular PostgreSQL database Retrieve all columns from the customers tableSELECT FROM customers Retrieve specific columns from the orders tableSELECT order id order date total amount FROM orders Filtering Data with WHERE Clause The WHERE clause allows us to filter data based on specific conditions Retrieve orders made by a specific customerSELECT FROM orders WHERE customer id Retrieve orders placed after a certain dateSELECT FROM orders WHERE order date gt Aggregating Data with GROUP BY The GROUP BY clause helps summarize data by grouping rows based on common values Get the total sales amount for each productSELECT product id SUM price AS total sales FROM order items GROUP BY product id Combining Tables with JOIN JOINs allow us to combine data from multiple tables based on common columns Retrieve all orders along with the customer informationSELECT FROM ordersJOIN customers ON orders customer id customers customer id Data Transformation with CASE The CASE statement enables conditional logic within SQL queries allowing us to perform data transformations Create a new column indicating whether an order is a high value orderSELECT order id total amount CASE WHEN total amount gt THEN High Value ELSE Regular END AS order typeFROM orders Sorting Data with ORDER BY The ORDER BY clause allows us to sort query results based on specific columns Retrieve orders sorted by total amount in descending orderSELECT FROM orders ORDER BY total amount DESC Conclusion In this comprehensive tutorial we ve explored the art of writing SQL queries in Apache Age to perform data analysis and transformations Apache Age s seamless integration of PostgreSQL and Apache Hadoop opens up a world of possibilities for handling big data with the familiarity and power of SQL	2023-07-30 19:43:24
海外TECH	DEV Community	Looking Beyond Atlassian StatusPage: The 5 Best Alternatives	https://dev.to/squadcast/looking-beyond-atlassian-statuspage-the-5-best-alternatives-4mop	Looking Beyond Atlassian StatusPage The Best Alternatives IntroductionStatus Page are crucial cogs in your Incident Communication process they serve as vital channels to keep your stakeholders informed during periods of downtime Although there are many proficient tools in the market such as Atlassian Status Page and Status io these standalone Status Page can come with a hefty price tag with various pricing plans and tiers for both Public and Private Status Page Additionally being standalone products these tools often lack functionalities found in comprehensive solutions that include On Call Management Incident Response and SRE Site Reliability Engineering The Status Page alternatives we delve into below have been evaluated based on the expansiveness of their functionalities and cost effectiveness We also touch upon a few open source Status Page but be forewarned that building your own Status Page comes with its own challenges As building one from scratch may sound feasible in theory you would invariably end up investing countless hours to customize it to your specifications Let s explore the diverse alternatives to Atlassian Status Page SquadcastSquadcast is among the top end to end Incident Management tools in the market Squadcast combines On Call Management Incident Response and SRE features like Unlimited Public and Private Status Page all in one comprehensive reliability workflow solution With enriched On Call Management features such as Schedules Escalation Policies Unlimited alerting and much more Squadcast offers a holistic solution For Incident Response it provides comprehensive ChatOps Integrations with Slack and MS teams a Mobile App and a multitude of options to enhance your Incident Response Squadcast also offers a host of SRE features including Automation Rules SLO Dashboard Runbooks Postmortems Analytics and more Creating on brand beautiful Status Page with a customizable domain is a breeze with Squadcast You can display whichever part of your Services or Components you desire on your Status Page with granular control Moreover the Services and Components come with the option to showcase Uptime history for up to days One of the defining features of Squadcast Status Page is to ensure that your customers and stakeholders remain informed about your Services and Components at every stage upcoming and Scheduled Maintenance Windows have been built keeping this in mind allowing your stakeholders and customers to subscribe to each Maintenance Window The Issue History timeline categorizes and outlines timelines of different Incidents Issues and status update announcements Additionally you can allow subscriptions to each component on your Status Page Cost Designed for Enterprises Squadcast offers an unlimited number of Status Page both Public and Private along with On Call Management and Incident Response to customers on their Enterprise plan priced at user This plan also permits up to subscribers Main Features Public and Private Status PageService Component Display Day Uptime HistoryMaintenance WindowsIssue Incident History TimelineCustom DomainCustomizable ThemesOver SubscribersPassword Protected Private Status PageCustom BillingAccess to Rest APIs Better StackWhile looking at Better Stack Status Page the first thing that will stand out is their neat User Interface Better Stack is a popular Incident Management platform that serves up both Public and Private Status Page making them a worthy inclusion in this list In Better Stack Status Page the status of the services displayed is directly linked to monitoring tools This can potentially lead to confusion as non critical downtime registered by the monitoring tool might be perceived as critical downtime by customers and stakeholders due to its immediate reflection on the Status Page Furthermore Better Stack s limited compatibility with various Infrastructure Monitoring tools presents another challenge If your services are monitored by a tool that isn t supported by Better Stack any resulting downtime wouldn t be displayed on the Status Page potentially leading to discrepancies Despite these challenges Better Stack does offer appealing features such as a large number of subscribers password protected Private Status Page customizable themes and more available within their higher pricing plan CostThe cost factor plays in Better Stack s favor as unique Status Page with custom domains can be created by all users on the free plan Their paid plan offering five Status Page along with a custom domain and customizable theme starts at for a single user account Main Features Public and Private Status PageFree Status PageCustom Domain RootlyRootly operates in the Incident Management space and offers a Status Page alongside Incident Response features With a user friendly interface they provide both Public and Private Status Page One of the standout features of Rootly s Status Page is the capability to publish incidents not only via the web user interface but also through Slack This can prove to be beneficial during critical incidents as it allows team members to stay within their familiar communication platform However it s worth noting that Rootly doesn t provide the option to subscribe to individual services or components directly from the Status Page Furthermore their documentation can be improved CostAs for the cost Rootly only has one paid plan which includes unlimited Private and Public Status Page along with other Incident Response features Detailed pricing information however is available only upon contacting their Sales team Main Features Public and Private Status PageCustom DomainIncidents Published via SlackDisplay of Services and Incident Status Cachet Open Source Cachet is a name that might ring a bell if you re into the open source scene It features a clean design for its Status Page displaying components past incidents and even a detailed progression of each incident They offer basic uptime monitors and provide an appealing visual display of your metrics Through their API you can conveniently set up the metrics that matter to you A couple of standout features that Cachet brings to the table are two factor authentication for account security and support for languages for your Status Page CostAs for the price tag though Cachet is an open source tool the installation of its Status Page starts at Main FeaturesService and Components DisplayDetailed Incident Progression TimelineMaintenance WindowsMetrics DisplayTwo factor Authentication Staytus Open Source Staytus offers you the ability to create neat Status Page with customizable themes to fit your brand One of the best parts about Staytus is its flexibility You have the option to either manually add issues incidents through the Web UI or directly link your services to your own monitoring systems It s entirely free and comes with features that can really level up your Status Page game Main Features Service Components DisplayMaintenance WindowsE mail SubscriptionsJSON API for updating statuses from external applications amp sources ConclusionIn conclusion each alternative offers unique features and the choice of making the right decision depends on your organization s specific needs budget preference for proprietary or open source tools We recommend that you explore different tools opt for demos interact with the sales team and consider doing a free trial if available At Squadcast you can get started with our Status Page and other offerings with a day free trial	2023-07-30 19:07:28
海外TECH	DEV Community	FLaNK Stack Weekly for 24 July 2023	https://dev.to/tspannhw/flank-stack-weekly-for-24-july-2023-40kf	FLaNK Stack Weekly for July July PTO week FLiPN FLaNK Stack WeeklyTim Spann PaaSDev tspannhw CODE COMMUNITYPlease join my meetup group NJ NYC Philly Virtual This is Issue Videos ab channel PierreVillard Talks Articles EventsJuly Implement a Universal Data Distribution Architecture to Manage All Streaming Data July Hours to Data Innovation Data FlowOctober Hours to Data Innovation Data FlowCloudera EventsMore Events Code NiFi Code Tools Tim Spann	2023-07-30 19:02:39
ニュース	BBC News - Home	Six killed at Palestinian refugee camp in Lebanon	https://www.bbc.co.uk/news/world-middle-east-66354364?at_medium=RSS&at_campaign=KARANGA	refugee	2023-07-30 19:43:09
ビジネス	ダイヤモンド・オンライン - 新着記事	生前贈与＆タワマン節税の2大節税術が「24年」に大改正、相続税は平均1819万円に！ - 有料記事限定公開	https://diamond.jp/articles/-/326437	生前贈与	2023-07-31 04:50:00
ビジネス	ダイヤモンド・オンライン - 新着記事	大和ハウス工業「売上高10兆円」へ！メーカー、ゼネコン、デベロッパーの顔を持つ“三刀流経営”徹底解剖 - 大和ハウス工業 三刀流の異端経営	https://diamond.jp/articles/-/326802	「創業周年の年に売上高兆円」という創業者の“夢に向かって猛進する大和ハウスは年度、創業から年で“合目にたどり着こうとしている。	2023-07-31 04:45:00
ビジネス	ダイヤモンド・オンライン - 新着記事	日本カストディ銀行の悪事を暴く！IBMや野村総研を巻き込んだ「DX利権」が判明 - DX利権 日本カストディ銀行の悪事	https://diamond.jp/articles/-/326787		2023-07-31 04:40:00
ビジネス	ダイヤモンド・オンライン - 新着記事	米利上げで脚光、昔ながらの貯蓄方法 - WSJ PickUp	https://diamond.jp/articles/-/326864	wsjpickupfrb	2023-07-31 04:35:00
ビジネス	ダイヤモンド・オンライン - 新着記事	インバウンドだけでGDP0.8％押し上げ？日本経済「堅調持続」を示唆する経済データ - 政策・マーケットラボ	https://diamond.jp/articles/-/326835		2023-07-31 04:30:00
ビジネス	ダイヤモンド・オンライン - 新着記事	米景気後退は数年先？ 成長いつまで続くか - WSJ PickUp	https://diamond.jp/articles/-/326863	wsjpickup	2023-07-31 04:25:00
ビジネス	ダイヤモンド・オンライン - 新着記事	ニジェールの軍事クーデター、ロシアに戦略的優位性も - WSJ PickUp	https://diamond.jp/articles/-/326862	wsjpickup	2023-07-31 04:20:00
ビジネス	ダイヤモンド・オンライン - 新着記事	人的資本を一極集中するには、フリーエージェント戦略が最適 - シンプルで合理的な人生設計	https://diamond.jp/articles/-/326724	人生設計	2023-07-31 04:20:00
ビジネス	ダイヤモンド・オンライン - 新着記事	MARCHに迫る人気大学・武蔵大生のリアルな就活状況は？ - 大学図鑑！2024 有名大学82校のすべてがわかる！	https://diamond.jp/articles/-/326847		2023-07-31 04:17:00
ビジネス	ダイヤモンド・オンライン - 新着記事	職場にいる「まわりのやる気をなくさせてしまう人」と「まわりをやる気にさせる人」の決定的な差とは - 1秒で答えをつくる力 お笑い芸人が学ぶ「切り返し」のプロになる48の技術	https://diamond.jp/articles/-/326843		2023-07-31 04:14:00
ビジネス	ダイヤモンド・オンライン - 新着記事	要注意！ 定年後の健康保険で「任意継続」を選んだ人が陥りがちな悲劇 - 知らないと大損する！定年前後のお金の正解　改訂版	https://diamond.jp/articles/-/326390	要注意定年後の健康保険で「任意継続」を選んだ人が陥りがちな悲劇知らないと大損する定年前後のお金の正解改訂版定年前後の決断で、人生の手取りは万円以上変わるマネージャーナリストでもある税理士の板倉京氏が著し、「わかりやすい」「本当に得をした」と大人気になった書籍が年の制度改正に合わせ改訂パワーアップ「知らないと大損する定年前後のお金の正解改訂版」として発売されます。	2023-07-31 04:11:00
ビジネス	ダイヤモンド・オンライン - 新着記事	児童精神科医が教える、子どもを苛む「不安と恐怖」に親ができること【書籍オンライン編集部セレクション】 - エディターズ・チョイス	https://diamond.jp/articles/-/326371	児童精神科医が教える、子どもを苛む「不安と恐怖」に親ができること【書籍オンライン編集部セレクション】エディターズ・チョイスコロナと生きる生活が日常になった今、目まぐるしく変わる状況や、情報にさらされて、不安や恐怖にとらわれる人が増えている。	2023-07-31 04:08:00
ビジネス	ダイヤモンド・オンライン - 新着記事	【精神科医が教える】 心がモヤモヤするときの必殺技・ベスト1 - 精神科医Tomyが教える 40代を後悔せず生きる言葉	https://diamond.jp/articles/-/323776	【精神科医が教える】心がモヤモヤするときの必殺技・ベスト精神科医Tomyが教える代を後悔せず生きる言葉【大好評シリーズ万部突破】誰しも悩みや不安は尽きない。	2023-07-31 04:05:00
ビジネス	ダイヤモンド・オンライン - 新着記事	業績が伸び悩んでも「乗り越える経営者」と「そこで止まる経営者」の決定的な差とは（前編） - 新装版　売上2億円の会社を10億円にする方法	https://diamond.jp/articles/-/326590	業績が伸び悩んでも「乗り越える経営者」と「そこで止まる経営者」の決定的な差とは前編新装版売上億円の会社を億円にする方法コツコツと業績を伸ばしてきた経営者が直面する「売上の壁」。	2023-07-31 04:02:00
ビジネス	東洋経済オンライン	宿題がサクサク進む子の親がやっている役割3つ ｢消しゴム係､ヨイショ係､生徒係｣とは何か？ | 子育て | 東洋経済オンライン	https://toyokeizai.net/articles/-/689833?utm_source=rss&utm_medium=http&utm_campaign=link_back	東洋経済オンライン	2023-07-31 04:50:00
ビジネス	東洋経済オンライン	コロナ禍脱した?JR東｢駅利用者回復｣ランキング 2022年度｢上位100駅｣､19年度比で見えた実力差 | 通勤電車 | 東洋経済オンライン	https://toyokeizai.net/articles/-/690453?utm_source=rss&utm_medium=http&utm_campaign=link_back	東洋経済オンライン	2023-07-31 04:30:00
海外TECH	reddit	[Post Game Thread] Light That Baby Up! Angels defeat Blue Jays!	https://www.reddit.com/r/angelsbaseball/comments/15dtpjl/post_game_thread_light_that_baby_up_angels_defeat/	Post Game Thread Light That Baby Up Angels defeat Blue Jays Angels Blue Jays First Pitch AM at Rogers Centre Team Starter TV Radio Angels Tyler Anderson ERA Peacock KLAA KTMZ ES Blue Jays Jose Berrios ERA Peacock SN Game Preview r angelsbaseball Discord Reddit Stream for this post Line Score Game Over R H E LOB LAA TOR Box Score TOR AB R H RBI BB SO BA LF Merrifield SS Bichette B Guerrero Jr PR Kiermaier B Chapman M RF Springer DH Kirk DH Biggio C Jansen D B Espinal CF Varsho TOR IP H R ER BB SO P S ERA Berríos Cabrera G Jackson J Mayza García Y LAA AB R H RBI BB SO BA SS Rengifo DH Ohtani LF Moniak B Moustakas C Thaiss C Wallach RF Renfroe B Escobar Edu CF Cabbage SS Velazquez A B Stefanic LAA IP H R ER BB SO P S ERA Anderson Moore Estévez Scoring Plays Inning Event Score T Hunter Renfroe out on a sacrifice fly to center fielder Daulton Varsho Shohei Ohtani scores B Whit Merrifield singles on a line drive to left fielder Mickey Moniak Daulton Varsho scores Whit Merrifield to nd Whit Merrifield advances to nd on a fielding error by left fielder Mickey Moniak T Hunter Renfroe homers on a fly ball to left field Mike Moustakas scores B Vladimir Guerrero Jr singles on a sharp ground ball to right fielder Hunter Renfroe Bo Bichette scores Highlights Description Length Video Bullpen availability for Los Angeles July vs Blue Jays Video Bullpen availability for Toronto July vs Angels Video Fielding alignment for Toronto July vs Angels Video Fielding alignment for Los Angeles July vs Blue Jays Video Starting lineups for Angels at Blue Jays July Video Breaking down JoséBerríos s pitches Video JoséBerríos s outing against the Angels Video Breaking down Tyler Anderson s pitches Video Tyler Anderson s outing against the Blue Jays Video Breaking down Hunter Renfroe s home run Video Analyzing Hunter Renfroe s home run through bat tracking Video Decisions Winning Pitcher Losing Pitcher Save Estévez ERA García Y ERA Game ended at PM submitted by u angelsbaseball to r angelsbaseball link comments	2023-07-30 19:14:38