Lmst

Subtypes and status-dependent data: pure relational approach https://lobste.rs/s/5rjh8v #databases
https://minimalmodeling.substack.com/p/subtypes-and-status-dependent-data

Avi Chawla (@_avichawla)

Microsoft, Google, AWS 등 주요 사업자가 AI 에이전트용으로 엔터프라이즈 데이터 연결 문제를 해결하려는 논의. Postgres, Snowflake, MongoDB, Gmail 등 여러 데이터 소스가 흩어져 있어 에이전트를 기존 툴을 이어붙이지 않고 통합하는 방법이 핵심 과제로 제기됨.

https://x.com/_avichawla/status/2017123456429805835

#ai #agents #enterprise #dataintegration #databases

Litestream Writable VFS https://lobste.rs/s/lrlmqz #databases
https://fly.io/blog/litestream-writable-vfs/

https://medium.com/@jeannetteaustin261/where-to-find-your-ancestors-online-genealogy-records-in-georgia-other-states-996049fdbf00 #georgiapioneers #familytree #genealogy #research #databases

Mission accomplished: Exam #Databases graded! This year's results were good: 130 out of 173 students passed the course: 75%. Lowest grade: 1.7; Highest grade: 9.8

Toddler showing their fist with the text: "When you get an A+: I accomplished something"

What if most transactions never needed retries at all? @FranckPachot shows how #MongoDB’s single-document atomic updates eliminate deadlocks completely—even under high load.

See the #SpringData example: https://javapro.io/2025/12/18/no-deadlocks-in-mongodb-atomic-documents-and-retries-with-spring-data-mongodb/

@MongoDB #SQL #Databases #Java #Performance

Bf-Tree A Modern Concurrent Larger-Than-Memory Range Index https://lobste.rs/s/651hoq #compsci #databases #rust
https://github.com/microsoft/bf-tree/

Isolation & Permissiveness of Distributed Transactions in MongoDB https://lobste.rs/s/6laiec #databases #distributed #formalmethods
https://www.mongodb.com/company/blog/engineering/formal-methods-beyond-correctness-isolation-permissiveness-distributed-transactions

WillSearch – GuardianDB. A peer-to-peer database for the Decentralized Web https://lobste.rs/s/bsgccc #databases #networking
https://www.willsearch.com.br/

Unlocking Accessible Research: Tools for Every Writer

Modern research tools have evolved to be accessible and supportive for neurodivergent and disabled writers. Libraries offer free resources and expert assistance, while online databases provide valuable academic articles. Tools like Google Scholar, Zotero, and Notion streamline the research process, making it less overwhelming. Focus on simplicity to enhance creativity.

https://dreamspacestudio.net/unlocking-accessible-research-tools-for-every-writer/

What really changes at 100TB+? 🤯

Teresa Lopes shares hard-won lessons from running massive PostgreSQL databases at Adyen—covering backups, HA, vacuum, and performance when “best practices” stop working. https://lnkd.in/d_QD95ZG

#PostgreSQL #P2D2 #PGScale #Databases

Dozens of #CDC #Health #Databases Have Gone Dark Under Trump: ‘The Consequences Will Be Dire’
Nearly half of routinely-updated CDC databases have experienced delays or shutdowns in #2025, with vaccination-related systems disproportionately affected, according to a new study. The breakdown is creating critical gaps in public health according to a study published on Monday in Annals of Internal Medicine.
https://www.404media.co/dozens-of-cdc-health-databases-have-gone-dark-under-trump-the-consequences-will-be-dire/
https://archive.ph/g6YNS

Do you really need Kafka for every queue? 🤔

Alexander Kukushkin revisits PgQ, PostgreSQL’s lock-free, high-performance queue, and why SKIP LOCKED falls apart under load. https://lnkd.in/dSrpHGmJ

#PostgreSQL #PgQ #P2D2 #EventDriven #Databases

Leaked Memo Exposes How DHS Is Building a Database on Protesters

Federal immigration agents are being told to collect as much personal data about anti-ICE protesters as they can.

https://newrepublic.com/post/205779/leaked-memo-department-homeland-security-database-protesters

#Republicans #MAGA #GOP #Trump #ICE #databases #protests #privacy #violations #Nazis #SS #press

Docker for React.js developers https://leanpub.com/docker-reactjs by Kristiyan Velkov is the featured book on the Leanpub homepage! https://leanpub.com #Docker #Aws #Kubernetes #React #NodeJs #Typescript #Javascript #Databases #Apis #AmazonWebServices

The "It Works on My Machine" Excuse Ends Today. Understand Docker. Ship with Confidence. Own Production.

SQL doesn’t run by magic. Your query travels through the network layer, gets parsed, optimized, executed, and finally hits storage with locks, buffers, and transactions managing every step. Knowing this makes you a faster, smarter analyst.

📕 https://ebokify.com/sql

#SQL #Databases #QueryOptimization #DataEngineering #BackendSystems #BigData #TechSkills

spreadsheets + vi + json https://lobste.rs/s/sbtjef #show #databases
https://awalgarg.me/untitled_project

TIL #PostgreSQL 16 and above has a level above the SUPERUSER role: the “bootstrap superuser,” from whom you cannot revoke SUPERUSER privileges: https://www.postgresql.org/docs/18/glossary.html#GLOSSARY-BOOTSTRAP-SUPERUSER

And since internal components may still refer to it by name or expect it to be present, you can’t effectively rename it.

So if you create a #database cluster and decide to name that first user after the application for which you're originally using PostgreSQL, you’re stuck with that name for the life of the cluster. You may think you’re keeping things simple at the time, but you’re setting yourself (and others) up for confusion later.

Better to just initialize the cluster with the default superuser name of `postgres`, and then create an app-specific user with lower privileges.

#DevOps #PlatfformEngineering #databases #SQL #Postgres