Gülçin Yıldırım J.'s Avatar

Gülçin Yıldırım J.

@apatheticmagpie.bsky.social

Postgres, books and more. “For most of history, anonymous was a woman.”

499 Followers  |  315 Following  |  118 Posts  |  Joined: 20.11.2024
Posts Following

Posts by Gülçin Yıldırım J. (@apatheticmagpie.bsky.social)

Spotify – Web Player

Belki bir gün bana kendin varırsın 🎵 #turkishfolk #pinhani

open.spotify.com/track/7fuEQa...

22.02.2026 17:32 — 👍 0    🔁 0    💬 0    📌 0
Preview
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

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...

04.02.2026 16:00 — 👍 2    🔁 1    💬 0    📌 0
Hettie is having her cake day!

Hettie is having her cake day!

Gulcin enjoying Czech donuts

Gulcin enjoying Czech donuts

Gulcin is womanning the 2ndQ booth, there is also Pavel :)

Gulcin is womanning the 2ndQ booth, there is also Pavel :)

First time (in the phone archive), 2016. It was only a single track back then and all talks were in Czech with the exception of one English talk.

First time (in the phone archive), 2016. It was only a single track back then and all talks were in Czech with the exception of one English talk.

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 🐘

27.01.2026 14:34 — 👍 3    🔁 0    💬 0    📌 0
Preview
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 .

Voting for @pg-data.bsky.social talks this weekend 🗳️

So many wonderful proposals, thanks everyone who submitted!

18.01.2026 11:48 — 👍 3    🔁 0    💬 0    📌 0

Decided to walk Camino Francés route of Camino de Santiago this October with a feminist group of women. I am so excited!

17.01.2026 20:16 — 👍 0    🔁 0    💬 0    📌 0

@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 👀 👇🏽

14.01.2026 13:41 — 👍 2    🔁 2    💬 0    📌 0

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👇🏽

12.01.2026 15:18 — 👍 2    🔁 2    💬 0    📌 0
Preview
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.

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...

08.01.2026 13:43 — 👍 5    🔁 3    💬 0    📌 0

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`!).

08.01.2026 13:43 — 👍 3    🔁 1    💬 1    📌 0
YELLOWFAGE
REBECCA F. KUANG

YELLOWFAGE REBECCA F. KUANG

Margaret ATWOOD
Old Babes in the Wood

Margaret ATWOOD Old Babes in the Wood

Monika Kim - The Eyes Are The Best Part

Monika Kim - The Eyes Are The Best Part

The best part of the holidays 📚 #books

29.12.2025 17:40 — 👍 1    🔁 0    💬 0    📌 0
Preview
Break Gender Stereotypes with Picture Books ft. Women in STEM While scrolling through social media, this graphic caught me eye.

“..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...

19.12.2025 11:28 — 👍 5    🔁 1    💬 0    📌 0
Post image

Little joys in life: Getting into Postgres Weekly with your blog 🎉

🔗 xata.io/blog/constra...

🐘 postgresweekly.com/issues/628

12.12.2025 05:41 — 👍 6    🔁 1    💬 0    📌 0
Preview
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.

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...

11.12.2025 15:18 — 👍 4    🔁 2    💬 0    📌 0
Preview
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.

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...

10.12.2025 12:20 — 👍 5    🔁 1    💬 0    📌 0
Preview
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...

Check out the full post here: xata.io/blog/a-codin...

08.12.2025 13:48 — 👍 1    🔁 1    💬 0    📌 0

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 🤘🏽

08.12.2025 11:06 — 👍 4    🔁 0    💬 0    📌 0
Preview
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...

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...

31.10.2025 13:30 — 👍 2    🔁 0    💬 0    📌 0
Post image Post image Post image Post image

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!

21.10.2025 20:23 — 👍 6    🔁 0    💬 0    📌 0

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 💙

21.10.2025 13:38 — 👍 1    🔁 1    💬 1    📌 0

Glad to see #pgroll popping up in my timeline 🎉

If anyone has questions or feedback I am here 📝

19.10.2025 14:06 — 👍 1    🔁 0    💬 0    📌 0
Preview
PGConf.EU 2025 Schedule PGConf.EU 2025 Schedule

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...

17.10.2025 15:38 — 👍 1    🔁 1    💬 0    📌 0
Preview
PGConf.EU 2025 Schedule PGConf.EU 2025 Schedule

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

17.10.2025 15:38 — 👍 2    🔁 1    💬 1    📌 0
Preview
Fireworks

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...

13.10.2025 12:50 — 👍 0    🔁 0    💬 0    📌 0
Preview
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.

🧬 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...

10.10.2025 11:46 — 👍 1    🔁 0    💬 0    📌 0
Preview
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

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...

22.09.2025 11:39 — 👍 3    🔁 1    💬 0    📌 1

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.

22.09.2025 10:03 — 👍 5    🔁 0    💬 0    📌 0

Loving the photos from @pgdaylowlands.bsky.social 🐘

It was a really fun conference and well organized!

19.09.2025 15:52 — 👍 4    🔁 0    💬 0    📌 0
Preview
Making Postgres scale to zero with CNPG by Esther Minano Sanz How we built activity-aware Postgres clusters that hibernate automatically and save resources

I am really proud of the work we did here, finding ways to optimize resources used by database branches and make sure all is safe while we do that!

We also open-sourced a CNPG-I plugin for scale-to-zero, so you can also give it a try!

🐘 Read more: xata.io/blog/making-...

17.09.2025 10:27 — 👍 2    🔁 0    💬 0    📌 0
Video thumbnail

Our list of supported extensions is growing every day.
Got any requests?

15.09.2025 12:30 — 👍 2    🔁 1    💬 0    📌 0
Video thumbnail

Have a branch you don’t need running all the time?
Save money by setting scale-to-zero as the default for a project or override it in the branch settings.

16.09.2025 12:45 — 👍 2    🔁 1    💬 0    📌 0