I am wokring on building a website, because I don't really understand how DBIC works it was suggested that I take Catalyst out of the equation and build my database first.
I would like to write my relationships first, then using a script deploy my DB and (if necessary) pre populate it. Doing it via scripted interface will allow for more flexibility in deployment as well as DB choice.
I have been working on this and you can see my full source at https://github.com/three18ti/dbix-schema-test. I did post about an error I am receiving in a previous post DBIC Error: DBIx::Class::PassphraseColumn::new(): new_result needs a hash at constructor but it seems that it is a rare error to encounter.
Can someone please provide some pointers on how to correctly design a DB schema using DBIC?