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

YeSQL

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

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

Featured

See All Featured
A Modern Web Designer's Workflow
Avatar for Chris Coyier chriscoyier
698
190k
Faster Mobile Websites
Avatar for Dean Hume deanohume
310
31k
The agentic SEO stack - context over prompts
Avatar for schlessera schlessera
0
580
Building the Perfect Custom Keyboard
Avatar for Naoto Takai takai
2
670
SEOcharity - Dark patterns in SEO and UX: How to avoid them and build a more ethical web
Avatar for Sara Fernández Carmona sarafernandez
0
98
Future Trends and Review - Lecture 12 - Web Technologies (1019888BNR)
Avatar for Beat Signer signer
PRO
0
3.1k
Color Theory Basics | Prateek | Gurzu
Avatar for Gurzu gurzu
0
160
The Limits of Empathy - UXLibs8
Avatar for Cassini Nazir cassininazir
1
200
Chasing Engaging Ingredients in Design
Avatar for Sebastian Deterding codingconduct
0
93
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
Avatar for Vitaly Friedman smashingmag
254
22k
AI in Enterprises - Java and Open Source to the Rescue
Avatar for ivargrimstad ivargrimstad
0
1.1k
10 Git Anti Patterns You Should be Aware of
Avatar for Lemi Orhan Ergin lemiorhan
PRO
659
61k

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!