DEV Community 👩‍💻👨‍💻

Franck Pachot profile picture

Franck Pachot

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

Education

France

Work

Developer Advocate at Yugabyte

Use case - daily limit: SELECT FOR UPDATE vs. UPDATE RETURNING in 🐘Aurora and 🚀YugabyteDB

Use case - daily limit: SELECT FOR UPDATE vs. UPDATE RETURNING in 🐘Aurora and 🚀YugabyteDB

Reactions 1 Comments
7 min read
Declarative vs. Application side Foreign Key referential integrity

Declarative vs. Application side Foreign Key referential integrity

Reactions 3 Comments
10 min read
pg_stat_statements with pg_hint_plan

pg_stat_statements with pg_hint_plan

Reactions 5 Comments
3 min read
EXPLAIN from pg_stat_statements normalized queries: how to always get the generic plan in 🐘&🚀

EXPLAIN from pg_stat_statements normalized queries: how to always get the generic plan in 🐘&🚀

Reactions 4 Comments
6 min read
Nakama with YugabyteDB

Nakama with YugabyteDB

Reactions 3 Comments
2 min read
SingleStore compared to YugabyteDB

SingleStore compared to YugabyteDB

Reactions 2 Comments
6 min read
Read local partition first, then global if not found locally

Read local partition first, then global if not found locally

Reactions 5 Comments
7 min read
Fixing Docker image vulnerabilities (with centos2ol.sh)

Fixing Docker image vulnerabilities (with centos2ol.sh)

Reactions 3 Comments
4 min read
YugabyteDB in a Micro VM with no network

YugabyteDB in a Micro VM with no network

Comments
3 min read
pg_hint_plan with subqueries

pg_hint_plan with subqueries

Reactions 2 Comments
4 min read
Parallelizing aggregates in YugabyteDB

Parallelizing aggregates in YugabyteDB

Reactions 2 Comments
4 min read
Fastest start of YugabyteDB for a small lab

Fastest start of YugabyteDB for a small lab

Reactions 1 Comments
2 min read
Bookmarklet for YugabyteDB table's tablets

Bookmarklet for YugabyteDB table's tablets

Reactions 4 Comments
2 min read
Embedded FerretDB with YugabyteDB: MongoDB API on distributed SQL 🚀☁

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

Reactions 3 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 7 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 12 Comments
4 min read
find the partition key with a duplicate covering index local read

find the partition key with a duplicate covering index local read

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 9 Comments
4 min read
Local reads from 🚀YugabyteDB Read Replicas

Local reads from 🚀YugabyteDB Read Replicas

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

Local reads from 🚀YugabyteDB raft followers

Reactions 10 Comments 1
6 min read
🚀 hash+hash partitioning+sharding

🚀 hash+hash partitioning+sharding

Reactions 10 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? (Backward Scan in🚀)

YugabyteDB range sharding: ASC or DESC? (Backward Scan in🚀)

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 10 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
loading...