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
45
Static Type Inferencing ... in Ruby?
Avatar for Danielle Smith daninithepanini
0
27
Off the Rails
Avatar for Danielle Smith daninithepanini
0
40
Action Game
Avatar for Danielle Smith daninithepanini
0
40
RubyGL
Avatar for Danielle Smith daninithepanini
0
31
Game Dev in Ruby
Avatar for Danielle Smith daninithepanini
0
40
Euler vs Hamilton
Avatar for Danielle Smith daninithepanini
0
45

Featured

See All Featured
Joys of Absence: A Defence of Solitary Play
Avatar for Sebastian Deterding codingconduct
1
360
Noah Learner - AI + Me: how we built a GSC Bulk Export data pipeline
Avatar for Tech SEO Connect techseoconnect
PRO
0
180
The SEO Collaboration Effect
Avatar for Kristina Bergwall kristinabergwall1
1
450
SEO for Brand Visibility & Recognition
Avatar for Aleyda Solis aleyda
0
4.5k
Leadership Guide Workshop - DevTernity 2021
Avatar for David Neal reverentgeek
1
280
The Art of Delivering Value - GDevCon NA Keynote
Avatar for David Neal reverentgeek
16
1.9k
Applied NLP in the Age of Generative AI
Avatar for Ines Montani inesmontani
PRO
4
2.2k
The Success of Rails: Ensuring Growth for the Next 100 Years
Avatar for Eileen M. Uchitelle eileencodes
47
8.1k
How to make the Groovebox
Avatar for あそなす asonas
2
2.2k
Discover your Explorer Soul
Avatar for Emna emna__ayadi
2
1.1k
Un-Boring Meetings
Avatar for Sebastian Deterding codingconduct
0
290
ラッコキーワード サービス紹介資料
Avatar for ラッコ株式会社 rakko
1
3.3M

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!