Nigel Farage is currently the only senior politician who is seen to be actually speaking for Britain - and doing so in a voice voters recognise: DAN HODGES
National Archives reveal No 10 aide's worry at Blair clothes expenses, Mandelson's bid for a return to power, bid to woo ministers over Royal Yacht, and Putin's birthday message
Anne Hathaway ditches Andy Sachs' infamous blue jumper for fashion-forward pinstripes in first look at long-awaited Devil Wears Prada 2
Bombshell from beyond the grave: Real story behind Oscar-winning actress Gloria Grahame's relationship with her stepson is revealed in a new memoir so explosive it could only be published after everyone involved died, writes BRIAN VINER
Prince William and Harry's cousin, 20, found dead 'with firearm nearby'
Trump rages as Jewish judge rips administration apart for stripping 'antisemitic' Harvard of its funding in blistering courtroom showdown
Climate Change Is Making Fire Weather Worse for World's Forests
Read more of this story at Slashdot.
Police name man charged with violent disorder after Epping protest arrests
Replit makes vibe-y promise to stop its AI agents making vibe coding disasters
Vibe coding service Replit has announced changes to its product that should prevent the database deletion disaster reported by one of its users.…
The Lionesses' smiling assassin - with her wedding photos on her shinpads: Why 'unique' Chloe Kelly doesn't miss when the big moments come - and is ready to fire England to Euro final again
Where over 6,000 new homes are planned in and around Canvey Island
Over £100k spent on policing outside Epping hotel during protests
What makes a man in his 50s cheat with a woman OLDER than his wife? Relationship expert weighs in after Coldplay 'kiss cam scandal'
Asylum seeker staying on Bibby Stockholm barge in Dorset sexually assaulted teenager on the beach after telling her, 'I've never been this close to a white woman'
Katie Holmes and Joshua Jackson REUNITE as they drive fans wild with special announcement
Major development in search for Julian Story's missing remains
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.
I too fell for the oleaginous charms of the same type of man as the Coldplay kisscam CEO. That's how I know his playbook - and exactly what happens now
Vibe coding service Replit deleted user’s production database, faked data, told fibs galore
The founder of SaaS business development outfit SaaStr has claimed AI coding tool Replit deleted a database despite his instructions not to change any code without permission.…