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
ピンチをチャンスに：未来をつくるプロダクトロードマップ #pmconf2020
Avatar for Aki / @LoveIdahoBurger aki_iinuma
127
53k
Building Adaptive Systems
Avatar for Chris Keathley keathley
43
2.7k
Done Done
Avatar for chrislema chrislema
185
16k
Side Projects
Avatar for Sacha Greif sachag
455
43k
Building Applications with DynamoDB
Avatar for Matt Wood mza
96
6.6k
BBQ
Avatar for Matthew Crist matthewcrist
89
9.8k
Embracing the Ebb and Flow
Avatar for Simon Collison colly
87
4.8k
Building an army of robots
Avatar for Kyle Neath kneath
306
46k
StorybookのUI Testing Handbookを読んだ
Avatar for Shingo Yamazaki zakiyama
31
6.1k
Writing Fast Ruby
Avatar for Erik Berlin sferik
628
62k
Building a Modern Day 
E-commerce SEO Strategy
Avatar for Aleyda Solis aleyda
43
7.6k
JavaScript: Past, Present, and Future - NDC Porto 2020
Avatar for David Neal reverentgeek
52
5.6k

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!