Gwen Shapira
@gwenshap.bsky.social
Founder of SaaS Developer Community and Nile Database.
Cats are great, actually.
May 29, 2025 at 4:00 PM
Cats are great, actually.
🚨 New blog alert:
Postgres 18 beta 1 was released last week, and includes native support for UUIDv7.
Great opportunity to explain why UUIDv7 is a great fit for your database keys, and show you how to use them in PG18.
www.thenile.dev/blog/uuidv7
Postgres 18 beta 1 was released last week, and includes native support for UUIDv7.
Great opportunity to explain why UUIDv7 is a great fit for your database keys, and show you how to use them in PG18.
www.thenile.dev/blog/uuidv7
May 20, 2025 at 4:54 PM
🚨 New blog alert:
Postgres 18 beta 1 was released last week, and includes native support for UUIDv7.
Great opportunity to explain why UUIDv7 is a great fit for your database keys, and show you how to use them in PG18.
www.thenile.dev/blog/uuidv7
Postgres 18 beta 1 was released last week, and includes native support for UUIDv7.
Great opportunity to explain why UUIDv7 is a great fit for your database keys, and show you how to use them in PG18.
www.thenile.dev/blog/uuidv7
Preparing a presentation (this is a draft from early in the year, so probably preparing for Monster Scale). Looks like a mess, but IIRC, the result was actually good.
May 4, 2025 at 2:59 AM
Preparing a presentation (this is a draft from early in the year, so probably preparing for Monster Scale). Looks like a mess, but IIRC, the result was actually good.
I blogged a deep dive on how "drop column" works in Postgres - inspecting the Postgres catalog and dumping data files to discover what Vacuum really does to dropped columns and why it doesn't violate GDPR.
www.thenile.dev/blog/drop-co...
www.thenile.dev/blog/drop-co...
April 24, 2025 at 4:29 PM
I blogged a deep dive on how "drop column" works in Postgres - inspecting the Postgres catalog and dumping data files to discover what Vacuum really does to dropped columns and why it doesn't violate GDPR.
www.thenile.dev/blog/drop-co...
www.thenile.dev/blog/drop-co...
Fountain pen Friday! I asked ChatGPT to imagine the result of Pelikan and Kaweco merger…
April 11, 2025 at 2:09 PM
Fountain pen Friday! I asked ChatGPT to imagine the result of Pelikan and Kaweco merger…
Authentication is part of web security - and as such it can be intimidating.
All these attack scenarios, secrets, encryption layers, protocols, mitigations and rules.
Luckily, James Mickens summarized all we need to know in his classic paper "This World of Ours":
All these attack scenarios, secrets, encryption layers, protocols, mitigations and rules.
Luckily, James Mickens summarized all we need to know in his classic paper "This World of Ours":
April 4, 2025 at 8:28 PM
Authentication is part of web security - and as such it can be intimidating.
All these attack scenarios, secrets, encryption layers, protocols, mitigations and rules.
Luckily, James Mickens summarized all we need to know in his classic paper "This World of Ours":
All these attack scenarios, secrets, encryption layers, protocols, mitigations and rules.
Luckily, James Mickens summarized all we need to know in his classic paper "This World of Ours":
Leia also has a message for you.
April 3, 2025 at 12:30 AM
Leia also has a message for you.
Just realized that the two books I’m currently reading go well together.
March 27, 2025 at 11:22 PM
Just realized that the two books I’m currently reading go well together.
I asked ChatGPT to roast me, and... I think I have a new elevator pitch.
"What do I do? Oh, I'm just here gaslighting Postgres into thinking its SaaS"
"What do I do? Oh, I'm just here gaslighting Postgres into thinking its SaaS"
March 25, 2025 at 6:13 PM
I asked ChatGPT to roast me, and... I think I have a new elevator pitch.
"What do I do? Oh, I'm just here gaslighting Postgres into thinking its SaaS"
"What do I do? Oh, I'm just here gaslighting Postgres into thinking its SaaS"
Nile-Auth drop-in UI components are not *just* pretty.
They make your app secure by default:
These components use cookies and CSRF tokens correctly to protect against XSS and CSRF attacks.
Oh, and if you don't like our style, just bring your own Tailwind themes.
They make your app secure by default:
These components use cookies and CSRF tokens correctly to protect against XSS and CSRF attacks.
Oh, and if you don't like our style, just bring your own Tailwind themes.
March 21, 2025 at 5:47 PM
Nile-Auth drop-in UI components are not *just* pretty.
They make your app secure by default:
These components use cookies and CSRF tokens correctly to protect against XSS and CSRF attacks.
Oh, and if you don't like our style, just bring your own Tailwind themes.
They make your app secure by default:
These components use cookies and CSRF tokens correctly to protect against XSS and CSRF attacks.
Oh, and if you don't like our style, just bring your own Tailwind themes.
Recommended paper: Linear Elastic Caching via Ski Rental (CIDR 25)
In which the authors propose a machine-learning optimized, cloud-native, cache algorithm that reduced the TCO of Google Spanner by 15% (!).
www.vldb.org/cidrdb/paper...
Summary (by a human!) thread 👇
In which the authors propose a machine-learning optimized, cloud-native, cache algorithm that reduced the TCO of Google Spanner by 15% (!).
www.vldb.org/cidrdb/paper...
Summary (by a human!) thread 👇
March 21, 2025 at 4:58 PM
Recommended paper: Linear Elastic Caching via Ski Rental (CIDR 25)
In which the authors propose a machine-learning optimized, cloud-native, cache algorithm that reduced the TCO of Google Spanner by 15% (!).
www.vldb.org/cidrdb/paper...
Summary (by a human!) thread 👇
In which the authors propose a machine-learning optimized, cloud-native, cache algorithm that reduced the TCO of Google Spanner by 15% (!).
www.vldb.org/cidrdb/paper...
Summary (by a human!) thread 👇
Siri, what is “buffer overflow”?
March 16, 2025 at 3:26 AM
Siri, what is “buffer overflow”?
🚀 PostgreSQL extensions, now effortless on Nile!
35+ extensions—AI search (pgvector), geospatial (PostGIS), full-text search & more—ready to use, no installs needed. Build smarter, faster.
🔗 Read more: www.thenile.dev/blog/announc...
🛠️ Try it: console.thenile.dev
#PostgreSQL #Serverless
35+ extensions—AI search (pgvector), geospatial (PostGIS), full-text search & more—ready to use, no installs needed. Build smarter, faster.
🔗 Read more: www.thenile.dev/blog/announc...
🛠️ Try it: console.thenile.dev
#PostgreSQL #Serverless
March 14, 2025 at 4:34 PM
🚀 PostgreSQL extensions, now effortless on Nile!
35+ extensions—AI search (pgvector), geospatial (PostGIS), full-text search & more—ready to use, no installs needed. Build smarter, faster.
🔗 Read more: www.thenile.dev/blog/announc...
🛠️ Try it: console.thenile.dev
#PostgreSQL #Serverless
35+ extensions—AI search (pgvector), geospatial (PostGIS), full-text search & more—ready to use, no installs needed. Build smarter, faster.
🔗 Read more: www.thenile.dev/blog/announc...
🛠️ Try it: console.thenile.dev
#PostgreSQL #Serverless
⚡️ We shipped Nile Management API months ago… it’s time to make some noise.
thenile.dev/docs/api-ref...
👉 Spin up unlimited free databases in milliseconds
👉 Automate AI agent environments & CI/CD workflows
Blog - www.thenile.dev/blog/announc...
Try Nile - thenile.dev
thenile.dev/docs/api-ref...
👉 Spin up unlimited free databases in milliseconds
👉 Automate AI agent environments & CI/CD workflows
Blog - www.thenile.dev/blog/announc...
Try Nile - thenile.dev
March 13, 2025 at 4:17 PM
⚡️ We shipped Nile Management API months ago… it’s time to make some noise.
thenile.dev/docs/api-ref...
👉 Spin up unlimited free databases in milliseconds
👉 Automate AI agent environments & CI/CD workflows
Blog - www.thenile.dev/blog/announc...
Try Nile - thenile.dev
thenile.dev/docs/api-ref...
👉 Spin up unlimited free databases in milliseconds
👉 Automate AI agent environments & CI/CD workflows
Blog - www.thenile.dev/blog/announc...
Try Nile - thenile.dev
(credit to @bsideup.github.io for the awesome meme)
March 13, 2025 at 12:59 AM
(credit to @bsideup.github.io for the awesome meme)
My husband is doing some home maintenance. I asked him to keep his stuff away from my GitHub repos, just to be on the safe side.
March 12, 2025 at 9:42 PM
My husband is doing some home maintenance. I asked him to keep his stuff away from my GitHub repos, just to be on the safe side.
I don't know either, but here's a good hallucination:
March 12, 2025 at 7:29 PM
I don't know either, but here's a good hallucination:
March 11, 2025 at 6:23 PM
PSA:
If you are responsible for performance of Postgres DBs, check out POWA.
It analyzes your workload, visualizes, provides insights and even suggests indexes that optimize the workload as a whole.
Docs: powa.readthedocs.io/en/latest/
Demo (just click login): demo-powa.anayrat.info/server/
If you are responsible for performance of Postgres DBs, check out POWA.
It analyzes your workload, visualizes, provides insights and even suggests indexes that optimize the workload as a whole.
Docs: powa.readthedocs.io/en/latest/
Demo (just click login): demo-powa.anayrat.info/server/
February 25, 2025 at 3:22 AM
PSA:
If you are responsible for performance of Postgres DBs, check out POWA.
It analyzes your workload, visualizes, provides insights and even suggests indexes that optimize the workload as a whole.
Docs: powa.readthedocs.io/en/latest/
Demo (just click login): demo-powa.anayrat.info/server/
If you are responsible for performance of Postgres DBs, check out POWA.
It analyzes your workload, visualizes, provides insights and even suggests indexes that optimize the workload as a whole.
Docs: powa.readthedocs.io/en/latest/
Demo (just click login): demo-powa.anayrat.info/server/
February 23, 2025 at 7:19 AM
Small things that make me happy #534:
Nile's console now has Github authentication 🥳
Nile's console now has Github authentication 🥳
February 11, 2025 at 9:47 PM
Small things that make me happy #534:
Nile's console now has Github authentication 🥳
Nile's console now has Github authentication 🥳