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

pg_stat_statements in YugabyteDB

pg_stat_statements in YugabyteDB

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 1 Comments
2 min read
"I want to try it" 🚀 YugabyteDB at KubeCon

"I want to try it" 🚀 YugabyteDB at KubeCon

Reactions 10 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 10 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
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
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 6 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
Learn how to write SQL recursive CTE in 5 steps

Learn how to write SQL recursive CTE in 5 steps

Reactions 44 Comments 8
6 min read
Quick 📸 on 🐘 active SQL from pg_stat_statements

Quick 📸 on 🐘 active SQL from pg_stat_statements

Reactions 7 Comments
3 min read
⏱ Read from the nearest peer in a multi-region database 🚀 with followers read

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

Reactions 6 Comments
12 min read
"Rows Removed by Index Recheck" on YugabyteDB Index Scan

"Rows Removed by Index Recheck" on YugabyteDB Index Scan

Reactions 5 Comments
8 min read
🌎🌍🌏 Yugabyte cross-continent deployment 🚀

🌎🌍🌏 Yugabyte cross-continent deployment 🚀

Reactions 1 Comments
11 min read
Yugabyte COPY batch size

Yugabyte COPY batch size

Reactions 1 Comments
4 min read
Text Search example with the OMDB sample database

Text Search example with the OMDB sample database

Reactions 1 Comments
7 min read
Query PostgreSQL, or any 🐘-compatible like Amazon Redshift, from YugabyteDB 🚀 thanks to Postgres FDW

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

Reactions 8 Comments
5 min read
Distributed SQL Essentials: Sharding and Partitioning in YugabyteDB

Distributed SQL Essentials: Sharding and Partitioning in YugabyteDB

Reactions 3 Comments
8 min read
kokizzu/hugedbbench

kokizzu/hugedbbench

Reactions 1 Comments
12 min read
ORDER BY is mandatory in SQL to get a sorted result

ORDER BY is mandatory in SQL to get a sorted result

Reactions 32 Comments
6 min read
🚀 Think about Primary Key & Indexes before anything else 🐘

🚀 Think about Primary Key & Indexes before anything else 🐘

Reactions 53 Comments
8 min read
Open-source🍃MongoDB API to 🚀YugabyteDB with 🥭MangoDB proxy

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

Reactions 6 Comments
7 min read
COPY progression in YugabyteDB

COPY progression in YugabyteDB

Reactions 6 Comments
5 min read
Boost Secondary Index Queries with Index Only Scan

Boost Secondary Index Queries with Index Only Scan

Reactions 6 Comments
11 min read
CREATE INDEX in YugabyteDB: online or fast?

CREATE INDEX in YugabyteDB: online or fast?

Reactions 3 Comments
6 min read
hyper-scale multi-tenant for SaaS: an example with pgbench

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

Reactions 7 Comments
12 min read
Bulk load into PostgreSQL / YugabyteDB - psycopg2

Bulk load into PostgreSQL / YugabyteDB - psycopg2

Reactions 5 Comments
4 min read
The cost and benefit of synchronous replication in PostgreSQL and YugabyteDB

The cost and benefit of synchronous replication in PostgreSQL and YugabyteDB

Reactions 5 Comments
8 min read
loading...