|
Ensuring uniqueness is only the first of many problems with natural keys. This opinion brought to you by Big UUID
|
|
|
|
|
I do prefer natural ones. Metal is better than plastic  
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
There was an article that hit a different, more automated, less curated (and inferior, and never having your awesome quips) service.
It was maligning UUID in particular. It was very rightfully skewered, imo.
I have no idea which DBA taught me... But you really want to do both. Space is cheap and if we're talking RDBMS, indexing and normalization strategies are the crux of performance. Part of the reason you want "two ways" is that there are fundamentally two different concerns and having both allows you to address things using either in the appropriate context.
A typical autonumber identity PK (sequence in oracle) combined with either a natural key on the data OR a UUID (and even both!) is just the way you should be doing things. I can maybe explain/rebut particular points of antithesis but laying out all the reasons why is something that belongs in multiple chapters of a database design book.
Totally agree that if you ONLY use natural keys you're basically laying a minefield.
|
|
|
|
|
A group of current and former employees at artificial intelligence (AI) companies, including Microsoft-backed, opens new tab OpenAI and Alphabet's, opens new tab Google DeepMind on Tuesday raised concerns about risks posed by the emerging technology. Yeah, but what do they know about it?
|
|
|
|
|
Kent Sharkey wrote: Yeah, but what do they know about it?
But do the ones that matter care about it?
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
The founder and CEO of video conferencing company Zoom wants AI avatars to take your place, despite meetings being the entire point of his company. What if they called a meeting, and only the AI show up?
|
|
|
|
|
Can I get an AI avatar to do the rest of my job, too?
There are no solutions, only trade-offs. - Thomas Sowell
A day can really slip by when you're deliberately avoiding what you're supposed to do.
- Calvin (Bill Watterson, Calvin & Hobbes)
|
|
|
|
|
Sorry, your avatar gets to go on vacation for all its wonderful input at those meetings. You? get back to work! 
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
Kent Sharkey wrote: What if they called a meeting, and only the AI show up?
Seeing how many meetings go, that could even be an improvement.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
How long till you can homebrew and AI to go to meetings for you?
What if that's how AI really ends up replacing us?
It doesn't, not really, it's just we all have to manage/educate/instruct our AI 'avatars' like tamagachis or w/e.
|
|
|
|
|
Windows Recall takes a screenshot every five seconds. Cybersecurity researchers say the system is simple to abuse—and one ethical hacker has already built a tool to show how easy it really is. I'm a little shocked that it's taken this long
Hopefully they don't dump this beyond the paywall. It isn't as I post this.
Cheery quote: “The database is unencrypted. It’s all plain text,” Hagenah says.
|
|
|
|
|
Kent Sharkey wrote: I'm a little shocked that it's taken this long
That was my first thought when I saw it in the news here.
My second thought was "What is Ken going to say about it?"
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I just hope that the hackers figure out which service is responsible for taking the screenshots, so that we can disable that one.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
Kent Sharkey wrote: “The database is unencrypted. It’s all plain text,” Hagenah says.
MS: Using Staples' Easy button option.
|
|
|
|
|
|
Instead of just showing who has been assigned what task, now Asana says its AI tool can do the assigning or reach out to fill in missing information. Because I'm sure there are people at work that you'd like to tell what to do
|
|
|
|
|
Kent Sharkey wrote: that you'd like to tell what to do
I wouldn't like to, but there for sure are some than definitively need "someone" telling them what to do, and even then... 
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
A study has found that projects adopting Agile practices are 268 percent more likely to fail than those that do not. "Fail fast"
|
|
|
|
|
Agile is a methode, but when it is taken as a religion... fail is not only expected but deserved.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Dr Junade Ali, author of Impact Engineering, said: "With 65 percent of projects adopting Agile practices failing to be delivered on time, it's time to question Agile's cult following.
"And the truth will set you free."
If that's how they're judging failure I'm really going to have to read about this Impact Engineering and how it is that it manages to figure out an appropriate timeline for an undefined and undefinable deliverable which is what I think 90% of the world deals with... "We'll know it when we see it".
|
|
|
|
|
Windows 10 development is about to get interesting, as the operating system is no longer on the back burner. Give the people what they want
|
|
|
|
|
They need more places to place ads for Windows 11.
I’ve given up trying to be calm. However, I am open to feeling slightly less agitated.
I’m begging you for the benefit of everyone, don’t be STUPID.
|
|
|
|
|
"Features"... yeah, right! 
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Quote: Microsoft’s approach has changed, and it wants to empower every computer, even those running Windows 10.
No, no. They want to backport some of their best spying features because not enough people are switching to 11.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
We have a winner! 
TTFN - Kent
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
