DEV Community

Franck Pachot profile picture

Franck Pachot

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

Education

France

Work

Developer Advocate at Yugabyte

Embedded FerretDB with YugabyteDB: MongoDB API on distributed SQL 🚀☁

Embedded FerretDB with YugabyteDB: MongoDB API on distributed SQL 🚀☁

Reactions 2 Comments
4 min read
🟩🚀 Draxlr SQL query/dashboard builder on YugabyteDB managed

🟩🚀 Draxlr SQL query/dashboard builder on YugabyteDB managed

Reactions 12 Comments
3 min read
Default tablet splitting in YugabyteDB 🚀

Default tablet splitting in YugabyteDB 🚀

Reactions 5 Comments
5 min read
📜 select * from 🚀 logfile with 🐘 file_fdw

📜 select * from 🚀 logfile with 🐘 file_fdw

Reactions 1 Comments
2 min read
YugabyteDB cardinality estimation in the absence of ANALYZE statistics

YugabyteDB cardinality estimation in the absence of ANALYZE statistics

Reactions 3 Comments
9 min read
IoT benchmark on Distributed SQL from MaibornWolff on AWS EKS

IoT benchmark on Distributed SQL from MaibornWolff on AWS EKS

Reactions 9 Comments
4 min read
⏳ Timing database calls to 🐘PostgreSQL or 🚀YugabyteDB (strace)

⏳ Timing database calls to 🐘PostgreSQL or 🚀YugabyteDB (strace)

Reactions 6 Comments 3
6 min read
🚀 YSQL-DocDB calls with yb_debug_log_docdb_requests

🚀 YSQL-DocDB calls with yb_debug_log_docdb_requests

Reactions 6 Comments
5 min read
access the local partition only in 🚀 YugabyteDB geo-partitioned tables

access the local partition only in 🚀 YugabyteDB geo-partitioned tables

Reactions 10 Comments
4 min read
find the partition key with a local read in 🚀 YugabyteDB geo-partitioned tables

find the partition key with a local read in 🚀 YugabyteDB geo-partitioned tables

Reactions 9 Comments 2
8 min read
JPA and PostgreSQL text

JPA and PostgreSQL text

Reactions 9 Comments 3
3 min read
The YugabyteDB configuration parameters (GFLAGs and GUCs)

The YugabyteDB configuration parameters (GFLAGs and GUCs)

Reactions 5 Comments
5 min read
Optimizing Nested Loop joins on YugabyteDB with jOOQ

Optimizing Nested Loop joins on YugabyteDB with jOOQ

Reactions 8 Comments
4 min read
geo-distribution with 🚀 YugabyteDB tablespaces

geo-distribution with 🚀 YugabyteDB tablespaces

Reactions 8 Comments
4 min read
Local reads from 🚀YugabyteDB Read Replicas

Local reads from 🚀YugabyteDB Read Replicas

Reactions 6 Comments
7 min read
Local reads from 🚀YugabyteDB raft followers

Local reads from 🚀YugabyteDB raft followers

Reactions 9 Comments
6 min read
🚀 hash+hash partitioning+sharding

🚀 hash+hash partitioning+sharding

Reactions 9 Comments
6 min read
(beta) yugabyted GUI

(beta) yugabyted GUI

Reactions 8 Comments
2 min read
PITR snapshot: an easy flashback / backtrack for application releases

PITR snapshot: an easy flashback / backtrack for application releases

Reactions 8 Comments
7 min read
Nested Loop performance in YugabyteDB

Nested Loop performance in YugabyteDB

Reactions 10 Comments
12 min read
Predictable plans with pg_hint_plan full hinting

Predictable plans with pg_hint_plan full hinting

Reactions 8 Comments
10 min read
Quickly get short stack from a YugabyteDB tserver

Quickly get short stack from a YugabyteDB tserver

Reactions 7 Comments
2 min read
YugabyteDB range sharding: ASC or DESC?

YugabyteDB range sharding: ASC or DESC?

Reactions 8 Comments
5 min read
ERROR: Timed out: BackfillIndex RPC

ERROR: Timed out: BackfillIndex RPC

Reactions 8 Comments
3 min read
Build a PostgreSQL Docker image with pg_hint_plan and pg_stat_statements

Build a PostgreSQL Docker image with pg_hint_plan and pg_stat_statements

Reactions 6 Comments
2 min read
YugabyteDB Predicate Push Down

YugabyteDB Predicate Push Down

Reactions 5 Comments
6 min read
1 million rows insert

1 million rows insert

Reactions 7 Comments
5 min read
tracing writes and locks in YugabyteDB

tracing writes and locks in YugabyteDB

Reactions 6 Comments
6 min read
Parsing YugabyteDB version()

Parsing YugabyteDB version()

Reactions 6 Comments
2 min read
pg_stat_statements in YugabyteDB

pg_stat_statements in YugabyteDB

Reactions 6 Comments
2 min read
PostgreSQL: An example of using WITH clauses to decompose the problem

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

Reactions 7 Comments
2 min read
🐘OID <-> 🚀table_id

🐘OID <-> 🚀table_id

Reactions 7 Comments
4 min read
🚀 YugabyteDB on fly.io - I - yugabyted

🚀 YugabyteDB on fly.io - I - yugabyted

Reactions 12 Comments
8 min read
docker-compose.yaml to start YugabyteDB with POSTGRES_USER POSTGRES_PASSWORD POSTGRES_DB env

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

Reactions 9 Comments
2 min read
🐘🚀 Update/Insert/Soft-Delete from a JSON payload

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

Reactions 6 Comments
4 min read
Read Committed is a must for Postgres-compatible distributed SQL databases

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

Reactions 9 Comments
7 min read
cluster-aware psycopg2 🚀

cluster-aware psycopg2 🚀

Reactions 6 Comments
7 min read
Soft delete cascade in PostgreSQL🐘 and YugabyteDB🚀

Soft delete cascade in PostgreSQL🐘 and YugabyteDB🚀

Reactions 19 Comments
5 min read
The cost of OKE for YugabyteDB - 4 - Explore the cost

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

Reactions 6 Comments
3 min read
The cost of OKE for YugabyteDB - 3 - Run a workload

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

Reactions 6 Comments
10 min read
The cost of OKE for YugabyteDB - 2 - Install from Helm chart

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

Reactions 6 Comments
6 min read
The cost of OKE for YugabyteDB - 1 Create the cluster

The cost of OKE for YugabyteDB - 1 Create the cluster

Reactions 6 Comments
4 min read
Index Skip Scan in YugabyteDB 🚀🐘

Index Skip Scan in YugabyteDB 🚀🐘

Reactions 7 Comments
11 min read
Directus on YugabyteDB

Directus on YugabyteDB

Reactions 7 Comments 1
4 min read
PostgreSQL GIN + B-Tree

PostgreSQL GIN + B-Tree

Reactions 6 Comments
6 min read
Efficient pagination in YugabyteDB & PostgreSQL 📃🐘🚀

Efficient pagination in YugabyteDB & PostgreSQL 📃🐘🚀

Reactions 6 Comments
10 min read
Serverless DB connections: Lambda to YugabyteDB 🚀

Serverless DB connections: Lambda to YugabyteDB 🚀

Reactions 5 Comments
17 min read
PostgreSQL index partition in same tablespace as table

PostgreSQL index partition in same tablespace as table

Reactions 7 Comments
7 min read
Avoiding hotspots in pgbench on 🐘or🚀

Avoiding hotspots in pgbench on 🐘or🚀

Reactions 3 Comments
9 min read
PostgreSQL on ARM: default page size matters

PostgreSQL on ARM: default page size matters

Reactions 8 Comments
9 min read
YugabyteDB on Public network 🚀🌐

YugabyteDB on Public network 🚀🌐

Reactions 4 Comments
7 min read
Computed columns in PostgreSQL 🐘 / YugabyteDB🚀

Computed columns in PostgreSQL 🐘 / YugabyteDB🚀

Reactions 2 Comments
4 min read
Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB

Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB

Reactions 7 Comments 2
7 min read
Reference Tables as duplicate covering indexes

Reference Tables as duplicate covering indexes

Reactions 7 Comments
16 min read
🔶🚀 YugabyteDB on Amazon EKS

🔶🚀 YugabyteDB on Amazon EKS

Reactions 8 Comments
13 min read
Table size in YugabyteDB, PostgreSQL and Oracle 🅾🐘🚀

Table size in YugabyteDB, PostgreSQL and Oracle 🅾🐘🚀

Reactions 6 Comments
11 min read
SQLcl to transfer data from Oracle to PostgreSQL or YugabyteDB 🅾🐘🚀

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

Reactions 6 Comments
3 min read
YugabyteDB table_id UUID for PostgreSQL tables

YugabyteDB table_id UUID for PostgreSQL tables

Reactions 6 Comments
6 min read
Most recent record (of many items) with YugabyteDB 🚀

Most recent record (of many items) with YugabyteDB 🚀

Reactions 7 Comments
11 min read
YBDemo: simple 💻 demo lab for YugabyteDB with Java client and Docker🚀☕🐳🐘

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

Reactions 4 Comments
1 min read
loading...