Database

Lucid

9 Series
109 Lessons
31h 45m

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
Filter by User's Watched Status
Let's Learn AdonisJS 6 #9.4
・
May 16

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
Let's Learn AdonisJS 6 #9.3
・
May 16

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
Let's Learn AdonisJS 6 #9.2
・
May 10

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
Let's Learn AdonisJS 6 #9.1
・
May 10

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
Let's Learn AdonisJS 6 #9.0
・
May 10

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
Let's Learn AdonisJS 6 #8.7
・
May 06

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
Let's Learn AdonisJS 6 #8.6
・
May 06

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
Let's Learn AdonisJS 6 #8.4
・
May 01

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
Let's Learn AdonisJS 6 #8.3
・
May 01

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
Let's Learn AdonisJS 6 #8.2
・
May 01

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
Let's Learn AdonisJS 6 #8.1
・
Apr 27

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
Let's Learn AdonisJS 6 #7.5
・
Apr 24

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
Let's Learn AdonisJS 6 #7.4
・
Apr 24

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
AdonisJS In 30 #5.0
・
Apr 18

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
Let's Learn AdonisJS 6 #5.13
・
Apr 05

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
Let's Learn AdonisJS 6 #5.12
・
Apr 05

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.

Video preview
Relationship CRUD
Let's Learn AdonisJS 6 #5.11
・
Apr 02

A Deep Dive Into Relationship CRUD with Models

In this lesson, we'll take a deep look at how we can perform CRUD operations with one-to-one, one-to-many, many-to-one, and many-to-many relationships using our Lucid Models.

Video preview
Many to Many Relationship Model Factories
Let's Learn AdonisJS 6 #5.10
・
Apr 02

Many-To-Many Model Factory Relationships

In this lesson, we'll learn how we can define and use many-to-many relationships with Model Factories, including how we can define pivot table data when creating our fake records.

Video preview
Defining Many to Many Relationships
Let's Learn AdonisJS 6 #5.9
・
Apr 02

Defining Many-To-Many Relationships and Pivot Columns

In this lesson, we'll learn how you can define many-to-many relationships within your Lucid ORM Models. We'll also discuss the relationship options, and how you can automatically include pivot table data with all queries.

Video preview
Using Eager and Lazy Loading to Load A Movie's Writer and Director
Let's Learn AdonisJS 6 #5.8
・
Mar 26

Using Eager and Lazy Loading to Load A Movie's Writer and Director

In this lesson, we'll learn how we can use eager loading to preload our writer and director onto our movie's details. We'll then, learn how we can load our writer and director onto our movie's details using lazy loading.

Showing 21 to 40 of 107 results