frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

Open in hackernews

That boolean should probably be something else

https://ntietz.com/blog/that-boolean-should-probably-be-something-else/
4•todsacerdoti•3h ago

Comments

PaulHoule•3h ago
I just converted a nullable timestamp + boolean to a plain nullable timestamp but I'd say, in general, there should be a side table for events and state transitions. All too often a "user" table winds up with 15 timestamps for 15 different events and you will eventually find that some of these events happen more than once: for instance, a student applies for an academic program, gets rejected, submits a better application next year, get accepted.

In the case of those email verification requests I think there should be a table that has one row for each verification attempt because you can track the history of the process, something you'll want to do someday because (1) email is wonky and (2) registration is on the critical path for everything. It may still make sense to have an email_verified flag on the user table because this gets looked at a lot and the join on the side table is a hassle. Not least you might need admins to flip that flag on an account for one reason or another.

Show HN: Validated Daily SaaS Ideas

https://www.dailysaasideas.com/
1•sandandcode•1m ago•0 comments

What's the difference between bio and non bio detergent? (2022)

https://smol.com/uk/stories/whats-the-difference-between-bio-vs-non-bio-detergent
1•mooreds•1m ago•0 comments

Amateurs Talk Algorithms, Professionals Talk Data Cleaning

https://progressandpoverty.substack.com/p/amateurs-talk-algorithms-professionals
1•hliyan•2m ago•0 comments

Show HN: BugBlaze – a CLI tool that explains your code errors using AI

https://github.com/MatthewTheCoder1218/bugblaze
1•lilprince1218•2m ago•0 comments

Ask HN: What's the 2025 stack for a self-hosted photo library with local AI?

1•jamesxv7•2m ago•0 comments

The Bear Manifesto – Herman's Blog

https://herman.bearblog.dev/manifesto/
1•FigurativeVoid•2m ago•0 comments

Alex Trebek Stamps, Sheet of 20

https://store.usps.com/store/product/alex-trebek-stamps-S_485304
1•mooreds•3m ago•0 comments

Show HN: Kichan.ai a free Chrome extension to generate and inject scripts

https://kichan.ai/
1•k1rd•4m ago•0 comments

Show HN: Attach Gateway – one-command OIDC / DID auth for local LLMs

https://github.com/attach-dev/attach-gateway
1•hammadtariq•4m ago•0 comments

Zig Community Mirrors

https://ziglang.org/download/community-mirrors/
2•todsacerdoti•5m ago•0 comments

The Simple Math Problem We Still Can't Solve

https://www.quantamagazine.org/why-mathematicians-still-cant-solve-the-collatz-conjecture-20200922/
1•chirau•8m ago•0 comments

They don't make 'em like that any more: Sony DTC-700 audio DAT player/recorder

https://kevinboone.me/dtc-700.html
2•naves•9m ago•0 comments

User-friendly and privacy-friendly LLM experience?

https://tildes.net/~comp/1orz/user_friendly_and_privacy_friendly_llm_experience
1•PaulHoule•9m ago•0 comments

Ask HN: Stock Android tablet free of bloatware?

2•miki_tyler•11m ago•0 comments

Alice's Adventures in a Differentiable Wonderland

https://arxiv.org/abs/2404.17625
1•henning•11m ago•0 comments

Why We Should Care About This War over the Future of Money

https://gizmodo.com/why-you-should-care-about-this-war-over-the-future-of-money-2000622009
1•rntn•12m ago•0 comments

Lua 5.5.0 (Beta) Released

https://www.lua.org/work/#5.5.0
1•dottrap•13m ago•1 comments

Proton joins suit against Apple for predatory practices

https://proton.me/blog/apple-lawsuit
2•moose44•14m ago•0 comments

Writing Code to Be Read at a Glance

https://jelv.is/blog/Writing-Code-To-Be-Read-at-a-Glance/
1•lawn•14m ago•0 comments

Fake AI-made videos about Diddy trial are raking in millions of views on YouTube

https://www.theguardian.com/technology/2025/jun/29/fake-diddy-ai-videos-youtube
1•sandebert•14m ago•0 comments

Operation Gold Rush, largest health care fraud bust in U.S. history

https://www.washingtonpost.com/health/2025/06/30/health-care-fraud-bust-largest-in-us-history/
3•brandonb•15m ago•1 comments

Satellites are fueling a space-based internet gold rush

https://restofworld.org/2025/satellites-space-based-internet/
1•tysone•15m ago•0 comments

Hit songs are getting shorter

https://www.economist.com/culture/2025/06/02/hit-songs-are-getting-shorter
1•gmays•15m ago•0 comments

Trump Vowed to Dismantle MS-13. His Deal with Bukele Threatens That Effort

https://www.nytimes.com/2025/06/30/us/politics/trump-bukele-ms-13-immigrants.html
3•JumpCrisscross•15m ago•0 comments

iOverlander's Pivot Shows the Cost of Community-Driven Tech

https://www.hereandthere.club/post/ioverlanders-pivot-shows-the-cost-of-community-driven-tech
1•dzogchen•17m ago•0 comments

Fil-C

https://github.com/pizlonator/llvm-project-deluge
1•mpweiher•17m ago•0 comments

A vision researcher's guide to some RL stuff: PPO and GRPO

https://yugeten.github.io/posts/2025/01/ppogrpo/
1•fzliu•20m ago•0 comments

Insider Trading on SEC Filings

https://www.bloomberg.com/opinion/newsletters/2025-06-30/insider-trading-on-sec-filings
2•ioblomov•20m ago•0 comments

High-Severity Vulnerability in Notepad++

https://www.csa.gov.sg/alerts-and-advisories/alerts/al-2025-063
1•onlinenotepad•24m ago•0 comments

Therapy dogs: stop crafting loopholes to fair, reasonable laws

https://dirtamericana.com/2025/04/therapy-dogs-business-interior-violations/
4•speckx•25m ago•0 comments