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
30
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
38
Euler vs Hamilton
Avatar for Danielle Smith daninithepanini
0
44

Featured

See All Featured
The SEO identity crisis: Don't let AI make you average
Avatar for Varn varn
0
64
Claude Code どこまでも/ Claude Code Everywhere
Avatar for nwiizo nwiizo
61
52k
Context Engineering - Making Every Token Count
Avatar for Addy Osmani addyosmani
9
650
sira's awesome portfolio website redesign presentation
Avatar for ElsiraPls elsirapls
0
140
Breaking role norms: Why Content Design is so much more than writing copy - Taylor Woolridge
Avatar for UX Y'all uxyall
0
160
How to Build an AI Search Optimization Roadmap - Criteria and Steps to Take #SEOIRL
Avatar for Aleyda Solis aleyda
1
1.9k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
Avatar for Dan Newman danielanewman
231
22k
Collaborative Software Design: How to facilitate domain modelling decisions
Avatar for Kenny Baas-Schwegler baasie
0
130
VelocityConf: Rendering Performance Case Studies
Avatar for Addy Osmani addyosmani
333
24k
Noah Learner - AI + Me: how we built a GSC Bulk Export data pipeline
Avatar for Tech SEO Connect techseoconnect
PRO
0
100
Designing for Timeless Needs
Avatar for Cassini Nazir cassininazir
0
130
Impact Scores and Hybrid Strategies: The future of link building
Avatar for Tamara Novitovic tamaranovitovic
0
200

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!