Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Migrating from other ORMs

From Diesel

Dieselruprizzle
table! macroschema.ruprizzle + ruprizzle generate
Selectable, Queryablegenerated Model structs
QueryDslselect(), filter(), order_by(), limit() builders
Migrations by handruprizzle migrate dev from schema diff

Quick translation

#![allow(unused)]
fn main() {
// Diesel
users::table.filter(users::email.eq("alice@example.com")).first::<User>(conn)?

// ruprizzle
db.user()
    .find_many()
    .filter(user::EMAIL.eq("alice@example.com"))
    .fetch_one()
    .await?
}

From SeaORM

SeaORMruprizzle
ActiveModelgenerated Set builders
Entityschema.ruprizzle model
Relation traitinclude() with generated relation helpers

Quick translation

#![allow(unused)]
fn main() {
// SeaORM
User::find_by_id(1).one(db).await?

// ruprizzle
db.user()
    .find_many()
    .filter(user::ID.eq(1))
    .fetch_one()
    .await?
}

From sqlx

sqlxruprizzle
Raw SQL with macrosdb.raw_pool().fetch_all_raw for escape hatches, generated builders for common cases
Manual FromRowgenerated FromRow impls per model
No migrationsruprizzle migrate

Quick translation

#![allow(unused)]
fn main() {
// sqlx
sqlx::query_as::<_, User>("SELECT * FROM users WHERE email = $1")
    .bind("alice@example.com")
    .fetch_one(&pool).await?

// ruprizzle
db.user()
    .find_many()
    .filter(user::EMAIL.eq("alice@example.com"))
    .fetch_one()
    .await?
}

From Prisma / Drizzle (TypeScript)

ruprizzle follows the Prisma shape most closely — a declarative schema file that drives both codegen and migration diffs — so most concepts map one-to-one. Feature names differ:

Prisma / Drizzleruprizzle (as of 1.5.1)
schema.prisma / drizzle-orm table defsschema.ruprizzle + ruprizzle generate
prisma migrate / drizzle-kitruprizzle migrate dev
Prisma Client extensions / Drizzle .$with()include() on the generated query builders
Prisma full-text search@@fulltext + search() filter (Postgres)
Soft-delete middleware@softDelete on the model
@@schema multi-tenancynot supported — see docs/KnownLimitations.md
pgvector extensionsnot supported
Prisma read replicas / Drizzle withReplicasPoolConfig replica routing (typed, v1.4)
Prisma Accelerate / Drizzle cachein-process query cache (v1.4)
Prisma Studio / Drizzle Studioruprizzle studio (local, per-run token auth since 1.6)
@libsql/client, @cloudflare/d1 driversruprizzle-turso, ruprizzle-d1 adapters