YugabyteDB YSQL Development
summary
Yugabyte YSQL claims near-Postgres compatibility while running on a distributed DocDB (custom RocksDB) storage engine; demos create a ybctl local three-node cluster with a replication factor of three so each table becomes three tablets (leader + two followers), show hash and range sharding, LSM indexes, GIN for jsonb, prepared statements, UDFs, triggers, materialized views and row-level geo-partitioning via table spaces. All demos run locally and validate that partitions land in the expected placement blocks.
AI-written summary · about
chapters (22)
- 0:00Start
- 0:12Housekeeping Items
- 5:23Free Tier
- 6:36Github Repository
- 11:27Distributed Data Storage
- 14:16Architecture
- 17:51Differences between You by Db and a Postgres Sql Database
- 20:00Enhancements to the Postgrad Sql Layer within Ysql
- 40:42Material Statements and Prepared Statements
- 46:50Function Overloading
- 48:38Math Functions
- 55:09Range Sharding Strategy
- 57:08Partial Indexes
- 58:12Global Flags
- 1:01:53Windows Functions
- 1:02:51Crosstab View
- 1:03:37Views
- 1:05:22Triggers
- 1:05:48Creating a Trigger Using Pl Postgresql
- 1:10:09Stored Procedures
- 1:12:23Materialized Views
- 1:13:54Table Partitions
related talks
25mYugabyteDB Technical Overview
30mTechnical Comparison of YugabyteDB with Oracle and PostgreSQL
27mIntroduction to YugabyteDB: Design and Architecture
47mAnatomy of a Distributed SQL Database - YugabyteDB
27mIntroduction to YugabyteDB – Design and Architecture
26mIntroducing YugabyteDB for PostgreSQL Users
30mBuilding Cloud Native Applications on Distributed SQL Platform
26mUnderstanding the Query Execution in YugabyteDB