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

Blogs about by Vlad Mihalcea about YugabyteDB

Blogs about by Vlad Mihalcea about YugabyteDB

Comments
1 min read

Want to connect with Franck Pachot?

Create an account to connect with Franck Pachot. You can also sign in below to proceed if you already have an account.

Already have an account? Sign in
YugabyteDB: when provisional records are applied to RegularDB from IntentsDB

YugabyteDB: when provisional records are applied to RegularDB from IntentsDB

Comments
5 min read
DynamoDB local in Docker

DynamoDB local in Docker

Reactions 4 Comments
5 min read
pREST on YugabyteDB

pREST on YugabyteDB

Reactions 1 Comments
4 min read
FerretDB + YugabyteDB on Kubernetes (Amazon EKS): a MongoDB API to Distributed SQL, at scale

FerretDB + YugabyteDB on Kubernetes (Amazon EKS): a MongoDB API to Distributed SQL, at scale

Reactions 6 Comments
5 min read
generate_series() in Oracle like in PostgreSQL

generate_series() in Oracle like in PostgreSQL

Reactions 1 Comments
2 min read
YugabyteDB Helm Chart services: LoadBalancer and headless ClusterIP ☸️🚀

YugabyteDB Helm Chart services: LoadBalancer and headless ClusterIP ☸️🚀

Reactions 2 Comments
6 min read
When are PostgreSQL prepared statements fully prepared for execution?

When are PostgreSQL prepared statements fully prepared for execution?

Reactions 4 Comments
5 min read
SQL doesn't need the "Single Table Design" but Composite Primary Keys

SQL doesn't need the "Single Table Design" but Composite Primary Keys

Reactions 13 Comments
13 min read
🚀Batched Nested Loop to reduce read requests to the distributed storage

🚀Batched Nested Loop to reduce read requests to the distributed storage

Reactions 3 Comments
8 min read
Scalable Sequence for PostgreSQL

Scalable Sequence for PostgreSQL

Reactions 2 Comments
6 min read
Parallel export to CSV in YugabyteDB thanks to yb_hash_code() and PostgreSQL-compatibility

Parallel export to CSV in YugabyteDB thanks to yb_hash_code() and PostgreSQL-compatibility

Reactions 1 Comments
3 min read
Migrating from Oracle Autonomous Database to YugabyteDB with YB-Voyager

Migrating from Oracle Autonomous Database to YugabyteDB with YB-Voyager

Comments
5 min read
Data Rollup in YugabyteDB🚀 and PostgreSQL🐘

Data Rollup in YugabyteDB🚀 and PostgreSQL🐘

Reactions 3 Comments
4 min read
Install extensions from PGDG repo to YugabyteDB - example with sequential_uuids

Install extensions from PGDG repo to YugabyteDB - example with sequential_uuids

Reactions 2 Comments
5 min read
Adding a PostgreSQL extension to YugabyteDB - example with timestamp9

Adding a PostgreSQL extension to YugabyteDB - example with timestamp9

Comments
6 min read
A very short demo on updates in YugabyteDB

A very short demo on updates in YugabyteDB

Reactions 3 Comments
3 min read
IvorySQL - I've tested some Oracle-PostgreSQL compatibility of version 2.1

IvorySQL - I've tested some Oracle-PostgreSQL compatibility of version 2.1

Comments
10 min read
Find active forks of a GitHub repository

Find active forks of a GitHub repository

Reactions 3 Comments
2 min read
Moving data from CockroachDB🪳 to PostgreSQL🐘 or YugabyteDB🚀

Moving data from CockroachDB🪳 to PostgreSQL🐘 or YugabyteDB🚀

Reactions 9 Comments
8 min read
A very short demo to show YugabyteDB follower reads

A very short demo to show YugabyteDB follower reads

Reactions 2 Comments
2 min read
INSERT ON CONFLICT returning old values

INSERT ON CONFLICT returning old values

Reactions 4 Comments
3 min read
SQL Macros in YugabyteDB with PostgreSQL UDF

SQL Macros in YugabyteDB with PostgreSQL UDF

Reactions 4 Comments
4 min read
EXPLAIN (ANALYZE, DIST) 🚀 YugabyteDB distributed execution plan

EXPLAIN (ANALYZE, DIST) 🚀 YugabyteDB distributed execution plan

Reactions 3 Comments
3 min read
What is a "truly distributed UDF" ?

What is a "truly distributed UDF" ?

Reactions 7 Comments
4 min read
Partial Index as an approximate Count(*) Materialized View

Partial Index as an approximate Count(*) Materialized View

Reactions 2 Comments
3 min read
Index usage monitoring in YugabyteDB & PostgreSQL

Index usage monitoring in YugabyteDB & PostgreSQL

Reactions 3 Comments
11 min read
Scalable Job Queue in SQL (YugabyteDB)

Scalable Job Queue in SQL (YugabyteDB)

Reactions 21 Comments 3
5 min read
The best indexes for an execution plan that never gets (too) wrong

The best indexes for an execution plan that never gets (too) wrong

Reactions 2 Comments
15 min read
Patroni and Availability Zone failure

Patroni and Availability Zone failure

Reactions 4 Comments
5 min read
DuckDB on YugabyteDB

DuckDB on YugabyteDB

Reactions 4 Comments
4 min read
Cross-cluster async replication with YugabyteDB xCluster

Cross-cluster async replication with YugabyteDB xCluster

Reactions 2 Comments
6 min read
YugabyteDB auto-sharding (showing tablet size with Grafana)

YugabyteDB auto-sharding (showing tablet size with Grafana)

Reactions 4 Comments
8 min read
Flashback query in YugabyteDB

Flashback query in YugabyteDB

Reactions 1 Comments
6 min read
How far is my AWS region?

How far is my AWS region?

Reactions 4 Comments 1
7 min read
MariaDB Xpand Distributed MySQL

MariaDB Xpand Distributed MySQL

Reactions 2 Comments
8 min read
LSM Tree, Tombstones and YugabyteDB 🚀

LSM Tree, Tombstones and YugabyteDB 🚀

Reactions 7 Comments
9 min read
YugabyteDB on OKE: testing batch size for bulk load

YugabyteDB on OKE: testing batch size for bulk load

Reactions 1 Comments
8 min read
Gitpod with YugabyteDB image

Gitpod with YugabyteDB image

Comments
2 min read
Mastodon on YugabyteDB

Mastodon on YugabyteDB

Reactions 6 Comments
4 min read
🚀 Autonomous Sharding in YugabyteDB (with automatic tablet splitting)

🚀 Autonomous Sharding in YugabyteDB (with automatic tablet splitting)

Comments
5 min read
YugabyteDB cloud/region/zone

YugabyteDB cloud/region/zone

Reactions 3 Comments
4 min read
How to set Read Committed in YugabyteDB

How to set Read Committed in YugabyteDB

Reactions 3 Comments 2
2 min read
Dirty Reads in Oracle Database (is Oracle ACID across failure?)

Dirty Reads in Oracle Database (is Oracle ACID across failure?)

Reactions 10 Comments 2
5 min read
YugabyteDB Skip Scan aka Loose Index Scan on compound index

YugabyteDB Skip Scan aka Loose Index Scan on compound index

Reactions 2 Comments
5 min read
Is CosmosDB a new SQL database? Is CitusDB a distributed SQL database? Has Hyperscale vanished in the Hyperspace?

Is CosmosDB a new SQL database? Is CitusDB a distributed SQL database? Has Hyperscale vanished in the Hyperspace?

Reactions 4 Comments
6 min read
SingleStore - is there a workaround for unsupported Foreign Key?

SingleStore - is there a workaround for unsupported Foreign Key?

Reactions 2 Comments
6 min read
pg_hint_plan: Get the right plan without surprises

pg_hint_plan: Get the right plan without surprises

Reactions 1 Comments
1 min read
Real Application Testing on 🚀YugabyteDB 🐘pgreplay

Real Application Testing on 🚀YugabyteDB 🐘pgreplay

Reactions 3 Comments
4 min read
Moving rows from one table to the other 🐘 🚀

Moving rows from one table to the other 🐘 🚀

Comments
2 min read
Testing Patroni strict synchronous mode 👉🏻 you must handle invisible commit and read split brain

Testing Patroni strict synchronous mode 👉🏻 you must handle invisible commit and read split brain

Reactions 1 Comments
5 min read
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 5 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
loading...