Data Modeling Guide for Real-Time Analytics with ClickHouse
Link: ssp.sh/blog/practical-data-mod…
Discussion: news.ycombinator.com/item?id=4…
Learn how to build sub-second real-time analytics with ClickHouse. Complete guide covering data modeling strategies, optimization techniques, and practical S3-to-dashboard examples.Data Engineering Blog
Interview with Japanese Demoscener – 0b5vr
Link: 6octaves.com/2025/09/interview…
Discussion: news.ycombinator.com/item?id=4…
→日本語で読むWelcome to "Interviews with Demosceners"! This time, we welcome Japanese demoscener 0b5vr, who mainly creates 64K...…6octaves
A computer upgrade has shut down BART
Link: bart.gov/news/articles/2025/ne…
Discussion: news.ycombinator.com/item?id=4…
PCGamesN just posted:
Hollow Knight Silksong user reviews tank in one region amid localization trouble
Was Hollow Knight Silksong worth the wait? Thanks to Steam issues and a full day's work, I've only had one lunch break to dive in, but in that hour I've beaten the first boss and started on Hornet's journey proper. Many other players have committed far more time to the game, and excitement is still at fever pitch. However, players in some ...
pcgamesn.com/hollow-knight-sil…
Hollow Knight Silksong has broken countless records (and storefronts), but players in China and France are dismayed by poor localization.Ben Sledge (PCGamesN)
Hyperliquid has slashed trading fees by 80% while preparing to launch its native USDH stablecoin under on-chain validator governance.Hassan Shittu (Cryptonews)
Pyongyang, September 5 (KCNA) — Kim Jong Un, general secretary of the Workers’ Party of Korea and president of the State Affairs of the Democratic People’s Republic of Korea, had talks with Xi Jinping, general secretary of the Central Committee of …Dermot Hudson (KFAUK.com)
Gamespot just posted:
Best Builds For NBA 2K26
NBA 2K26 features a variety of modes and content, but creating the best MyPlayer builds is a time-honored tradition every year. Your MyPlayer is used to access a wide majority of the game's content, and when you opt to create your own player, you need to kit them out with every attribute that makes for an NBA star. You can specify their position, height, weight, and, most importantly, attributes. The ...
gamespot.com/gallery/best-buil…
If you want the best version of your MyPlayer possible in NBA 2K26, check out our builds for every position on the court.Joey Carr (GameSpot)
Discover the top crypto PR agencies for blockchain & Web3 in 2025. Outset PR leads the guide, with case studies of firms delivering measurable results.Crypto Daily
Analysis of XRP price action, institutional demand, technical support, and how Outset PR helps crypto projects build trust in volatile markets.Crypto Daily
Pyongyang, September 5 (KCNA) — Kim Jong Un, general secretary of the Workers’ Party of Korea and president of the State Affairs of the Democratic People’s Republic of Korea, left Beijing by his private train in the evening of September 4 after fin…Dermot Hudson (KFAUK.com)
South Korea: 'many' of its nationals detained in ICE raid on GA Hyundai facility
Link: nbcnews.com/news/us-news/ice-h…
Discussion: news.ycombinator.com/item?id=4…
The Fortune 500 company confirmed the presence of law enforcement at the LG Energy Solution and Hyundai battery joint venture construction site in Ellabell.Nicole Acevedo (NBC News)
Protobuffers Are Wrong
Link: reasonablypolymorphic.com/blog…
Discussion: news.ycombinator.com/item?id=4…
PC Gamer just posted:
Audeze LCD-S20 Closed-back review
Planar magnetic drivers with epic sound isolation.
pcgamer.com/hardware/earbuds-h…
kaia likes this.
Our socials: fediverse.blog/~/ActaPopuli/fo…
Follow us on social
(main) @actapopuli@friendica.vrije-mens.org
(backup) @actapopuli@friendica.rogueproject.org
Sensitive content
PC Gamer just posted:
Asus says its Intel 800-series motherboards are approved to run DDR5-7200 without an XMP profile, pointing to a RAM speed boost for an Arrow Lake refresh
Truth be told, I think we'd just prefer to have Nova Lake instead, thanks.
pcgamer.com/hardware/memory/as…
Bitcoin (BTC) has fallen below the $110,000 zone leaving traders to hunt for larger gains in other places. Meme investors are now looking at Layer Brett (LBRETT), a new Ethereum Layer 2 project with huge promise.Maisie Morrison (Blockonomi)
SharpLink has reaffirmed its full compliance with Nasdaq rules, dismissing speculation about shareholder approval requirements.Coingape Staff (CoinGape)
By: Andrew S LAWRENCE, MA– Unionists and socialists gathered together at the Heritage State Park for the 41st Annual Bread and Roses Heritage Festival on September 1 – Labor Day.Deputy Managing Editor (Working Mass)
Making the most of a dumb fax switcher box in the old days
Link: rachelbythebay.com/w/2025/09/0…
Discussion: news.ycombinator.com/item?id=4…
Vetinari's Clock (2011)
Link: waitingforfriday.com/?p=264
Discussion: news.ycombinator.com/item?id=4…
1TB Raspberry Pi SSD on sale now for $70
Link: raspberrypi.com/news/1tb-raspb…
Discussion: news.ycombinator.com/item?id=4…
Rock, Paper, Shotgun just posted:
Dryft racing, hip-hop and pirates: the cheeky, eclectic games of Aussie studio Nonsense Machine
For most of his game-making career, Australian developer dweedes has projected an image of cheeky, punkish rebellion. His website WET GAMIN has accumulated a trove of experimental games over the last decade: short works by various freeware developers that exemplify a scribbly, DIY spirit. Now, making and selling games ...
rockpapershotgun.com/dryft-rac…
Inside the punkish, DIY game-making craft of Australian indie studio Nonsense Machine.Austin Lancaster (Rock Paper Shotgun)
PAME expresses its solidarity with the workers of the London Underground and their union RMT, who, from Friday, September 5th, are launching rolling strike actions, demanding wage increases, better working conditions, reduction of working hours, and …rodoula (Πανεργατικό Αγωνιστικό Μέτωπο (Π.Α.ΜΕ.))
South Korea: 'many' of its nationals detained in ICE raid on GA Hyundai facility
Link: nbcnews.com/news/us-news/ice-h…
Discussion: news.ycombinator.com/item?id=4…
The Fortune 500 company confirmed the presence of law enforcement at the LG Energy Solution and Hyundai battery joint venture construction site in Ellabell.Nicole Acevedo (NBC News)
A computer upgrade has shut down BART
Link: bart.gov/news/articles/2025/ne…
Discussion: news.ycombinator.com/item?id=4…
Kotaku just posted:
This UGREEN USB-C Charger Drops to a Practically Free, Stock Up for Samsung and Apple’s New Devices
Save 40% on the UGREEN 65W USB-C charger over at Amazon for a limited time.
The post This UGREEN USB-C Charger Drops to a Practically Free, Stock Up for Samsung and Apple’s New Devices appeared first on Kotaku.
kotaku.com/this-ugreen-usb-c-c…
Using Your Phone on Toilet May Give You Hemorrhoids: Study
Link: nbcnews.com/health/health-news…
Discussion: news.ycombinator.com/item?id=4…
Excessive scrolling on smartphones while on the toilet can lead to itchy, painful hemorrhoids, finds a new study.Erika Edwards (NBC News)
Game Developer just posted:
Digging into the combat design of Cronos: The New Dawn - Game Developer Podcast Ep. 54
This week on the Game Developer Podcast, Bloober Team lead combat designer Shamil Yanbukhtin and senior game AI programmer Dennis Pauly share insights from making a new kind of survival horror combat system for Cronos: The New Dawn.
gamedeveloper.com/design/diggi…
This week on the Game Developer Podcast, Bloober Team's Shamil Yanbukhtin and Dennis Pauly share insights from making the combat of Cronos: The New Dawn.www.gamedeveloper.com
BTC’s price may dominate the headlines again, holding firm at $112,000 amid institutional demand, but a new story is stirring. Traders are quietly shifting some attention toward a presale altcoin capturing excitement on X (formerly Twitter).Maisie Morrison (Blockonomi)
The long-awaited XRP ETF is on track for early 2026 approval, a development that could unleash a wave of institutional money into the market.Michelle DG (Blockonomi)
Stellar's explosive volume spikes and resistance breakthrough signal heightened volatility amid growing institutional interest.CD Analytics (CoinDesk)
The investor, who originally acquired 1 million ETH during the 2014 ICO for $310,000, still holds 105,000 ETH valued at $451 million in two wallets.Shaurya Malwa (CoinDesk)
Chainlink's native token encountered persistent bearish pressure as BTC, ETH and the broader crypto market consolidates, CoinDesk Research's model shows.CD Analytics (CoinDesk)
Soft U.S. jobs numbers released Friday cemented the case for an imminent Fed rate cut and provided what turned out to be only a brief jolt higher to crypto markets.Helene Braun (CoinDesk)
Institutional accumulation absorbs selling pressure as ETF speculation and Fed signals drive market sentiment.Shaurya Malwa (CoinDesk)
Wyoming picks Hedera for state-backed FRNT stablecoin as token crashes in final trading session.CD Analytics (CoinDesk)
For the West, the summit sent a clear signal: the countries of the Global South are ready to demonstrate unity and defend their own interests.Joshua MODISE (Oriental Review)
Insider Gaming just posted:
Omara HANDS-ON Preview: The Future of Immersion in Gaming
OVR invited us to test Omara, a device that aims to change how we play games. Check our impressions in our preview.
The post Omara HANDS-ON Preview: The Future of Immersion in Gaming appeared first on Insider Gaming.
Rehn likes this.
reshared this
Sensitive content
By Drago Bosnic. What has caught the attention of many military observers is a whole generation of hypersonic missiles that will form the backbone of Chinese deterrence for decades to come.Réseau International
Gamespot just posted:
Former Bethesda Boss Reveals The "Dumbest Thing I Ever Did" At The Company
Former longtime Bethesda marketing and publishing boss Pete Hines retired after Microsoft bought parent company ZeniMax, and in a new interview, he discussed one part of his career where he did the "dumbest thing."Some may recall that one of the promised items in Fallout 76's $200 Power Armor Edition was a canvas West Tek bag. However, upon delivery, ...
gamespot.com/articles/former-b…
Pete Hines discusses "my biggest failing" with a certain situation at Bethesda.Eddie Makuch (GameSpot)
Nintendo Life just posted:
Cronos: The New Dawn Gets A Launch Trailer Specifically For Switch 2
Such is our calling.We've all been getting a little caught up in the Silksong hype recently, but we thought it best to remind you that Bloober Team's Cronos: The New Dawn is out now on the Switch 2.To mark the occasion, a new launch trailer specifically for the Switch 2 has been released, and yeah, it's cool. We get a good look at some combat, traversal ...
nintendolife.com/news/2025/09/…
WLFI trading is down significantly from the recent peak. Get updated on market performance and what factors influence WLFI.Jamie Redman (Bitcoin News)
PCGamesN just posted:
Cult of the Lamb DLC Woolhaven is "almost longer" than the base game
The new Cult of the Lamb DLC, Woolhaven, is so large it almost eclipses the base game, according to developer Massive Monster. The cute-but-concerning action roguelike about building a community of fanatical worshippers is set to get a major expansion in early 2026, bringing a wintery tinge to proceedings. It whisks us to a new region in search of the history ...
pcgamesn.com/cult-of-the-lamb/…
The upcoming Cult of the Lamb Woolhaven DLC is “almost longer” than the launch version of Massive Monster’s base-building action roguelike.Ken Allsop (PCGamesN)
The Old Robots Website
Link: theoldrobots.com/index2.html
Discussion: news.ycombinator.com/item?id=4…
Robots, Tomy, Toy, Omnibot, Hearoid, OOM, Omnibot MK II, Robots, Omnibot 2000, Verbot, Chatbot, Spotbot, Hootbot, Dustbot, Dingbot, Verbot, Crackbot, Flipbot, Omni Jr, R.A.D.www.theoldrobots.com
The yearly international Eastern Economic Forum held in Vladivostok is focused on attracting investment to the vast Russian Far East.Sputnik Africa
TheGamer just posted:
Star Wars Outlaws Switch 2 Game Key Card Decision Wasn't Cost-Related
An engine-specific explanation, but a welcome one.
thegamer.com/star-wars-outlaws…
US economy added just 22,000 jobs in August, unemployment highest in 4 yrs
Link: cnn.com/2025/09/05/economy/us-…
Discussion: news.ycombinator.com/item?id=4…
Polygon just posted:
What are Shell Shards in Hollow Knight: Silksong?
Find out how to use shell shards in Hollow Knight: Silksong, and how to get more of them
polygon.com/hollow-knight-silk…
Find out how to use shell shards in Hollow Knight: Silksong, and how to get more of them.Marloes Valentina Stella (Polygon.com)
Explore why the ADA price is on the verge of a strong bullish breakout, potentially by 30% as a top economist calls for a cut.crispus (CoinGape)
Meme coins are getting popular again, but a new project might change everything in 2025. Experts now think that Layer Brett could be better than Shiba Inu, Dogecoin, and even Pepe Coin. It is built on Ethereum and has true Layer 2 power.Maisie Morrison (Blockonomi)
This Sunday will be jam packed with geopolitical and historical insights starting with Pluralia Dialogos’ livestream at 11am ET where I will be speaking with former CIA analyst Ray McGovern and the Duran’s Alex Christoforou (watch that live stream he…Matthew Ehret (Matt Ehret's Insights)
Development Speed Has Never Been a Bottleneck
Link: pawelbrodzinski.substack.com/p…
Discussion: news.ycombinator.com/item?id=4…
Big part of discussion around vibe coding revolves around pace of development while it was never a key constraint in succeeding with a product.Pawel Brodzinski (The Pre-Pre-Seed)
RPG Site just posted:
Square Enix releases Dragon Quest I & II HD-2D Remake gameplay overview trailer
The Dragon Quest I & II HD-2D Remake goes over exploration, combat, party setup, and more ahead of the game's launch next month.
rpgsite.net/news/18359-dragon-…
The Dragon Quest I & II HD-2D Remake goes over exploration, combat, party setup, and more ahead of the game's launch next month.Mikhail Madnani (RPG Site)
Tokenized money market funds are expected to lead adoption thanks to their attractive yields relative to stablecoins, the report said.Will Canny (CoinDesk)
Shiba Inu and Dogecoin look vulnerable as recent reports highlight their shaky foundations in a shifting crypto landscape.Maisie Morrison (Blockonomi)
Trump Media secures 684M CRO valuing at $105M and partnering with Crypto.com to create a Cronos Treasury and enhance blockchain adoption.Paul (CoinGape)
Could the Chainlink Reserve be the hidden force behind LINK’s next bull run? Explore why this quiet strategy has everyone watching.Jane Lubale (CoinGape)
Bitcoin ignores US nonfarm payrolls data to dive $3,000 in an hour.William Suberg (Cointelegraph)
Paul Atkins and Caroline Pham presented a united front when discussing future regulatory moves by their two agencies during a call on Friday.Nikhilesh De (CoinDesk)
Kotaku just posted:
Marshall Major V On-Ear Headphones Crash to Lowest Price Ever, Over 5x Cheaper Than AirPods Max
Save 38% on the Marshall Major V on-ear wireless headphones over at Amazon.
The post Marshall Major V On-Ear Headphones Crash to Lowest Price Ever, Over 5x Cheaper Than AirPods Max appeared first on Kotaku.
kotaku.com/marshall-major-v-on…
The Yemeni Armed Forces successfully struck Israeli Ben Gurion Airport with a Zulfiqar ballistic missile.ABNA English
DualShockers just posted:
Star Wars Outlaws Port Shows That Switch 2 Game-Key Cards Are A Necessary Evil
It looks like Nintendo Switch 2 game-key cards are here to stay.
dualshockers.com/switch-2-game…
US economy added just 22,000 jobs in August, unemployment highest in 4 yrs
Link: cnn.com/2025/09/05/economy/us-…
Discussion: news.ycombinator.com/item?id=4…
Browse millions of anime, manga, videos, hentai, and video game themed images on Gelbooru. Discover art with detailed tags. Contains explicit hentai content.Gelbooru
Insider Gaming just posted:
Battlefield 6 Leak Reveals Mirak Valley Gameplay
Battlefield 6's latest gameplay leak showcases the Mirak Valley map's various points of interest. Here are more details.
The post Battlefield 6 Leak Reveals Mirak Valley Gameplay appeared first on Insider Gaming.
insider-gaming.com/battlefield…
Battlefield 6's latest gameplay leak showcase the Mirak Valley map's various points of interest. Here are more details.Sam Sepiol (Insider Gaming)
French elite forces freed a Swiss hostage and arrested seven suspects in a crypto kidnapping as France leads in crypto-linked violent crime.Anas Hassan (Cryptonews)
Blacklisting drama hits WLFI as a whale wallet gets frozen – WLFI price prediction now hinges on what this shock move means.Alejandro Arrieche (Cryptonews)
Haya Murtaja’s heart stopped after Israel resumed its attacks on Gaza in March.The Electronic Intifada
Rock, Paper, Shotgun just posted:
Photograph bosses to death in this head-pulsing whirligig of a bullet hell
I fear and covet no videogame genre on this Earth like the bullet hell shoot 'em up. I find these scions of the arcades irresistibly beautiful. They look like how I imagine human nervous systems appear to thunder spirits. By the same token, I’m not sure they're actually designed to be processed by the human nervous system. They're the kind ...
rockpapershotgun.com/photograp…
Touhou Kouzougi ～ Flickerframe Shutter Festival is the latest fangame from the absolutely enormous Touhou Project universe.Edwin Evans-Thirlwell (Rock Paper Shotgun)
DualShockers just posted:
Final Fantasy 7 Remake Part Three's Release Date Has Been Decided
Tetsuya Nomura has revealed that the release date for the third entry in the Final Fantasy 7 Remake series has been decided, but he's not saying when.
dualshockers.com/final-fantasy…
