sea-clickhouse is a ClickHouse client that integrates with the SeaQL ecosystem. It is a soft fork of clickhouse-rs: 100% compatible with all upstream features, with SeaQL's dynamic type and Arrow support added on top. The fork is continuall...
The Problem: Durability Long-running programs crash. When they do, you start over from zero. The fix is checkpointing: periodically save state to a database so the program can resume where it left off. In this tutorial we wire up checkpoin...
SeaORM 2.0 adds native Apache Arrow and Parquet support. Derive an Arrow schema directly from your SeaORM entity: no redundant schema definitions, no drift. Motivation Traditional ORMs are built for OLTP. But Rust backends increasingly nee...
Over the past few months, we've rolled out a series of SeaORM 2.0 releases packed with new capabilities that reshape how you'd use SeaORM. We've stablized our API surface now. Other than dependency upgrades (sqlx 0.9), there won't be more m...
SeaORM now has an official Rusqlite backend. SeaORM began as Rust's first async‑first ORM. Now we've come full circle with a synchronous crate: perfect for building lightweight CLI programs with SQLite. In this post, we'll share how we port...
This interview features Émile Fugulin, co-founder of Caido — a security auditing toolkit built for the hacker community. Rust powers the core of the Caido platform, from the backend to the desktop app. Émile shares how Caido has grown in re...
In our last post, we introduced a Smart Entity Loader that made querying multi-path relations into nested models simple and efficient. That solved the read side of the problem. With nested ActiveModel, you can now do the reverse: persist a...
In our last post, we introduced a new Entity format - designed to be more concise, more readable, and easy to write by hand. We've also added a new COLUMN constant to make it more ergonomic, along with other enhancements. Bye-bye CamelCase...
In our last post, we introduced a new Entity format - designed to be more concise, more readable, and easy to write by hand. With this format, you can embrace an Entity‑first workflow: stay focused on your domain model without getting bogge...
SeaORM’s current entity format is explicit, but it can feel verbose, making it difficult to write by hand. In SeaORM 2.0, we’re introducing a more information‑dense entity format, along with new features that make relational queries easier...
GraphQL has become the preferred interface for product teams. Both frontend and backend developers benefit from its type-safety, contractual guarantees, and composability. Yet the real challenge lies on the backend: implementing relational...
SeaORM 2.0 introduces Role-Based Access Control (RBAC), bringing first-class authorization into your data layer. No more bolting on ad-hoc permission checks or scattering business rules across services - SeaORM lets you define roles and per...
In the previous blog post, we highlighted some of the new features in SeaORM 2.0. In this post, we're going to take a closer look to some of the changes under the hood. Overhauled Entity::insert_many #2628 We've received many issue reports...
SeaORM 1.0 debuted on 2024-08-04. Over the past year, we've shipped 16 minor releases - staying true to our promise of delivering new features without compromising stability. While building new features in 1.0, we often found ourselves bend...
SeaQuery 0.1.0 was first released on 2020-12-16 - it's been a few years! Since then, there have been 32 releases, each introducing a set of new features. As with many software projects, the organic evolution driven by a diverse community of...
You enjoy writing raw SQL queries, SeaQuery just made it better! We've created a new raw_query! macro with neat features to make writing raw SQL queries more ergononmic. The biggest headache when crafting complex queries is parameter bindin...
This blog post summarizes the new features and enhancements introduced in SeaORM 1.1: 2025-03-30 1.1.8 2025-04-14 1.1.9 2025-04-14 1.1.10 2025-05-07 1.1.11 2025-05-27 1.1.12 New Features Implement DeriveValueType for enum strings DeriveVa...
This blog post summarizes the new features and enhancements introduced in SeaORM 1.1: 2024-10-15 1.1.0 2024-11-04 1.1.1 2024-12-02 1.1.2 2024-12-24 1.1.3 2025-01-10 1.1.4 2025-02-14 1.1.5 2025-02-24 1.1.6 2025-03-02 1.1.7 New Features Supp...
Introduction This tutorial walks you through the design and implementation of a REST API endpoint that involves some complex relational queries. The API looks like this: POST /api/v1/complex-products Parameters (JSON body): FieldTypeDescri...
🎉 We are pleased to release SeaQuery 0.32.0 / 0.32.1! Here are some feature highlights 🌟: New Features Unify Expr and SimpleExpr Methods with ExprTrait #791 Previously, "operator" methods (e.g. add, eq) are duplicated across Expr and Simp...