frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

Open in hackernews

A Visual Explanation of SQL Joins

https://blog.codinghorror.com/a-visual-explanation-of-sql-joins/
3•90s_dev•4h ago

Comments

90s_dev•4h ago
I don't know why SQL has always been so confusing to me. When he puts it this way, joins make perfect sense. But before reading this guide and this SO answer[1], they just felt like black magic. I don't understand why.

[1] https://stackoverflow.com/a/4401540/30477628

Probably the Most Perfect Programming for Solving SQL Data Analysis Pain Points

https://github.com/SPLWare/esProc/wiki/This-Is-Probably-the-Most-Perfect-Programming-for-Solving-SQL-Data-Analysis-Pain-Points
1•ossdwa•1m ago•0 comments

What are the risks from Artificial Intelligence?

https://airisk.mit.edu/
1•doener•2m ago•0 comments

Critical Warning for External Purchases in Apple App Store

https://mjtsai.com/blog/2025/05/14/critical-warning-for-external-purchases-in-app-store/
1•mpweiher•3m ago•0 comments

Asking a LLM for help is fine

https://reflexions.florianernotte.be/post/asking-llm/
1•flornt•4m ago•0 comments

Bitcoin price forecast next bull run

https://blockdag.network/blog/bitcoin-price-prediction-for-2025-2030-2040-2050-and-the-next-bull-run
1•karenkhine•5m ago•1 comments

Show HN: Postman/Insomnia Alternative

1•iondodon•7m ago•0 comments

DragonForce Ransomware – Reverse Engineering Malware Analysis

https://www.resecurity.com/blog/article/dragonforce-ransomware-reverse-engineering-report
1•azalemeth•9m ago•0 comments

89M Steam accounts reportedly leaked. Change your password now

https://mashable.com/article/89-million-steam-accounts-leaked-change-your-password
1•taubek•12m ago•0 comments

System Prompts and Models of AI Tools

https://github.com/x1xhlol/system-prompts-and-models-of-ai-tools
1•cmogni1•14m ago•0 comments

Appeals court rules that tracking-based online advertising is illegal in Europe

https://www.engadget.com/big-tech/appeals-court-confirms-that-tracking-based-online-advertising-is-illegal-in-europe-223714124.html
1•adwmayer•17m ago•0 comments

"Get Rich Quick" by Edward de Bono - Review by Ian Hislop (1985)

https://literaryreview.co.uk/get-rich-quick
1•PaulRobinson•19m ago•1 comments

The Joy Is Not Optional: The Growing Kids God's Way Protocol

https://aella.substack.com/p/the-joy-is-not-optional
1•decimalenough•21m ago•1 comments

Amortized Analysis as a Cost-Aware Abstraction Function

https://www.cs.cmu.edu/~csd-phd-blog/2025/amortized-abstraction/
1•matt_d•23m ago•0 comments

Bayesian yacht sinking preliminary report [pdf]

https://assets.publishing.service.gov.uk/media/6821ea1aced319d02c9060f2/2025-Bayesian-InterimReport.pdf
4•urban_winter•23m ago•0 comments

Bitwarden registration flow failed – so I wrote a stand-up comedy set instead

https://github.com/MenstaDay/bitwarden-registration-theatre
2•Yulenka•24m ago•2 comments

Cognitive Artifacts: Complementary and Competitive

https://jackson-t.com/cognitive-artifacts-complementary-competitive/
1•jthuraisamy•25m ago•0 comments

Tactics and Keyframes: Visualizing Lean 4 Proofs in Blender [video]

https://www.youtube.com/watch?v=KuxFWwwlEtc
1•downboots•25m ago•0 comments

A dangerous E. coli strain has emerged; a small mutation may explain its rise

https://arstechnica.com/health/2025/05/a-dangerous-e-coli-strain-has-emerged-a-small-mutation-may-explain-its-rise/
1•lentoutcry•28m ago•0 comments

Microsoft extends Office app support on Windows 10 to 2028

https://www.theverge.com/news/665599/microsoft-365-office-apps-windows-10-end-of-support-extension-2028
2•walterbell•34m ago•0 comments

Chapter 2: Serializability Theory (Concurrency Control Book)

http://muratbuffalo.blogspot.com/2025/05/chapter-2-serializability-theory.html
1•matt_d•42m ago•0 comments

How a Mechanical Watch Works (2020) [video]

https://www.youtube.com/watch?v=9_QsCLYs2mY
1•Tomte•43m ago•0 comments

Postgres.app – the easiest way to get started with PostgreSQL on the Mac

https://postgresapp.com/
1•Tomte•43m ago•0 comments

A cross-platform Markdown note-taking application

https://github.com/codexu/note-gen
1•461229817•45m ago•0 comments

FrankenPHP moving under the PHP GitHub organization

https://externals.io/message/127347
1•brrrrrd•51m ago•0 comments

Harvard's unofficial copy of Magna Carta is an original, experts say

https://www.theguardian.com/uk-news/2025/may/15/harvards-unofficial-copy-of-magna-carta-is-actually-an-original-experts-say
1•ascorbic•58m ago•0 comments

Garry Nolan Interview [video]

https://www.youtube.com/watch?v=QpJebYW_vb4
2•dasefx•1h ago•1 comments

New PostgreSQL Support in IBM COBOL for Linux on x86

https://www.ibm.com/docs/en/cobol-linux-x86/1.2?topic=environments-programming-postgresql-environment
1•sbuttgereit•1h ago•0 comments

Red Hat Enterprise Linux 10 (Coughlan) released via general availability (GA)

https://nixsanctuary.com/red-hat-enterprise-linux-10-coughlan-released-via-general-availability-ga-first-peak-into-rhel-10-workstation/
2•linuxlibre•1h ago•0 comments

Does It Scale (Down)?

https://www.bugsink.com/blog/does-it-scale-down/
1•thunderbong•1h ago•0 comments

Fast Text-to-Audio Generation with Adversarial Post-Training

https://arc-text2audio.github.io/web/
1•guardienaveugle•1h ago•0 comments