Computer
Humans Can Be Tracked With Unique 'Fingerprint' Based On How Their Bodies Block Wi-Fi Signals
Read more of this story at Slashdot.
Amazon Buys Bee AI Wearable That Listens To Everything You Say
Read more of this story at Slashdot.
Nvidia's CUDA Platform Now Support RISC-V
Read more of this story at Slashdot.
Brave Browser Blocks Microsoft Recall By Default
Read more of this story at Slashdot.
Science Confirms What We All Suspected: Four-Day Weeks Rule
Read more of this story at Slashdot.
Apple Set To Stave Off Daily Fines, EU To Accept App Store Changes
Read more of this story at Slashdot.
California Won't Force ISPs To Offer $15 Broadband
Read more of this story at Slashdot.
Surge CEO Says '100x Engineers' Are Here
Read more of this story at Slashdot.
Microsoft Poaches Top Google DeepMind Staff in AI Talent War
Read more of this story at Slashdot.
Google Users Are Less Likely To Click on Links When an AI Summary Appears in the Results, Pew Research Finds
Read more of this story at Slashdot.
Many Lung Cancers Are Now in Nonsmokers. Scientists Want to Know Why.
Read more of this story at Slashdot.
Banks View Heavy 'Buy Now, Pay Later' Use as Red Flag for Loan Approvals
Read more of this story at Slashdot.
Mike Lynch's Estate and Business Partner Owe HP $944M, Court Rules
Read more of this story at Slashdot.
Google Launches OSS Rebuild
Read more of this story at Slashdot.
How NASA Saved a Camera From 370 Million Miles Away
Read more of this story at Slashdot.
US Signals Intention To Rethink Job H-1B Lottery
Read more of this story at Slashdot.
ChatGPT Users Send 2.5 Billion Prompts a Day
Read more of this story at Slashdot.
Climate Change Is Making Fire Weather Worse for World's Forests
Read more of this story at Slashdot.
CodeSOD: A Unique Way to Primary Key
"This keeps giving me a primary key violation!" complained one of Nancy's co-workers. "Screw it, I'm dropping the primary key constraint!"
That was a terrifying thing to hear someone say out loud. Nancy decided to take a look at the table before anyone did anything they'd regret.
CREATE TYPE record_enum AS ENUM('parts'); CREATE TABLE IF NOT EXISTS parts ( part_uuid VARCHAR(40) NOT NULL, record record_enum NOT NULL, ... ... ... PRIMARY KEY (part_uuid, record) );This table has a composite primary key. The first is a UUID, and the second is an enum with only one option in it- the name of the table. The latter column seems, well, useless, and certainly isn't going to make the primary key any more unique. But the UUID column should be unique. Universally unique, even.
Nancy writes:
Was the UUID not unique enough, or perhaps it was too unique?! They weren't able to explain why they had designed the table this way.
Nor were they able to explain why they kept violating the primary key constraint. It kept happening to them, for some reason until eventually it stopped happening, also for some reason.
[Advertisement] Keep all your packages and Docker containers in one place, scan for vulnerabilities, and control who can access different feeds. ProGet installs in minutes and has a powerful free version with a lot of great features that you can upgrade when ready.Learn more.At Least 750 US Hospitals Faced Disruptions During Last Year's CrowdStrike Outage, Study Finds
Read more of this story at Slashdot.