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

YeSQL

Avatar for Danielle Smith Danielle Smith
July 01, 2015
29
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
49
Static Type Inferencing ... in Ruby?
Avatar for Danielle Smith daninithepanini
0
27
Off the Rails
Avatar for Danielle Smith daninithepanini
0
44
Action Game
Avatar for Danielle Smith daninithepanini
0
41
RubyGL
Avatar for Danielle Smith daninithepanini
0
31
Game Dev in Ruby
Avatar for Danielle Smith daninithepanini
0
43
Euler vs Hamilton
Avatar for Danielle Smith daninithepanini
0
47

Featured

See All Featured
The Anti-SEO Checklist Checklist. Pubcon Cyber Week
Avatar for Ryan Jones ryanjones
0
170
The Psychology of Web Performance [Beyond Tellerrand 2023]
Avatar for Tammy Everts tammyeverts
49
3.5k
The Curious Case for Waylosing
Avatar for Cassini Nazir cassininazir
1
400
Why Our Code Smells
Avatar for Brandon Keepers bkeepers
PRO
340
58k
Lessons Learnt from Crawling 1000+ Websites
Avatar for Charles Meaden charlesmeaden
PRO
1
1.3k
We Have a Design System, Now What?
Avatar for Morgane Peng morganepeng
55
8.2k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
Avatar for Vitaly Friedman smashingmag
254
22k
No one is an island. Learnings from fostering a developers community.
Avatar for Antonio thoeni
21
3.8k
A Tale of Four Properties
Avatar for Chris Coyier chriscoyier
163
24k
Dominate Local Search Results - an insider guide to GBP, reviews, and Local SEO
Avatar for Greg Gifford greggifford
PRO
0
200
Groundhog Day: Seeking Process in Gaming for Health
Avatar for Sebastian Deterding codingconduct
0
210
Facilitating Awesome Meetings
Avatar for Lara Hogan lara
57
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!