med-mastodon.com is one of the many independent Mastodon servers you can use to participate in the fediverse.
Medical community on Mastodon

Administered by:

Server stats:

314
active users

#PostgreSQL

13 posts8 participants2 posts today

#PostgreSQL writes to disk, it executes one of the system fsync calls (fsync or fdatasync) to flush that data to disk. By
default, the cache on hard disks and disk controllers are assumed to be
volatile: when power fails, data written there will be lost. Since that
can result in filesystem and/or database corruption when it happens,
fsync in Linux issues a write barrier that forces all data onto physical
disk. That will flush the write cache on both RAID and drive write
caches.
#syscalls
avidandrew.com/understanding-d

avidandrew.comUnderstanding Disk Caches, The Journal, Barriers, and Writeback Using QEMU/KVM and EXT4 - Avid AndrewThere are multiple layers of caching involved when writing a file before it makes it to permanent storage on your disk. This becomes even more complicated with a virtual machine which has its own set of caches. Let's explore how exactly writes make it safely to your disk, both on a physical server and a VM.

When building CRUD apps with capability for partial updates in #Go & #PostgreSQL with #sqlc , how do you tell the difference between "field omitted" and "field was set explicitly to zero-value"?

Go pointers solve that issue but carrying it all the way to the database requires bridging three type systems.

I explored reflection, generics, and code generation as possible solutions.

Here's the write-up:
laelapa.dev/blog/001-the-three

---

Replies to this thread show up in the article's comment section.

laelapa.devLaelapa - Demetrius PapasPersonal website, portfolio & blog of Demetrius Papas - Software Developer specializing in APIs, services and back-end development with Go

Don’t miss the finals of the PGConf.EU chess tournament! ♟️🏆
After three hard-won rounds to reach the semis, today’s finalists are battling it out — with one contender already holding 10 wins!

Come watch the strategy unfold — it’s not just databases that require smart moves. 😉

🇱🇻 We continue celebrating Latvia’s incredible contributions to computer science.

Andris Ambainis, born in Daugavpils, is one of the leading minds in quantum computing — shaping how we think about algorithms and complexity in the quantum era.

His research reminds us that innovation in computing never stops evolving — much like PostgreSQL itself. 🐘💡
#PGConfEU #PostgreSQL #Riga #ComputerScience #OpenSource

Continued thread

🇱🇻 Did you know our PGConf.EU Slonik has a new look?
This year, he’ll be wearing a Lielvārdes josta — a traditional Latvian woven belt symbolising strength and heritage.

The design, created by local artist Megija Baumane, inspired both our conference logo and visuals.

Share your feedback during the conference for a chance to win Slonik’s belt — the winner will be announced at the closing ceremony!
#PGConfEU #PostgreSQL #Latvia #Community