frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Show HN: Shoptimist – Amazon but Curated

https://shoptimist.co/
1•MisterJoe•32s ago•0 comments

Show HN: Gami.Fied – Self-hosted gamification engine (XP, streaks, leaderboards)

https://github.com/gami-fied/gami.fied
1•ronak0020•2m ago•0 comments

Who ChatGPT and Gemini name: 83 small businesses, 498 answers

https://buyersaskai.com/small-businesses-in-chatgpt-and-gemini
1•berkoheko•2m ago•0 comments

'Tax the Rich' Policies Need a Clear Economic Vision for Fairness

https://news.bloombergtax.com/tax-insights-and-commentary/tax-the-rich-policies-need-a-clear-econ...
1•tldrthelaw•3m ago•0 comments

Show HN: Elak – helps you buy/lease/finance a car with better negotiation

https://elak.app
1•abbosmuy•3m ago•0 comments

Show HN: Parser – Turn invoices, scans and long PDFs into JSON or Excel

https://parserai.co/
1•guilhermemichel•4m ago•0 comments

Lawyers for man accused of bugging OpenAI say there's no evidence he's a spy

https://www.washingtonpost.com/technology/2026/11/16/saudi-man-accused-spying-openai-alleges-he-b...
1•nephihaha•5m ago•0 comments

Microsoft Purged 126 Blank VS Code Extensions as Malware

https://apiiro.com/blog/blank-canvas
1•shmulc•5m ago•0 comments

Dealing with AI Depression and Meaninglessness [video]

https://www.youtube.com/watch?v=oycBOHeu760
1•marvinborner•7m ago•0 comments

California sues OpenAI over hacking risks

https://www.npr.org/2026/11/16/nx-s1-6042920/california-sues-openai-hugging-face-hacking-incident
1•pseudolus•7m ago•0 comments

Green Threads for Node.js

http://www.jasnell.me/posts/green-threads-in-node
1•mariuz•13m ago•0 comments

An 8-bit CPU designed from scratch using mostly 74xx ICs in Logisim Evolution

https://github.com/hoetzenofer/Limbo-8
1•hoetzenofer•14m ago•0 comments

Regulatory Capture by Anthropic Through METR

https://nitter.cf/kevinnbass/status/2099621874279817638
3•agnosticmantis•17m ago•0 comments

Show HN: Aquasand – A pixel-art aquarium everyone shares, with 346 real species

https://aquasand.ru/en
1•valdiszhvaginsh•18m ago•0 comments

Stop using encrypted email (2020)

https://www.latacora.com/blog/2020/02/19/stop-using-encrypted-email/
2•stared•18m ago•0 comments

Inverlair Lodge

http://secretscotland.org.uk/index.php/Secrets/InverlairLodge
1•bryanrasmussen•19m ago•0 comments

Police Raid on Nvidia Partner Megaspeed Finds Empty Frames and Missing GPUs

https://respawnfirst.com/they-never-even-unpacked-the-racks-police-raid-on-nvidia-partner-megaspe...
3•windexh8er•19m ago•0 comments

I'm a human doctor with human intelligence. But I sure do like my AI notetaker

https://www.npr.org/2026/11/17/nx-s1-6037556/medicine-ai-doctor-notetaker-scribe
1•colinprince•20m ago•0 comments

Making Art with QR Codes, and the Fine Line Between Inspiration and Idea Theft

https://www.gorillasun.de/blog/making-art-with-qr-codes-and-the-fine-line-between-inspiration-and...
1•gorillasun•20m ago•0 comments

Show HN: AI Data Brokerage

https://mainstreetwealth.ai/ai-data-brokerage
5•novateg•20m ago•0 comments

Make your LLM accept only signed prompts

https://discounttimu.substack.com/p/make-your-llm-only-accept-signed
2•guardiangod•20m ago•1 comments

Live ranking CVEs based on vibes, not CVSS

https://cves.io/
1•patrikgrobs•20m ago•0 comments

Show HN: CofreAdmin Wallet – Self-Custodial Web3 Personal Finance

https://github.com/cofreadminwallet/app
1•erissonmarques•21m ago•0 comments

Can Solar Murals Make Clean Energy More Attractive?

https://triplepundit.com/2026/solar-murals-artwork-renewable-energy-aesthetics/
1•rdmuser•21m ago•0 comments

Laptop/Phone can hear you without a mic. Proof

https://twitter.com/whyvanamali/status/2122276417031585879
1•mrkn1•23m ago•0 comments

We Logged 183,291 MCP and A2A Requests. Only 2.2% Were Task-Shaped

https://wagerx.io/news/agentic-web-observatory-november-17-2026
1•wagerx•23m ago•0 comments

Framefields v3

https://framefields.dev/v3/
2•oknaslnkn•23m ago•0 comments

California sues OpenAI over safety concerns after rogue agent hacking

https://www.theguardian.com/technology/2026/nov/16/california-openai-rogue-agent-hacking-lawsuit
2•richardbarosky•25m ago•0 comments

Modern LLMs hate Python the most

https://blog.jetbrains.com/ai/2026/11/ai-models-hate-python-and-love-php-we-asked-12-of-them-1-20...
1•neuraldenis•27m ago•0 comments

Amazon Eyes 20k Pairs of Smart Glasses for Delivery Drivers by 2027

https://wwd.com/sourcing-journal/logistics/amazon-smart-glasses-delivery-riders-privacy-1239404883/
1•bookofjoe•28m ago•1 comments
Open in hackernews

Decomposing Transactional Systems

https://transactional.blog/blog/2025-decomposing-transactional-systems
132•pongogogo•1y ago

Comments

karmakaze•1y ago
> commit version is chosen — the time at which the database claims all reads and writes occurred atomically.

This post doesn't mention transaction isolation specifically though it does say "How does this end up being equal to SERIALIZABLE MySQL?" So maybe I'm supposed to consider this post only for 'Every transactional system' running with SERIALIZABLE transaction isolation. I don't particularly care about that. I do care that the database I use clearly states what its isolation names mean in detail and that it does exactly what it says. e.g. I don't expect MySQL SERIALIZABLE to exactly mean the same as any other database that uses the same term.

mjb•1y ago
MySQL Serializable is pretty similar to serializable in other databases, in terms of the observable anomalies. There's a good set of tests here: https://github.com/ept/hermitage

> So maybe I'm supposed to consider this post only for 'Every transactional system' running with SERIALIZABLE transaction isolation.

No, it's a general point about the nature of transactions in DBMSs, and the different implementation choices. As the article says, there are some variations (e.g. MVCC at levels lower than serializable inherently has two 'order' steps).

karmakaze•1y ago
I'm not seeing the mention of two 'order' steps. Are you referring to the larger part of what I quoted?

> MVCC databases may assign two versions: an initial read version, and a final commit version. In this case, we’re mainly focused on the specific point at which the commit version is chosen — the time at which the database claims all reads and writes occurred atomically.

For non-SERIALIZABLE isolation there may be no such "time at which the database claims all reads and writes occurred atomically", which is how I took the rest of the post to mean when running with SERIALIZABLE isolation.

transactional•1y ago
(Hi! Post author here.)

It is written with a lean towards serializable, partly because there's a wide variety of easy examples to pull which all implement serializable, but the ideas mostly extend to non-serializable as well. Non-serializable but still MVCC will also place all of their writes as having happened at a single commit timestamp, they just don't try to serialize the reads there, and that's fine. When looking at non-serializable not MVCC databases, it's still useful to just try to answer how the system does each of the four parts in isolation. Maybe I should have been more direct that you're welcome to bend/break the mental model in whatever ways are helpful to understand some database.

The line specifically about MySQL running at serializable was because it was in the Spanner section, and Spanner is a (strictly) serializable database.

karmakaze•1y ago
Thanks for the clarifications and diagrams. I can see how using something like Spanner from the outset makes sense to use and stick with serializable isolation. With other SQL dbs, I've mostly seen repeatable read, read committed, and even read uncommitted used in the name of performance. Read committed works fine but you have to design everything for it from the start with thoughtful write and read sequences.

Moving to serializable should be easy but isn't in the case of Spanner and the like because you can't make 100+ of sub-millisecond queries to respond to an API request if that's how your app evolved.

The way I imagine the future is to bring the code closer to the data like stored procedures, but maybe in a new way like modern languages compiled to run (and if necessary retry) in a shard of the database.

mjb•1y ago
This is great, really worth reading if you're interested in transactions.

I liked it so much I wrote up how the model applies to Amazon Aurora DSQL at https://brooker.co.za/blog/2025/04/17/decomposing.html It's interesting because of DSQL's distributed nature, and the decoupling between durability and application to storage in our architecture.

maniacalhack0r•1y ago
DSQL is so cool - have been following since the release and once it supports more of the postgres feature set + extensions it’ll be a killer. Fantastic architecture deep dive at ReInvent as well.
pongogogo•1y ago
Hey Mark, I actually found this post via yours so thanks!