Latitude is a library for dynamic runtime DDL based on sqlx
and barrel. NOTE: This project
is in early development along with sqlx. Please use at your own risk and strongly
consider using a better tested and polished project such as
Refinery. There will definitely be API changes
in the near future.
Originally this was intended to to be a migration toolkit, but, it has been slimmed down. It's unclear if we will still pursue a migration oriented API. Adding migration capability would be a feature addition as opposed to a rewrite.
With the migration changes this library could be considered amore portable but less
accessible alternative to sqlx-cli: users require less concern over understanding and
maintaining multiple SQL dialects, but, must have familiarity with Rust to get up and
running. It may be a good fit if your application is already written in Rust and either:
-
you want migration compatibility across multiple databases (e.g. if you are using MySQL in production and SQLite for development); or
-
you just like writing in the DSL over plain SQL
Please raise an issue on GitHub if you have suggestions, feedback, bug reports, or otherwise.
latitude = 0.0.1use latitude::prelude::*;
let connection = Connection::new("sqlite::memory:").await?;
db::create().execute(&connection).await?;
let date_updated = date().nullable(true);
table::create("users")
.column("name", varchar(255))
.column("age", integer())
.column("date_updated", date_updated)
.execute(&mut connection)
.await?
db::drop().execute(&connection).await?;License: MIT OR Apache-2.0