~/talks

Franck Pachot

what they talk about

all 10 in the filters

where they keep going back

all 11 in the filters

on a stage with

all 7 in the filters

who talks about the same things

titleconferencedate
The Modern Database Debate: Documents, Tables, or Documents in Tables?IntelliJ IDEA Conf 20252025-06-03
Compares PostgreSQL and MongoDB with concrete examples: a Spring Data demo app shows many SQL round trips for normalized schemas versus single-document reads…
Talk on
Day 2IntelliJ IDEA Conf 20252025-06-03
Live demos focus on what actually changed and whether it worked: Juny agent edits code and runs tests (cloned Spring PetClinic, added logging, extracted…
Talk on
The ESR Equality Sort Range Rule of Composite IndexesPGConf India 20252025-03-05
Explains a concrete rule for Postgres composite indexes: put all equality first columns, then range columns, then the columns used for ORDER BY/LIMIT so the…
Talk on
SQL indexing: expressions, text fragments, JSON attributes and Top-N queriesVoxxed Days Luxembourg 20242024-06-20
How to create SQL indexes that go beyond simple columns by indexing expression results, text fragments (e.g., substrings or tokens), and JSON attributes to…
Talk in French on
Hibernate: Mapping Strategies and Their Database Performance ImpactJCON EUROPE 20242024-05-13
Compares Hibernate mapping choices by showing actual SQL and costs: sequence vs identity (default sequence cache 50 causes nextval calls; identity avoids…
Talk on
Technical Comparison of YugabyteDB with Oracle and PostgreSQLDistributed SQL Summit Asia 20242024-04-24
YugabyteDB claims to deliver Oracle-grade enterprise features by combining a Postgres query layer fork with a distributed storage layer built on RocksDB LSM…
Talk on
SQL Indexing Beyond Simple Columns: Expressions, Text Fragments, Attributes J...Devoxx France 20242024-04-17
Shows concrete SQL indexing techniques beyond simple columns: create expression indexes (e.g., trunc(date_delivery - date_order) for same‑day deliveries), use…
Talk in French on
Harness the Power of a Single Database for MicroservicesInfobip Shift 20232023-09-18
Argues that multiple microservices can share a single SQL database when using modern relational and distributed SQL features to isolate workloads and maintain…
Talk on
Harness the Power of a Single Database for MicroservicesJCON Europe 20232023-06-20
This session will delve into the benefits of using Distributed SQL for microservices. We will discuss the challenges of managing multiple databases in a…
Talk on
SQL (The Return): Demystifying Preconceptions and Using the DB EffectivelyDevoxx France 20232023-04-12
This talk argues that SQL remains modern: NoSQL systems adopt SQL features and new distributed SQL engines (Google Spanner, Yugabyte, and derivatives like…
Talk in French on
Distributed Loose Index Scan (aka Skip/Jump/Hybrid Scan): Time Series in YugabyteDBDistributed SQL Summit Asia 20232023-03-28
YugabyteDB implements a storage‑level iterator called a hybrid scan (aka Loose Index Scan) that jumps between index keys so a 31 million row time‑series table…
Talk on
Distributed SQL Tuning and Optimization in YugabyteDBDistributed SQL Summit 20222022-09-14
Workshop shows how YugabyteDB stores tables as primary-key indexes, splits data into tablets by hash or range, and replicates them (commonly replication factor…
Talk on
A DB on K8s, Cloud-Native, Open-Source, and PostgreSQL-Compatible: YugabyteDBVoxxed Days Luxembourg 20222022-06-21
YugabyteDB is a cloud-native, open-source, PostgreSQL-compatible distributed database designed to run on Kubernetes using StatefulSets. The talk demonstrates…
Talk in French on
Anatomy of a Distributed SQL Database - YugabyteDBDevoxx France 20222022-04-20
YugabyteDB is an open-source distributed SQL database that implements PostgreSQL features while scaling horizontally. The talk explains its cloud-native…
Talk in French on
YugabyteDB Elasticity and Resilience in ContainersDistributed SQL Summit Asia 20222022-03-30
Live demo of YugabyteDB on docker-compose and K8s helm shows a Java demo app, yb-master and yb-tserver containers (default eight tservers) actually handle…
Talk on
SQL primary key, surrogate key, composite keys, foreign keys... and JPAJoker 20212021-10-25
Practical rules for keys: use a generated surrogate id for stable joins and JPA object identity, but keep composite keys when the relationship itself is the…
Talk on
Microservices: Get Rid of Your DBA and Send the DB into BurnoutRiga Dev Days 20192019-05-29
Demo uses Oracle SQL and PL/SQL and the database’s multilingual engine to run JavaScript in the DB and measures CPU and latency when a simple money-transfer is…
Talk on
The code is back to the database with Oracle MLE (GraalVM)Voxxed Days CERN 20192019-05-01
Demonstrates Oracle Labs integrating GraalVM polyglot in-database so JavaScript and Python can run inside Oracle/MySQL, with a Docker beta that stores code as…
Talk on
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.