Skip to main content

5 posts tagged with "testing"

View All Tags

Your Software Factory Stops at the Database

· 11 min read
Ariel Mashraki
Building Atlas

In August, I wrote that the AI-native SDLC playbook stops at the database. Code is cheap to regenerate. The data in your production database isn't. Software factories make this sharper. An agent takes a ticket, writes the code, runs the tests, and ships it, with no human in the loop. That works for code because code has gates. Tests say whether it's correct, and a bad deploy rolls back.

A migration has no such gate. It can pass every test and still lock your largest table for minutes, because what it costs depends on the data, not the code. Today, the gate is a person who reads the migration and knows which tables are big. A factory doesn't have that person.

In this post, I'll show how we close that gap in Atlas. The team writes down what database code may cost: migrations, queries, functions, procedures, and triggers. Atlas measures every agent's change against those limits twice, first on synthetic data in the agent's sandbox, then on a masked production snapshot before deploy.

Atlas v1.4: Security Scanning, Database Profiler, Agent Skills, Drift Detection, and More

· 37 min read
Ariel Mashraki
Building Atlas

Hey everyone!

We're excited to announce Atlas v1.4. This release brings security scanning to your databases: the new atlas security scan command reports the CVEs affecting your database servers and extensions, from the CLI, CI, or Kubernetes. It also introduces agent skills, a profiler for the Atlas testing framework that works on production-like data, and drift checks between deployments.

Here is what you can find in this release:

  • Security Scanning for Databases - Vulnerability detection for your database servers and extensions with atlas security scan, from CI to Kubernetes, and blast-radius checks for roles.
  • Atlas Agent Skills - Teach Claude Code, Codex, Cursor, and GitHub Copilot to plan, lint, and test schema changes with Atlas.
  • Profiler for the Testing Framework - Measure the locks, rewrites, and space of migrations, queries, and database code, over a masked Amazon RDS snapshot, CSV files, or synthetic rows. In preview.
  • Drift Detection Between Deployments - atlas migrate drift reports every object that diverged from your migrations, for one database or every tenant.
  • Schema Repositories in Your Own Storage - Store schema repositories in your own S3, GCS, or Azure Blob Storage bucket, or an OCI registry, instead of Atlas Cloud.
  • Database Driver Improvements - Snowflake governance policies, SQL Server linked servers and filegroups, PostgreSQL temporal keys, Databricks metric views, Redshift datashares, and more.
  • Atlas Binaries Are Moving to atlasbinaries.com - Starting December 2026, release.ariga.io redirects to atlasbinaries.com. Direct downloads only need the new hostname.

Testing PostgreSQL Schemas with pgTAP and Atlas

· 7 min read
Noa Rogoszinski
DevRel Engineer

Testing your database schema shouldn't be an afterthought. Automating checks on your objects, constraints, and functions is critical to catching breaking changes before they hit production.

Enter pgTAP—which relies on traditional runtime assertions in an ephemeral database—and Atlas—which leverages a modern, declarative approach. This post breaks down how both tools handle schema testing and explains when you should swap out heavy runtime assertions for Atlas's lightweight lint rules.

Strategies for Reliable Schema Migrations

· 12 min read
Rotem Tamir
Building Atlas

Adapted from a talk given at Kube Native 2024:

Introduction​

Database schema migrations are a critical part of the software development lifecycle. They allow us to evolve our data model as our application grows and changes. However, migrations can also be a significant source of risk and downtime if not handled carefully.

Despite teams applying all the common best practices, such as using a migration tool to automate changes and carefully examining each migration before approving it during code review, issues still slip through the cracks, making migrations a source of significant headaches for many engineering teams.

This post explores five strategies for making database schema migrations more reliable by introducing Atlas, a database schema-as-code tool that helps teams make their database schema changes both safer and easier to manage.

How Go Tests "go test"

· 21 min read
Rotem Tamir
Building Atlas

Adapted from a talk given at GopherCon Israel 2024

Introduction​

How does Go, the project, and team behind it, test go test, the Go tool's command for running tests? Does Go test go test using the go test command? In this article, we explore the evolution of how the Go team tests the Go tool (go) and discuss strategies for testing command-line tools written in Go in general.