Upgrade to Pro — share decks privately, control downloads, hide ads and more …

YeSQL

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for Danielle Smith Danielle Smith
July 01, 2015
28
0

 YeSQL

Short demonstration of PostgreSQL's JSON data type, as a SQL alternative to NoSQL.

Avatar for Danielle Smith

Danielle Smith

July 01, 2015

More Decks by Danielle Smith

See All by Danielle Smith
Ruby Ruby
Avatar for Danielle Smith daninithepanini
0
150
A Brief History of Ruby
Avatar for Danielle Smith daninithepanini
0
44
Static Type Inferencing ... in Ruby?
Avatar for Danielle Smith daninithepanini
0
26
Off the Rails
Avatar for Danielle Smith daninithepanini
0
39
Action Game
Avatar for Danielle Smith daninithepanini
0
39
RubyGL
Avatar for Danielle Smith daninithepanini
0
31
Game Dev in Ruby
Avatar for Danielle Smith daninithepanini
0
39
Euler vs Hamilton
Avatar for Danielle Smith daninithepanini
0
45

Featured

See All Featured
How Fast Is Fast Enough? [PerfNow 2025]
Avatar for Tammy Everts tammyeverts
3
540
Writing Fast Ruby
Avatar for Erik Berlin sferik
630
63k
Sam Torres - BigQuery for SEOs
Avatar for Tech SEO Connect techseoconnect
PRO
0
250
Stop Working from a Prison Cell
Avatar for Chris Michel hatefulcrawdad
274
21k
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
29
4.2k
Large-scale JavaScript Application Architecture
Avatar for Addy Osmani addyosmani
515
110k
HU Berlin: Industrial-Strength Natural Language Processing with spaCy and Prodigy
Avatar for Ines Montani inesmontani
PRO
0
320
We Analyzed 250 Million AI Search Results: Here's What I Found
Avatar for Josh Blyskal joshbly
1
1.2k
Optimising Largest Contentful Paint
Avatar for Harry Roberts csswizardry
37
3.6k
Lightning Talk: Beautiful Slides for Beginners
Avatar for Ines Montani inesmontani
PRO
1
530
Mind Mapping
Avatar for Hélio Medeiros helmedeiros
PRO
1
160
Context Engineering - Making Every Token Count
Avatar for Addy Osmani addyosmani
9
840

Transcript

  1. YeSQL PostgreSQL as a “NoSQL” Database

  2. Postgres JSONB • Unstructured data ⇐ (NoSQL bit) • Deeply-nestedly

    Query-able • Stored in binary format (small and fast) • Index-able! { } Hi, I’m Jason!

  3. Relational NoSQL • Unstructured data with relationships • Schema-less-ness with

    guaranteed safety • Have your NoSQL and join it, too!