Database

Lucid

9 Series
102 Lessons
30h 46m

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.

Series.

Snippets.

Lessons.

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

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

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.

Video preview
Posting an Array of Objects with HTML Forms
Let's Learn AdonisJS 6 #11.8
・
Jun 26

Posting Objects, Arrays, and an Array of Objects in HTML Forms

In this lesson, we'll learn how we can use form field names to send an array of objects with our HTML form submission. We'll discuss pitfalls to watch out for and how we use AlpineJS to simplify index syncing within our field names.

Allowing Admins to Update Movies and Clear Values
Let's Learn AdonisJS 6 #11.4
・
Jun 15

Allowing Admins to Update Movies and Clear Values

In this lesson, we'll recreate our movie form for the purpose of updating our movies. We'll also add the ability to clear values and discuss the difference between VineJS' optional and nullable chain options.

Video preview
Allowing Admins to Create Movies
Let's Learn AdonisJS 6 #11.3
・
Jun 12

Allowing Admins to Create Movies

In this lesson, we'll allow our administrators to create movies via our admin panel. We'll walk through getting the form set up, validated, and our movies created.

Video preview
Paginated Admin Movie Table
Let's Learn AdonisJS 6 #11.2
・
Jun 12

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

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

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

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

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

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

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
AdonisJS In 30 #6.0
・
May 21

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

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
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.

Showing 1 to 20 of 101 results