Franck Pachot (@franckpachot) 's Twitter Profile
Franck Pachot

@franckpachot

🥑 Developer Advocate at 🍃 MongoDB
🔸 AWS Data Hero
🅾️ Oracle Certified Master
▝▞ Yugabyte​DB 🐘 PostgreSQL
𝕏posting to bsky/mstdn/lnkdn

ID: 866752441

linkhttp://blog.pachot.net calendar_today07-10-2012 18:28:56

35,35K Tweet

16,16K Followers

1,1K Following

Kamran (@kamrannetic) 's Twitter Profile Photo

v yeah storing full data as JSONB doesn't work much in postgres, first you should either normalize the data correctly, because there's rarely a data that's not rational or can't be normalized, only store small stuff like Metadata or small settings there, don't use it as a table.

Franck Pachot (@franckpachot) 's Twitter Profile Photo

So, SQL is popular again. Cool, but does it mean that developers are now ok to: - Declare foreign keys without concerns about performance - Use stored procedures to avoid multiple roundtrips per transaction - Fine-tune their Hibernate mappings to prevent N+1 ?

Franck Pachot (@franckpachot) 's Twitter Profile Photo

A great read for anyone interested in how a read replica affects the primary in PostgreSQL. Congratulations to the authors—it's a complex topic, but they've explained it brilliantly

Franck Pachot (@franckpachot) 's Twitter Profile Photo

I didn't know, but like PostgreSQL, an index-only scan in MySQL may have to read the table. MVCC on B-Tree is complex, and not all databases have all visibility information in the index entry (or its rollback segment)

Franck Pachot (@franckpachot) 's Twitter Profile Photo

New to the MongoDB API? In the latest ORAWORLD e-Magazine issue (pages 46-52), you can learn through a Docker lab, understand with execution plans, and compare MongoDB with Oracle emulation. 🔗 oraworld.org/fileadmin/docu… (This is part 1 - more content is expected after summer).

New to the <a href="/MongoDB/">MongoDB</a> API? In the latest <a href="/ORAWORLD_Mag/">ORAWORLD e-Magazine</a>  issue (pages 46-52), you can learn through a Docker lab, understand with execution plans, and compare MongoDB with Oracle emulation. 
🔗 oraworld.org/fileadmin/docu… (This is part 1 - more content is expected after summer).
Abdel SGHIOUAR (@boredabdel) 's Twitter Profile Photo

Don't let your brilliant ideas become null pointers in the void! 💀 The Call for Papers for Devoxx Morocco 2025 closes on July 9th at midnight (GMT+1), which is T-minus 5 days and counting. 🚀 That's right, folks. If you've been meticulously crafting that mind-blowing

Don't let your brilliant ideas become null pointers in the void! 💀

The Call for Papers for Devoxx Morocco 2025 closes on July 9th at midnight (GMT+1), which is T-minus 5 days and counting. 🚀

That's right, folks. If you've been meticulously crafting that mind-blowing
Philippe Noël (@philippemnoel) 's Twitter Profile Photo

On our latest ParadeDB blog post about the LSM tree we built in Postgres, many asked me how we map it down to Postgres pages. We also wrote a blog post about that, which you can find here: paradedb.com/blog/block_sto…

Franck Pachot (@franckpachot) 's Twitter Profile Photo

Adding a column in #PostgreSQL compared to adding a field in MongoDB: dev.to/franckpachot/a… (please, tell me if you learned something new about postgres or mongo here, and if you want more content like this)

Franck Pachot (@franckpachot) 's Twitter Profile Photo

A document database isn't just a JSON store with flexible schemas; it also integrates flexibility directly into indexes. MongoDB accepts wildcards in index definitions: dev.to/franckpachot/w…. I've tested the same on MongoDB emulations on top of SQL databases, and they all fail

Franck Pachot (@franckpachot) 's Twitter Profile Photo

💚 Welcome the 2025 MongoDB Community Champions! A diverse group from various countries, growing the tech community with professionals from industry, academia, startups, and large companies mongodb.com/company/blog/n…