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

YeSQL

Avatar for Danielle Smith Danielle Smith
July 01, 2015
0
24

 YeSQL

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

Danielle Smith

July 01, 2015
Tweet

More Decks by Danielle Smith

See All by Danielle Smith
Ruby Ruby
Avatar for Danielle Smith daninithepanini
0
140
A Brief History of Ruby
Avatar for Danielle Smith daninithepanini
0
39
Static Type Inferencing ... in Ruby?
Avatar for Danielle Smith daninithepanini
0
21
Off the Rails
Avatar for Danielle Smith daninithepanini
0
26
Action Game
Avatar for Danielle Smith daninithepanini
0
35
RubyGL
Avatar for Danielle Smith daninithepanini
0
26
Game Dev in Ruby
Avatar for Danielle Smith daninithepanini
0
36
Euler vs Hamilton
Avatar for Danielle Smith daninithepanini
0
40

Featured

See All Featured
Navigating Team Friction
Avatar for Lara Hogan lara
187
15k
VelocityConf: Rendering Performance Case Studies
Avatar for Addy Osmani addyosmani
332
24k
Typedesign – Prime Four
Avatar for Hannes Fritz hannesfritz
42
2.7k
Balancing Empowerment & Direction
Avatar for Lara Hogan lara
1
430
The Art of Delivering Value - GDevCon NA Keynote
Avatar for David Neal reverentgeek
15
1.5k
Done Done
Avatar for chrislema chrislema
184
16k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
Avatar for Stéphanie Walter stephaniewalter
281
13k
Learning to Love Humans: Emotional Interface Design
Avatar for Aarron Walter aarron
273
40k
Making the Leap to Tech Lead
Avatar for Ryan Cromwell cromwellryan
134
9.4k
A Tale of Four Properties
Avatar for Chris Coyier chriscoyier
160
23k
Fight the Zombie Pattern Library - RWD Summit 2016
Avatar for Marcelo Somers marcelosomers
233
17k
The Pragmatic Product Professional
Avatar for Laura Van Doore lauravandoore
35
6.7k

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!