Declarative Schemas for simpler database management

Today we’re releasing declarative schemas to simplify managing and maintaining complex database schemas. With declarative schemas, you can define your database structure in a clear, centralized, and version-controlled manner. What are declarative schemas? # Declarative schemas store the final desired state of the database in .sql files that can be saved and versioned alongside a project. For example, here is the declarative schema for a classic products table: _ 10 create table "products" ( _ 10 "id" serial primary key, _ 10 "name" text not null, _ 10 "description" text, _ 10 "price" numeric(10,2) not null, _ 10 "created_at" timestamp default now() _ 10 ); _ 10 _ 10 alter table "products" _ 10 enable row level security; Declarative schemas offer numerous benefits over making changes to your database schema directly: Single pane of glass . Maintain your entire database schema in one place, reducing redundancy and potential errors. . Maintain your entire database schema in one ... Read full article.