---
title: "Franck Pachot (@FranckPachot) | Hashnode"
description: "Dev. advocate on YugabyteDB. Read the latest articles by Franck Pachot on Hashnode."
url: "https://hashnode.com/@FranckPachot"
---

@FranckPachot

# Franck Pachot

@FranckPachot · Joined August 2021

Dev. advocate on YugabyteDB

### [Oracle 19c on ARM processors](https://pachot.net/oracle-19c-on-arm-processors?utm_source=hashnode&utm_medium=feed)

Oracle has announced Oracle Database for Arm Architectures and it is now available. Let's test it. A VM in the Cloud (Ampere processor) On the Oracle Cloud you can create a free ARM instance: I Choose the following image and shape: which was config...

3 min read · [pachot.net](https://pachot.net/oracle-19c-on-arm-processors?utm_source=hashnode&utm_medium=feed)

[Jun 30, 2023](https://hashnode.com/posts/oracle-19c-on-arm-processors/649e8b1465bd47e830d5ebeb)

### [Indexing JSON in PostgreSQL](https://pachot.net/indexing-json-in-postgresql?utm_source=hashnode&utm_medium=feed)

Indexing JSON documents in PostgreSQL is similar to indexing relational table columns. Although the structure is not enforced at write time like normalized tables, we can still add indexes for our access patterns. In SQL, we index the values we selec...

10 min read · [pachot.net](https://pachot.net/indexing-json-in-postgresql?utm_source=hashnode&utm_medium=feed)

[Jun 29, 2023](https://hashnode.com/posts/indexing-json-in-postgresql/649d9489db80d96029f0ff77)

### [when you have millions of insert statements in a file...](https://pachot.net/when-you-have-millions-of-insert-statements-in-a-file?utm_source=hashnode&utm_medium=feed)

Let's say you have a script of one million insert statements with literal values. Of course, this is a bad idea. SQL is a language, not a data exchange format. You should have a file to import with COPY, with all values as CSV for example. Or at leas...

6 min read · [pachot.net](https://pachot.net/when-you-have-millions-of-insert-statements-in-a-file?utm_source=hashnode&utm_medium=feed)

[Jun 29, 2023](https://hashnode.com/posts/when-you-have-millions-of-insert-statements-in-a-file/649d91e9880d8d359d066897)
