brad garland

Where does the database schema live?

Hi XXXXX,

Yes, the GUI reads the csv and populates the performance tables.

The tables and views were not documented in Internal_table.xlsx spreadsheet or in the create_db.sql script, as in a Rails project the correct place for database schema information is in the db folder within the project – adding it elsewhere is duplication which leads to errors, missing information and unnecessary overhead.

There really needs to be a single place for database information and in Rails, that place is migrations. A sql script could be generated from the database after migrations have run, and the schema could be exported to Excel if necessary for reporting purposes. It makes no sense to have 3 original sources of the same information.

Regards,
Brad.

Filed under: Uncategorized