← Back to team overview

brewtarget-devs team mailing list archive

Schema Management

 

I put up MR #84
<https://gitorious.org/brewtarget/brewtarget/merge_requests/84> that moves
all the schema-related things from their various scattered locations all
into DatabaseSchemaHelper.cpp. The database schema and migrations are all
contained within. If you would, take a look and let me know if you see any
issues.

## Overview
* No more sql scripts or xml files
* DB versioning is no longer text like "2.1.0" but integer
* Every change to the schema should bump the DB version

## Advantages
* One place to edit the schema
* Devs no longer need to manually run partial migration scripts when
  someone edits the schema
* Don't need sqlite3 to build
* Database code is simplified

-- 
Philip G. Lee
www.linkedin.com/in/philipgreggorylee