2025-06-29
How to Write Complex Queries in Apache Spark SQL Using CTE (WITH Clause)
This guide explains how Spark SQL's WITH clause (CTE) improves query readability, reusability, and performance, with real-world examples and best use cases.
StartAMA
Host your AMA session & build your audience Discussion | Link
co.dev MCP
Turn your ideas into full-stack apps Discussion | Link
Slow progress on a browser plugin
Slow progress on a browser plugin
Scientists Investigate What Happens If You Snort Moon Dust
The Good Stuff Wondering whether snorting Moon dust will kill you? Don't worry: science is on it. A recent study conducted by a team of Australian researchers and published in...
Dual Shades
Keep your subject in color, fade the background to B&W Discussion | Link
Our favorite RPG from last year is 40% off in the Steam Summer Sale
Metaphor: ReFantazio is a delightful RPG from the creators of the Persona series.
Anthropic Shredded Millions of Physical Books to Train its AI
Anthropic, the AI company which Google has invested billions of dollars in, had an extremely wasteful way of gathering the data it needed to train its Claude AI model. As...
Melania Trump's Audiobook Is Narrated by an AI Copy of Herself
Let's get one thing straight: it's hard to be married to the president. From coming up with epoch-defining slogans like "Be Best" to decorating the White House with bizarre Christmas...
The HackerNoon Newsletter: A Data Engineers Guide to PyIceberg (6/29/2025)
How are you, hacker? 🪐 What’s happening in tech today, June 29, 2025? The HackerNoon Newsletter brings the HackerNoon homepage straight to your inbox. On this day, Apple Launched the...
Couples Retreat for Humans Dating AIs Becomes Skin-Crawlingly Uncomfortable
A well-intentioned writer decided to get a group of humans and their AI companions together for a cabin retreat. Somehow, it went even worse than anyone could have imagined. As...
The Museum of All Things: A Wikipedia You Can Visit
What if Wikipedia was a place you could visit? That’s the idea behind The Museum of All Things, a free and open-source procedurally-generated museum built on Wikipedia’s vast knowledge base.
New Smart Glasses Block Out All Real-Life Advertising
Block Party When you're online, you have the ability to block those annoying ads that pop up and clutter up your screen, but unfortunately we can't do that to ads...
These Algorithms Were Meant to Improve the Human Condition: They Failed
High-tech computer systems can reflect the misjudgments of the people who designed them—but this idea gets obscured because the systems’ algorithms don’t have any agency.
Deep Dive into MS MARCO Web Search: Unpacking Dataset Characteristics
Explore a comprehensive analysis of the MS MARCO Web Search dataset, detailing its multilingual distribution, significant data skew, and rigorous test-train overlap minimization for robust model evaluation.
Chinese Police Cracking Down on Naughty Fiction
Crime and Fanfic Imagine you publish your erotic Harry Potter fanfic that involves the titular character and his arch nemesis Draco Malfoy getting hot and heavy in the some forgotten...
Crafting Real-World Queries: MS MARCO Web Search's Authentic Data
Discover how MS MARCO Web Search meticulously selects and labels millions of real queries from Bing search logs, mirroring authentic web query distribution for unparalleled AI training.
Let's look at another "LLMs lack true understanding" paper
Published on June 29, 2025 2:00 PM GMTPotemkin Understanding in Large Language Models: https://arxiv.org/pdf/2506.21521If LLMs can correctly define a concept/idea but fail to identify an example or provide an example,...
Wreckfest 2's latest update lets you drive a grotty motorhome that's definitely had meth cooked in it, and ensures that 'realistic damage mode is now more realistic'
New tracks and demolition derby arenas also added.
Scientists Playing God are Building Human DNA From the Ground Up
More on DNA: You Can Now Buy a Sample of Ozzy Osbourne's DNA in Twelve Easy Payments
Welcome to Postreads
Discover and follow the best content from across the web, all in one place. Create an account to start building your personalized feed today and never miss out on great reads.
Support Postreads
Enjoying the service? Help me keep it running and improve it further by buying me a coffee!
Buy me a coffeeContent Timeline
24,056 articles since 2008
Trending Now
Top 5 clicked items this week out of 760 added this week
Freshly added
New feeds to discover
