frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

Understanding conflict resolution and avoidance in PostgreSQL: a complete guide

https://www.pgedge.com/blog/living-on-the-edge
27•birdculture•1w ago

Comments

wppick•3h ago
> An ounce of prevention is worth a pound of cure, after all.

  Don’t do what? Consider the primary cause of conflicts: simultaneous operations occurring on the same data on different nodes. That happens because data may not have distinct structural or regional boundaries, or because a single application instance is interacting with multiple nodes simultaneously without regard for transmission latency.

  Thus the simplest way to avoid conflicts is to control write targets

  Use “sticky” sessions. Applications should only interact with a single write target at a time, and never “roam” within the cluster.

  Assign app servers to specific   (regional) nodes. Nodes in Mumbai shouldn’t write to databases in Chicago, and vice versa. It’s faster to write locally anyway.

  interact with specific (regional) data. Again, an account in Mumbai may physically exist in a globally distributed database, but multiple accessors increase the potential for conflicts.

  Avoid unnecessary cross-node activity. Regional interaction also applies on a more local scale. If applications can silo or prefer certain data segments on specific database nodes, they should.

  To solve the issue of updates on different database nodes modifying the same rows, there’s a solution for that too: use a ledger instead

Best points are this summary near the end. IMO it's better to also allow for slower writes doing something simpler than trying to complex distributed stuff just so writes are quick. Users seem to have pretty long tolerance for something they understand as a write taking even many seconds.

Power over Ethernet (PoE) basics and beyond

https://www.edn.com/poe-basics-and-beyond-what-every-engineer-should-know/
106•voxadam•5d ago•63 comments

rlsw – Raylib software OpenGL renderer in less than 5k LOC

https://github.com/raysan5/raylib/blob/master/src/external/rlsw.h
135•fschuett•7h ago•28 comments

OpenBSD 7.8 Released

https://cdn.openbsd.org/pub/OpenBSD/7.8/ANNOUNCEMENT
84•paulnpace•2h ago•15 comments

Replacing a $3000/mo Heroku bill with a $55/mo server

https://disco.cloud/blog/how-idealistorg-replaced-a-3000mo-heroku-bill-with-a-55-server/
484•jryio•8h ago•339 comments

LLMs can get "brain rot"

https://llm-brain-rot.github.io/
319•tamnd•14h ago•180 comments

Neural audio codecs: how to get audio into LLMs

https://kyutai.org/next/codec-explainer
342•karimf•15h ago•103 comments

The Hidden Engineering of Niagara Falls

https://practical.engineering/blog/2025/10/21/the-hidden-engineering-of-niagara-falls
69•chmaynard•5h ago•1 comments

Ask HN: Our AWS account got compromised after their outage

222•kinj28•12h ago•57 comments

Wikipedia says traffic is falling due to AI search summaries and social video

https://techcrunch.com/2025/10/18/wikipedia-says-traffic-is-falling-due-to-ai-search-summaries-an...
321•gmays•1d ago•300 comments

Show HN: Modshim – a new alternative to monkey-patching in Python

https://github.com/joouha/modshim
14•joouha•5d ago•3 comments

NASA chief suggests SpaceX may be booted from moon mission

https://www.cnn.com/2025/10/20/science/nasa-spacex-moon-landing-contract-sean-duffy
253•voxleone•15h ago•739 comments

ChatGPT Atlas

https://chatgpt.com/atlas
599•easton•11h ago•569 comments

Mathematicians have found a hidden 'reset button' for undoing rotation

https://www.newscientist.com/article/2499647-mathematicians-have-found-a-hidden-reset-button-for-...
112•mikhael•5d ago•78 comments

Rectal oxygen delivery might soon be a real medical treatment

https://arstechnica.com/science/2025/10/butt-breathing-might-soon-be-a-real-medical-treatment/
133•zdw•5h ago•63 comments

Getting DeepSeek-OCR working on an Nvidia Spark via brute force with Claude Code

https://simonwillison.net/2025/Oct/20/deepseek-ocr-claude-code/
135•simonw•1d ago•24 comments

Build your own database

https://www.nan.fyi/database
420•nansdotio•11h ago•64 comments

Understanding conflict resolution and avoidance in PostgreSQL: a complete guide

https://www.pgedge.com/blog/living-on-the-edge
27•birdculture•1w ago•1 comments

Minds, brains, and programs (1980) [pdf]

https://home.csulb.edu/~cwallis/382/readings/482/searle.minds.brains.programs.bbs.1980.pdf
60•measurablefunc•1w ago•24 comments

60k kids have avoided peanut allergies due to 2015 advice, study finds

https://www.cbsnews.com/news/peanut-allergies-60000-kids-avoided-2015-advice/
307•zdw•1d ago•278 comments

Doomsday scoreboard

https://doomsday.march1studios.com/
191•diymaker•8h ago•87 comments

What do we do if SETI is successful?

https://www.universetoday.com/articles/what-do-we-do-if-seti-is-successful
131•leephillips•1d ago•214 comments

Foreign hackers breached a US nuclear weapons plant via SharePoint flaws

https://www.csoonline.com/article/4074962/foreign-hackers-breached-a-us-nuclear-weapons-plant-via...
339•zdw•12h ago•231 comments

The death of thread per core

https://buttondown.com/jaffray/archive/the-death-of-thread-per-core/
94•ibobev•1d ago•38 comments

Cdb: Add support for cdb64

https://cdb.cr.yp.to/download.html
75•kreco•4h ago•21 comments

Flexport Is Hiring SDRs in Chicago

https://job-boards.greenhouse.io/flexport/jobs/5690976?gh_jid=5690976
1•thedogeye•11h ago

Show HN: Katakate – Dozens of VMs per node for safe code exec

https://github.com/Katakate/k7
96•gbxk•13h ago•36 comments

Erowid - Documenting the Complex Relationship Between Humans and Psychoactives

https://www.erowid.org
27•slow_typist•7h ago•1 comments

KDE Connect: Enabling communication between all your devices

https://community.kde.org/KDEConnect
392•snthd•1w ago•160 comments

Diamond Thermal Conductivity: A New Era in Chip Cooling

https://spectrum.ieee.org/diamond-thermal-conductivity
178•rbanffy•17h ago•59 comments

Ilo – a Forth system running on UEFI

https://asciinema.org/a/Lbxa2w9R5IbaJqW3INqVrbX8E
108•rickcarlino•15h ago•42 comments