Postgresql

Changing a field type in an Ecto embedded schema requires both a code update and a database migration. This guide walks through the process, ensuring data consistency and avoiding common pitfalls.

Learn how to create a non-primary key UUID field in an Ecto schema using PostgreSQL's `uuid_generate_v4()` function.

Learn how to use PostgreSQL WITH queries to efficiently generate breadcrumbs in a storage system.