Question​

How to test PostgreSQL Row-Level Security (RLS) policies using Atlas.

Question​

What encoding is used by Atlas for schema files? How do you avoid encoding issues with PowerShell on Windows?

Answer​

Atlas uses UTF-8 to encode schema files and migration files generated by Atlas. UTF-8 is the default encoding on nearly all system terminals, but on Windows, PowerShell uses UTF-16 by default. This can cause an encoding issue when Atlas loads the schema files generated by the inspect command.

How can I check the size of my database schemas and count the number of objects in each schema?

Applications often rely on a static dataset to pre-exist in the database in order to function. Examples for such datasets include user roles, country names, or product categories.

The process of populating the database with this initial data is called "seeding". This guide will show you how to seed your database using Atlas.

Question​

How can I keep a single canonical schema or model and apply it to multiple database drivers (for example, an application Postgres database and a data-lake store) so the two remain in sync?

How do I instruct Atlas to not generate RENAME commands for table constraints in schema migrations when running commands such as migrate diff, schema apply, schema plan, etc.?

Question​

How can I run init scripts on SQL Server when using GitHub Actions services instead of the Atlas docker blocks?

How to use a database URL that contains a password with special characters such as @ or #?