The Consensus

Software infrastructure company of the week: @niledatabase. They're hiring!

Kumar Ujjawal gives us a look at the code and behavior of type coercion in SQLite, or the lack thereof, and how it contrasts with other databases like DuckDB. (paywall has expired, give it a read!)

Kosta just got his first job working at a database company on a Rust database product. 🎉

Whatever your transactional database is, help me understand your use of it. This survey is run by @theconsensusdev, independent of any database or vendor. RT or pass along to industry peers for broader representation forms.gle/fqjQsezWsztxvY…

The Consensus Weekly is out, free to read as always, which features interesting internships, job openings, and funding news in software infrastructure, as well as systems developers looking for work. Up first are all new internships this past week.

I wrote about transaction isolation levels and checking them with Hermitage. A lot has changed in a decade. MariaDB has made progress toward standard definitions of transaction isolation, though it has some outstanding bug reports from Jepsen and Percona. (paywall has expired)

Kumar Ujjawal, Apache DataFusion committer and Turso contributor, takes us behind the scenes to understand affinity and type coercion in SQLite, which differs in this regard from how many other major SQL databases work, in a new article for The Consensus.

Donate $30 to an educational non-profit or open-source project and I'll credit you $30 toward The Consensus Standard subscription. I'm excited to support these organizations with you!

The Consensus Weekly went out yesterday which features internships, interesting jobs in software engineering, and funding news in software infrastructure. Here are all new tracked internships at Replit, Atomic Semi, SiFive, etc. No subscription needed, go do interesting things!

Here is Monastery running against MySQL 9.7 and a script to try to trigger Dirty Writes (which MySQL won't allow). Use Monastery to script concurrent transactions on any SQL database. Currently plugins for PostgreSQL, MySQL, and MariaDB. github.com/theconsensusla…

Martin Kleppmann's Hermitage project categorizes the behavior of transaction isolation levels in major SQL databases, but many results haven't been updated in over a decade. And MariaDB has diverged significantly from MySQL in behavior since then. Let's see what's changed!

We just raised $30M at a $500M valuation, bringing our total funding to $47M. Led by @craft_ventures , with @PaceCap , @chemistry , TruArrow, and others. But before anything else: this belongs to the community. ComfyUI started as one developer and one open-source repo. No roadmap. No company. Just creators who wanted real control over how they built with AI. That community is now: → 4 million users → 60,000+ community-built nodes → 150,000+ daily downloads Every number traces back to people who built in the open, for anyone to use. Here's where the funding goes: → Comfy Cloud: for teams and studios that need security and scale → Collaborative workflows: versioning and iteration built for how studios actually work → A better local experience: more seamless, more stable → Ecosystem reliability: making 60,000+ community nodes more dependable → Day-one model support: every major release, compatible at launch We are not building a walled garden. We are building open infrastructure, built to last. Thank you genuinely, The ComfyUI Team

Sereact has raised $110M in Series B funding. Cortex 2 is live. We're opening our first US office in Boston. 200+ systems. 1B+ real picks. 1 intervention per 53,000. sereact.ai/posts/series-b

Today, True Anomaly announced its $650 million Series D fundraise. All of it invested in one mission: space superiority. We are building autonomous spacecraft, advanced payloads, mission software, and now, space-based interceptors. All designed from the ground up for contested space, at the speed and scale the moment demands. Thank you to our investors, customers, partners, and employees. Read more on our blog: trueanomaly.space/newsroom/our-s…

OpenObserve just raised $10M and launched Observability 3.0. AI SRE, anomaly detection, and LLM observability in one platform. No more fragmented tools or data tradeoffs. Read what we’re building toward 👇 na2.hubs.ly/H059zMQ0

Introducing Ineffable Intelligence. Led by David Silver, we're assembling the best engineers and researchers in the world to make first contact with superintelligence. We’ll be solving the hardest problems in AI on the way. Come join us. ineffable.ai

I chatted with Branimir Lambov from IBM on a decade of contributing to Cassandra, including his recent work to replace the Skiplist in Cassandra's LSM tree with a Trie.