Database

Lucid

10 Series
141 Lessons
37h 13m

Lucid is AdonisJS' Object Relational Mapping (ORM). It's a first-party package that follows the active record pattern. With it you can easily perform CRUD operations, add database hooks, normalize data, and so much more.

Lessons.

Video preview
Adocasts Plus Exclusive
Exclusive
Showing Course Details
Building with AdonisJS & Inertia
#8.4
・
Dec 02, 24

Showing A Course's Details

In this lesson, we'll add our courses show page, which will be in charge of displaying the course details along with its modules & lessons. In this lesson we'll lay the groundwork, then in the next module we'll add in our modules & lessons.

Video preview
Adocasts Plus Exclusive
Exclusive
Deleting Courses
Building with AdonisJS & Inertia
#8.3
・
Dec 02, 24

Deleting Courses

In this lesson, we'll add the ability to delete courses from an organization with confirmation from our user.

Video preview
Adocasts Plus Exclusive
Exclusive
Editing & Updating Courses
Building with AdonisJS & Inertia
#8.2
・
Nov 27, 24

Editing & Updating Courses

In this lesson, we'll add the ability to edit and update a course within the active organization.

Video preview
Adocasts Plus Exclusive
Exclusive
Building with AdonisJS & Inertia
#8.1
・
Nov 27, 24

Creating A New Course

In this lesson, we'll add the ability to create a new course within the active organization.

Video preview
Adocasts Plus Exclusive
Exclusive
Querying & Listing Courses
Building with AdonisJS & Inertia
#8.0
・
Nov 27, 24

Querying & Listing An Organization's Courses

In this lesson, we'll query the active organization's courses and list them out in a table.

Video preview
Adocasts Plus Exclusive
Exclusive
Drag & Drop Sorting
Building with AdonisJS & Inertia
#7.5
・
Nov 22, 24

Sorting Difficulties with Drag & Drop

In this lesson, we'll allow our user's to customize the ordering of their difficulties via drag-and-drop using VueDraggable. When they commit a change by dropping an item, we'll persist the updated sort to our database.

Video preview
Adocasts Plus Exclusive
Exclusive
Deleted Replacement
Building with AdonisJS & Inertia
#7.3
・
Nov 15, 24

Replacing A Course's Deleted Difficulty

In this lesson, we'll add the ability to gracefully handle instances where a required relationship's record is being deleted. When a difficulty is being used by a course, we'll have our users select a replacement difficulty for the one being deleted.

Video preview
Adocasts Plus Exclusive
Exclusive
Deleting Difficulties
Building with AdonisJS & Inertia
#7.2
・
Nov 15, 24

Confirming & Deleting Difficulties

In this lesson, we'll add the ability to delete an organization's difficulties. We'll also make use of our ConfirmDeleteDialog component to confirm the deletion action with our user.

Video preview
Adocasts Plus Exclusive
Exclusive
Updating Difficulties
Building with AdonisJS & Inertia
#7.1
・
Nov 15, 24

Updating Difficulties

In this lesson, we'll add the ability to update an organization's difficulties using our useResourceActions composable.

Video preview
Adocasts Plus Exclusive
Exclusive
Listing and creating difficulties
Building with AdonisJS & Inertia
#7.0
・
Nov 11, 24

Listing & Creating Difficulties

In this lesson, we'll create a page to list the active organization's difficulties. Then, we'll add the ability to create a new difficulty and add a new color picker type to our FormInput component.

Video preview
Adocasts Plus Exclusive
Exclusive
Confirm Delete Dialog
Building with AdonisJS & Inertia
#6.6
・
Nov 11, 24

The Confirm Delete Dialog & Deleting the Active Organization

In this lesson, we'll create a reusable confirm deletion dialog and bind its state into our use resource actions composable. We'll then incorporate this all together to allow users to delete their active organization.

Video preview
Adocasts Plus Exclusive
Exclusive
Forgot Password
Building with AdonisJS & Inertia
#5.6
・
Oct 21, 24

Forgot Password & Password Reset

In this lesson, we'll walk through setting up the complete forgot password flow including, creating a password reset token with time-expiry, sending an email notification with a password reset link, verifying the token, and resetting the users password.

Video preview
Adocasts Plus Exclusive
Exclusive
Model Types with DTOs
Building with AdonisJS & Inertia
#4.5
・
Sep 27, 24

Typing Lucid Models in Inertia with DTOs

In this lesson, we'll learn how we can specify types for our Lucid Models easily using DTOs we'll generate directly from our models.

Video preview
Adocasts Plus Exclusive
Exclusive
Seeding Our Initial Data
Building with AdonisJS & Inertia
#4.4
・
Sep 27, 24

Seeding Our Initial Database Data

In this lesson, we'll create a seeder file to create the initial data we'll need in our database to get going. For now, that's just going to be our application's roles.

Video preview
Adocasts Plus Exclusive
Exclusive
Lucid Model Relationship Mixin
Building with AdonisJS & Inertia
#4.3
・
Sep 27, 24

Creating A Lucid Model Mixin for our Organization Relationship

In this lesson, we'll learn how we can extract repetitive relationships, and other model properties/methods, into a mixin. We'll also learn what to look out for when using decorators within a TypeScript mixin.

Video preview
Adocasts Plus Exclusive
Exclusive
Defining Our Lucid Models & Relationships
Building with AdonisJS & Inertia
#4.2
・
Sep 20, 24

Defining Our Lucid Models & Relationships

In this lesson, we'll convert our migrations into Lucid Models and define both sides of the relationships so they're ready to go.

Video preview
Adocasts Plus Exclusive
Exclusive
Defining Our Migrations & Foreign Keys
Building with AdonisJS & Inertia
#4.1
・
Sep 20, 24

Defining Our Migrations & Foreign Keys

In this lesson, we'll create our migrations, models, and some of our controllers. We'll then fill out our migrations and define our relationship's foreign key constraints.

Video preview
Adocasts Plus Exclusive
Exclusive
Database Schema
Building with AdonisJS & Inertia
#4.0
・
Sep 20, 24

Understanding Our Database Schema

In this lesson, we'll walk through a diagram of our application's database schema to understand how things relate to one another.

Video preview
Allowing Admins to Delete Movies
Let's Learn AdonisJS 6
#11.10
・
Jun 29, 24

Allowing Admins to Delete Movies and their Relationships

In this lesson, we'll learn how we can safely delete movies and their relationships. We'll discuss how we need to consider foreign key constraints, and what to do when our deletes aren't set to cascade.

Video preview
Managed Transactions and Syncing Movie Cast Members
Let's Learn AdonisJS 6
#11.9
・
Jun 26, 24

Managed Transactions and Syncing Movie Cast Members

In this lesson, we'll learn how we can use what we learned in the last lesson to also sync our cast members. We'll then extract this functionality into a service and wrap it within a managed database transactions.

Showing 21 to 40 of 139 results