Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

YeSQL

Avatar for Danielle Smith Danielle Smith
July 01, 2015
34
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
160
A Brief History of Ruby
Avatar for Danielle Smith daninithepanini
0
61
Static Type Inferencing ... in Ruby?
Avatar for Danielle Smith daninithepanini
0
31
Off the Rails
Avatar for Danielle Smith daninithepanini
0
51
Action Game
Avatar for Danielle Smith daninithepanini
0
43
RubyGL
Avatar for Danielle Smith daninithepanini
0
34
Game Dev in Ruby
Avatar for Danielle Smith daninithepanini
0
49
Euler vs Hamilton
Avatar for Danielle Smith daninithepanini
0
57

Featured

See All Featured
Building Applications with DynamoDB
Avatar for Matt Wood mza
96
7.2k
SEO in 2025: How to Prepare for the Future of Search
Avatar for Michael King ipullrank
3
3.9k
Test your architecture with Archunit
Avatar for Yoan thirion
2
2.4k
The browser strikes back
Avatar for Jono Alderson jonoalderson
0
1.8k
Accessibility Awareness
Avatar for Sarah Abderemane sabderemane
1
230
Information Architects: The Missing Link in Design Systems
Avatar for Michelle Chin soysaucechin
1
1.2k
Max Prin - Stacking Signals: How International SEO Comes Together (And Falls Apart)
Avatar for Tech SEO Connect techseoconnect
PRO
0
470
Conquering PDFs: document understanding beyond plain text
Avatar for Ines Montani inesmontani
PRO
4
3.1k
Designing Experiences People Love
Avatar for Jonathan Moore moore
143
24k
The Mindset for Success: Future Career Progression
Avatar for Greg Gifford greggifford
PRO
0
520
Sharpening the Axe: The Primacy of Toolmaking
Avatar for Bryan Cantrill bcantrill
46
3k
Designing for Timeless Needs
Avatar for Cassini Nazir cassininazir
1
510

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!