Franck Pachot

Developer Advocate 🚀 YugabyteDB - postgres compatible open-source distributed SQL database 🔶AWS Data Hero, 🅾Oracle ACE Alumni & OCM, 🐘 PostgreSQL fan

Lausanne, Switzerland Joined on Nov 12, 2018 https://www.linkedin.com/in/franckpachot

Education

France

Work

Developer Advocate at Yugabyte

Pinned

Franck Pachot for YugabyteDB

Nov 11

Triggers in SQL database to extend its declarative data logic (but not business logic)

#yugabytedb #distributed #sql #database

5 min read

Franck Pachot for YugabyteDB

Dec 5

How to optimize indexing for distributed one-to-many join with pagination

#yugabytedb #distributed #postgres #database

5 min read

Want to connect with Franck Pachot?

Create an account to connect with Franck Pachot. You can also sign in below to proceed if you already have an account.

Create Account

Already have an account? Sign in

Franck Pachot

Dec 5

Isolation Levels - part VII: Repeatable Read

#sql #database

3 min read

Franck Pachot

Dec 5

Isolation Levels - part VI: Snapshot Isolation

#sql #database

2 min read

Franck Pachot

Dec 4

Isolation Levels - part V: Read Only

#sql #database

3 min read

Franck Pachot for AWS Heroes

Dec 3

Amazon Aurora and PostgreSQL buffer cache

#postgres #aurora #aws #rds

5 min read

Franck Pachot

Dec 3

Isolation Levels - part IV: Serializable

#sql #database

3 min read

Franck Pachot for AWS Heroes

Dec 1

PostgreSQL at AWS re:Invent

#postgres #conferences

5 min read

Franck Pachot

Nov 29

Isolation Levels - part III: Main concepts

#sql #database

5 min read

Franck Pachot for AWS Heroes

Nov 29

Atomic clocks in EC2

#aws #ec2 #atomic #clock

2 min read

Franck Pachot

Nov 28

Isolation Levels - part II: Characteristics and use-case

#sql #database

4 min read

Franck Pachot

Nov 28

What about temporary tables in OCI PostgreSQL?

#oracle #postgres #oci #cloud

5 min read

Franck Pachot

Nov 27

Isolation Levels - part I: Introduction

#sql #database

3 min read

Franck Pachot

Nov 27

PostgreSQL double buffering: understand the cache size in a managed service (OCI)

#postgres

10 min read

Franck Pachot

Nov 24

YBIO on OCI PostgreSQL

#postgres #oracle #oci

4 min read

Franck Pachot

Nov 24

MFA on OCI (you don't need to read this if you don't understand the title)

1 min read

Franck Pachot

Nov 23

Oracle Cloud Infrastructure Optimized PostgreSQL 14.9

#oci #oracle #postgres #cloud

9 min read

Franck Pachot for YugabyteDB

Nov 18

Row Level Security with an ARRAY of tenants set in session parameter (RLS)

#yugabytedb #distributed #sql #postgres

8 min read

Franck Pachot for YugabyteDB

Nov 13

IN() list filter with Top-N

#yugabytedb #distributed #sql #postgres

15 min read

Franck Pachot for YugabyteDB

Nov 12

Foreign Keys on Distributed SQL: don't worry, it scales

#yugabytedb #distributed #sql #postgres

6 min read

Franck Pachot for YugabyteDB

Nov 10

Monolithic vs. Distributed SQL

#monolithic #distributed #sql #yugabytedb

6 min read

Franck Pachot for YugabyteDB

Nov 8

Dirty Writes, INSERT ... ON CONFLICT DO UPDATE, Read Committed Isolation Level and Lost Update

#yugabytedb #distributed #sql #postgres

6 min read

Franck Pachot for YugabyteDB

Nov 6

Is co-partition or interleave necessary in Distributed SQL?

#yugabytedb #distributed #sql #postgres

8 min read

Franck Pachot for YugabyteDB

Nov 4

@DynamicUpdate with column-level locking in YugabyteDB and how to avoid write skew anomalies

#yugabytedb #distributed #sql #postgres

4 min read

Franck Pachot for YugabyteDB

Nov 4

Foreign Key validation in YugabyteDB when created in NOT VALID

#yugabytedb #distributed #sql #postgres

4 min read

Franck Pachot for YugabyteDB

Oct 30

Docker Image for YugabyteDB Developers

#yugabytedb #distributed #sql #postgres

3 min read

Franck Pachot for YugabyteDB

Oct 29

Can writes be blocked by reads in YugabyteDB?

#yugabytedb #distributed #sql #postgres

6 min read

Franck Pachot for YugabyteDB

Oct 25

Inner Inverted Join in YugabyteDB & PostgreSQL

#yugabytedb #distributed #sql #postgres

6 min read

Franck Pachot for YugabyteDB

Oct 24

TTL in YugabyteDB with batched deletes

#yugabytedb #ilm #distributed #postgres

5 min read

Franck Pachot for YugabyteDB

Oct 22

Fast SELECT COUNT(*) WHERE in YugabyteDB

#yugabytedb #distributed #sql #postgres

5 min read

Franck Pachot for YugabyteDB

Oct 8

Scalable range sharding to avoid hotspots on indexes

#yugabytedb #distributed #sql #postgres

13 min read

Franck Pachot for YugabyteDB

Oct 3

YugabyteDB in Jupyter Notebook in Google Colab

#yugabytedb #postgres #distributed #sql

2 min read

Franck Pachot for YugabyteDB

Oct 3

PostGIS on YugabyteDB Alma8 (workarounds)

#yugabytedb #distributed #sql #postgres

4 min read

Franck Pachot for YugabyteDB

Sep 24

Online Rolling Upgrade in YugabyteDB Managed

#yugabytedb #distributed #sql #postgres

11 min read

Franck Pachot for YugabyteDB

Sep 23

IF-THEN-ELSE in SQL WHERE CLAUSE

#yugabytedb #distributed #sql #postgres

4 min read

Franck Pachot for YugabyteDB

Sep 21

Bitmap Scan in YugabyteDB

#yugabytedb #distributed #sql #postgres

9 min read

Franck Pachot for YugabyteDB

Sep 18

YugabyteDB Cost-Based Optimizer and cost model for Distributed LSM-Tree

#yugabytedb #distributed #sql #postgres

7 min read

Franck Pachot for YugabyteDB

Sep 15

Transaction Internals: Fast Path vs Multi-Shard

#yugabytedb #distribute #sql #postgres

1 min read

Franck Pachot for YugabyteDB

Sep 15

The cost of additional secondary indexes in PostgreSQL & YugabyteDB

#postgres #yugabytedb #distributed #sql

6 min read

Franck Pachot for YugabyteDB

Sep 11

Postgres Join Methods in YugabyteDB

#yugabytedb #postgres #distributed #sql

12 min read

Franck Pachot

Sep 11

ACID properties explained to NoSQL vendors

#sql #nosql #acid #transactional

4 min read

Franck Pachot for YugabyteDB

Sep 4

JSON as TEXT, JSON, or JSONB datatypes in YugabyteDB

#yugabytedb #distributed #postgres #json

11 min read

Franck Pachot for YugabyteDB

Aug 30

PL/Python in YugabyteDB (build with yugabyte)

#yugabytedb #postgres #distributed #sql

3 min read

Franck Pachot for YugabyteDB

Aug 25

pg_stat_activity from all servers in YugabyteDB

#yugabytedb #distributed #sql #database

3 min read

Franck Pachot for YugabyteDB

Aug 24

No-gap sequence in PostgreSQL and YugabyteDB

#yugabytedb #postgres #distributed #sql

4 min read

Franck Pachot for YugabyteDB

Aug 15

YugabyteDB is Distributed SQL: resilient and consistent

#yugabytedb #distributed #sql #postgres

6 min read

Franck Pachot for YugabyteDB

Aug 15

Citus is not ACID but Eventually Consistent

#postgres #citus #distributed #sql

6 min read

Franck Pachot for YugabyteDB

Aug 14

Partitioning vs. Sharding - What about SQL Features?

#distributed #sql #sharding #postgres

7 min read

Franck Pachot for YugabyteDB

Aug 11

YugabyteDB official Dockerfile

#yugabytedb #distributed #sql #docker

2 min read

Franck Pachot for YugabyteDB

Aug 9

Counters with YugabyteDB

#yugabytedb #distributed #sql #postgres

2 min read

Franck Pachot for YugabyteDB

Aug 7

pg-hostname on YugabyteDB compiled and installed directly on the server

#yugabytedb #postgres #distributed #sql

3 min read

Franck Pachot for YugabyteDB

Jul 28

FlameGraphs on Steroids with profiler.firefox.com

#linux #perf #stat #profiler

3 min read

Franck Pachot for YugabyteDB

Jul 27

Another funny benchmark: "hugedbbench"

#yugabytedb #benchmark #distributed #sql

3 min read

Franck Pachot for YugabyteDB

Jul 25

SQL for low code applications: SQLPage

#yugabytedb #postgres #lowcode #sql

2 min read

Franck Pachot for AWS Heroes

Jul 24

PostgreSQL Optimizer Hints Discussion

#postgres #sql #hints #optimizer

5 min read

Franck Pachot for YugabyteDB

Jul 19

Understand what you run before publishing your (silly) benchmark results

#yugabytedb #hammerdb #distributed #postgres

16 min read

Franck Pachot for YugabyteDB

Jul 10

YugabyteDB: set read-only for a single query to allow follower reads

#distributed #postgres #yugabyte #readonly

8 min read

Franck Pachot for AWS Heroes

Jul 5

Query Amazon Redshift from YugabyteDB though PostgreSQL Foreign Data Wrapper and VPC peering

#yugabytedb #postgres #amazon #redshift

7 min read

Franck Pachot for AWS Heroes

Jul 3

Book review: Mastering PostgreSQL 15

#postgres #sql #database #books

5 min read

Franck Pachot for YugabyteDB

Jun 30

Approximate Count Distinct in YugabyteDB (and PostgreSQL) with HyperLogLog

#yugabytedb #postgres #distributed #sql

6 min read

Franck Pachot for YugabyteDB

Jun 28

Quickly testing an extension from docker image

#yugabytedb #postgres #distributed #sql

2 min read

AWS Heroes

YugabyteDB

Five Year Club

Four Year Club

1 Week Community Wellness Streak

16 Week Streak

Three Year Club

8 Week Streak

4 Week Streak

Two Year Club

One Year Club

Want to connect with Franck Pachot?