erikbra/grate repository overview

grate is an automated database deployment (change management) system that allows you to use plain old .sql scripts but gain much more. We don't believe in writing databse migrations in C#, but don't care how you get your scripts on disk. Write them at dev time alongside the code for your new feature, or generate larger diff's using other tooling (SSDT/RedGate/etc), whatever works for you and your team! Include schema objects, data, server configuration, whatever you need!

Grate supports:

• Microsoft SQL server
• MariaDB/MySQL
• PostgreSQL
• Sqlite

Check out our site⁠ for more details.

⁠grate features:

Low Maintenance Migrations: It seeks to solve both maintenance concerns and ease of deployment. We follow some of the same idioms as other database management systems (SQL scripts), but we are different in that we think about future maintenance concerns. We want to apply certain scripts whenever there's changes (like functions, views, stored procedures, and permissions), so we don’t have to throw everything into our one-time only update change scripts.

What Version Is YOUR Database On?: We subscribe to the idea of versioning your database how you want. At this point it's very rare to find someone that doesn't think should version your code, and few would argue against versioning your code in a way that can lead back to a specific point in source control history. However, most people don’t really think of doing the same thing with your database. We say version it using the same version as your code base by passing it a version number at runtime. We love versioning our applications based on source control revisions, and how sweet it is when you can pinpoint the exact state of your datatabase and the exact code in your application all to a given point in space and time in your repo!

Use your whole DBMS: You're running a full DBMS, why not use all it's features! Table-Valued Parameters for efficient processing? Data compression for space savings? Fancy-pants indexes? Replication? Fine-grained permission management? If you've ever had to fight with code-based database scaffolding then you'll appreciate the value of sql scripts.