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
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
48
Static Type Inferencing ... in Ruby?
Avatar for Danielle Smith daninithepanini
0
27
Off the Rails
Avatar for Danielle Smith daninithepanini
0
42
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
42
Euler vs Hamilton
Avatar for Danielle Smith daninithepanini
0
46

Featured

See All Featured
Lessons Learnt from Crawling 1000+ Websites
Avatar for Charles Meaden charlesmeaden
PRO
1
1.3k
Visual Storytelling: How to be a Superhuman Communicator
Avatar for David Neal reverentgeek
2
550
B2B Lead Gen: Tactics, Traps & Triumph
Avatar for Sophie Logan marketingsoph
0
130
SEO Brein meetup: CTRL+C is not how to scale international SEO
Avatar for Linda Hogenes lindahogenes
1
2.7k
Making Projects Easy
Avatar for Brett Harned brettharned
120
6.7k
How to Ace a Technical Interview
Avatar for Jacob Kaplan-Moss jacobian
281
24k
RailsConf 2023
Avatar for Aaron Patterson tenderlove
30
1.5k
How to Grow Your eCommerce with AI & Automation
Avatar for Katarina Dahlin katarinadahlin
PRO
1
200
Fantastic passwords and where to find them - at NoRuKo
Avatar for Phil Nash philnash
52
3.7k
StorybookのUI Testing Handbookを読んだ
Avatar for Shingo Yamazaki zakiyama
31
6.8k
Statistics for Hackers
Avatar for Jake VanderPlas jakevdp
799
230k
Raft: Consensus for Rubyists
Avatar for Patrick Van Stee vanstee
141
7.5k

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!