投稿時間:2023-07-31 02:15:07 RSSフィード2023-07-31 02:00 分まとめ(18件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
IT	気になる、記になる…	Apple、子供のスクリーンタイム制限にバグがあることを認める	https://taisy0.com/2023/07/31/174712.html	thewallstreet	2023-07-30 16:50:21
python	Pythonタグが付けられた新着投稿 - Qiita	Data Engineering Geeks #3 Snowflakeハンズオンセミナー参加レポート	https://qiita.com/ak-sakatoku/items/e171c966e4ca6748730c	dataengineeringgeeks	2023-07-31 01:56:35
海外TECH	MakeUseOf	Choosing the Right Blogging Platform: Medium vs. Blogger	https://www.makeuseof.com/medium-vs-blogger/	blogger	2023-07-30 16:30:22
海外TECH	MakeUseOf	7 Ways to Open the AppsFolder in Windows 11	https://www.makeuseof.com/open-appsfolder-windows-11/	windows	2023-07-30 16:16:22
海外TECH	MakeUseOf	How to Use Next.js Server Actions	https://www.makeuseof.com/nextjs-server-actions-how-use/	actions	2023-07-30 16:16:22
海外TECH	MakeUseOf	How to Check If Someone Blocked You on Instagram: 7 Methods	https://www.makeuseof.com/how-to-check-if-blocked-instagram/	instagram	2023-07-30 16:05:23
海外TECH	MakeUseOf	9 Reasons Why You Can't Tag Someone on Instagram (And Their Fixes)	https://www.makeuseof.com/reasons-cant-tag-someone-on-instagram-and-fixes/	potential	2023-07-30 16:05:23
海外TECH	MakeUseOf	The 7 Best Noom Alternatives for Dieting and Health	https://www.makeuseof.com/best-noom-alternatives-dieting-health/	alternatives	2023-07-30 16:00:23
海外TECH	DEV Community	I care more about Code than about People	https://dev.to/noriller/i-care-more-about-code-than-about-people-2lc1	I care more about Code than about People Any fool can write code that a computer can understand Good programmers write code that humans can understand  Martin FowlerYou re probably wondering if this is an oxymoron because the title says “one thing and the quote “says another …I hope I can convince you it s not the case People talk too muchPeople love to talk The problem in programming is that all the talk is meaningless Maybe not now or this week But with enough time you ll already forget about it Not to mention everyone else who wasn t a part of it This applies even to discussions in a PR While you can commit “fixing stuff mentioned in PR Imagine the nightmare to find the PR just to find that part of the discussion was made outside of it Sometimes while helping someone they start telling me what it should do or what they think it i s doing I then have to use far too many words to politely say “Shut up Now show me what the code is actually doing and what it should be doing I m sure you think it s perfect but if it was then you wouldn t need to call me For the enlightened ones this is a “Rubber Duck Debugging session for the unenlightened ones here s the link Code is the source of truthYou can talk all day but at the end of it only what is written in the code will remain Talk is cheap Show me the code Linus TorvaldSometimes you need to be more direct and ask for the code to say what you want to talk about I know I have to take care to not sound so harsh But my point is to always say less and show in the code what I m thinking “Code that communicates its purpose is very important I often refactor just when I m reading some code That way as I gain understanding about the program I embed that understanding into the code for later so I don t forget what I learned Martin FowlerAgain people talk too much but it s unfortunately common that the code is a mix of mysticism and bursts of code made for the machine to understand the famous FullStackOverflow programmers who say I only know it works Caring about the code is caring about the people“Clean code always looks like it was written by someone who cares Michael FeathersMaybe you ll have to work on it later maybe someone else But someone will read it over and over “Indeed the ratio of time spent reading versus writing is well over to We are constantly reading old code as part of the effort to write new code Therefore making it easy to read makes it easier to write Robert C MartinInstead of taking the easy way of responding to a PR comment with a comment chat message or in person conversation change the code in a way to make such discussions disappear Whatever is poorly or not said with words can be made up with a more expressive code And if it isn t clear by now all that time talking and trying to understand indecipherable code adds up So no it s not “easier nor “faster to do things that way Notable exceptionsOne exception to this is when you know what you want to do but can t make the code for it Juniors usually suffer from this In this case words are very good Use as many as you can to clearly explain concepts and how to do something Another exception is for non technical people If they need to understand something use words not too many because they probably won t understand but try to make it clear and simple Time spent explaining something to someone is never a waste of time If you re a junior remember this And if you re the one explaining remember them this Finally planning time is always important “If I am to speak ten minutes I need a week for preparation if fifteen minutes three days if half an hour two days if an hour I am ready now Woodrow WilsonI m not saying to spend a day thinking about writing a line of code But more people would benefit from thinking a little more before they start cooking spaghetti at WPM	2023-07-30 16:34:04
海外TECH	DEV Community	🇵🇹 GitHub Portugal: the Portuguese development community on GitHub 🇵🇹	https://dev.to/mmroch4/github-portugal-the-portuguese-development-community-on-github-355b	GitHub Portugal the Portuguese development community on GitHub Hii developers and open source enthusiasts We are excited to announce GitHub Portugal an open community dedicated to promoting the Portuguese development community and open source projects on GitHub WebsiteDiscord community Introducing GitHub PortugalGitHub Portugal is a dynamic open source project inspired by GitHub Brazil the official GitHub Brazilian community We aim to create a rich ecosystem of open source projects and bring together interested developers programmers and tech lovers from all over Portugal GitHub Portugal IS NOT an official GitHub community We are a NON PROFIT group that works on an applied volunteer interest Our main goal is to showcase the incredible talent of the Portuguese development community and shed light on the unique open source projects from Portugal Here is what you can do after joining our fantastic community Learning and sharingWe believe in the power of knowledge sharing Members can attend workshops webinars and other online events to learn from each other and improve their skills Contribute to open source projectsGitHub Portugal is not just a place for talk but also a place for action Participate in exciting open source projects collaborate with others and make a meaningful impact in the tech community Growing togetherWhether you re an experienced developer or just starting we support EVERYONE s growth journey Let s build the futureTogether let s build an exciting hub for open source enthusiasts in Portugal Head over to our GitHub repository and contribute to the first open Portuguese development community on GitHub Remember the power of open source lies in collaboration and we can t wait to see what we can achieve together 🫵Let s make Portugal s tech community shine on the global stage 🫵	2023-07-30 16:27:16
海外TECH	DEV Community	Decode Your Emotions: Emotional Intelligence for Software Developers	https://dev.to/sushantchhetryy/decode-your-emotions-emotional-intelligence-for-software-developers-453i	Decode Your Emotions Emotional Intelligence for Software DevelopersIn the software industry the focus has long been on showcasing coding prowess and technical achievementsーsolving LeetCode problems mastering complex algorithms and contributing to prestigious open source projects However a crucial aspect of a successful software career often gets overlooked emotional intelligence The ability to regulate emotions read the room and influence others plays a significant role in achieving professional growth and thriving in the world of software development In this article we ll delve into the importance of emotional intelligence for software developers and how it can pave the way to a fulfilling and prosperous career Emotional intelligence EQ is the compass that guides us through the complexities of human interactions It s not just about being smart it s about being wise in understanding our emotions and using that wisdom to inspire motivate and positively impact the lives of those around us There are four aspects to emotional intelligence Self Awareness The ability to recognize and label your own emotions accurately Self Regulation Skillfully managing your emotions to respond appropriately to situations Social Awareness Understanding and empathizing with the emotions of others Relationship Management Cultivating strong social connections and effectively navigating interactions with others to build meaningful and collaborative connections So let us look at examples where these pillars would come in play for a software engineer Self Awareness and Self Regulation As you work on this new feature the deadline looms ever closer and there s a mountain of tasks ahead You find yourself struggling with poor sleep and an abundance of caffeine in your system Suddenly stress takes hold and thoughts flood your mindーWill I be able to finish this product on time What if I can t What if my colleagues resent me for it and your boss forms a negative impression Could this jeopardize my entire career hindering the future I ve been tirelessly striving towards As the cursor blinks before you you feel paralyzed unable to write a single line of code Taking a deep breath you recognize this as a burst of anxiety Reminding yourself of your hard work you realize your mind is simply trying to keep you safe You decide to take a short break listen to your favorite music and savor some tea Soon you return refreshed and refocused ready to tackle the challenge at hand In this instance we leverage self awareness to not only identify our emotions but also to effectively manage them enabling us to navigate through the stress and regain focus on the task at hand Social Awareness and Relationship Management In a software development team meeting there is currently an air of tension There are conflicting ideas among the developers testers and project manager on how to tackle this technical hurdle You notice the increasing tension and observe emotional cues of frustrations among your teammates this is causing some hindrance to the collaboration and progress So you suggest a quick break to collect thoughts and allow emotions to settle During the break you reach out to teammates and others individually to listen to their insights and offer some compromises that align with everyone s goals When the team reconvenes there is a noticeable improvement in the atmosphere and progress begins to flow more smoothly In this scenario we demonstrated not only our ability to read the room but also our commitment to improving relationships by proactively reaching out and actively listening to our team members By fostering open communication and understanding we contributed to a more harmonious and productive team dynamic “Emotional intelligence is critical in building and maintaining relationships and influencing othersーkey skills that help people throughout their career and wherever they sit in an organizational structure Margaret Andrews executive director at the MIT Sloan School of Management So with these scenarios we clearly recognize the significance of emotional intelligence EQ not only in our software development but also in our personal lives According to Harvard s article on EQ these are some telltale signs of low EQ and high EQ Low EQ Feels that they are often misunderstoodThey easily get upsetEmotions can overwhelm them easilyHave problems with being assertive High EQHave a better understanding of their emotions and relationships among themThey cans stay calm and composed during stressful situationsHave the ability to influence others towards a goalCan diplomatically deal with difficult peopleEQ is not a black and white concept An individual can find themselves relating to aspects of both sections of high and low EQ It s a continuously learned and honed skill that can be developed over time The wonderful thing about EQ is that it can be learned and mastered empowering us to enhance our interpersonal skills and emotional well being Here are some key points on how to improve EQ Be aware of your emotionTake a moment to reflect What emotions are you experiencing right now Can you identify and name these emotions Are you aware of the triggers that led to these emotions When faced with stressful situations what is your immediate reaction Being able to pause and recognize your emotions as well as manage your reactions accordingly is a crucial aspect of emotional intelligence By developing this self awareness you can respond to challenging situations with greater composure and make more informed decisions Get FeedbacksIt is a beneficial habit to audit your self perception because sometimes our view of ourselves may not align with reality To gain valuable insights into your emotional intelligence reach out to people who know you well or have worked closely with you and ask them to provide feedback on your EQ Consider asking questions such as How do you perceive my adaptability How have you seen me react to difficult situations in the past Would you describe me as empathetic How do you think I handle conflicts Receive their answers with an open mind embracing this feedback as an opportunity for personal growth Understanding how others perceive your emotional intelligence can help you identify areas for improvement and further enhance your interpersonal skills Practice active listeningActive listening is a vital aspect of developing EQ When we engage in active listening we put aside our judgment and distractions We are able to gain valuable insights and also build meaningful connections By maintaining eye contact and using verbal and non verbal cues we show genuine interest and empathy for the speaker s emotions and perspectives Reflecting and paraphrasing their words demonstrates that we are actively engaged and seeking to understand their message accurately Asking open ended questions encourages deeper conversation inviting the speaker to share more thoughts and feelings JournalingJournaling can be a valuable practice for enhancing emotional intelligence EQ By expressing our thoughts and emotions on paper we gain self awareness and insight into our feelings Regular journaling allows us to identify patterns triggers and areas for growth ultimately leading to a deeper understanding of ourselves and improved emotional management In conclusion as a software developer recognizing the significance of emotional intelligence in both the professional and personal life is a truly transformative journey By honing on self awareness empathy towards others actively listening and emotional regulation As we continue investing in developing our emotional intelligence we unlock the key to becoming not just exceptional developers but also compassionate leaders and collaborators making a positive impact on ourselves our teams and the entire software development community	2023-07-30 16:19:01
海外TECH	DEV Community	SQL Common Table Expressions and Window functions	https://dev.to/lawrence_cooke_d169c15549/sql-common-table-expressions-and-window-functions-25ce	SQL Common Table Expressions and Window functionsSometimes when writing queries for reporting purposes the queries required to manipulate the data can get complex If you are able to use PHP or Python to manipulate the data after running a query then the query required to get the desired result is much simpler But sometimes you just have to find a way to fetch the data you need using only a SQL query For the purposes of this article the desired outcome from the query is to fetch the total amount transacted each day and display both the daily amount and a running tally for a day period DateAmountTally The data queried to get this output istransaction dateamount Getting StartedWith any complex query the trick is to break it down into its parts and work on each part until you are ready to put it all together Here I would run a query to fetch the data for the date range just so I can see what I need to do SELECT transaction date amountFROM subscriptionsWHERE transaction date BETWEEN AND transaction dateamount Now I need to group the data by day and SUM the amount transacted each day SELECT DATE transaction date transaction date SUM amount amountFROM subscriptionsWHERE transaction date BETWEEN AND GROUP BY DATE transaction date transaction dateamount The date is in the right format the amounts are grouped and summed correctly but we are missing days There are many ways in SQL to fill in the gaps some are fairly simple and others are overly complex For me my preferred method is to use Common Table Expressions What are Common Table Expressions CTE CTEs are reusable temporary result sets In their simplest form they can replace a sub query or a view but they have some unique characteristics which makes them powerful CTEs are reusable which means that a query is run once but the resulting data set can be used queried multiple times Defining a CTECTEs are defined using WITHWITH counter AS query This creates a temporary result set that can then be used in a queryWITH counter AS SELECT SELECT FROM counterIf needed the field name returned from a CTE can be definedWITH counter number AS SELECT SELECT FROM counterIts also possible to define multiple CTEsWITH counter number AS SELECT WITH total total AS SELECT SELECT FROM counterA slightly more complex CTE might look likeWITH counter number AS SELECT UNION ALLSELECT SELECT FROM counternumberWhere CTEs become powerful is in their ability to reference themselves recursively If I wanted to return the numbers to I could use a recursive CTE to generate the numbersWITH RECURSIVE counter number AS SELECT UNION ALLSELECT number FROM counter WHERE number lt SELECT FROM counterThis will producenumber Using a CTE to generate a date rangeFor our original request all dates within the date range were required even for dates where there were no transactions To do this a CTE can be created to return the date range required WITH RECURSIVE dates day AS SELECT UNION ALLSELECT day INTERVAL day FROM dates WHERE day lt SELECT FROM datesday Joining CTEs In QueriesFor the purposes of the original requirements I am adding the query that fetched the transactions into its own CTE so I can manipulate the data a little later onWITH RECURSIVE dates day AS SELECT UNION ALLSELECT day INTERVAL day FROM dates WHERE day lt transactions AS SELECT DATE transaction date transaction date SUM amount amountFROM subscriptionsWHERE transaction date BETWEEN AND GROUP BY DATE transaction date SELECT FROM transactionsA feature of CTEs is the ability to check the result from each CTE before putting it all togetherSELECT FROM transactions OR SELECT FROM dates will help me verify that the data the queries produce are correct While this query works as is if the date range needs to change both CTEs would need to be updated A CTE can reference another CTE To change the query so only one CTE needs to be updated in order to change the date range we can reference the dates CTE from within the transactions CTE WHERE transaction date BETWEEN SELECT MIN day FROM dates AND SELECT MAX day INTERVAL DAY FROM dates Now to join the two CTEs together to see all the data togetherWITH RECURSIVE dates day AS SELECT UNION ALLSELECT day INTERVAL day FROM dates WHERE day lt transactions AS SELECT DATE transaction date transaction date SUM amount amountFROM subscriptionsWHERE transaction date BETWEEN SELECT MIN day FROM dates AND SELECT MAX day INTERVAL DAY FROM dates GROUP BY DATE transaction date SELECT day amount FROM dates dLEFT JOIN transactions t ON t transaction date d daydayamount NULL NULL Other than the NULLs the data is looking good so far To remove the NULL values we can use the COALESCE function What Does COALESCE Do COALESCE replaces NULL values with the first non null value in a list of valuesCOALEASCE value will replace the value with if the value is NULL Equally COALESCE value null null will also replace with as its the first non null value in the list of values SELECT day COALESCE amount amount FROM dates dLEFT JOIN transactions t ON t transaction date d daydayamount The last part of the request was a running tally To return a running tally SQL Window functions are required What Are Window Functions Window functions are functions that are run across the entire result set They allow you to fetch a running tally or data from a previous row or from the rows ahead of the current row There are quite a few window function some of them are LEAD LAG NTILELEAD return a value from a row ahead of the current rowLAG return a value from a previous rowNTILE break rows out into sections this would allow you to only return the top of results for example You can also use aggregating functions in a window SUM AVG etc We will use the SUM function to fetch the running tally The format of a window function isfunction field OVER clause The PARTITION BY clause is similar to a GROUP BY but not the same In a window function the function is run over every row it won t group rows together but it will produce a result that grouped values together in its calculation ORDER BY will order the results in a specific way that is then used to calculate a result Fetching A Running TallyTo fetch the running tally required we need to add a window function field into the querySUM amount OVER ORDER BY day tally Predefining a WindowWhile the method above is fine to use If you find yourself in a situation where multiple window functions are required it is possible to pre define the window and reference it In our current querySELECT day COALESCE amount amount SUM amount OVER ORDER BY day tallyFROM dates dLEFT JOIN transactions t ON t transaction date d dayThis could be changed toSELECT day COALESCE amount amount SUM amount OVER w tallyFROM dates dLEFT JOIN transactions t ON t transaction date d dayWINDOW w AS ORDER BY day Final QueryThe final query using the window functions and CTEs looks likeWITH RECURSIVE dates day AS SELECT UNION ALLSELECT day INTERVAL day FROM dates WHERE day lt transactions AS SELECT DATE transaction date transaction date SUM amount amountFROM subscriptionsWHERE transaction date BETWEEN SELECT MIN day FROM dates AND SELECT MAX day INTERVAL DAY FROM dates GROUP BY DATE transaction date SELECT day COALESCE amount amount SUM amount OVER w tallyFROM dates dLEFT JOIN transactions t ON t transaction date d dayWINDOW w AS ORDER BY day dayamounttally Common Table Expressions and Windows open up SQL for better data processing especially for reporting and data analysis CTEs contain powerful features that simplify tasks they also add readability making building or debugging complex queries easier Being reusable means that where you might have to run a subquery more than once in a query the CTE will only run the query once and use the result set instead of running multiple subqueries which can add efficiency to the query in some cases Window functions are a great way to provide analysis over the result set this is evident in accounting type reports but not limited to just accounting it has a lot of use cases where using window functions allow you to gather additional information needed to produce the results required	2023-07-30 16:03:30
Apple	AppleInsider - Frontpage News	Apple confirms Parental Controls settings-clearing bug will get fixed	https://appleinsider.com/articles/23/07/30/apple-confirms-screen-time-reset-bug-will-get-fixed?utm_medium=rss	Apple confirms Parental Controls settings clearing bug will get fixedApple has confirmed issues with Screen Time has resulted in restrictions to a child s iPhone or iPad failing to be enforced allowing younger users to use their devices for longer than parents want Screen Time is designed as a way for parents to keep tabs on the device usage of their children The feature allows parents to set an iPhone iPad or other Apple product to be used for a certain amount of time within a schedule including limiting the kinds of apps being used However the tool isn t working as intended at the moment as attempts to change settings aren t being applied properly The result is that the child can continue using the hardware under previously configured settings rather than the updated scheduling Read more	2023-07-30 16:11:01
金融	ニュース - 保険市場TIMES	ソニー損保、「2023年　全国カーライフ実態調査」の結果を発表	https://www.hokende.com/news/blog/entry/2023/07/31/020000	ソニー損保、「年全国カーライフ実態調査」の結果を発表半数弱が「お盆に帰省する予定」ソニー損害保険株式会社以下、ソニー損保は年月日、「年全国カーライフ実態調査」の結果を発表した。	2023-07-31 02:00:00
ニュース	BBC News - Home	Niger coup: West African leaders threaten military intervention	https://www.bbc.co.uk/news/world-africa-66353284?at_medium=RSS&at_campaign=KARANGA	deadline	2023-07-30 16:48:30
ニュース	BBC News - Home	The Ashes: Australia openers frustrate England before rain	https://www.bbc.co.uk/sport/av/cricket/66351070?at_medium=RSS&at_campaign=KARANGA	The Ashes Australia openers frustrate England before rainEngland are frustrated by Australia s strong start to a chase of before rain wipes out half of the fourth day of the final Ashes Test at The Oval	2023-07-30 16:08:06
ニュース	BBC News - Home	Netball World Cup 2023 results: England beat Scotland 62-37 to finish top of Pool B	https://www.bbc.co.uk/sport/netball/66354256?at_medium=RSS&at_campaign=KARANGA	Netball World Cup results England beat Scotland to finish top of Pool BEngland finish top of their Netball World Cup pool with a perfect record as they beat Scotland with both teams already through to the next phase	2023-07-30 16:44:36
ニュース	BBC News - Home	Super League: Wakefield Trinity 42-6 Warrington Wolves - Innes Senior claims four tries in victory	https://www.bbc.co.uk/sport/rugby-league/66301927?at_medium=RSS&at_campaign=KARANGA	Super League Wakefield Trinity Warrington Wolves Innes Senior claims four tries in victoryInnes Senior s four try haul helps Wakefield thrash Warrington to boost their Super League survival bid	2023-07-30 16:08:35