Is JSONB a Silver Bullet

  Рет қаралды 1,791

PostgresConf South Africa

PostgresConf South Africa

4 жыл бұрын

Angus Dippenaar
PostgresConf South Africa 2019
postgresconf.org/conferences/...
I've seen many times people giving JSONB praise. But is it the silver bullet they make it out to be?
I try to answer this question by taking some real-life data and testing how JSON(B) compares to tables in every-day database use-cases.

Пікірлер
PostgreSQL/PostGIS devops with Docker and Rancher
35:53
PostgreSQL/PostGIS devops with Docker and Rancher
PostgresConf South Africa
Рет қаралды 1,9 М.
Shadow Tables vers PGAudit
40:29
Shadow Tables vers PGAudit
PostgresConf South Africa
Рет қаралды 1,7 М.
Айбек Оралбай - Олайтан Олаоре | 92 кг | БОКС | Олимпиада | 1/16 финал
16:49
Айбек Оралбай - Олайтан Олаоре | 92 кг | БОКС | Олимпиада | 1/16 финал
Khabar SPORT
Рет қаралды 370 М.
The hard turtle was blasted into pieces |Chinese Mountain Forest Life And Food #MoTiktok #Fyp
00:19
The hard turtle was blasted into pieces |Chinese Mountain Forest Life And Food #MoTiktok #Fyp
Eater Straw Hat
Рет қаралды 29 МЛН
ЧУТЬ НЕ УТОНУЛ #shorts
00:27
ЧУТЬ НЕ УТОНУЛ #shorts
Паша Осадчий
Рет қаралды 10 МЛН
Fast and Furious: New Zealand 🚗
00:29
Fast and Furious: New Zealand 🚗
How Ridiculous
Рет қаралды 45 МЛН
What's all this fuss about Common Table Expressions (CTE's) anyway?
30:50
What's all this fuss about Common Table Expressions (CTE's) anyway?
PostgresConf South Africa
Рет қаралды 2,9 М.
PostgresOpen 2019 JSONB Tricks
47:42
PostgresOpen 2019 JSONB Tricks
Postgres Open
Рет қаралды 14 М.
Event Stores and Postgres
36:39
Event Stores and Postgres
PostgresConf South Africa
Рет қаралды 2 М.
Effectively securing your PostgreSQL database
40:23
Effectively securing your PostgreSQL database
PostgresConf South Africa
Рет қаралды 8 М.
Postgres Extensions
34:31
Postgres Extensions
PostgresConf South Africa
Рет қаралды 7 М.
Boriss Mejias: Should I use JSON in PostgreSQL? (PGConf.EU 2023)
48:47
Boriss Mejias: Should I use JSON in PostgreSQL? (PGConf.EU 2023)
PostgreSQL Europe
Рет қаралды 2,5 М.
Jonathan S. Katz: Vectors are the new JSON (PGConf.EU 2023)
48:10
Jonathan S. Katz: Vectors are the new JSON (PGConf.EU 2023)
PostgreSQL Europe
Рет қаралды 3,4 М.
AutoVacuum - Tuning and Monitoring
41:32
AutoVacuum - Tuning and Monitoring
PostgresConf South Africa
Рет қаралды 4,5 М.
Hans-Jürgen Schönig: Performance tricks you have never seen before 2.0 (PGConf.EU 2023)
44:34
Hans-Jürgen Schönig: Performance tricks you have never seen before 2.0 (PGConf.EU 2023)
PostgreSQL Europe
Рет қаралды 1,8 М.
Pydantic is all you need: Jason Liu
17:55
Pydantic is all you need: Jason Liu
AI Engineer
Рет қаралды 173 М.
Айбек Оралбай - Олайтан Олаоре | 92 кг | БОКС | Олимпиада | 1/16 финал
16:49
Айбек Оралбай - Олайтан Олаоре | 92 кг | БОКС | Олимпиада | 1/16 финал
Khabar SPORT
Рет қаралды 370 М.