Schemaless SQL The Best of Both Worlds

on YouTube ↗33m

" summary

Shows how Postgres becomes a document store using hstore key/value column and PLV8 runs V8 inside Postgres to parse and index JSON. Demonstrates querying product attributes with hstore indexes, storing a million JSON rows, creating expression indexes to drop queries from minutes to milliseconds, and a Fibonacci benchmark where PLV8 outruns plpgsql (orders of magnitude faster after memoization). Mentions Wall-E backups, Postgres 9.2 JSON type, and ActiveRecord integration approaches.

AI-written summary · about

" chapters (8)

1. 0:00Introduction to speaker
2. 1:02Document vs relational data
3. 4:29Postgres features
4. 7:15Hstore for JSON data
5. 14:00PLV8 and Javascript
6. 22:47Advanced Javascript queries
7. 26:30Rails and ActiveRecord
8. 28:56Future of data storage

" related talks

• 59mPostgreSQL's secret NoSQL superpowersAmanda Gilmore · PGConf Silicon Valley 2016
• 53mThe NoSQL Store everyone ignores: PostgreSQLStephan Hochdorfer · PHP UK Conference 2015
• 29mPostgres DemystifiedCraig Kerstiens · MountainWest RubyConf 2013
• 43mEmbracing the Web with JSON and PLV8Will Leinweber · Postgres Open 2012
• 14mJSON data structure – the hidden gem inside your database engineMizanur Rahman · PHPConf.Asia 2018
• 20mLeveraging PLV8 in Javascript heavy Web ApplicationsTaras Mitran · Postgres Open 2012
• 42mNoSQL as Not Only SQLStefanie Janine Stölting · FrOSCon 2016
• 48mThe NoSQL Way in PostgreSQLVibhor Kumar · PostgresOpen 2014