Index

Introduction

1. Introduction

   1.1. Introduction to SeaORM

   1.2. What's New in SeaORM 2.0

Basics

2. Installation & Configuration

   2.1 Choosing a Database & Async Runtime

   2.2 Connection Pool

   2.3 Debug Log

3. Migration

   3.1 Setting Up Migration

   3.2 Writing Migration

   3.3 Running Migration

   3.4 Seeding Data

4. Generating Entities

   4.1 Using sea-orm-cli

   4.2 Entity Structure

   4.3 Column Types

   4.4 Enumeration

   4.5 New Type

   4.6 Entity First Workflow

5. Basic CRUD

   5.1 Basic Schema

   5.2 SELECT: find, filter, sort, paging

   5.3 ActiveModel & ActiveValue

   5.4 INSERT: insert one & insert many

   5.5 UPDATE: find & save, update many

   5.6 SAVE: insert or update

   5.7 DELETE: delete one & delete many

   5.8 JSON

   5.9 Raw SQL query

   5.10 Custom Active Model

Advanced Topics

6. Relations

   6.1 One to One

   6.2 One to Many

   6.3 Many to Many

   6.4 Complex Relations

   6.5 Model Loader

   6.6 Entity Loader

   6.7 Bakery Schema

   6.8 Nested Selects

   6.9 Multi Selects

   6.10 Relational Query

7. Writing Tests

   7.1 Robust & Correct

   7.2 Mock Interface

   7.3 Using SQLite

8. Advanced Queries

   8.1 Custom select

   8.2 Conditional expressions

   8.3 Aggregate functions

   8.4 Custom Join Condition

   8.5 Sub Query

   8.6 Transaction

   8.7 Streaming

   8.8 Nested Active Model

   8.9 Error Handling

   8.10 Advanced Joins

9. Schema Statement

   9.1 Create Table

   9.2 Create Enum

   9.3 Create Index

10. GraphQL Support

    10.1 🧭 Seaography

    10.2 Getting Started

11. Admin Panel

    11.1 🖥️ SeaORM Pro

    11.2 Getting Started

    11.3 Role Based Access Control

12. Data Science

    12.1 Arrow & Parquet

    12.2 ClickHouse

13. Internal Design

    13.1 Traits and Types

    13.2 Derive Macros

    13.3 Architecture

    13.4 Compare with Diesel

    13.5 Expanded Entity Format

14. What's Next

    14.1 What's Next