Franck Pachot

30 years of @java has shaped our interaction with databases: from stored procedures and SQL pre-compilers, to #JDBC @Hibernate #JPA #NoSQL @SpringData I survived through all of that on #Db2 @Oracle @PostgreSQL @Yugabyte @MongoDB ! What is your experience with these transitions?

I know some fantastic people at @Oracle and one more is joining them. Thanks for what you did at @MongoDB (like hiring me 😃) and congrats for the next chapter!

Without checksum you can't detect corrupt data (and no storage is 100% reliable). Or you detect it to too late at a time where point in time recovery is not possible. Databases with checksum by default: avi.im/blag/2024/data…

We just launched Voyage-context-3, a new embedding model that gives AI a full-document view while preserving chunk-level precision that offers better retrieval performance than leading alternatives. When building AI that reads and reasons over documents (such as reports,…

ACID properties in @MongoDB: 🔂 Single-document wait on conflicts, ike pessimistic locking, but with optimistic concurrency control to avoid locks 🔁 User-managed transactions detect conflicts and let applications cancel and retry their transactions dev.to/franckpachot/l…

💬 Hear it from our partners. Sponsoring DevoxxMA isn’t just about visibility — it’s about meaningful connections, community, and lasting impact. 📩 Want the same results for your brand? Let’s talk: [email protected]

If your app breaks when the DB changes—you’re not alone. @FranckPachot shows how shifting from DB-first to #JPA-first solved and created problems. Build schema-resilient Java apps that scale. One read = fewer production bugs javapro.io/2025/06/19/jav… @Hibernate #SpringData #ORM

I mainly use query planner hints for troubleshooting, and I rarely use them as workarounds. It's essential to understand whether hints force a plan, affecting the result, or favor one and may be ignored. Here's how hints work in @MongoDB dev.to/franckpachot/h…

Simulating edge conditions: Running #pgbench with added latency to test client/server transaction logic in SQL (business logic in App or DB?) and compare it with @MongoDB document model dev.to/franckpachot/c…

If you are not solving write scalability, reducing operational complexity in databases these days then you are mostly competing with SQLite.

😂

Looking for an AUTO-INCREMENT, BIGSERIAL, or GENERATED ALWAYS AS IDENTITY in @MongoDB? Simply use a collection with an atomic increment-and-fetch operation, and choose ACID or not (SQL sequences are not ACID) dev.to/franckpachot/s…

Old debates about relational 3NF are resurfacing. I revisited Codd’s paper to better understand the original goals of normalization, this time considering today’s developer experience and document data modeling linkedin.com/pulse/data-mod…

A better database development experience in free @intellijidea

💚 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…

😎

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

ChatGPT's most outstanding achievement is making the PostgreSQL mailing lists readable 😂

please stop dming me asking us to do mongodb

What’s new for #Developer in #Oracle #Database 23.7 geraldonit.com/whats-new-for-…

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)