Developing Materialize

Compiling

Check compilation with cargo check. Do not use cargo build or cargo run to build or run Materialize. Use bin/environmentd --build-only to build without running.

Running locally

Start Materialize using bin/environmentd --optimized. Pass --reset to delete data from prior runs (clears the mzdata directory and resets Postgres schemas), useful when testing catalog changes or starting fresh.

Access Materialize using psql:

• psql -p 6875 -h localhost -U materialize for regular access.
• psql -p 6877 -h localhost -U mz_system for system access.

If it fails because CockroachDB is not running, start it: