Lucid is a SQL object-relational mapper designed for applications built with AdonisJS. It uses the Active Record pattern and is built on top of Knex, combining model-based database access with a fluent SQL query builder.
The software includes tools for managing schemas, running migrations, seeding databases and generating model factories for testing. It supports multiple database connections and provides dedicated dialects for PostgreSQL, MySQL, SQLite, LibSQL, Microsoft SQL Server and Oracle.
This is free and open source software.
Key Features
- Active Record ORM with TypeScript decorators for defining models and columns.
- Fluent query builder for constructing and executing SQL queries.
- Relationships including has-one, has-many, belongs-to, many-to-many and has-many-through.
- Eager loading and preloading of related models.
- Database schema builder and version-controlled migrations.
- Commands for running, rolling back, refreshing and inspecting migrations.
- Seeders and model factories for creating development and test data.
- Transactions and connection pooling.
- Multiple named database connections.
- Pagination for database and model queries.
- Model lifecycle hooks such as before-save and after-create.
- Support for PostgreSQL, MySQL, SQLite, LibSQL, Microsoft SQL Server and Oracle.
- Extensible classes with runtime macros.
- Database health checks, query logging and event reporting.
Website: github.com/adonisjs/lucid
Support:
Developer: AdonisJS team
License: MIT License
Lucid is written in TypeScript. Learn TypeScript with our recommended free books and free tutorials.
Related Software
| TypeScript Object-Relational Mapping Software | |
|---|---|
| Sequelize | Promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite and more |
| TypeORM | ORM that can run in NodeJS, Browser, Cordova, PhoneGap, Ionic ... |
| Prisma | Next-generation Node.js and TypeScript ORM |
| Drizzle ORM | Lightweight TypeScript toolkit for type-safe SQL database access |
| Objection.js | ORM for Node.js that aims to stay out of your way |
| MikroORM | ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns |
| Lucid | Active Record database layer designed for AdonisJS applications |
| Joist | Opinionated TypeScript data layer with strong typing and relations |
Read our verdict in the software roundup.
 Explore our carefully curated directory of recommended free and open source software, covering every major software category.The directory forms part of our extensive collection of articles for Linux enthusiasts. It includes hundreds of detailed reviews, together with free and open source alternatives to proprietary software from companies such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. LinuxLinks also covers interesting projects worth exploring, Linux-compatible hardware, free programming books and tutorials, and much more. Know a useful free and open source Linux application that we haven’t covered? Tell us about it using our submission form. |
Please read our Comment Policy before commenting.