Seaography

Seaography is a GraphQL framework for building GraphQL resolvers using SeaORM entities. It ships with a CLI tool that can generate ready-to-compile Rust GraphQL servers from existing MySQL, Postgres and SQLite databases.

Benefits

• Quick and easy to get started
• Generates readable code
• Extensible project structure
• Based on popular async libraries: async-graphql and SeaORM

Features

• Relational query (1-to-1, 1-to-N)
• Pagination on query's root entity
• Filter with operators (e.g. gt, lt, eq)
• Order by any column

(Right now there is no mutation, but it's on our plan!)

Quick start - ready to serve in 3 minutes!

Install

sh cargo install seaography-cli

MySQL

Setup the sakila sample database.

sh cd examples/mysql seaography-cli mysql://user:pw@localhost/sakila seaography-mysql-example . cargo run

Go to http://localhost:8000/ and try out the following queries:

Fetch films and their actors

graphql { film(pagination: { limit: 10, page: 0 }, orderBy: { title: ASC }) { data { title description releaseYear filmActor { actor { firstName lastName } } } } }

Fetch store and its employee

graphql { store(filters: { storeId: { eq: 1 } }) { data { storeId address { address address2 } staff { firstName lastName } } } }

Fetch inactive customers with pagination

grahpql { customer(filters: { active: { eq: 0 } }, pagination: { page: 2, limit: 3 }) { data { customerId lastName email } pages current } }

Postgres

Setup the sakila sample database.

sh cd examples/postgres seaography-cli postgres://user:pw@localhost/sakila seaography-postgres-example . cargo run

SQLite

sh cd examples/sqlite seaography-cli sqlite://sakila.db seaography-sqlite-example . cargo run

Contribution

Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in the work by you, as defined in the Apache-2.0 license, shall be dual licensed as above, without any additional terms or conditions.

Seaography is a community driven project. We welcome you to participate, contribute and together build for Rust's future.