We walk through creating a new Database in the FaunaDB console complete with some demo data. We do some exploration of the data, introducing concepts like Collections and Indexes, before showing an example FQL query that runs against the database. This sets us up to talk about FQL in future videos
Instructor: [00:00] Once you've signed up for a Fauna account, you'll end up at the dashboard. Since I already have a database in my account, I see it right here along with the readops, the writeops, storage, and data transfer.
[00:10] To create a new database, we'll click create new database. We'll give our database a name and let Fauna prepopulate it with demo data. This demo data creates a warehouse data structure for us.
[00:30] Now that we've created our database with the demo data, we can see that there are a number of collections and a number of indexes. If we look at the customers collection, we can see a number of objects or documents. These documents can be explored through the UI.
[00:44] Indexes are groups of documents inside of each of our collections. In this case, we have indexes that represent all the objects in each of our collections. If we go to the shell on the FaunaDB console, we can use FQL to write a query.
[00:59] This query matches on the index all customers, paginates the results, selects the data from the pagination, and maps over the results of the pagination using a Lambda. Since in the Lambda, the argument is a ref, we have to get the object.
[01:17] Finally, we select the first name from all of the data. If we run this query, we can see that we do indeed get all first names.
Member comments are a way for members to communicate, interact, and ask questions about a lesson.
The instructor or someone from the community might respond to your question Here are a few basic guidelines to commenting on egghead.io
Be on-Topic
Comments are for discussing a lesson. If you're having a general issue with the website functionality, please contact us at support@egghead.io.
Avoid meta-discussion
Code Problems?
Should be accompanied by code! Codesandbox or Stackblitz provide a way to share code and discuss it in context
Details and Context
Vague question? Vague answer. Any details and context you can provide will lure more interesting answers!