YugabyteDB YCQL Development

on YouTube ↗01h 21m

" summary

Yugabyte’s YCQL claims full Cassandra compatibility while adding strong consistency, semi-relational types (lists, maps, JsonB) and secondary indexes that are globally stored with transactions enabled. The demo boots a three-node Gitpod cluster, creates tables, shows explain plans (sequential scans read every row while index-only scans avoid main-table access), builds JsonB and unique/partial indexes, and proves row-scoped Time To Live deletion works in seconds.

AI-written summary · about

" chapters (60)

1. 0:00YugabyteDB introduction
2. 1:31Distributed SQL overview
3. 2:36YugabyteDB geo-distribution
4. 3:16Cassandra features limits
5. 4:20YugabyteDB architecture
6. 5:23SQL vs semi-relational model
7. 6:47Cassandra vs YCQL
8. 8:14YCQL DDL compatibility
9. 9:58Keyspaces in YCQL
10. 11:26Tables with semi-relational types
11. 12:09Document store sharding
12. 12:53Primary and clustering keys
13. 14:00Shard organization hashing
14. 15:47Tablets across nodes
15. 17:10Clustering keys sorting
16. 18:16Data manipulation YCQL
17. 20:24Query-driven data modeling
18. 21:50Four data modeling stages
19. 23:15E-commerce data model
20. 25:47Data access patterns
21. 27:33Physical tables creation
22. 29:21Primary key workload balance
23. 31:52Fewer tables optimization
24. 33:35Products by category search
25. 34:40Products by name search
26. 36:05Access pattern tables
27. 37:34Data model tuning
28. 38:58EXPLAIN query plans
29. 40:43Scan operations types
30. 43:50Query plan demo scans
31. 44:32Indexes in YCQL
32. 45:36Secondary indexes work
33. 46:18Creating secondary indexes
34. 47:22INCLUDE clause covering
35. 48:28Unique indexes integrity
36. 49:09Partial indexes efficiency
37. 50:35Advanced YCQL data types
38. 51:40JSONB complex queries
39. 53:06JSONB indexing
40. 54:13TTL data expiration
41. 55:41Table-level TTL
42. 56:03Row-level TTL deletion
43. 57:27Column-level TTL cleanup
44. 58:10YCQL certifications
45. 1:00:16GitPod lab setup
46. 1:02:03YCQL cluster exploration
47. 1:03:29Keyspace and tables creation
48. 1:05:18Data loading queries
49. 1:06:00Query plans sequential scans
50. 1:06:42Secondary indexes demo
51. 1:08:07Indexes validation results
52. 1:09:33Index-only scan plans
53. 1:10:37Unique indexes validation
54. 1:11:39Self-practice lab
55. 1:12:43Partial indexes range queries
56. 1:13:48Altering tables advanced types
57. 1:15:35Frozen lists and sets
58. 1:17:24JSONB indexing efficiency
59. 1:18:50Time to Live demonstration
60. 1:20:19Summary closing

" related talks

• 27mIntroduction to YugabyteDB – Design and ArchitectureKarthik Ranganathan · Distributed SQL Summit Asia 2021
• 25mYugabyteDB Technical OverviewTOMOHIRO ICHIMURA · Distributed SQL Summit Asia 2022
• 30mBuilding Cloud Native Applications on Distributed SQL PlatformSHIGERU URUSHIBARA · Distributed SQL Summit Asia 2023
• 51mJump Start Your Developer Journey in 60 Minutes: Go from 0 to ExpertSrinivasa Vasu · Distributed SQL Summit Asia 2022
• 30mTechnical Comparison of YugabyteDB with Oracle and PostgreSQLFranck Pachot · Distributed SQL Summit Asia 2024
• 30mBuilding Scalable Spring Applications with YugabyteDBTakeshi Ogawa · Distributed SQL Summit Asia 2023
• 27mIntroduction to YugabyteDB: Design and ArchitectureKarthik Ranganathan · Distributed SQL Summit 2020
• 25mDiscover the Easiest Path to Distributed DBaaS: Yugabyte CloudAmol Bhoite · Distributed SQL Summit Asia 2022