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

YeSQL

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

Featured

See All Featured
KATA
Avatar for Megan Lloyd mclloyd
PRO
35
15k
Lightning Talk: Beautiful Slides for Beginners
Avatar for Ines Montani inesmontani
PRO
1
500
XXLCSS - How to scale CSS and keep your sanity
Avatar for Zaharenia Atzitzikaki sugarenia
249
1.3M
Reality Check: Gamification 10 Years Later
Avatar for Sebastian Deterding codingconduct
0
2.1k
Claude Code のすすめ
Avatar for schroneko schroneko
67
220k
Accessibility Awareness
Avatar for Sarah Abderemane sabderemane
0
93
The untapped power of vector embeddings
Avatar for Frank van Dijk frankvandijk
2
1.7k
Ruling the World: When Life Gets Gamed
Avatar for Sebastian Deterding codingconduct
0
190
Git: the NoSQL Database
Avatar for Brandon Keepers bkeepers
PRO
432
67k
Optimising Largest Contentful Paint
Avatar for Harry Roberts csswizardry
37
3.6k
The World Runs on Bad Software
Avatar for Brandon Keepers bkeepers
PRO
72
12k
Facilitating Awesome Meetings
Avatar for Lara Hogan lara
57
6.8k

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!