DEV Community

Franck Pachot profile picture

Franck Pachot

đŸ”¶AWS Data Hero, đŸ…ŸOracle ACED & OCM, 🐘PostgreSQL fan, 😎 SQL fan, and Developer Advocate 🚀 YugabyteDB - open-source distributed SQL database

Work

Developer Advocate at Yugabyte

Maintain a duplicate covering index in a region

Maintain a duplicate covering index in a region

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

Quick 📊 on 🐘 active SQL from pg_stat_activity

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

Scaling Token Buckets Rate limiting with YugabyteDB

Reactions 6 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 8 Comments
10 min read
YugabyteDB JDBC Smart Driver for proxyless HA/LB

YugabyteDB JDBC Smart Driver for proxyless HA/LB

Reactions 5 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 5 Comments
7 min read
SQL to avoid data corruption in race conditions with SERIALIZABLE 🐘 🚀

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

Reactions 8 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 4 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 41 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 31 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 5 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 6 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
when you have millions of insert statements in a file...

when you have millions of insert statements in a file...

Reactions 28 Comments
6 min read
YugabyteDB on OKE

YugabyteDB on OKE

Reactions 1 Comments
11 min read
Aurora PostgreSQL db.r6g compared to db.r5 with YBIO

Aurora PostgreSQL db.r6g compared to db.r5 with YBIO

Reactions 11 Comments
8 min read
Index Scan in YugabyteDB

Index Scan in YugabyteDB

Reactions 3 Comments
7 min read
UUID or cached sequences?

UUID or cached sequences?

Reactions 11 Comments
7 min read
Pressure Stall Information on CentOS7

Pressure Stall Information on CentOS7

Reactions 6 Comments
3 min read
Index Only Scan on Functional Indexes

Index Only Scan on Functional Indexes

Reactions 20 Comments 2
4 min read
A kind of flashback query in PostgreSQL

A kind of flashback query in PostgreSQL

Reactions 9 Comments
3 min read
pgbench --client --jobs

pgbench --client --jobs

Reactions 3 Comments
8 min read
usql on YugabyteDB

usql on YugabyteDB

Reactions 2 Comments
4 min read
Visible number of cpu on OpenVZ and LXC

Visible number of cpu on OpenVZ and LXC

Reactions 5 Comments
5 min read
VisiData to read JSON, HTML and YugabyteDB

VisiData to read JSON, HTML and YugabyteDB

Reactions 4 Comments 2
5 min read
PostgreSQL prepared statements in PL/pgSQL

PostgreSQL prepared statements in PL/pgSQL

Reactions 7 Comments
4 min read
Arctype connects to YugabyteDB

Arctype connects to YugabyteDB

Reactions 2 Comments
6 min read
SLOB on YugabyteDB

SLOB on YugabyteDB

Reactions 2 Comments
6 min read
YugabyteDB on OCI Free Tier

YugabyteDB on OCI Free Tier

Reactions 5 Comments
3 min read
jOOQ on YugabyteDB

jOOQ on YugabyteDB

Reactions 2 Comments
5 min read
HASH or RANGE in distributed databases

HASH or RANGE in distributed databases

Reactions 1 Comments
11 min read
READ COMMITTED anomalies in PostgreSQL

READ COMMITTED anomalies in PostgreSQL

Reactions 8 Comments
5 min read
EXPLAIN ANALYZE on COUNT() pushdown

EXPLAIN ANALYZE on COUNT() pushdown

Reactions 4 Comments
7 min read
pg_hint_plan and single-table cardinality correction

pg_hint_plan and single-table cardinality correction

Reactions 7 Comments
8 min read
Amazon RDS Oracle in Multitenant

Amazon RDS Oracle in Multitenant

Reactions 1 Comments
6 min read
PostgreSQL on AWS Graviton2: CFLAGS

PostgreSQL on AWS Graviton2: CFLAGS

Reactions 1 Comments
8 min read
AWS Aurora vs. RDS PostgreSQL on frequent commits

AWS Aurora vs. RDS PostgreSQL on frequent commits

Reactions 9 Comments
7 min read
AWS Aurora IO:XactSync is not a PostgreSQL wait event

AWS Aurora IO:XactSync is not a PostgreSQL wait event

Reactions 3 Comments
10 min read
Oracle Standard Edition on AWS ☁ socket arithmetic

Oracle Standard Edition on AWS ☁ socket arithmetic

Reactions 2 Comments
6 min read
AWS: PostgreSQL on Graviton2 with newer GCC

AWS: PostgreSQL on Graviton2 with newer GCC

Reactions 3 Comments
18 min read
An example of ORA-01152: file ... was not restored from a sufficiently old backup

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

Reactions 1 Comments
20 min read
DynamoDB / Aurora: sparse and partial indexes

DynamoDB / Aurora: sparse and partial indexes

Reactions 5 Comments
7 min read
Amazon DynamoDB: a r(el)ational Glossary

Amazon DynamoDB: a r(el)ational Glossary

Reactions 2 Comments
9 min read
El Carro: The Oracle Operator for Kubernetes

El Carro: The Oracle Operator for Kubernetes

Reactions 1 Comments
7 min read
K8s on Windows/VirtualBox (and a DB)

K8s on Windows/VirtualBox (and a DB)

Reactions 6 Comments
9 min read
loading...