A repository for holding the surreal queries used in the learning process of SurrealDB. You can watch the livestreams on my YouTube playlist.
Each stream has its own folder with the queries used in the livestream.
In the first stream, we learn the basics of defining tables and fields, went over various data types and learned to query them.
In the seconds stream, we learn about the graph relations.
In the third stream, we designed a schema for my blog.
The finished schema diagram:
In the fourth stream, we learn how to authenticate users using third-party authentication providers like Clerk. We also learn how to automatically create user record when the user is authenticated for the first time and keep it up to date afterwards.
The fifth stream focuses on the permissions system in SurrealDB. We learn how to use the PERMISSIONS clause and discover it's limitations. We also discover how events allow us to perform actions with elevated privileges. This led us to implementing automatic counting of likes and comments and ensuring complex requirements of comment approvals.
During this stream, we continue to explore the permissions system. We implement a view table that allows us to expose only partial post data to the users while increasing the performance of various queries.
This stream covers the updates introduced in the 2.0.0-beta.1 release of SurrealDB. We explore some of the new features by updating and completing the existing schema. Then we move on to writing queries that generate tons of test data and connect it all together. We finish the stream by completing the "permissions" adventures.
We will learn how design a set of functions that allow us to send content from the Astro build process to the database. Database will then automatically update the necessary content and remove the outdated parts.