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
41

Featured

See All Featured
Testing 201, or: Great Expectations
Avatar for Joseph Mastey jmmastey
46
7.7k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
Avatar for Morgane Peng morganepeng
132
19k
The MySQL Ecosystem @ GitHub 2015
Avatar for Sam Lambert samlambert
251
13k
Raft: Consensus for Rubyists
Avatar for Patrick Van Stee vanstee
140
7.2k
Designing Experiences People Love
Avatar for Jonathan Moore moore
142
24k
Easily Structure & Communicate Ideas using Wireframe
Avatar for Afnizar Nur Ghifari afnizarnur
194
16k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
Avatar for Kevin Liebholz kevinliebholz
36
6.1k
Dealing with People You Can't Stand - Big Design 2015
Avatar for Cassini Nazir cassininazir
367
27k
Music & Morning Musume
Avatar for Bryan Veloso bryan
46
6.9k
Why Our Code Smells
Avatar for Brandon Keepers bkeepers
PRO
340
57k
Agile that works and the tools we love
Avatar for Rasmus Luckow-Nielsen rasmusluckow
331
21k
Learning to Love Humans: Emotional Interface Design
Avatar for Aarron Walter aarron
274
41k

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!