Maintaining schema in two places?

[kaihendry]

I don't understand your docs here: https://docs.sqlc.dev/en/stable/howto/ddl.html

I'm maintaining my database schema in two places and that doesn't seem right:

1. https://github.com/kaihendry/sqlc-tutorial/blob/main/migrations/20230417134833_init.sql
2. https://github.com/kaihendry/sqlc-tutorial/blob/main/schema.sql

What am I missing please?

I think my question is related to #1928

[coolaj86]

@kaihendry I don't understand the question.

What is the purpose of schema.sql?

I don't have that in my projects and I don't know what it's for (or where it's referenced in the documentation).

I think you're just supposed to pick one - I think goose is what I would pick if I were starting over and hadn't already been using sql migrate - and you're done.

sqlc is aware of those popular migration tools, but doesn't really do anything with them other than follow the convention of the folder name and the lexicographical sort of the files.

[kaihendry]

schema.sql drops out after doing the tutorial here: https://docs.sqlc.dev/en/latest/tutorials/getting-started-postgresql.html

[coolaj86]

I think that's just the "Hello World" migrator - no goose, etc.

[kaihendry]

I grokked what I need to do, just use the migrations directory: https://github.com/kaihendry/sqlc-tutorial/blob/main/sqlc.yaml#L5 and sqlc compiles it..

Thank you @coolaj86 !