Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
petepete
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
34 ms
·
631.
▲
by
petepete
4y ago
It's funny how the huge silent majority get on just fine with GNOME but the vocal few act like the devs have poked them in the eye and called their mother fat.
632.
▲
by
petepete
4y ago
Mainly because you end up with something that's untidy. Your elegant table that contains all data identifiable by a single PK is now spread across two tables and relies on a (often forgotten) constraint in addition to a FK. I'd ra
633.
▲
by
petepete
4y ago
Yes, I mentioned the approach elsewhere. Now you have two database things (the FK and the constraint) describing a single relationship. I don't think it's very elegant and people often forget the unique constraint. One table is a
634.
▲
by
petepete
4y ago
Yeah, I noted elsewhere among the replies it's possible to use constraints to prevent extra rows in the related table, but it's inelegant and I've seen plenty of cases where it's forgotten and ends up being buggy. I'
635.
▲
by
petepete
4y ago
This is related to what I meant, but specifically I was referring to the inability of databases to prevent a 1:1 becoming a 1:2 (or 1:N). Yes, you can hack it with a unique constraint, but it's not very elegant.
636.
▲
by
petepete
4y ago
That's a 1:N relationship. There's nothing to prevent you from adding more related records. At the database level there's only one kind of foreign key. Yeah, you can try and prevent it from happening in code or throw some uni
637.
▲
by
petepete
4y ago
How do you enforce the 1:1 relationship at the database level?
638.
▲
by
petepete
4y ago
I mean at the database level. Your relationships are foreign keys and they're 1:N. Yes, you can try and artificially limit them to 1:1 using constraints but it's a hack. The correct way to represent a 1:1 relationship in a databas
639.
▲
by
petepete
4y ago
I entirely agree. This advice is plain wrong: > Does your users table have a few columns prefixed with oidc for single sign-on authentication? Those should probably be in their own table. If your users have one set of oidc data each, lea
640.
▲
Spying on the scammers part 5 [video]
(youtube.com)
1 points
by
petepete
4y ago
|
0 comments
641.
▲
by
petepete
4y ago
Those videos by Mark Rober mainly build on the work done by Jim Browning. https://www.youtube.com/c/JimBrowning/featured ScammerPayback also does an incredible job. https://www.youtube.com/@Scammer
642.
▲
by
petepete
4y ago
This is the main reason I use a HHKB. I'd support any other keyboard makers who put the CTRL in the right place too.
643.
▲
by
petepete
4y ago
On my phone (Pixel) if you type 'gitlab' into the Google Keyboard and it suggests 'girls'.
644.
▲
by
petepete
4y ago
We went with esbuild and regardless of speed (it's way faster) the main reason I like it is because the config is tiny and I actually understand what it's doing. Our Webpacker config was big and fragile by comparison.
645.
▲
by
petepete
4y ago
Hopefully Virgin Money will get one too. They broke their Android app earlier this year and since they make you verify web logins using the app I was unable to access any of my business accounts for ~3 weeks. If something really urgent had
646.
▲
by
petepete
4y ago
Having watched every possible minute of every competition since France '98, I haven't seen any of this World Cup. It still boggles my mind that FIFA weren't forced to overturn the decision when they were uncovered as the most
647.
▲
by
petepete
4y ago
Does nobody do it because support's only just been added? Could it be the next step in collaborative remote music making?
648.
▲
by
petepete
4y ago
For the NZ one you'll see the following snippet at the bottom of each component page: > Credit. Guidance, original HTML and CSS derived from GOV.UK Design System. https://design-system-alpha.digital.govt.nz/component
649.
▲
by
petepete
4y ago
Or just make the whole page rotate body[href*= "<OFFENDING URL>"] { animation: rotation 20s infinite linear; } @keyframes rotation { from { transform: rotate(0deg); } to {
650.
▲
by
petepete
4y ago
Yeah I'd agree that having the ability to customise what's displayed in the top bar could be useful, and the audio source selection could definitely be improved. It only takes a few clicks to get to settings but if you do it a few
651.
▲
by
petepete
4y ago
What GNOME extensions do you need to provide 'the bare minimum'? I use none and it's fine for me.
652.
▲
by
petepete
4y ago
I've been using tmux daily for more than a decade and didn't know prefix+! converted a pane to a new window.
653.
▲
by
petepete
4y ago
GitHub's command line tool does a pretty good job of this, it does emoji too.
654.
▲
by
petepete
4y ago
My brother was so disappointed at losing Beehive Bedlam when we switched from Sky to NTL in ~2002. I remember asking around for something similar and he subsequently was hooked on Bust-a-Move for about 2 years. Music still etched on my brai
655.
▲
by
petepete
4y ago
But in the UK the burgers made of veg are at least as expensive as their meat counterparts. On the menu I posted the bean burger is 50p more expensive than beef.
656.
▲
by
petepete
4y ago
Would https://gofiber.io/ work for you?
657.
▲
by
petepete
4y ago
I missed the shell integration when switching to Fish a couple of years ago. fzf.fish saved the day, I wouldn't be without the keybindings now (Ctrl+Alt+F is roughly the equivalent of **Tab) https://github.com/PatrickF1
658.
▲
by
petepete
4y ago
Less Useful Key Bindings: C-l Clear screen This is the one I use most frequently. All day every day. I hate clutter and unless I need to refer to the output from the previous commands, it's gone.
659.
▲
by
petepete
4y ago
In the UK that's rarely the case. The veg options are usually the same price as the meat. In some places. At Gourmet Burger Kitchen the Beyond Meat cheeseburger costs 30% more than its beef counterpart. https://gbk.co.uk
660.
▲
by
petepete
4y ago
Similarly, I use diff-highlight 99% of the time because it works flawlessly with all of git diff's arguments (including --word-diff) but break out Meld for big content-heavy changes. https://meldmerge.org/
More ›