Entertainment - viralpique.com

The perils of UUID primary keys in SQLite

0 CommentsEntertainment

🔥 Explore this insightful post from Hacker News 📖 📂 **Category**: 📌 **What You’ll Learn**: 05 Jun 2026It's common to use random UUIDs as a primary key in databases. One of the known downsides of random UUIDs is that their unordered nature (UUID4) can cause a lot of extra paging for the clustered index because you are inserting rows randomly into the Btree and having to re-balance it. This post tries to help us develop a more visceral understanding of the performance cost of all that extra paging.While this post is about SQLite specifically, the problem of random UUIDs also…

The back cover of C++: The Programming Language also raises questions not answered by the front cover

0 CommentsEntertainment

🔥 Read this awesome post from Hacker News 📖 📂 **Category**: 💡 **What You’ll Learn**: A little while ago, we considered how the cover of the book C++: The Programming Language raises questions not answered by the cover, since the cover illustration for a book putatively about the C++ programming language shows code written in JavaScript.¹ But there’s also a question raised by the back cover. According to the blurb for the book, The topics included in it are of utmost significance and are bound to provide incredible insights to students. Some of the diverse topics covered in this text…

S&P 500 rejects SpaceX, also blocking entry for OpenAI and Anthropic

0 CommentsEntertainment

💥 Explore this trending post from Hacker News 📖 📂 **Category**: 💡 **What You’ll Learn**: But in its final decision, the S&P Dow Jones Indices stated that “no changes will be made to the eligibility criteria including financial viability screens, seasoning period, or minimum IWF.” Even after the standard yearlong wait, SpaceX, Anthropic, and OpenAI may struggle to deliver the consistent profitability necessary to qualify for the S&P 500. Money rules and exceptions Swift entry into the S&P 500 would have triggered $14 billion of passive fund buying for SpaceX, according to Bloomberg Intelligence. The investment research arm of Bloomberg…

Why They Fight – A Collection of Unmitigated Pedantry

0 CommentsEntertainment

🔥 Explore this must-read post from Hacker News 📖 📂 **Category**: ✅ **What You’ll Learn**: This week I want to try something a little different. Rather than taking apart a particular fantasy military system, I thought I might try to lay out a more general sense of how military systems tend to map on to societies, both because such general historical frameworks are handy for thinking about the past, but also because they make useful rules of thumb for imagining fantastical societies. So essentially here we are asking: how do societies end up with the sort of armies they have?…

Stop Using Conventional Commits – Sumner Evans

0 CommentsEntertainment

✨ Discover this awesome post from Hacker News 📖 📂 **Category**: 💡 **What You’ll Learn**: You’ve almost certainly encountered Conventional Commits before. It may have reared its ugly head in the changelog of an open source project you’ve used. It may have been the enforced commit format for an open source project you contributed to. A lot of people swear by it. I swear at it.Even though it is used by a large number of popular open source projects, Conventional Commits is an actively bad standard which encourages focus on the wrong things and fails to deliver on its promises.Focus…

Classic 100: 2001 to 2021

0 CommentsEntertainment

💥 Read this insightful post from Hacker News 📖 📂 **Category**: 💡 **What You’ll Learn**: Classic 100: 2001 to 2021 ABC Classic 100 Rankings: 2001 to 2021 Every year since 2001, ABC Classic FM has run a Classic 100 event, where listeners vote on their favourite pieces. This page visualises the rankings for three different years: Each dot represents a piece of music. The lines track how the rankings for that piece have changed between 2001 and 2021. …

Sigma 45mm f/2.8 Lens Repair & Analysis

0 CommentsEntertainment

💥 Explore this awesome post from Hacker News 📖 📂 **Category**: 📌 **What You’ll Learn**: Sigma 45mm f/2.8 Lens Repair & Analysis[05.12.24] I have a camera gear collection problem and as part of my personal 12 step plan, I restrict myself from purchasing functioning lenses. This sounds illogical, and it frankly is, but it's very hard for me to resist heavily discounted lenses. To keep my hat, I tend to only bid on lenses that are less than 1/4 of the going used sale prices and have little to no mechanical damage. In this case I've…

Gemma 4 with quantization-aware training

0 CommentsEntertainment

💥 Explore this awesome post from Hacker News 📖 📂 **Category**: ✅ **What You’ll Learn**: Since releasing Gemma 4 two months ago, we've been continuously working to expand its capabilities. First, we introduced Multi-Token Prediction (MTP) to accelerate inference, and just a couple of days ago, we released a 12B model to bridge the gap between our E4B and 26B MOE models.Today, we are releasing new checkpoints optimized with Quantization-Aware Training (QAT) to make Gemma 4 even more efficient, so you can run models locally on everyday edge devices and consumer GPUs.By simulating quantization during training, QAT minimizes quality loss…

Microsoft wants users to be addicted to Scout, their AI personal assistant – disassociated.com

0 CommentsEntertainment

🔥 Read this must-read post from Hacker News 📖 📂 **Category**: ✅ **What You’ll Learn**: Microsoft wants users to be addicted to Scout, their AI personal assistant 6 June 2026 Jason Koebler, and Emanuel Maiberg, writing for 404 Media: An internal Microsoft strategy document says that the plan for its just-announced “Scout” personal assistant AI is to “make people addicted” to the tool before rolling out additional functionality, 404 Media has learned. “Three phases from addictive app to agentic platform,” the documentation. Is anyone surprised? The big tech company has long been in the business of building not so much…

GOV.UK goes Dutch on payments as it dumps Stripe

0 CommentsEntertainment

✨ Discover this must-read post from Hacker News 📖 📂 **Category**: ✅ **What You’ll Learn**: public sector Means residents can skip the credit card and use 'pay by bank' for local authorities and services The UK’s Government Digital Service (GDS) has replaced Stripe with Dutch provider Adyen as its processor for many payments made through its GOV.UK Pay service.Adyen will take over GOV.UK Pay card payments for local authorities, police forces and armed forces units from Stripe, as well as pay by bank services, under a three-year contract worth up to £25.3 million. According to the tender notice published in…