Franck Pachot

🔶AWS Data Hero, 🅾Oracle ACED & OCM, 🐘PostgreSQL fan, 😎 SQL fan, and Developer Advocate 🚀 YugabyteDB - open-source distributed SQL database

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

Education

France

Work

Developer Advocate at Yugabyte

Pinned

Franck Pachot for Yugabyte

Mar 18

Efficient pagination in YugabyteDB & PostgreSQL 📃🐘🚀

#yugabytedb #postgres #pagination #sql

10 min read

Franck Pachot for Yugabyte

Mar 16

Serverless DB connections: Lambda to YugabyteDB 🚀

#yugabytedb #lambda #serverless #distributedsystems

17 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 Yugabyte

May 16

🐘OID <-> 🚀table_id

#yugabytedb #distributed #sql #database

4 min read

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

Learn how to write SQL recursive CTE in 5 steps

Yes, ANSI joins introduced 20 years ago and still many bugs 🤷...

Dec 19 '21

View all 14 comments

Franck Pachot for Yugabyte

May 8

🚀 YugabyteDB on fly.io - I - yugabyted

#yugabytedb #distributed #sql #database

8 min read

Franck Pachot

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 Yugabyte

Apr 29

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

#yugabytedb #postgres #sql #database

4 min read

Franck Pachot for Yugabyte

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 Yugabyte

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 Yugabyte

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 AWS Heroes

Mar 13

PostgreSQL index partition in same tablespace as table

#postgres #tablespace #partition #index

6 min read

Franck Pachot for Yugabyte

Mar 10

Avoiding hotspots in pgbench on 🐘or🚀

#postgres #yugabytedb #sql #database

9 min read

Franck Pachot for Yugabyte

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 Yugabyte

Feb 25

Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB

#yugabytedb #sql #database #postgres

6 2

7 min read

Franck Pachot for Yugabyte

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 Yugabyte

Feb 18

Table size in YugabyteDB, PostgreSQL and Oracle 🅾🐘🚀

#yugabytedb #postgres #oracle #size

11 min read

Franck Pachot for Yugabyte

Feb 17

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

#postgres #yugabytedb #oracle #csv

3 min read

Franck Pachot for Yugabyte

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 Yugabyte

Feb 9

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

#yugabytedb #docker #jdbc #sql

1 min read

Franck Pachot for Yugabyte

Feb 7

REST Data Service on YugabyteDB / PostgreSQL

#postgres #yugabytedb #rest #sql

3 min read

Franck Pachot for Yugabyte

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 Yugabyte

Jan 18

Maintain a duplicate covering index in a region

#yugabytedb #distributed #sql #database

7 min read

Franck Pachot for Yugabyte

Jan 14

Quick 📊 on 🐘 active SQL from pg_stat_activity

#postgres #yugabytedb #sql #database

5 min read

Franck Pachot for Yugabyte

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 Yugabyte

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 Yugabyte

Jan 3

Rate limiting with PostgreSQL / YugabyteDB (token buckets function)

#yugabytedb #sql #distributed #postgres

6 1

7 min read

Franck Pachot for Yugabyte

Jan 2

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

#postgres #yugabytedb #sql #database

6 2

5 min read

Franck Pachot for Yugabyte

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 Yugabyte

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 Yugabyte

Dec 8 '21

Quick 📸 on 🐘 active SQL from pg_stat_statements

#postgres #yugabytedb #sql #database

3 min read

Franck Pachot

Dec 7 '21

⏱ Read from the nearest peer in a multi-region database 🚀 with followers read

#yugabytedb #distributed #sql #database

12 min read

Franck Pachot for Yugabyte

Dec 6 '21

"Rows Removed by Index Recheck" on YugabyteDB Index Scan

#yugabytedb #distributed #sql #database

8 min read

Franck Pachot for Yugabyte

Dec 1 '21

🌎🌍🌏 Yugabyte cross-continent deployment 🚀

#yugabytedb #distributed #sql #database

11 min read

Franck Pachot for Yugabyte

Nov 30 '21

Yugabyte COPY batch size

#yugabytedb #distributed #sql #database

4 min read

Franck Pachot for Yugabyte

Nov 29 '21

Text Search example with the OMDB sample database

#yugabytedb #distributed #sql #postgres

7 min read

Franck Pachot for AWS Heroes

Nov 22 '21

Query PostgreSQL, or any 🐘-compatible like Amazon Redshift, from YugabyteDB 🚀 thanks to Postgres FDW

#yugabytedb #redshift #sql #database

5 min read

Franck Pachot for Yugabyte

Nov 21 '21

Distributed SQL Essentials: Sharding and Partitioning in YugabyteDB

#yugabytedb #distributed #sql #webdev

8 min read

Franck Pachot

Nov 19 '21

kokizzu/hugedbbench

#yugabytedb #sql #database

12 min read

Franck Pachot for Yugabyte

Nov 15 '21

ORDER BY is mandatory in SQL to get a sorted result

#postgres #yugabytedb #sql #database

6 min read

Franck Pachot for Yugabyte

Nov 7 '21

🚀 Think about Primary Key & Indexes before anything else 🐘

#yugabytedb #database #postgres #sql

8 min read

Franck Pachot for Yugabyte

Nov 3 '21

Open-source🍃MongoDB API to 🚀YugabyteDB with 🥭MangoDB proxy

#postgres #yugabytedb #mongodb #proxy

7 min read

Franck Pachot for Yugabyte

Oct 28 '21

COPY progression in YugabyteDB

#yugabytedb #postgres #copy #database

5 min read

Franck Pachot for Yugabyte

Oct 20 '21

Boost Secondary Index Queries with Index Only Scan

#postgres #yugabytedb #index #sql

11 min read

Franck Pachot for Yugabyte

Oct 7 '21

CREATE INDEX in YugabyteDB: online or fast?

#yugabytedb #database #index #create

6 min read

Franck Pachot for Yugabyte

Oct 4 '21

hyper-scale multi-tenant for SaaS: an example with pgbench

#postgres #yugabytedb #pgbench #saas

12 min read

Franck Pachot for Yugabyte

Sep 28 '21

Bulk load into PostgreSQL / YugabyteDB - psycopg2

#postgres #python #database #copy

4 min read

Franck Pachot for Yugabyte

Sep 28 '21

The cost and benefit of synchronous replication in PostgreSQL and YugabyteDB

#postgres #yugabytedb #database #ha

8 min read

Franck Pachot for Yugabyte

Sep 22 '21

when you have millions of insert statements in a file...

#postgres #yugabytedb #sql #database

6 min read

Franck Pachot for Yugabyte

Sep 19 '21

YugabyteDB on OKE

#yugabytedb #oraclecloud #kubernetes #database

11 min read

Franck Pachot for AWS Heroes

Sep 6 '21

Aurora PostgreSQL db.r6g compared to db.r5 with YBIO

#aws #aurora #postgres #database

8 min read

DEV Community is a community of 848,284 amazing developers

AWS Heroes

Yugabyte

Recent comments

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

Learn how to write SQL recursive CTE in 5 steps