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

geo-distribution with 🚀 YugabyteDB tablespaces

geo-distribution with 🚀 YugabyteDB tablespaces

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

Local reads from 🚀YugabyteDB Read Replicas

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

Local reads from 🚀YugabyteDB raft followers

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

🚀 hash+hash partitioning+sharding

Reactions 7 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
6 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 8 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 6 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
REST Data Service on YugabyteDB / PostgreSQL

REST Data Service on YugabyteDB / PostgreSQL

Reactions 6 Comments
3 min read
Retry logic for optimistic locking and transparent failover 🐘🚀

Retry logic for optimistic locking and transparent failover 🐘🚀

Reactions 7 Comments
8 min read
Delete column statistics in PostgreSQL or YugabyteDB 🐘🚀

Delete column statistics in PostgreSQL or YugabyteDB 🐘🚀

Comments
2 min read
Maintain a duplicate covering index in a region

Maintain a duplicate covering index in a region

Reactions 6 Comments
7 min read
Quick 📊 on 🐘 active SQL from pg_stat_activity

Quick 📊 on 🐘 active SQL from pg_stat_activity

Reactions 15 Comments
5 min read
Scaling Token Buckets Rate limiting with YugabyteDB

Scaling Token Buckets Rate limiting with YugabyteDB

Reactions 7 Comments
7 min read
Optimistic or Pessimistic locking for Token Buckets Rate limiting in PostgreSQL

Optimistic or Pessimistic locking for Token Buckets Rate limiting in PostgreSQL

Reactions 7 Comments
10 min read
YugabyteDB JDBC Smart Driver for proxyless HA/LB

YugabyteDB JDBC Smart Driver for proxyless HA/LB

Reactions 6 Comments
18 min read
PostgreSQL Bitmap Scan with GIN indexes on Array or Secondary Table with Index Only Scan

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

Reactions 6 Comments
4 min read
Rate limiting with PostgreSQL / YugabyteDB (token buckets function)

Rate limiting with PostgreSQL / YugabyteDB (token buckets function)

Reactions 6 Comments 1
7 min read
SQL to avoid data corruption in race conditions with SERIALIZABLE 🐘 🚀

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

Reactions 6 Comments 2
5 min read
🐘🚀 Triggers & Stored Procedures for pure data integrity logic and performance

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

Reactions 5 Comments 2
15 min read
Quick 📸 on 🐘 active SQL from pg_stat_statements

Quick 📸 on 🐘 active SQL from pg_stat_statements

Reactions 8 Comments
3 min read
loading...