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

AdonisJS Filter Form Handler
AdonisJS Filter Form Handler

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.

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 Model Query Builder Macro Favorites

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
Static Model Query Methods

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
Model Hook Overview

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
AdonisJS Creating Records

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
AdonisJS Model Relationships

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
Default Team

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
Migration to Model

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
Schema to Migration

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?
What is a model?

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
Altering Database Tables with Migrations

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.

AdonisJS Migrations & Their Flow
AdonisJS Migrations & Their Flow

Migrations & Understanding the Flow of Migrations

In this lesson, we'll learn all about migrations, what they are, how they're used, and how they're tracked. We'll also learn about the flow of migrations and how they work similarly to a timeline.

Introducing the Lucid ORM
Introducing the Lucid ORM

Introducing, Installing, and Configuring Lucid ORM

In this lesson, we'll learn about Lucid ORM; its capabilities, Ace CLI commands, and the difference between it and the Database module. We'll then install and configure it within our project.

How To Do Multi Model Authentication with AdonisJS and Lucid ORM

In this lesson, we'll learn how to set up multi-model authentication using a User and Admin model with AdonisJS and Lucid ORM.

Comment Likes & Unlikes

In this stream, we'll be adding the ability to like and unlike a comment on the new upcoming Jagr.Co site, built with AdonisJS.

How To Add A Custom Method to the Model Query Builder in AdonisJS

In this lesson, we'll learn how to define a macro for the Model Query Builder within an AdonisJS project to provide a new method onto all our Model's Query Builder.

Building A Comment System

In this stream, we focused on building a comment system that allowed infinitely nestable responses. It's all done server-side too, so it's SEO friendly!

Showing 127 to 144 of 161 results