iiinova — where your digital self keeps evolving

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

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.

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

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

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