Getting Started with SurrealDB - Future of Cloud Databases

Explore the future of cloud databases in this 26-minute tutorial on SurrealDB, a new cloud-native database designed to run on cloud, browser, and edge environments. Learn about the evolution of compute architecture and databases, the limitations of existing technologies like SQLite for cloud-native architectures, and how SurrealDB addresses these challenges. Follow along as the instructor demonstrates installation, CLI usage, and basic operations such as starting an in-memory database, connecting, and working with namespaces and databases. Gain hands-on experience with SurrealDB's SQL-like syntax for inserting, updating, and deleting data, as well as performing queries with column selection and where clauses. Discover SurrealDB's versatility as a key-value store, relational database, and graph database, along with its native JSON and array support. Finally, learn how to join tables and create relations in this comprehensive introduction to SurrealDB's capabilities.

- the evolution of compute architecture
- evolution of databases
- sqlite and the problem it solves
- the problems with sqlite on cloud native architectures
- surrealdb and the need for a new cloud native database technology
- installing surrealdb
- surrealdb CLI
- starting the surrealdb as an in-memory database
- checking you can connect
- namespaces and databases
- surrealdb sql and selecting data
- tables, records and inserting data
- updating data with sql
- deleting data via the CLI with SQL
- selecting specific columns
- where clauses
- super fast querying via records
- native json support
- array support
- joining tables and relations
- conclusion