frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

Open in hackernews

Postgres sequences can commit out-of-order

https://blog.sequinstream.com/postgres-sequences-can-commit-out-of-order/
4•dagss•2mo ago

Comments

dagss•2mo ago
This details an approach to working with commit-ordered event IDs which is a very powerful primitive to, e.g., do pub/sub event processing within a SQL database without having to deal with outbox patterns, event brokers and so on.

People throw Kafka or Event Hub at everything, but really, if you do not need to offload your DB for storage/access of massive amounts of events, you may not need them...

I have a lot of experience with this approach on MS SQL (https://github.com/vippsas/mssql-changefeed), interesting to see the same thing on postgres.

Hope databases gets these things built in (i.e., supported more directly) in the future.

dagss•2mo ago
I wonder if this is a bug:

   -- If no locks are found, return the maximum possible bigint value
    if max_seq is null then
        return 9223372036854775807;
    end if;
Would be a race here by returning a big number to the caller, then more data is written in between? Should instead check the current max sequence number before checking the locks?

SQLite per User Database Creation with Turso [video]

https://www.youtube.com/watch?v=AtZiAU9-A5A
1•thunderbong•2m ago•0 comments

France and Switzerland shut down nuclear power plants amid scorching heatwave

https://www.euronews.com/2025/07/02/france-and-switzerland-shut-down-nuclear-power-plants-amid-scorching-heatwave
1•toomuchtodo•4m ago•0 comments

Dialects for Humans: Sounding Distinct from LLMs

https://www.lesswrong.com/posts/yRoXmjBKJFbc6zSFq/dialects-for-humans-sounding-distinct-from-llms
1•nebrelbug•6m ago•1 comments

Conventions for Extensible System Calls(2020)

https://lwn.net/Articles/830666/
1•howtofly•6m ago•0 comments

The deception that we crave

https://billmei.net/blog/love-reinforcement-learning
1•Kortaggio•10m ago•0 comments

The Salvadoran beach town that became a Bitcoin testbed

https://www.bbc.com/travel/article/20250625-the-beach-town-that-became-a-bitcoin-testbed
1•rmason•12m ago•0 comments

How fast is it really? Latency, measurement and optimization in trading systems

https://www.architect.co/posts/how-fast-is-it-really
1•sneakerblack•18m ago•0 comments

Hacker News vs. Claude Code

https://www.youtube.com/watch?v=FDyDb4sX30w
1•pj4533•18m ago•1 comments

LLMs as Compilers

https://resync-games.com/blog/engineering/llms-as-compiler
1•kadhirvelm•18m ago•0 comments

Show HN: I made a Chrome extension to export web element to code

https://copyui.online
1•Graxi•21m ago•0 comments

2025 Njpls – Revisiting the D Language – My 2^x Programming Language[Ep. 133]

https://www.youtube.com/watch?v=PJf0etigg7o
1•MikeShah•24m ago•1 comments

Stacked Clock (2014)

https://www.danieldjohnson.com/2014/06/30/stacked-clock/
1•wonger_•28m ago•0 comments

Parallel-in-Time Preconditioning for Time-Dependent Variational Mean Field Games

https://arxiv.org/abs/2507.01958
1•badmonster•33m ago•0 comments

Show HN: Bubble UI] – open-source LLM UI"

https://github.com/KenoLeon/BubbleUI
1•k3no•35m ago•0 comments

The Uncertain Future of Coding Careers and Why I'm Still Hopeful

https://jonmagic.com/posts/the-uncertain-future-of-coding-careers-and-why-im-still-hopeful/
2•mooreds•38m ago•0 comments

Gaza: Doctors Under Attack review – this crucial film is the stuff of nightmares

https://www.theguardian.com/tv-and-radio/2025/jul/03/gaza-doctors-under-attack-review-channel-4-crucial-film-stuff-of-nightmares
13•NomDePlum•42m ago•0 comments

Poudriere Inside FreeBSD VNET Jail

https://vermaden.wordpress.com/2025/07/03/poudriere-inside-freebsd-vnet-jail/
2•vermaden•49m ago•0 comments

Agentic Coding Tools – Not Skynet, Not a Stochastic Parrot

https://www.brethorsting.com/blog/2025/07/agentic-coding-tools-not-skynet,-not-a-stochastic-parrot/
1•aaronbrethorst•56m ago•0 comments

Listen to Rfc2119

https://ericwbailey.website/published/you-must-listen-to-rfc-2119/
1•bluGill•57m ago•1 comments

Armin Ronacher on Agentic Coding

https://www.youtube.com/watch?v=nfOVgz_omlU
1•paulsutter•1h ago•0 comments

Super Simple "Hallucination Traps" to detect interview cheaters

4•EliotHerbst•1h ago•0 comments

A customizable and extensible all-purpose diagrams library for Blazor

https://github.com/Blazor-Diagrams/Blazor.Diagrams
1•mountainview•1h ago•1 comments

Coinbase Acquires LiquiFi

https://www.coinbase.com/es-la/blog/Coinbase-acquires-LiquiFi-the-leading-token-management-platform
1•wslh•1h ago•0 comments

Trans-Taiga Road:The farthest you can get from a town on a road in North America

https://www.jamesbayroad.com/ttr/index.html
5•jason_pomerleau•1h ago•0 comments

Checklist Genie App – Last Call for Beta Testers

https://checklistgenie.app
1•alohaplannerapp•1h ago•0 comments

Show HN: I created a privacy respecting ad blocker for apps

https://www.magiclasso.co/insights/app-ad-blocking/
2•bentocorp•1h ago•0 comments

An Analysis of Links from the White House's "Wire" Website

https://blog.jim-nielsen.com/2025/links-from-whgov-wire/
2•OuterVale•1h ago•0 comments

Why are my Product Hunt upvotes delayed

https://www.ceresai.xyz/
1•Mahsanziak9•1h ago•2 comments

Qualcomm's Centriq 2400 and the Falkor Architecture

https://chipsandcheese.com/p/qualcomms-centriq-2400-and-the-falkor
1•brian_herman•1h ago•0 comments

Bridging Shopify and Shipstation on Heroku: A Story of Custom Fulfillment

https://kevinhq.com/shopify-shipstation-heroku-integration/
1•kevinhq•1h ago•0 comments