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

YeSQL

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
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
Utilizing Notion as your number one productivity tool
Avatar for Mfonobong Umondia mfonobong
3
220
How to Ace a Technical Interview
Avatar for Jacob Kaplan-Moss jacobian
281
24k
Keith and Marios Guide to Fast Websites
Avatar for Keith Pitt keithpitt
413
23k
Pawsitive SEO: Lessons from My Dog (and Many Mistakes) on Thriving as a Consultant in the Age of AI
Avatar for David Carrasco davidcarrasco
0
62
Large-scale JavaScript Application Architecture
Avatar for Addy Osmani addyosmani
515
110k
Primal Persuasion: How to Engage the Brain for Learning That Lasts
Avatar for Mike Taylor tmiket
0
250
The Cult of Friendly URLs
Avatar for Andy Hume andyhume
79
6.8k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
Avatar for Irina Nazarova irinanazarova
9
1.2k
Leveraging Curiosity to Care for An Aging Population
Avatar for Cassini Nazir cassininazir
1
160
VelocityConf: Rendering Performance Case Studies
Avatar for Addy Osmani addyosmani
333
24k
Navigating the moral maze — ethical principles for Al-driven product design
Avatar for Skipper Chong Warson skipperchong
2
240
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
Avatar for panda_program panda_program
122
21k

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!