1. X
  2. Franck Pachot
Log inSign up
Franck Pachot
35.3K posts
Image
user avatar
Franck Pachot
@FranckPachot
🥑 Developer Advocate at 🍃 MongoDB 🔸 AWS Data Hero 🅾️ Oracle Certified Master ▝▞ Yugabyte​DB 🐘 PostgreSQL 𝕏posting to bsky/mstdn/lnkdn
Lausanne🇨🇭
blog.pachot.net
Joined October 2012
1,806
Following
17.7K
Followers
RepliesRepliesMediaMedia

New to X?

Sign up now to get your own personalized timeline!

Create account

By signing up, you agree to the Terms of Service and Privacy Policy, including Cookie Use.

Terms·Privacy·Cookies·Accessibility·Ads Info·© 2026 X Corp.
Don't miss what's happening
People on X are the first to know.
Log inSign up
  • Pinned
    user avatar
    Franck Pachot
    @FranckPachot
    Jun 23
    The #PostgreSQL Hub for Azure Developers azure-samples.github.io/postgres-hub/
    770
  • user avatar
    Franck Pachot
    @FranckPachot
    Jun 29, 2018
    WTF? the new washing machine comes with 7 pages of open source license!
    Image
    Image
  • user avatar
    Franck Pachot
    @FranckPachot
    May 28, 2023
    The most useful I've read about microservices and databases is this article by @GaryStafford. Nothing is better than a Sakila example on PostgreSQL🤩 programmaticponderings.com/2022/04/14/mon…
    56K
  • user avatar
    Franck Pachot
    @FranckPachot
    Apr 22, 2020
    If you want to know "What is SQL", don't ask @MongoDB mongodb.com/nosql-explained Normalization was not invented to reduce storage but for data integrity, and may require more space in tables and indexes. It is not about physical consideration. By the way, SQL is a language.
    Image
  • user avatar
    Franck Pachot
    @FranckPachot
    Jun 27, 2025
    How many years of SQL do you need to understand how NULL works? This was my lightning talk at pgday.ch
    Image
    20K
  • user avatar
    Franck Pachot
    @FranckPachot
    Jul 4, 2023
    Myths Programmers Believe about CPU Caches
    Image
    Myths Programmers Believe about CPU Caches
    From software.rajivprab.com
    58K
  • user avatar
    Franck Pachot
    @FranckPachot
    Jul 5, 2020
    A new blog post on another myth in NoSQL vs. RDBMS: “joins dont scale” blog.dbi-services.com/the-myth-of-no…
  • user avatar
    Franck Pachot
    @FranckPachot
    Oct 27, 2024
    SQLite is cool but do not forget that it is a single connection database for local use. One user at a time. The doc is awesome: >> SQLite does not compete with client/server databases. SQLite competes with fopen() sqlite.org/whentouse.html
    99K
  • user avatar
    Franck Pachot
    @FranckPachot
    Sep 27, 2020
    Do you know what means #backward #compatibility? You take a binary dump from 1986 and import it into Oracle 20c with one simple command and no additional tool🤓 Different characterset, different OS, different DB version... but same table and data. This is @OracleDatabase
    Image
  • user avatar
    Franck Pachot
    @FranckPachot
    Dec 2, 2023
    Starting a blog series about Isolation Levels: dev.to/franckpachot/i… Because many descriptions based on SQL standards are obsolete with modern MVCC databases
    Image
    Isolation Levels - part I: Introduction
    From dev.to
    37K
  • user avatar
    Franck Pachot
    @FranckPachot
    May 20, 2021
    If you think nothing can be free with Oracle, please name another cloud provider where the ALWAYS free trial is: 📆 unlimited in monthly usage ⌛ unlimited in duration 🆓 with zero risk of being billed The credit card you enter for trial is NEVER charged.
    Image
  • user avatar
    Franck Pachot
    @FranckPachot
    Feb 1, 2024
    I had a great tech discussion on Archil Podcast youtu.be/NL7TvAUxSuY?si… Topics:
    Image
    16K
  • user avatar
    Franck Pachot
    @FranckPachot
    Apr 13, 2024
    Really nice pg-schema-diff by @stripe to generate SQL migration scripts for PostgreSQL
    Image
    GitHub - stripe/pg-schema-diff: Go library for diffing Postgres schemas and generating SQL migrat...
    From github.com
    17K
  • user avatar
    Franck Pachot
    @FranckPachot
    Aug 15, 2023
    You can't understand your query performance by looking at the SQL code. The SQL is the spec. The code that is executed is the execution plan. Would be like asking why your trip took longer than expected without telling which road you have taken
    186K
Advertisement
Advertisement