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

Work

Developer Advocate at Yugabyte

Pinned

Franck Pachot for Yugabyte

Mar 21 '21

Foreign Keys in MySQL, NoSQL, NewSQL (YugaByteDB)

#foreignkey #sql #yugabytedb #postgres

11 min read

Franck Pachot for Yugabyte

Jan 18

Maintain a duplicate covering index in a region

#yugabytedb #distributed #sql #database

7 min read

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

Learn how to write SQL recursive CTE in 5 steps

Michael, to be fair, Oracle had CONNECT BY from the initial v...

Dec 19 '21

Linux buffered write latency

Adding to this, to help google searches, that Available Memor...

Nov 24 '21

Stored Procedures - love or leave 'em?

On the "love or leave 'em?" question, I easily apply a three-...

Oct 22 '21

View all 11 comments

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

7 min read

Franck Pachot for Yugabyte

Jan 2

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

#postgres #yugabytedb #sql #database

8 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

4 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

41 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

Franck Pachot for Yugabyte

Sep 3 '21

Index Scan in YugabyteDB

#yugabytedb #index #database

7 min read

Franck Pachot for Yugabyte

Aug 30 '21

UUID or cached sequences?

#database #postgres #sql #yugabytedb

7 min read

Franck Pachot for AWS Heroes

Aug 24 '21

Pressure Stall Information on CentOS7

#linux #performance #psi

3 min read

Franck Pachot for AWS Heroes

Aug 24 '21

Index Only Scan on Functional Indexes

#postgres #sql #database

20 2

4 min read

Franck Pachot for AWS Heroes

Aug 22 '21

A kind of flashback query in PostgreSQL

#postgres #database #sql

3 min read

Franck Pachot for Yugabyte

Aug 19 '21

pgbench --client --jobs

#postgres #pgbench

8 min read

Franck Pachot for Yugabyte

Aug 17 '21

usql on YugabyteDB

#yugabytedb #sql #database

4 min read

Franck Pachot for Yugabyte

Aug 5 '21

Visible number of cpu on OpenVZ and LXC

#containers #kubernetes #openvz #cpu

5 min read

Franck Pachot for Yugabyte

Aug 2 '21

VisiData to read JSON, HTML and YugabyteDB

#visidata #yugabytedb

4 2

5 min read

Franck Pachot for AWS Heroes

Jul 28 '21

PostgreSQL prepared statements in PL/pgSQL

#postgres #plpgsql #prepared #oltp

4 min read

Franck Pachot for Yugabyte

Jul 28 '21

Arctype connects to YugabyteDB

#sql #yugabytedb

6 min read

Franck Pachot for Yugabyte

Jul 27 '21

SLOB on YugabyteDB

#yugabytedb #benchmark #slob

6 min read

Franck Pachot for Yugabyte

Jul 21 '21

YugabyteDB on OCI Free Tier

#yugabytedb

3 min read

Franck Pachot for Yugabyte

Jul 19 '21

jOOQ on YugabyteDB

#java #yugabytedb #jooq #sql

5 min read

Franck Pachot for Yugabyte

Jul 14 '21

HASH or RANGE in distributed databases

#sql #sharding #yugabytedb #database

11 min read

Franck Pachot for AWS Heroes

Jul 13 '21

READ COMMITTED anomalies in PostgreSQL

#database #sql #postgres

5 min read

Franck Pachot for Yugabyte

Jul 8 '21

EXPLAIN ANALYZE on COUNT() pushdown

#yugabytedb #postgres #explain #database

7 min read

Franck Pachot for Yugabyte

Jul 5 '21

pg_hint_plan and single-table cardinality correction

#postgres #yugabytedb #sql #database

8 min read

Franck Pachot for AWS Heroes

May 29 '21

Amazon RDS Oracle in Multitenant

#rds #oracle #cdb #multitenant

6 min read

Franck Pachot for AWS Heroes

May 19 '21

PostgreSQL on AWS Graviton2: CFLAGS

#postgres #database #aarch64 #aws

8 min read

Franck Pachot for AWS Heroes

May 15 '21

AWS Aurora vs. RDS PostgreSQL on frequent commits

#aws #postgres #aurora #database

7 min read

Franck Pachot for AWS Heroes

May 15 '21

AWS Aurora IO:XactSync is not a PostgreSQL wait event

#aws #postgres #aurora #database

10 min read

Franck Pachot for AWS Heroes

May 15 '21

Oracle Standard Edition on AWS ☁ socket arithmetic

#oracle #standardedition #aws #license

6 min read

Franck Pachot for AWS Heroes

May 15 '21

AWS: PostgreSQL on Graviton2 with newer GCC

#aws #postgres #graviton2 #gcc

18 min read

Franck Pachot

May 15 '21

An example of ORA-01152: file ... was not restored from a sufficiently old backup

#oracle #recovery #rman #resetlogs

20 min read

Franck Pachot for AWS Heroes

May 15 '21

DynamoDB / Aurora: sparse and partial indexes

#dynamodb #aurora #index #nosql

7 min read

Franck Pachot for AWS Heroes

May 15 '21

Amazon DynamoDB: a r(el)ational Glossary

#dynamodb #relational #table #item

9 min read

Franck Pachot

May 15 '21

El Carro: The Oracle Operator for Kubernetes

#google #oracle #operator #kubernetes

7 min read

Franck Pachot for Yugabyte

Apr 12 '21

K8s on Windows/VirtualBox (and a DB)

#kubernetes #windows #sql #yugabytedb

9 min read

DEV Community is a community of 787,570 amazing developers

AWS Heroes

Yugabyte

Recent comments

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

Learn how to write SQL recursive CTE in 5 steps

Linux buffered write latency

Stored Procedures - love or leave 'em?