Load SpiceDB schema into pg

This change runs the `spicedb datastore migrate` command against the
pg database at startup. It's not a performant solution but it allows for
iteration and exploration to understand the challenges with hosting
spicedb in postgresql.

1 files changed, 8 insertions, 1 deletions

diff --git a/Makefile b/Makefile
index f50bc8d..4425037 100644
--- a/Makefile
+++ b/Makefile
@@ -3,6 +3,7 @@ GIT_BRANCH := $(shell git rev-parse --abbrev-ref HEAD | sed 's/\//_/g')
 IMAGE_TAG := $(PROJECT_NAME):$(GIT_BRANCH)
 AUTHZD_BIN := bin/authzd
 SPARKLED_BIN := bin/sparkled
+SPICEDB := bin/spicedb
 TOOL := bin/tool
 ZED := bin/zed
 
@@ -90,4 +91,10 @@ db-init:
 db-create: db-init
 	@mise exec postgres -- createdb -h /tmp sparkle_development || true
 
-db-setup: db-schema-load db-seed
+db-migrate:
+	@$(TOOL) godotenv -f .env.local,.env -- sh -c '$(SPICEDB) datastore migrate head --datastore-engine postgres --datastore-conn-uri "$$DATABASE_URL" --log-level trace' --skip-release-check
+
+db-console:
+	@mise exec postgres -- psql -h /tmp sparkle_development
+
+db-setup: db-create db-schema-load db-seed