Gülçin Yıldırım J.
@apatheticmagpie.bsky.social
Postgres, books and more.
“For most of history, anonymous was a woman.”
“For most of history, anonymous was a woman.”
Pinned
Reposted by Gülçin Yıldırım J.
pgstream v1.0.0 is out, with a major architectural change.
Schema changes are now emitted directly into WAL as logical messages, without schema logs or stored schema state.
If you work with Postgres CDC, this might be interesting.
Details in the blog 👇
xata.io/blog/pgstrea...
Schema changes are now emitted directly into WAL as logical messages, without schema logs or stored schema state.
If you work with Postgres CDC, this might be interesting.
Details in the blog 👇
xata.io/blog/pgstrea...
pgstream v1.0.0: Stateless schema change replication by Esther Minano Sanz
A major architectural milestone that removes schema logs and simplifies how pgstream captures and replicates Postgres schema changes
xata.io
February 4, 2026 at 4:00 PM
pgstream v1.0.0 is out, with a major architectural change.
Schema changes are now emitted directly into WAL as logical messages, without schema logs or stored schema state.
If you work with Postgres CDC, this might be interesting.
Details in the blog 👇
xata.io/blog/pgstrea...
Schema changes are now emitted directly into WAL as logical messages, without schema logs or stored schema state.
If you work with Postgres CDC, this might be interesting.
Details in the blog 👇
xata.io/blog/pgstrea...
My contribution to the 2016 trend 😄 Apparently the first time I attended #P2D2 was 10 years ago. Over the years I worked at 2ndQuadrant, EDB and now @xata.io. Some things didn’t change: still talking about Postgres, helping organize, womanning booths and having fun 🤩
Pics: today, 2019, 2018, 2016 🐘
Pics: today, 2019, 2018, 2016 🐘
January 27, 2026 at 2:34 PM
Voting for @pg-data.bsky.social talks this weekend 🗳️
So many wonderful proposals, thanks everyone who submitted!
So many wonderful proposals, thanks everyone who submitted!
a man in a suit and tie is looking out a window .
ALT: a man in a suit and tie is looking out a window .
media.tenor.com
January 18, 2026 at 11:48 AM
Voting for @pg-data.bsky.social talks this weekend 🗳️
So many wonderful proposals, thanks everyone who submitted!
So many wonderful proposals, thanks everyone who submitted!
Decided to walk Camino Francés route of Camino de Santiago this October with a feminist group of women. I am so excited!
January 17, 2026 at 8:16 PM
Decided to walk Camino Francés route of Camino de Santiago this October with a feminist group of women. I am so excited!
@divyendusingh.com is doing a great job making agents do all sorts of stuff using databases. In our case with a few simple instructions, they are able to do branching operations, run queries, validate bug fixes and more.
The blog posts are paired with demo videos, have a look 👀 👇🏽
The blog posts are paired with demo videos, have a look 👀 👇🏽
AI agents get useful faster with guardrails, not plugins.
Repo playbook: gh issue → xata branch create + xata branch wait-ready → xata branch url (not $DATABASE_URL) → psql repro/verify → fix.
Video + write-up:
Repo playbook: gh issue → xata branch create + xata branch wait-ready → xata branch url (not $DATABASE_URL) → psql repro/verify → fix.
Video + write-up:
Database branching in the age of AI: One markdown file is all you need by Divyendu Singh
Learn how to enable database branching for coding agents like Claude Code and Amp Code using simple Xata CLI instructions in AGENTS.md. No complex skills required.
xata.io
January 14, 2026 at 1:41 PM
@divyendusingh.com is doing a great job making agents do all sorts of stuff using databases. In our case with a few simple instructions, they are able to do branching operations, run queries, validate bug fixes and more.
The blog posts are paired with demo videos, have a look 👀 👇🏽
The blog posts are paired with demo videos, have a look 👀 👇🏽
Taking database snapshots and moving large volumes of data over the network is something our customers do regularly. While batching is the de facto way to make this efficient choosing the right batch size is non-trivial considering network variability, latency & system load.
Read how we solved it👇🏽
Read how we solved it👇🏽
Batching is often used to process large volumes of data but a batch size that works in one network setup can perform poorly in another.
We applied automatic batch size tuning to Postgres snapshots in pgstream to adapt across different network environments.
Check the post 👇
xata.io/blog/postgre...
We applied automatic batch size tuning to Postgres snapshots in pgstream to adapt across different network environments.
Check the post 👇
xata.io/blog/postgre...
Optimizing data throughput for Postgres snapshots with batch size auto-tuning by Esther Minano Sanz
Why static batch size configuration breaks down in real world networks and how automatic batch size tuning improves snapshot throughput.
xata.io
January 12, 2026 at 3:18 PM
Taking database snapshots and moving large volumes of data over the network is something our customers do regularly. While batching is the de facto way to make this efficient choosing the right batch size is non-trivial considering network variability, latency & system load.
Read how we solved it👇🏽
Read how we solved it👇🏽
Reposted by Gülçin Yıldırım J.
If you want to understand how constraint enforcement works internally, @apatheticmagpie.bsky.social breaks it down beautifully in her latest blog:
👉 xata.io/blog/constra...
👉 xata.io/blog/constra...
What you should know about constraints in PostgreSQL | xata.io by Gulcin Yildirim Jelinek
In this blog, we explore Postgres constraints through the pg_constraint catalog, covering table vs. column constraints, constraint triggers, domains and more.
xata.io
January 8, 2026 at 1:43 PM
If you want to understand how constraint enforcement works internally, @apatheticmagpie.bsky.social breaks it down beautifully in her latest blog:
👉 xata.io/blog/constra...
👉 xata.io/blog/constra...
Reposted by Gülçin Yıldırım J.
PostgreSQL stores *all* constraints: check, not-null, PK, FK, unique, exclusion and domain constraints as rows in `pg_constraint` catalog.
In Postgres 18, even NOT NULL constraints now get their own entries here (before 18 they lived in `pg_attribute`!).
In Postgres 18, even NOT NULL constraints now get their own entries here (before 18 they lived in `pg_attribute`!).
January 8, 2026 at 1:43 PM
PostgreSQL stores *all* constraints: check, not-null, PK, FK, unique, exclusion and domain constraints as rows in `pg_constraint` catalog.
In Postgres 18, even NOT NULL constraints now get their own entries here (before 18 they lived in `pg_attribute`!).
In Postgres 18, even NOT NULL constraints now get their own entries here (before 18 they lived in `pg_attribute`!).
“..it matters what stories we put in kids’ hands. Picture books that spotlight women in STEM help children expand their ideas about who scientists are, who they can be and where curiosity can lead.”
👇🏽 List of inspiring picture book biographies of women in STEM 📚
open.substack.com/pub/maistory...
👇🏽 List of inspiring picture book biographies of women in STEM 📚
open.substack.com/pub/maistory...
Break Gender Stereotypes with Picture Books ft. Women in STEM
While scrolling through social media, this graphic caught me eye.
open.substack.com
December 19, 2025 at 11:28 AM
“..it matters what stories we put in kids’ hands. Picture books that spotlight women in STEM help children expand their ideas about who scientists are, who they can be and where curiosity can lead.”
👇🏽 List of inspiring picture book biographies of women in STEM 📚
open.substack.com/pub/maistory...
👇🏽 List of inspiring picture book biographies of women in STEM 📚
open.substack.com/pub/maistory...
Little joys in life: Getting into Postgres Weekly with your blog 🎉
🔗 xata.io/blog/constra...
🐘 postgresweekly.com/issues/628
🔗 xata.io/blog/constra...
🐘 postgresweekly.com/issues/628
December 12, 2025 at 5:41 AM
Little joys in life: Getting into Postgres Weekly with your blog 🎉
🔗 xata.io/blog/constra...
🐘 postgresweekly.com/issues/628
🔗 xata.io/blog/constra...
🐘 postgresweekly.com/issues/628
Reposted by Gülçin Yıldırım J.
Postgres constraints are the rules that keep your data clean.
Types tell you *what* can be stored but constraints enforce *what must be true*.
If a row violates a rule, Postgres rejects it. No silent corruption.
A few well-chosen constraints prevent entire classes of bugs.
xata.io/blog/constra...
Types tell you *what* can be stored but constraints enforce *what must be true*.
If a row violates a rule, Postgres rejects it. No silent corruption.
A few well-chosen constraints prevent entire classes of bugs.
xata.io/blog/constra...
What you should know about constraints in PostgreSQL | xata.io by Gulcin Yildirim Jelinek
In this blog, we explore Postgres constraints through the pg_constraint catalog, covering table vs. column constraints, constraint triggers, domains and more.
xata.io
December 11, 2025 at 3:19 PM
Postgres constraints are the rules that keep your data clean.
Types tell you *what* can be stored but constraints enforce *what must be true*.
If a row violates a rule, Postgres rejects it. No silent corruption.
A few well-chosen constraints prevent entire classes of bugs.
xata.io/blog/constra...
Types tell you *what* can be stored but constraints enforce *what must be true*.
If a row violates a rule, Postgres rejects it. No silent corruption.
A few well-chosen constraints prevent entire classes of bugs.
xata.io/blog/constra...
I wrote about Postgres constraints and covered deferrability concept and a few not-so-well-known gems like constraint triggers and domains 💎
xata.io/blog/constra...
xata.io/blog/constra...
What you should know about constraints in PostgreSQL | xata.io by Gulcin Yildirim Jelinek
In this blog, we explore Postgres constraints through the pg_constraint catalog, covering table vs. column constraints, constraint triggers, domains and more.
xata.io
December 10, 2025 at 12:20 PM
I wrote about Postgres constraints and covered deferrability concept and a few not-so-well-known gems like constraint triggers and domains 💎
xata.io/blog/constra...
xata.io/blog/constra...
Reposted by Gülçin Yıldırım J.
Check out the full post here: xata.io/blog/a-codin...
Closing the loop: Building a coding agent that uses Postgres branches by Divyendu Singh
Explore how to build an AI coding agent that follows a full developer workflow, including creating Postgres branches, using a sandbox, fixing bugs, and raising pull requests with Xata, Vercel, and Git...
xata.io
December 8, 2025 at 1:48 PM
Check out the full post here: xata.io/blog/a-codin...
A few days ago my 6yo asked me to play a song from Stratovarius, I think I reached the parental peak. It is only downhill from now on 😅 I didn’t listen to them since college. Rediscovered a piece of my past thanks to my little genie. Now writing a Postgres blog to celebrate my new found joy 🤘🏽
December 8, 2025 at 11:06 AM
A few days ago my 6yo asked me to play a song from Stratovarius, I think I reached the parental peak. It is only downhill from now on 😅 I didn’t listen to them since college. Rediscovered a piece of my past thanks to my little genie. Now writing a Postgres blog to celebrate my new found joy 🤘🏽
I love the offsites we do twice a year at @xata.io ☀️Building stronger bonds with my colleagues while working on Xata’s roadmap feels quite amazing. I am grateful for this opportunity ☺️ 🇮🇹
xata.io/blog/club-xa...
xata.io/blog/club-xa...
The Villa Getaway: Club Xata Rome 2025 by Natalia Woroniec
Somewhere between a team retreat and a family holiday, our week in Rome was about connection, ideas, and joy of being in one place together. A reminder of what can happen when the whole team shares th...
xata.io
October 31, 2025 at 1:30 PM
I love the offsites we do twice a year at @xata.io ☀️Building stronger bonds with my colleagues while working on Xata’s roadmap feels quite amazing. I am grateful for this opportunity ☺️ 🇮🇹
xata.io/blog/club-xa...
xata.io/blog/club-xa...
The first day of PGConf.EU was a blast! 💥
I had the chance to co-organize two community summits: PostgreSQL on Kubernetes and Postgres & AI. Thanks to my co-organizers Floor Drees, Ellyne Phneah and Torsten Steinbach, I had a great time and all went amazingly!
I had the chance to co-organize two community summits: PostgreSQL on Kubernetes and Postgres & AI. Thanks to my co-organizers Floor Drees, Ellyne Phneah and Torsten Steinbach, I had a great time and all went amazingly!
October 21, 2025 at 8:23 PM
The first day of PGConf.EU was a blast! 💥
I had the chance to co-organize two community summits: PostgreSQL on Kubernetes and Postgres & AI. Thanks to my co-organizers Floor Drees, Ellyne Phneah and Torsten Steinbach, I had a great time and all went amazingly!
I had the chance to co-organize two community summits: PostgreSQL on Kubernetes and Postgres & AI. Thanks to my co-organizers Floor Drees, Ellyne Phneah and Torsten Steinbach, I had a great time and all went amazingly!
Reposted by Gülçin Yıldırım J.
Day 1 at #PGConfEU kicked off with Community Summits!
Our own Gülçin Yıldırım Jelínek is co-organizing two of them
☸️ PostgreSQL on Kubernetes Summit
🧠 PostgreSQL & AI Summit
Big thanks to the volunteers & speakers who made this happen.
Community is what makes Postgres great 💙
Our own Gülçin Yıldırım Jelínek is co-organizing two of them
☸️ PostgreSQL on Kubernetes Summit
🧠 PostgreSQL & AI Summit
Big thanks to the volunteers & speakers who made this happen.
Community is what makes Postgres great 💙
October 21, 2025 at 1:38 PM
Day 1 at #PGConfEU kicked off with Community Summits!
Our own Gülçin Yıldırım Jelínek is co-organizing two of them
☸️ PostgreSQL on Kubernetes Summit
🧠 PostgreSQL & AI Summit
Big thanks to the volunteers & speakers who made this happen.
Community is what makes Postgres great 💙
Our own Gülçin Yıldırım Jelínek is co-organizing two of them
☸️ PostgreSQL on Kubernetes Summit
🧠 PostgreSQL & AI Summit
Big thanks to the volunteers & speakers who made this happen.
Community is what makes Postgres great 💙
October 19, 2025 at 2:06 PM
Reposted by Gülçin Yıldırım J.
Then on the main track Esther Minano & Ahmet Gedemenli dive into anonymization and Gulcin on Postgres 18 constraints.
Get the schedule: www.postgresql.eu/events/pgcon...
Get the schedule: www.postgresql.eu/events/pgcon...
PGConf.EU 2025 Schedule
PGConf.EU 2025 Schedule
www.postgresql.eu
October 17, 2025 at 3:38 PM
Then on the main track Esther Minano & Ahmet Gedemenli dive into anonymization and Gulcin on Postgres 18 constraints.
Get the schedule: www.postgresql.eu/events/pgcon...
Get the schedule: www.postgresql.eu/events/pgcon...
Reposted by Gülçin Yıldırım J.
The countdown to #PGConfEU is on ⏳
On Oct 21, @apatheticmagpie is co-hosting two community summits:
🧠 PostgreSQL & AI with Gulcin on DB Agents
☸️ PostgreSQL on Kubernetes with Esther Minano & Andrew Farries
On Oct 21, @apatheticmagpie is co-hosting two community summits:
🧠 PostgreSQL & AI with Gulcin on DB Agents
☸️ PostgreSQL on Kubernetes with Esther Minano & Andrew Farries
PGConf.EU 2025 Schedule
PGConf.EU 2025 Schedule
www.postgresql.eu
October 17, 2025 at 3:38 PM
The countdown to #PGConfEU is on ⏳
On Oct 21, @apatheticmagpie is co-hosting two community summits:
🧠 PostgreSQL & AI with Gulcin on DB Agents
☸️ PostgreSQL on Kubernetes with Esther Minano & Andrew Farries
On Oct 21, @apatheticmagpie is co-hosting two community summits:
🧠 PostgreSQL & AI with Gulcin on DB Agents
☸️ PostgreSQL on Kubernetes with Esther Minano & Andrew Farries
What is your current song fixation? 🍂
Wherever I went I always knew, always knew
Till I didn't know
Why do I do this to myself every time?
I know the way it ends before it's even begun
I am the only one at the finish line
open.spotify.com/track/3qJImz...
Wherever I went I always knew, always knew
Till I didn't know
Why do I do this to myself every time?
I know the way it ends before it's even begun
I am the only one at the finish line
open.spotify.com/track/3qJImz...
Fireworks
open.spotify.com
October 13, 2025 at 12:50 PM
What is your current song fixation? 🍂
Wherever I went I always knew, always knew
Till I didn't know
Why do I do this to myself every time?
I know the way it ends before it's even begun
I am the only one at the finish line
open.spotify.com/track/3qJImz...
Wherever I went I always knew, always knew
Till I didn't know
Why do I do this to myself every time?
I know the way it ends before it's even begun
I am the only one at the finish line
open.spotify.com/track/3qJImz...
🧬 This is cool!
..designing a whole genome is challenging owing to complex interactions between genes and gene replication and regulation processes. “There are many important biological functions that you can only access if you’re able to design complete genomes.”
www.nature.com/articles/d41...
..designing a whole genome is challenging owing to complex interactions between genes and gene replication and regulation processes. “There are many important biological functions that you can only access if you’re able to design complete genomes.”
www.nature.com/articles/d41...
World’s first AI-designed viruses a step towards AI-generated life
Scientists used artificial intelligence to write coherent viral genomes, using them to synthesize bacteriophages capable of killing resistant strains of bacteria.
www.nature.com
October 10, 2025 at 11:46 AM
🧬 This is cool!
..designing a whole genome is challenging owing to complex interactions between genes and gene replication and regulation processes. “There are many important biological functions that you can only access if you’re able to design complete genomes.”
www.nature.com/articles/d41...
..designing a whole genome is challenging owing to complex interactions between genes and gene replication and regulation processes. “There are many important biological functions that you can only access if you’re able to design complete genomes.”
www.nature.com/articles/d41...
Reposted by Gülçin Yıldırım J.
Can an AI agent handle your Postgres on-call?
@divyendusingh.com from @xata.io is speaking at the Postgres Berlin Meetup tomorrow showing how we’re using LLMs to automate DB diagnostics, fixes, and even PRs.
Come see “Xata Agent” in action.
📍 RSVP: www.meetup.com/postgresql-m...
@divyendusingh.com from @xata.io is speaking at the Postgres Berlin Meetup tomorrow showing how we’re using LLMs to automate DB diagnostics, fixes, and even PRs.
Come see “Xata Agent” in action.
📍 RSVP: www.meetup.com/postgresql-m...
PostgreSQL September Meetup, Tue, Sep 23, 2025, 6:30 PM | Meetup
We will be hosting our September Meetup. Thanks to Amazon for sponsoring us. Please note that you have to show sign up with your real name and show a Photo ID to the build
www.meetup.com
September 22, 2025 at 11:39 AM
Can an AI agent handle your Postgres on-call?
@divyendusingh.com from @xata.io is speaking at the Postgres Berlin Meetup tomorrow showing how we’re using LLMs to automate DB diagnostics, fixes, and even PRs.
Come see “Xata Agent” in action.
📍 RSVP: www.meetup.com/postgresql-m...
@divyendusingh.com from @xata.io is speaking at the Postgres Berlin Meetup tomorrow showing how we’re using LLMs to automate DB diagnostics, fixes, and even PRs.
Come see “Xata Agent” in action.
📍 RSVP: www.meetup.com/postgresql-m...
Oh, just saw Neosync was archived:
⚠️ Disclaimer: Neosync has been acquired by Grow Therapy. As a result, this repository is no longer actively maintained.
We've been using Neosync transformers in pgstream, so we'll have to find a replacement or extend our own transformers to cover the gaps.
⚠️ Disclaimer: Neosync has been acquired by Grow Therapy. As a result, this repository is no longer actively maintained.
We've been using Neosync transformers in pgstream, so we'll have to find a replacement or extend our own transformers to cover the gaps.
September 22, 2025 at 10:03 AM
Oh, just saw Neosync was archived:
⚠️ Disclaimer: Neosync has been acquired by Grow Therapy. As a result, this repository is no longer actively maintained.
We've been using Neosync transformers in pgstream, so we'll have to find a replacement or extend our own transformers to cover the gaps.
⚠️ Disclaimer: Neosync has been acquired by Grow Therapy. As a result, this repository is no longer actively maintained.
We've been using Neosync transformers in pgstream, so we'll have to find a replacement or extend our own transformers to cover the gaps.