Tarantool 2.1 Adds SQL Support: Details

on YouTube ↗49m

" summary

Tarantool 2.1 adds SQL support compliant with ANSI-style syntax. It describes how Tarantool executes nontrivial SELECT queries and implements data-integrity features such as foreign keys, triggers, check constraints and privileges.

AI-written summary · about

" chapters (20)

1. 0:00Introduction
2. 1:55Why add SQL to Tarantool
3. 4:03SQL goals and drivers
4. 8:17Design principles
5. 11:30Implementation approach
6. 13:15SQL syntax and features
7. 16:11Table creation and constraints
8. 20:44Data manipulation
9. 23:54Update and delete
10. 26:39Triggers
11. 27:44Integrity constraints
12. 30:17Alter table
13. 31:40Advanced queries
14. 33:25Transactions and EXPLAIN
15. 34:08Collations and functions
16. 36:43Built-in functions and types
17. 38:28Calling SQL from Lua
18. 39:11Performance benchmarks
19. 40:35Current state and future
20. 41:20Q&A

" related talks

• 42mWhat's New in Tarantool 2.0Kirill Yukhin · Tarantool Conference 2018
• 46mTarantool: How to Save a Million Dollars on Your DBDenis Anikin · HighLoad++ 2015
• 29mTarantool as a Platform for MicroservicesVladimir Perepelitsa, Anton Reznikov · HighLoad++ 2015
• 47mStored Procedures in NoSQL DBMSs: The Tarantool ExampleDenis Linnik · HighLoad++ 2017
• 56mUsing Tarantool as a Data Virtualization PlatformK.Osipov, S.Myasnikov · РИТ++ 2016
• 49mPrimary Use Cases for In-Memory DBMS Illustrated by TarantoolDenis Anikin · РИТ++ 2016
• 50mCreating a Production-Ready Application on TarantoolIgor Latkin · Tarantool Conference 2018
• 23mSynchronizing Data from PgSQL to TarantoolVeniamin Gvozdikov · HighLoad++ 2017