March 30, 2025
Do you support Ghibli style or use it?
submitted by /u/gagsty [comments] Source link
Blog
March 30, 2025
Wild Video Shows Solar Winds Spiraling Millions of Miles From the Sun
Behold, the piping host particles of solar wind streaming from our Sun, caught in new footage from the ESA/NASA Solar Orbiter. The video was captured by the orbiter’s Metis instrument, a coronagraph which blocks light directly from the Sun in order to see fainter phenomena in its outer atmosphere, or corona. New research describing the observations was published today in The Astrophysical Journal. “In this paper, we present observations by Metis during its perihelion passage of a striking helical radial structure that extended from 1.5 to 3 [solar radii] and lasted for more than 3 hr,” the team wrote. “To
March 30, 2025
How I Reduced My Oracle SQL Execution Time from 110s to 2s
🧩 The Problem Recently, I encountered a performance bottleneck while writing a SQL query: the execution time was over 110 seconds. Here’s a simplified version of the query: SELECT 'A' AS type, COUNT(adl.is_attend) AS count, ROUND(SUM(CASE WHEN adl.is_attend = 1 THEN 1 ELSE 0 END) / COUNT(adl.is_attend), 2) * 100 AS rate FROM attendance adl INNER JOIN ( SELECT deptId FROM department START WITH deptId = '...' CONNECT BY up_daptId = PRIOR deptId ) nbd ON adl.deptId = nbd.deptId WHERE TO_DATE(adl.date, 'yyyy-MM-dd') >= TO_DATE(#{begin_date}, 'yyyy-MM-dd') AND TO_DATE(adl.date, 'yyyy-MM-dd') <= TO_DATE(#{end_date}, 'yyyy-MM-dd') UNION ALL -- other queries with different deptId and
March 30, 2025
Data shows certain flairs have a 3X higher chance of going viral (with visualizations)
Ever noticed how some posts blow up while others with similar content just disappear? After getting frustrated with this pattern, I started collecting data on posts across different subreddits to see if there was a pattern. Turns out, the flair you choose has a massive impact on visibility. I analyzed thousands of posts and created some visualizations that show exactly which flairs perform best in different communities. Here's what the data revealed for r/ChatGPTPromptGenius: The data was surprising – "Other " posts are 3X more likely to go viral than "Prompt Engineering – not a prompt" posts. Also, Friday at
March 30, 2025
Image replies are…. something else
submitted by /u/Sparky_248 [comments] Source link
March 30, 2025
Electric Cooler vs. Ice Cooler: Which is Better? I Tested Both To Find Out
Everything from cars to bikes to coolers is getting new electric components even while their legacy counterparts remain on the market. For example, you can get an electric wine opener even though regular elbow grease wine openers are still available. The same is true for the trusty old icebox cooler, which now comes with battery and charging options, letting you keep food and drinks chilled on the go for longer. At least, that’s how it’s supposed to work in theory. The unfortunate truth is that electrification usually adds considerable cost to most products against what was already available. This
March 30, 2025
$15 Windows 11 Pro license
TL;DR: Give your old PC a new lease on life with a Microsoft Windows 11 Pro license, now only $14.97 through tonight at 11:59 p.m. PT. Need a new laptop but don’t have the budget to buy one? We’ve found the next best thing — updating your operating system. If you’ve got an old PC that could use an upgrade, Microsoft Windows 11 Pro is now just $14.97, $175 off the usual price. But you’ll want to act fast because this deal ends tonight at 11:59 p.m. PT. Check out what Windows 11 Pro has to offer Curious what
March 30, 2025
THIS is why large language models can understand the world
Hey I found this really cool video with only 8000 views and I thought this community would like it a lot. Oh and before any critics comments on the video or on this thread about his conclusion read the comment and replies of 5454a1 it won't solve ure critique but it will hopefully help you get a better view of the youtubers conclusion. submitted by /u/kniff974 [comments] Source link
March 30, 2025
The Millennial Question
METHOD We used the Event Registry API to scrape news articles about Millennials. The query filtered on news articles with the word “Millennials”, “millennials”, “Millennial”, or “millennial” in the headline published between June 15, 2015 and June 15, 2019. This query yielded nearly 38,000 articles. We obtained article metadata, including the URL, title, body, and publishing date from the query. Sometimes, multiple news outlets in the same media family publish the same article; removing these duplicates yielded a total of 26,565 articles. We used the Spacy Python package to part-of-speech tag the headline text. Part-of-speech tagging identifies each word’s part-of-speech
March 30, 2025
We hacked Gemini’s Python sandbox and leaked its source code (at least some)
submitted by /u/namanyayg [comments] Source link