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.

10 Series
152 Lessons
Database

Lessons

Video preview
Paginated Admin Movie Table
Video preview

Paginated Admin Movie Table

In this lesson, we'll learn how we can create a paginated movie table for our administrators. We'll list the movies and some of their relationship data, like the number of crew and cast members associated with the movie.

Video preview
Counting Stats for our Admin Dashboard
Video preview

Counting Stats for our Admin Dashboard

In this lesson, we'll perform various counts against our models to display on our admin dashboard page.

Video preview
Filtering, Preloading, and Sorting By Relationship
Video preview

Filtering, Preloading, and Sorting By Relationship

In this lesson, we'll list the movies a user has watched on their profile. To do this, we'll filter, preload, and sort by the watchlist relationship where the user's watched at value is not null.

Video preview
Uploading and Displaying User Avatars
Video preview

Uploading and Displaying User Avatars

In this lesson, we'll learn how to validate and upload avatar images into our project's storage. We'll then learn how we can easily display images we have contained within our app's storage

Video preview
Saving All Or Nothing with Database Transactions
Video preview

Saving All Or Nothing with Database Transactions

In this lesson, we'll learn about database transactions and how we can use them to batch commit or rollback updates, safeguarding against partial updates due to errors.

Video preview
Video preview

How to Create and Fix Missing User Profiles in Your Application

Learn how to create and manage user profiles in your application. This tutorial covers adding an edit profile button, setting up routes and controllers, ensuring profile creation during registration, handling existing users without profiles, and verifying

Video preview
Paginator Query Strings
Video preview

Persist Filters Easily with Lucid's Query String Method

Learn how to simplify pagination by persisting active filters with the query string method. Follow this step-by-step guide to clean up your code, apply the .queryString method from Lucid, and ensure seamless pagination for your web applications.

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

Showing 55 to 72 of 150 results