Sign in

Gwen Shapira

@gwenshap.bsky.social
6.6K followers 2.1K following 409 posts

Founder of SaaS Developer Community and Nile Database.

PostsRepliesMedia
Reposted by Gwen Shapira
PGConf.dev 🐘 @pgconf.dev · 01/04/2026
Introducing the pgconf.dev 2026 conference t-shirt! 🐘🎉 This year we're celebrating 30 years of PostgreSQL, and Slonik is dressed for the occasion. The only way to get one? Be there. See you in Vancouver, May 19–22.
061
Gwen Shapira @gwenshap.bsky.social · 19/03/2026
I'm so excited to go on Talking Postgres! One of my fav podcasts! I'll chat about my journey to found Nile and discover Postgres. The podcast has a Discord channel where fans discuss the episode as it is recorded. If you want to join ua live, let me know and I'll send you an invite.
1174
Reposted by Gwen Shapira
PGConf.dev 🐘 @pgconf.dev · 12/03/2026
PGConf.dev 2026 needs volunteers! Room hosts, registration desk, and more. If you're attending in Vancouver, we'd love your help. Email contact@pgconf.dev to sign up! Details: 2026.pgconf....
021
Reposted by Gwen Shapira
PGConf.dev 🐘 @pgconf.dev · 10/03/2026
Tuesday is community engagement day 🐘 Hot take: it is the best day! Full of panels and discussions. Whether you're a first-timer or a longtime contributor, there's a seat at the table. Schedule (more sessions still being added!) → 2026.pgconf....
032
Reposted by Gwen Shapira
PGConf.dev 🐘 @pgconf.dev · 05/03/2026
The pgconf.dev 2026 schedule is stacked 🐘✨ WAL internals, query planning, logical replication, temporal data, columnar storage, 30 years of Postgres retrospective… and cake cutting. Something for every Postgres nerd. Full schedule → 2026.pgconf....
084
Gwen Shapira @gwenshap.bsky.social · 05/02/2026
Poster sessions are honestly my favorite for complex deepdive topics. It is visual, conversational, collaborative and includes coffee. Just how I like my deep technical content.
050
Reposted by Gwen Shapira
PGConf.dev 🐘 @pgconf.dev · 21/11/2025
PGConf.dev 2026: top things to do at the conference: • Debate MVCC trivia with strangers • Discover a feature you didn’t know you needed • Realize you’re not the only one who reads pg_waldump for fun Registration and CFP are open.
033
Reposted by Gwen Shapira
PGConf.dev 🐘 @pgconf.dev · 10/11/2025
CFP for PGConf.dev 2026 is open until Jan 16 🐘 Tips for strong proposals: • Share what you discovered. Not just what you built. • Be specific • Discuss bigger Postgres picture • Failures welcome Be specific, connect to Postgres internals, and don’t hide the messy bits.
052
Reposted by Gwen Shapira
Bala @bala.bsky.social · 28/09/2025
0221
Gwen Shapira @gwenshap.bsky.social · 28/09/2025
At what point do we stop saying “worth its weight in gold” and start saying “worth its weight in high-end GPU”?
2111
Reposted by Gwen Shapira
Bala @bala.bsky.social · 28/09/2025
2121
Reposted by Gwen Shapira
Chris @chris.blue · 14/07/2025
So.. Pierre Barre just built an NFS server implementation on SlateDB. ZeroFS is today days old, but it's going to get wild. Bottomless storage and checkpoints mean instant FS snapshots (zero overhead). github.com/Barre/zerofs
github.com
GitHub - Barre/zerofs: ZeroFS: The S3FS that does not suck.
ZeroFS: The S3FS that does not suck. Contribute to Barre/zerofs development by creating an account on GitHub.
5335
Reposted by Gwen Shapira
P(aul) Frazee @pfrazee.com · 16/06/2025
I use a spreadsheet to track all my documentation It's important to keep all your docs in a row
3658922
Gwen Shapira @gwenshap.bsky.social · 10/06/2025
Videos from PgConfDev are starting to show up on YouTube! Great time to catch up on both the new content and the amazing talks from past events. You can start with my talk: "Scaling Postgres to Million Tenants" www.youtube.com/watch?v=EfAS...
youtube.com
Re-engineering Postgres for Millions of Tenants (PGConf.dev 2025)
YouTube video by PostgreSQL Development Conference
0152
Gwen Shapira @gwenshap.bsky.social · 30/05/2025
So, Tensor (as in Pytorch) is just like a vector, except that it is somehow better for GPUs? Did I get that right?
160
Gwen Shapira @gwenshap.bsky.social · 29/05/2025
“Why is Postgres seq-scanning rather than use this index?” 🤯 Short answer: the planner thinks that index won’t help (or can’t use it). Longer answer—5 usual suspects 👇
2121
Gwen Shapira @gwenshap.bsky.social · 29/05/2025
Cats are great, actually.
290
Reposted by Gwen Shapira
Tanel Poder @tanelpoder.com · 28/05/2025
New blog: Using Postgres pg_test_fsync tool for testing low latency writes An easy to use tool that comes with standard Postgres installation, for testing write latency of devices where you put your WAL/redo logs and any other files requiring low write latency. (link in reply)
295
Reposted by Gwen Shapira
Paul Ramsey @pwramsey.bsky.social · 25/05/2025
I feel like I've found a new controlling meme for open source contribution and innovation.
05210
Reposted by Gwen Shapira
schrepfler.bsky.social @schrepfler.bsky.social · 22/05/2025
I've registered it with context7 so it's now available as up-to-date nile documentation via the context7 MCP context7.com/www.thenile....
context7.com
Context7 - Up-to-date documentation for LLMs and AI code editors
Generate context with up-to-date documentation for LLMs and AI code editors
121
Gwen Shapira @gwenshap.bsky.social · 20/05/2025
🚨 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
1134
Gwen Shapira @gwenshap.bsky.social · 05/05/2025
You know the advice to say "thank you" instead of "sorry"? It looks like ChatGPT took it to heart. Me: You just said something incorrect. ChatGPT: Thank you for keeping it precise.
150
Gwen Shapira @gwenshap.bsky.social · 04/05/2025
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.
Very messy draft of a talk
020
Reposted by Gwen Shapira
PGConf.dev 🐘 @pgconf.dev · 01/05/2025
PGConf.dev 2025 starts in 13 days. Conference swag is starting to arrive in Montreal. Are your travel plans set? You can still register. 2025.pgconf.... #Postgresql #PGConf.dev
031
Reposted by Gwen Shapira
@pgconfnyc @pgconfnyc.bsky.social · 01/05/2025
We have a new venue for PGConf NYC 2025 and a new hotel to go with it! Check it out and book now:
2025.pgconf.nyc
PGConf NYC 2025 | PostgreSQL Conference
PGConf NYC 2025 will be held from on September 29th - October 1st in New York City, NY at Convene 117 West 46th Street.
064
Reposted by Gwen Shapira
Martin Kleppmann @martin.kleppmann.com · 30/04/2025
Folks at Google: there's no longer a button to get the PDF of your research papers directly from your website. Instead you have to do a hop through Google Scholar. Is that intentional? Seems worse than it used to be before.
Screenshot of the Percolator paper on the Google Research website. There are buttons for "Google Scholar" and "Copy Bibtex", but none to download the actual paper!
2562
Gwen Shapira @gwenshap.bsky.social · 29/04/2025
Running TPC-C can be a bit challenging. Running pgbench is easy (it ships with Postgres and uses simple Postgres configs), but its main built-in script is TPC-B. Thankfully, Ryo Kanbayashi wrote a pgbench script that is TPC-C-like: github.com/ryogrid/tpcc...
github.com
GitHub - ryogrid/tpcc_like_with_pgbench: Simplified version of the TPC-C benchmark using pgbench custom scripts
Simplified version of the TPC-C benchmark using pgbench custom scripts - ryogrid/tpcc_like_with_pgbench
060
Gwen Shapira @gwenshap.bsky.social · 28/04/2025
Serious question: Why do so many developers hate stored procedures?
27486
Reposted by Gwen Shapira
Peter Hanssens @petehanssens.bsky.social · 28/04/2025
⚡️ LAST DAYS for DataEngBytes 2025 Percolating tickets! After April 30th, prices increase from $449 to $499. Don't miss Oceania's premier data engineering & ML conference this July in Sydney & Melbourne! dataengbytes.com
031
Reposted by Gwen Shapira
Gergely Orosz @gergely.pragmaticengineer.com · 22/04/2025
What great engineering looks like: invisible at most times… except when it matters. Had no idea an iPhone would measure water presence on a charging port and warn for it. But it does! Was at a pool and a few hours later when plugging it in got this helpful message.
8828
Gwen Shapira @gwenshap.bsky.social · 26/04/2025
Happy Caturday!
140
Gwen Shapira @gwenshap.bsky.social · 26/04/2025
Movie you’ve watched more than six times using gifs. (“Hard mode” no Star Wars, Star Trek, or LOTR)
media.tenor.com
a man in a military uniform is talking to another man with the words round up the usual suspects above him
ALT: a man in a military uniform is talking to another man with the words round up the usual suspects above him
130
Gwen Shapira @gwenshap.bsky.social · 24/04/2025
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...
Diagram of a page in Postgres data file. The linked blog has a full description of the diagram (and a lot of other info about dropping columns)
1122
Gwen Shapira @gwenshap.bsky.social · 21/04/2025
If a bio-lab decides to start a metal band, they can call it: “Parasite Host”. (Sorry. I’ll see myself out)
060
Gwen Shapira @gwenshap.bsky.social · 20/04/2025
Somehow @tanelpoder.com managed to combine my two favorite things: * Benchmarks * Cats github.com/tanelpoder/c... If there's a way to make this generate ice-cream, I think perfection will be achieved.
github.com
GitHub - tanelpoder/catbench: CatBench Vector Search Playground
CatBench Vector Search Playground. Contribute to tanelpoder/catbench development by creating an account on GitHub.
151
Gwen Shapira @gwenshap.bsky.social · 19/04/2025
I have some #AWS #Lambda code examples that I used to deploy with #Serverless framework. Unfortunately, v3 is not maintained and is kinda broken, and v4 has both license and functionality changes that I can't really adopt. How do y'all deploy to AWS Lambda these days?
630
Gwen Shapira @gwenshap.bsky.social · 17/04/2025
Just signed up to your product. Don’t make me: ❌ Confirm email ❌ Log in again ❌ 10 step tutorial ❌ Find an API key Just show me why this product rocks. One page. One “wow.” That’s it. ** Nile-Auth lets you redirect to anything after signup - use this power responsibly!
092
Gwen Shapira @gwenshap.bsky.social · 11/04/2025
Fountain pen Friday! I asked ChatGPT to imagine the result of Pelikan and Kaweco merger…
260
Reposted by Gwen Shapira
hailey @hailey.at · 10/04/2025
turns out that with facebook's pdq hashing algorithm, you can hash every image that goes through the firehose. minimal cpu required. fun stuff! then just throw pgvector on top and boom
4836
Reposted by Gwen Shapira
Kaslin Fields @kaslin.rocks · 10/04/2025
The KubeCon NA CFP is open now until May 27th! KubeCon is over, time to get ready for #KubeCon! events.linuxfoundation.org/kubecon-clou...
events.linuxfoundation.org
Call For Proposals (CFP) | LF Events
KubeCon + CloudNativeCon gathers adopters and technologists from leading open source and cloud native communities from November 10-13. Join our current graduated, incubating, and sandbox projects as…
051
Gwen Shapira @gwenshap.bsky.social · 04/04/2025
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":
0166
Reposted by Gwen Shapira
Jason Thorne @jasonthorne.bsky.social · 28/03/2025
“There's no machine known that is more efficient than a human on a bicycle. Bowl of oatmeal, 30 miles - you can't come close to that." - Bill Nye
11627127
Gwen Shapira @gwenshap.bsky.social · 27/03/2025
Just realized that the two books I’m currently reading go well together.
4301
Gwen Shapira @gwenshap.bsky.social · 25/03/2025
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"
2111
Gwen Shapira @gwenshap.bsky.social · 23/03/2025
Spring #caturday is for enjoying the hammock.
0171
Gwen Shapira @gwenshap.bsky.social · 21/03/2025
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.
041
Gwen Shapira @gwenshap.bsky.social · 21/03/2025
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 👇
1172
Gwen Shapira @gwenshap.bsky.social · 21/03/2025
Attention Django users! ⚠️ If you are on Django 5.x, make sure you upgrade to 5.0.9 or higher. If you are on Django 4.2.x, make sure you upgrade to 4.2.16 or higher. There are 4 Critical/High CVE against lower versions that open you to DDOS and SQL Injection.
1108
Reposted by Gwen Shapira
Ian Boudreau @ianboudreau.com · 21/03/2025
Tried and true method, 100% effective. "Everyone wants to do it, five out of five stars" - Herman Melville
4451
Reposted by Gwen Shapira
Brendan O’Leary ✅ @brendan.fyi · 16/03/2025
Now that’s a heap
173