~/talks

Lætitia Avrot

what they talk about

all 4 in the filters

where they keep going back

all 6 in the filters

on a stage with

who talks about the same things

titleconferencedate
PostgreSQL Analytics: It's a Trap!Devoxx France 20262026-04-22
This talk analyzes PostgreSQL's architecture to identify its real limitations for analytics (notably row-oriented storage) and explains how PostgreSQL 18…
Talk in French on
SQL vs PrejudiceDevoxx France 20262026-04-22
A PostgreSQL expert challenges common prejudices about SQL—claims that it is obsolete, overly complex, or unsuitable for modern data—and defends SQL by showing…
Talk in French on
Can PostgreSQL Compete with Analytics Specialists?PostgreSQL Conference Europe 20252025-10-21
Argues PostgreSQL can handle most analytics if tuned, claiming 95% of cases PostgreSQL is good enough while admitting a real 5% need purpose-built engines…
Talk on
SQL vs PrejudiceForum PHP 20252025-10-09
Compares common prejudices about SQL with how SQL actually works, discussing concrete misconceptions and demonstrating correct usage and best practices for…
Talk in French on
Rethinking PostgreSQL Performance in the Age of Monster HardwarePGConf.dev 20252025-05-13
Postgres is largely not NUMA-aware, so on modern multi-socket servers shared_buffers can sit on a different NUMA node than worker processes, increasing…
Talk on
Untangling the Web of PostgreSQL PermissionsPostgreSQL Conference Europe 20242024-10-22
States that create user/group are aliases for create role and roles are cluster-wide not per-database, so use pg_dumpall -g to export them; shows psql…
Talk on
Interview of Lætitia AvrotDevoxx France 20242024-04-17
Solves Advent of Code puzzles using pure SQL, claiming it’s feasible and educational while noting some queries run for three days before returning results…
Interview on
Interview of Lætitia Avrot And Karen JexDevoxx France 20242024-04-17
Claims that 56% leave 10–20 years into their careers (about double the male rate) and that 90% report imposter syndrome anchor the conversation, backed by…
Interview on
Trying to be Barbie in Ken's Mojo Dojo Casa HouseDevoxx France 20242024-04-17
Europe shows women in tech at 22% of roles and a projected shortage of 1.4–3.9 million workers by 2027; open source Postgres lists 96 contributors, 4 women and…
Talk on
SQL for NerdsDevoxx France 20242024-04-17
Shows how to solve Advent of Code puzzles using only PostgreSQL SQL (no PL/pgSQL). Describes loading raw inputs with psql \copy, making scripts idempotent via…
Talk in French on
Learning advanced SQL the weird (and hard) wayPostgreSQL Conference Europe 20232023-12-12
Claims to solve Advent of Code puzzles using only Postgres SQL and succeeds on many days, beating a Java attempt by one home competitor. Uses Postgres 17 with…
Talk on
Trying to be Barbie in Ken's Mojo Dojo Casa HousePostgreSQL Conference Europe 20232023-12-12
Women occupy roughly 20% of tech roles in Europe and within PostgreSQL only 4 of 96 contributors and 2 of 41 major contributors are women while the core team…
Talk on
Forum PHP 2022 - October 13 & 14 - Conference Center - Disney Hotel New York - The Art of MarvelForum PHP 20222022-10-13
An event recap for Forum PHP 2022 held 13–14 October at Disney Hotel New York’s conference center titled "The Art of Marvel." It mentions membership and…
Talk in French
The I in ACIDPGConf NYC 20222022-09-22
Clear definitions of ACID with focus on isolation anomalies: dirty read, lost update, non‑repeatable read and phantom read, each shown with concrete bank or…
Talk on
PostgreSQL WafflesFOSDEM 20212021-02-06
FOSDEM would not be FOSDEM without waffles... What if we coud use Postgres to make waffles ? During this talk we will use the excuse of FOSDEM and Brussels to…
Talk
~/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.