I recently had a use case at work (a LiteStar app) where I needed to write to two linked tables (see below) in a transaction in our PostgreSQL database.

Wednesday 22nd October 2025—Crossref, the open scholarly infrastructure nonprofit, today releases an enhanced dashboard showing metadata coverage and individual organisations’ contributions to documenting the process and outputs of scientific research in the open.

por María Paula Corredor Acosta ¿Podría una receta cambiar el destino del mundo conocido? En el siglo XVIII, la preparación de un alimento naval podría cambiar el curso de los imperios… Era 1789 y el comandante de la expedición española al Pacífico, Alejandro Malaspina, comisionó a Claudio Chambovet para preparar una receta de cebada fermentada.

tl;dr: People’s motivations to engage with online citizen science are complex and change over time Apparently, last week iNaturalist released a blog post, demoing their mock-up of how they envision using LLMs to process user-contributed wildlife observation data.

Appalachian History A feud comes to the railroad On an April morning in 1921, a long running mountain feud flared beside the tracks at Heidrick in Knox County, Kentucky. Businessman Beverly P. White stepped off the train that had carried him back from Manchester and walked toward the small restaurant at the Cumberland and Manchester Railroad stop. John Bailey, a member of a rival family clan, shot him multiple times.

This month, a quiet yet momentous event occurred in DataCite infrastructure: the registration of our 100 millionth DOI.  100 million is a huge number. And it says a lot about global adoption of DataCite and the scale of our community and infrastructure.  But the bigger story behind this exciting headline is about what this number represents. So we are marking the milestone with a few reflections about its broader significance.

With this blog post, the science blog archive Rogue Scholar starts the formal process to adhere to the Principles of Open Scholarly Infrastructure (POSI). To do so, an organization has to perform a self-audit of its compliance with the principles, with a focus on principles and not hard rules. POSI was updated to version 2.0 this October, with the changes marked up in a separate document.

Back at the start of October I posted Necks: the lying liars that just keep lying, which included Coy Pearson’s beautiful photo of a Cooper’s hawk from behind, with its neck twisted a full 180 degrees to look at the camera.

Nihon, noted

Polyhedral optimization is a tool used in compilers for optimizing loop nests. While the major compilers that use this implement polyhedral optimizations from scratch,1 there is a generally-applicable open source C library called the Integer Set Library (ISL) that implements the core algorithms used in polyhedral optimization.

Also call for Sponsors!