Franck Pachot

Developer Advocate 🚀 YugabyteDB - open-source distributed SQL database 🔶AWS Data Hero, 🅾Oracle ACED & 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

May 21

"I want to try it" 🚀 YugabyteDB at KubeCon

#kubecon #distributed #sql #yugabytedb

2 min read

Franck Pachot for YugabyteDB

Dec 17 '21

Learn how to write SQL recursive CTE in 5 steps

#postgres #yugabytedb #sql #database

44 8

6 min read

Franck Pachot for YugabyteDB

Nov 7 '21

🚀 Think about Primary Key & Indexes before anything else 🐘

#yugabytedb #database #postgres #sql

8 min read

Franck Pachot for YugabyteDB

Jun 30

geo-distribution with 🚀 YugabyteDB tablespaces

#yugabytedb #distributed #postgres #sql

4 min read

UUID/GUID, CUID & NanoID: What's The Difference?

Nice to see alternatives to balance size and performance, but...

Jun 3

Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB

@jamesvanderpump yes one difference with PostgreSQL is that Y...

May 10

What is a LSM Tree?

Great article ! One thing, DynamoDB uses B-Tree, not LSM Tree...

Mar 14

Stop AWS Account Hacks

Good tips for people doing a professional usage, ready to pay...

Feb 16

SQL to avoid data corruption in race conditions with SERIALIZABLE 🐘 🚀

Thanks Rafael. Yes I think an update of a single row is safe ...

Jan 7

TIL: MySQL timestamp column can't go beyond '2038-01-19 03:14:07'

Sure PostgreSQL can. Seems MySQL fixed it in 8.0.28: bugs.mys...

Jan 3

🐘🚀 Triggers & Stored Procedures for pure data integrity logic and performance

Thanks Pavel! Yes, faster, less code and much more readable. ...

Dec 22 '21

VisiData to read JSON, HTML and YugabyteDB

Nope. Formats are there: visidata.org/docs/formats/ (but if y...

Dec 21 '21

View all 15 comments

Franck Pachot for YugabyteDB

Jun 27

Local reads from 🚀YugabyteDB Read Replicas

#yugabytedb #distributed #postgres #sql

7 min read

Franck Pachot for YugabyteDB

Jun 27

Local reads from 🚀YugabyteDB raft followers

#yugabytedb #distributed #postgres #sql

6 min read

Franck Pachot for YugabyteDB

Jun 22

🚀 hash+hash partitioning+sharding

#yugabytedb #distributed #sql #database

6 min read

Franck Pachot for YugabyteDB

Jun 15

(beta) yugabyted GUI

#yugabytedb #cloud #gui #database

2 min read

Franck Pachot for YugabyteDB

Jun 14

PITR snapshot: an easy flashback / backtrack for application releases

#yugabytedb #cicd #snapshot #database

7 min read

Franck Pachot for YugabyteDB

Jun 12

Nested Loop performance in YugabyteDB

#yugabytedb #distributed #sql #database

12 min read

Franck Pachot for YugabyteDB

Jun 9

Predictable plans with pg_hint_plan full hinting

#yugabytedb #postgres #sql #hints

10 min read

Franck Pachot for YugabyteDB

Jun 7

Quickly get short stack from a YugabyteDB tserver

#yugabytedb #distributed #sql #database

2 min read

Franck Pachot for YugabyteDB

Jun 7

YugabyteDB range sharding: ASC or DESC?

#postgres #yugabytedb #sql #database

5 min read

Franck Pachot for YugabyteDB

Jun 3

ERROR: Timed out: BackfillIndex RPC

#yugabytedb #distributed #sql #database

3 min read

Franck Pachot for YugabyteDB

Jun 3

Build a PostgreSQL Docker image with pg_hint_plan and pg_stat_statements

#postgres #docker #sql #database

2 min read

Franck Pachot for YugabyteDB

Jun 2

YugabyteDB Predicate Push Down

#yugabytedb #sql #distributed #database

6 min read

Franck Pachot for YugabyteDB

Jun 1

1 million rows insert

#yugabytedb #distributed #sql #database

5 min read

Franck Pachot

Jun 1

tracing writes and locks in YugabyteDB

#yugabytedb #distributed #sql #lock

6 min read

Franck Pachot for YugabyteDB

May 30

Parsing YugabyteDB version()

#yugabytedb #postgres #sql #database

2 min read

Franck Pachot for YugabyteDB

May 27

pg_stat_statements in YugabyteDB

#yugabytedb #postgres #monitoring #sql

2 min read

Franck Pachot for AWS Heroes

May 27

PostgreSQL: An example of using WITH clauses to decompose the problem

#yugabytedb #postgres #sql #cte

2 min read

Franck Pachot for YugabyteDB

May 16

🐘OID <-> 🚀table_id

#yugabytedb #distributed #sql #database

4 min read

Franck Pachot for YugabyteDB

May 8

🚀 YugabyteDB on fly.io - I - yugabyted

#yugabytedb #distributed #sql #database

8 min read

Franck Pachot for YugabyteDB

May 4

docker-compose.yaml to start YugabyteDB with POSTGRES_USER POSTGRES_PASSWORD POSTGRES_DB env

#yugabytedb #postgres #docker #compose

2 min read

Franck Pachot for YugabyteDB

Apr 29

🐘🚀 Update/Insert/Soft-Delete from a JSON payload

#yugabytedb #postgres #sql #database

4 min read

Franck Pachot for YugabyteDB

Apr 29

Read Committed is a must for Postgres-compatible distributed SQL databases

#yugabytedb #postgres #sql #database

7 min read

Franck Pachot

Apr 21

cluster-aware psycopg2 🚀

#postgres #yugabytedb #python

7 min read

Franck Pachot for YugabyteDB

Apr 17

Soft delete cascade in PostgreSQL🐘 and YugabyteDB🚀

#yugabytedb #distributed #sql #postgres

5 min read

Franck Pachot

Apr 11

The cost of OKE for YugabyteDB - 4 - Explore the cost

#yugabytedb #kubernetes #oracle #cloud

3 min read

Franck Pachot

Apr 11

The cost of OKE for YugabyteDB - 3 - Run a workload

#yugabytedb #kubernetes #oracle #cloud

10 min read

Franck Pachot

Apr 11

The cost of OKE for YugabyteDB - 2 - Install from Helm chart

#yugabytedb #kubernetes #oracle #cloud

6 min read

Franck Pachot

Apr 11

The cost of OKE for YugabyteDB - 1 Create the cluster

#yugabytedb #kubernetes #oracle #cloud

4 min read

Franck Pachot

Apr 4

Index Skip Scan in YugabyteDB 🚀🐘

#postgres #yugabyted #distributed #sql

11 min read

Franck Pachot for YugabyteDB

Apr 1

Directus on YugabyteDB

#yugabytedb #nocode #distributed #sql

7 1

4 min read

Franck Pachot for AWS Heroes

Mar 19

PostgreSQL GIN + B-Tree

#postgres #gin #btree #index

6 min read

Franck Pachot for YugabyteDB

Mar 18

Efficient pagination in YugabyteDB & PostgreSQL 📃🐘🚀

#yugabytedb #postgres #pagination #sql

10 min read

Franck Pachot for YugabyteDB

Mar 16

Serverless DB connections: Lambda to YugabyteDB 🚀

#yugabytedb #lambda #serverless #distributedsystems

17 min read

Franck Pachot for AWS Heroes

Mar 13

PostgreSQL index partition in same tablespace as table

#postgres #tablespace #partition #index

6 min read

Franck Pachot for YugabyteDB

Mar 10

Avoiding hotspots in pgbench on 🐘or🚀

#postgres #yugabytedb #sql #database

9 min read

Franck Pachot for AWS Heroes

Mar 4

PostgreSQL on ARM: default page size matters

#postgres #graviton #arm #pagesize

9 min read

Franck Pachot for YugabyteDB

Mar 1

YugabyteDB on Public network 🚀🌐

#yugabytedb #distributed #sql #database

7 min read

Franck Pachot

Mar 1

Computed columns in PostgreSQL 🐘 / YugabyteDB🚀

#postgres #yugabytedb #sql #database

4 min read

Franck Pachot for YugabyteDB

Feb 25

Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB

#yugabytedb #sql #database #postgres

7 2

7 min read

Franck Pachot for YugabyteDB

Feb 23

Reference Tables as duplicate covering indexes

#yugabytedb #distributed #sql #database

16 min read

Franck Pachot for AWS Heroes

Feb 23

🔶🚀 YugabyteDB on Amazon EKS

#aws #yugabytedb #kubernetes #database

13 min read

Franck Pachot for YugabyteDB

Feb 18

Table size in YugabyteDB, PostgreSQL and Oracle 🅾🐘🚀

#yugabytedb #postgres #oracle #size

11 min read

Franck Pachot for YugabyteDB

Feb 17

SQLcl to transfer data from Oracle to PostgreSQL or YugabyteDB 🅾🐘🚀

#postgres #yugabytedb #oracle #csv

3 min read

Franck Pachot for YugabyteDB

Feb 17

YugabyteDB table_id UUID for PostgreSQL tables

#yugabytedb #distributed #sql #database

6 min read

Franck Pachot

Feb 9

Most recent record (of many items) with YugabyteDB 🚀

#postgres #yugabytedb #distributed #sql

11 min read

Franck Pachot for YugabyteDB

Feb 9

YBDemo: simple 💻 demo lab for YugabyteDB with Java client and Docker🚀☕🐳🐘

#yugabytedb #docker #jdbc #sql

1 min read

Franck Pachot for YugabyteDB

Feb 7

REST Data Service on YugabyteDB / PostgreSQL

#postgres #yugabytedb #rest #sql

3 min read

Franck Pachot for YugabyteDB

Feb 7

Retry logic for optimistic locking and transparent failover 🐘🚀

#yugabytedb #postgres #optimistic #retry

8 min read

Franck Pachot

Jan 26

Delete column statistics in PostgreSQL or YugabyteDB 🐘🚀

#postgres #yugabytedb #sql #database

2 min read

Franck Pachot for YugabyteDB

Jan 18

Maintain a duplicate covering index in a region

#yugabytedb #distributed #sql #database

7 min read

Franck Pachot for YugabyteDB

Jan 14

Quick 📊 on 🐘 active SQL from pg_stat_activity

#postgres #yugabytedb #sql #database

5 min read

Franck Pachot for YugabyteDB

Jan 6

Scaling Token Buckets Rate limiting with YugabyteDB

#yugabytedb #sql #distributed #database

7 min read

Franck Pachot for AWS Heroes

Jan 6

Optimistic or Pessimistic locking for Token Buckets Rate limiting in PostgreSQL

#postgres #sql #database #serializable

10 min read

Franck Pachot for YugabyteDB

Jan 4

YugabyteDB JDBC Smart Driver for proxyless HA/LB

#yugabytedb #distributed #sql #database

18 min read

Franck Pachot for AWS Heroes

Jan 3

PostgreSQL Bitmap Scan with GIN indexes on Array or Secondary Table with Index Only Scan

#postgres #sql #database #array

4 min read

Franck Pachot for YugabyteDB

Jan 3

Rate limiting with PostgreSQL / YugabyteDB (token buckets function)

#yugabytedb #sql #distributed #postgres

6 1

7 min read

Franck Pachot for YugabyteDB

Jan 2

SQL to avoid data corruption in race conditions with SERIALIZABLE 🐘 🚀

#postgres #yugabytedb #sql #database

6 2

5 min read

Franck Pachot for YugabyteDB

Dec 21 '21

🐘🚀 Triggers & Stored Procedures for pure data integrity logic and performance

#yugabytedb #postgres #sql #database

5 2

15 min read

Franck Pachot for YugabyteDB

Dec 8 '21

Quick 📸 on 🐘 active SQL from pg_stat_statements

#postgres #yugabytedb #sql #database

3 min read

DEV Community is a community of 871,665 amazing developers

AWS Heroes

YugabyteDB

Recent comments

UUID/GUID, CUID & NanoID: What's The Difference?

Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB

What is a LSM Tree?

Stop AWS Account Hacks

SQL to avoid data corruption in race conditions with SERIALIZABLE 🐘 🚀

TIL: MySQL timestamp column can't go beyond '2038-01-19 03:14:07'

🐘🚀 Triggers & Stored Procedures for pure data integrity logic and performance

VisiData to read JSON, HTML and YugabyteDB