undefined

Lucid

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.

12 Series
163 Lessons
Database

Lessons

Video preview
AdonisJS 6 Access Token Authentication in 20 Minutes
Video preview

AdonisJS 6 Access Token Authentication in 20 Minutes

In this lesson, we'll cover how to implement access token authentication, using opaque tokens, in AdonisJS 6. We'll also take a look at what this would look like on the frontend via a Vue 3 app using Pinia

Video preview
Composite Unique Constraint
Video preview

Defining A Composite Unique Constraint

In this lesson, we'll learn how you can enforce uniqueness between multiple columns using a composite unique constraint.

Video preview
Filter by User's Watched Status
Video preview

Filtering By User's Watched Status

In this lesson, we'll learn how to add a filter to our user's watchlist allowing them to show only movies they have or have not watched.

Video preview
Tracking Watched Movies
Video preview

Allowing Users To Toggle A Movie As Watched

In this lesson, we'll learn how to allow users to toggle whether they've watched a movie or not within their watchlist.

Video preview
Listing and Filtering User Watchlist Items
Video preview

Listing and Filtering User Watchlist Items

In this lesson, we'll take our movie filter, and learn how we can reuse it to display a filterable list of the user's watchlist movies.

Video preview
Toggling A Movie in an Authenticated User's Watchlist
Video preview

Toggling A Movie in an Authenticated User's Watchlist

In this lesson, we'll learn how to add the ability to toggle whether a user has a movie within their watchlist. We'll also query and display whether a movie is in the authenticated user's watchlist as well.

Video preview
An Alternative Approach to Many-To-Many Relationships
Video preview

An Alternative Approach to Many-To-Many Relationships

In this lesson, learn an alternative approach to many-to-many relationships that allows you to work directly with the pivot table as a model.

Video preview
Pagination First, Last, Next, and Previous Buttons
Video preview

Pagination First, Last, Next, and Previous Buttons

In this lesson, we'll take a look at how to add pagination links to the next and previous pagination pages. Then, we'll follow the same process to add links to the first and last pagination pages.

Video preview
How To Paginate Filtered Query Results
Video preview

How To Paginate Filtered Query Results

In this lesson, we'll learn about AdonisJS Model Query Builder pagination and walk through an example of how we can easily paginate the results of our filtered movies.

Video preview
Joining SQL Tables To Order By A Related Column
Video preview

Joining SQL Tables To Order By A Related Column

In this lesson, we'll learn how to join a related table into our query and use that table to apply a sort via the relationship. We'll then see how we can conditionally apply this join only when it's needed for the selected order by.

Video preview
How To Apply A Dynamic Sort Filter To Your Query
Video preview

How To Apply A Dynamic Sort Filter To Your Query

In this lesson, we'll learn how we can add a user-selected sort option to our filters. Then, we'll apply the selected filter to our movie query

Video preview
Filtering Our List by Movie Status
Video preview

Filtering Our List by Movie Status

In this lesson, we'll alter our form input component to allow selects. Then, we'll learn how to add a select-based filter to our movie list page so that we can see only movies containing a specific movie status.

Video preview
Filtering A Query By Pattern Likeness
Video preview

Filtering A Query By Pattern Likeness

In this lesson, we'll learn how to add a pattern filter to our movies.index page that will allow us to filter our movies list by title using a case-insensitive pattern search.

Video preview
Remembering A User's Authenticated Session
Video preview

Remembering A User's Authenticated Session

In this lesson, we'll learn how we can use AdonisJS' Remember Me Tokens feature to allow a user to specify they'd like their authentication state to be remembered for a long time across sessions.

Video preview
Logging In An Existing User
Video preview

Logging In An Existing User

In this lesson, we'll learn how we can login an existing user using just their email and password. We'll discuss how the AuthFinder mixin protects us from timing attacks, and how we can use it to verify the accuracy of a user's password.

Video preview
AdonisJS 6 Session Authentication in 15 Minutes
Video preview

AdonisJS 6 Session Authentication in 15 Minutes

In this lesson, we'll learn how to add authentication to a new AdonisJS 6 application using the session guard. In these 15 minutes, you'll learn how to register a user, logout a user, verify a user's credentials and log them in, and more.

Video preview
Sorting and Filtering Pivot Table Data
Video preview

How To Query, Sort, and Filter by Pivot Table Data

In this lesson, we'll learn how we can query pivot table data. We'll then learn how we can also sort and filter our results by those pivot table columns as well.

Video preview
Data Pools
Video preview

How To Create Factory Relationships from a Pool of Data

In this lesson, we'll learn how we can refactor our fake data seeder to allow us to assign cast members and crew members to our movies via our many-to-many relationships from a single pool of cineast records.

Showing 73 to 90 of 161 results