Molly-Mae Hague is convinced fans will 'hate' the very unique baby name she and Tommy Fury have chosen
M&S' Love Story with Carolyn Bessette Kennedy! Retailer's new '90s edit' delights fans of the hit drama
Which supplements ACTUALLY work? Dietician Josie Porter reveals the pills worth your money - and the pricey powders to ditch for good
GitHub backs down, kills Copilot pull-request ads after backlash
Updated Microsoft has done a 180. Following backlash from developers, GitHub has removed Copilot's ability to stick ads - what it calls "tips" - into any pull request that invokes its name. …
Coronation Street actress Helen Worth, 75, reveals why she really quit the soap after 50 years as she reflects on 'tiring' filming schedules
Brits are paying 9% more for Easter eggs than last year as Iran conflict rumbles on - after global cocoa shortage sparks cost crisis
Met Office predicts a wet and windy Easter weekend, but Essex may get off lightly
Met Office predicts a wet and windy Easter weekend, but Essex may get off lightly
Scientists Shocked To Find Lab Gloves May Be Skewing Microplastics Data
Read more of this story at Slashdot.
From £17m Swiss chalet to a plastic caravan: Andrew Mountbatten-Windsor thinks his new caravan is 'hilarious', says CHARLOTTE GRIFFITHS
Scott Mills 'probed by police in 2016 over serious sex offences against teenage boy' as crisis leaves BBC in 'absolute chaos'
British 'serial killer' who is still on the loose: Coroner lost her job for raising the alarm after FIVE elderly couples died in murder suicides in the heart of leafy Cheshire… but could she be proved right...
Trump teases design for 50-story skyscraper presidential library complete with Air Force One INSIDE: 'Coming soon'
North Essex pubs and restaurants offering fish-filled Good Friday menus
New boss to take on 'inadequate' Essex NHS trust
New boss to take on 'inadequate' Essex NHS trust
CodeSOD: Joined Up
Sandra from InitAg (previously) works with Bjørn, and Bjørn has some ideas about how database schemas should be organized.
First, users should never see an auto-incrementing ID. That means you need to use UUIDs. But UUIDs are large and expensive, so they should never be your primary key, use an auto-incrementing ID for that.
This is not, in and of itself, a radical or ridiculous statement. I've worked on many a database that followed similar rules. I've also seen "just use a UUID all the time" become increasingly common, especially on distributed databases, where incrementing counters is expensive.
One can have opinions and disagreements about how we handle IDs in a database, but I wouldn't call anything a WTF there.
No, the WTF is how Bjørn would design his cross-reference tables. You know, the tables which exist to permit many-to-many relationships between two other tables? Tables that should just be tableA.id and tableB.id?
Table "public.foo_bar" Column | Type | Collation | Nullable | Default -----------+------------------------+-----------+----------+------------------------------------ id | integer | | not null | nextval('foo_bar_id_seq'::regclass) foo_id | integer | | not null | bar_id | integer | | not null | uuid | character varying(128) | | not null |Yes, every row in this table has an ID, which isn't itself a terrible choice, and a UUID, despite the fact that the ID of these rows should never end up in output anyway. It exists only to facilitate queries, not store any actual data.
I guess, what's the point of having a rule if you don't follow it unthinkingly at all times?
[Advertisement] Picking up NuGet is easy. Getting good at it takes time. Download our guide to learn the best practice of NuGet for the Enterprise.