Lucid

8 Series
44 Lessons
22h 6m

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
Adocasts Plus Exclusive
Free in 12 days
Let's Learn AdonisJS 6 #4.1
Feb 21

Understanding our Database Schema

In this lesson, we'll walk through how to understand a database schema diagram. We'll then discuss the schema we'll be working with throughout this series; describing the tables, columns, data types, and relationships.

Video preview
Adocasts Plus Exclusive
Free in 12 days
Configuring Lucid and our Database Connection
Let's Learn AdonisJS 6 #4.0
Feb 21

Configuring Lucid and our Database Connection

In this lesson, we'll learn how we can configure Lucid to use a different driver other than SQLite; PostgreSQL is shown but MySQL and MSSQL are much the same. Then, we'll set up our connection details so that we can successfully connect to our database.

Video preview
Structuring Data with Models
Let's Learn AdonisJS 6 #2.11
Jan 31

Defining A Structure for our Movie using Models

In this lesson, we'll introduce the concept of models by using one to define the properties our movies should contain. We'll then stub some methods that will mock calls we'll later be able to use to load data from our database.

Video preview
Model vs Database
Let's Learn AdonisJS 5 #6.2
Dec 28, 23

Model vs Database Query Builder

In this lesson, we'll take a look at the differences between the model and database query builders.

Video preview
Adocasts Plus Exclusive
Exclusive
Mixins and Compose
Dec 17, 23

A Deep Dive Into Mixins & Compose

In this lesson, we'll walk through what mixins are and how they work by first inspecting them as plain objects then working our way into classes then finally TypeScript. We'll then implement mixins via AdonisJS' compose utility.

Video preview
Limiting, Sorting, and Pagination
Let's Learn AdonisJS 5 #6.1
Dec 08, 23

Limiting, Sorting, & Pagination with the Query Builder

In this lesson, we'll take a look at the various options we have to limit results when using the query builder including first, firstOrFail, limit, and pagination. We'll also learn how we can sort our results.

Video preview
Introducing the Query Builder
Let's Learn AdonisJS 5 #6.0
Nov 26, 23

Intro to the Query Builder & It's Where Statements

In this lesson, we'll introduce the query builder. We'll spend most of our time looking at its various where statement options and how we can use them to build queries.

Logging User Actions
AdonisJS Quick Tip #18.0
Jul 09, 23

How To Use AdonisJS Model Hooks To Log All User Actions

In this lesson, we’ll be taking a look at how we can log any and every user action performed against our AdonisJS models.

AdonisJS Filter Form Handler
HTMX & AdonisJS Filters #3.0
Mar 26, 23

Defining Our AdonisJS Filter Form Handler

In this lesson, we'll expand on the filter query we built in the last lesson by reusing the query within a service for our filter form handler.

HTMX & AdonisJS Filters #2.0
Mar 26, 23

Creating Our Filter Query with AdonisJS

In this lesson, we'll create the route and query we'll need to get filtered results with our filter form using the Lucid ORM and AdonisJS.

AdonisJS Model Query Builder Macro Favorites
AdonisJS Quick Tip #16.0
Mar 12, 23

Exploring My Favorite AdonisJS Model Query Builder Macros: Tips and Examples

In this lesson, I'll highlight a few of my favorite Model Query Builder Macros that I carry with me from project to project. Have a favorite of your own? Let me know in the comments!

Static Model Query Methods
Let's Learn AdonisJS 5 #5.9
Mar 09, 23

Easy Querying with Static Model Query Methods

In this lesson, we'll learn what static methods are available on our Lucid Models to help us easily query records from our database. These methods offer a convenient query option compared to the query builder.

Model Hook Overview
Let's Learn AdonisJS 5 #5.8
Mar 01, 23

Password Hashing & Model Hook Overview

In this lesson, we'll learn briefly about the model hooks available and how they work. Then, we'll walk through an example by hashing our password anytime it is changed.

AdonisJS Creating Records
Let's Learn AdonisJS 5 #5.7
Feb 02, 23

Creating Records with Lucid ORM

In this lesson, we'll learn various ways we can create and bulk-create records using the AdonisJS Lucid ORM.

AdonisJS Model Relationships
Let's Learn AdonisJS 5 #5.6
Jan 27, 23

Defining Model Relationships

In this lesson, we'll learn how to define relationships on our Lucid Models. We'll cover one-to-one, many-to-one, one-to-many, and many-to-many relationship definitions.

Default Team
Let's Build A Changelog App #4.0
Jan 07, 23

Creating Teams & Setting Default Team

In this stream, we'll be adding the ability to create new teams, set the default team for a user when they switch between teams, and auto-forward users to their default team after login.

Migration to Model
Let's Learn AdonisJS 5 #5.5
Jan 05, 23

Database Migrations To Lucid Models

In this lesson, we'll walk through examples of transferring our database migrations into our Lucid Models. This will pave the way for us to begin CRUD operations in later lessons.

Schema to Migration
Let's Learn AdonisJS 5 #5.4
Dec 29, 22

Database Schema to Migration

In this lesson, we'll walk through a real-world example of a database schema and how to create migrations. We'll define each table's columns, primary keys, and foreign keys.

What is a model?
Let's Learn AdonisJS 5 #5.3
Dec 22, 22

What Is A Model?

In this lesson, we'll delve into AdonisJS Models learning what they are, what they represent, how to create them, what we can do with them, and more.

Altering Database Tables with Migrations
Let's Learn AdonisJS 5 #5.2
Nov 17, 22

What To Know Before Altering Your Database with Migrations

In this lesson, we'll discuss two different flows you can use to alter your database. One, when working completely locally and another when a migration has already been executed on your production database.

Showing 1 to 20 of 43 results