Closed
Bug 1003527
Opened 12 years ago
Closed 9 years ago
Split schema into raw data and reports_clean + reports
Categories
(Socorro :: Database, task)
Socorro
Database
Tracking
(Not tracked)
RESOLVED
WONTFIX
People
(Reporter: selenamarie, Unassigned)
References
Details
Todo:
* Separate schemas in model.py
* Create script to deploy in two different databases
* Set up configuration and system-level config for separate DBs
* Set up postgres_fdw between databases in test environment
|
Reporter | |
Comment 1•12 years ago
|
||
Some prior art:
Examples of syntax for multiple bind styles:
https://pythonhosted.org/Flask-SQLAlchemy/binds.html
https://docs.djangoproject.com/en/dev/topics/db/multi-db/
http://stackoverflow.com/questions/15275799/sqlalchemy-and-multiple-databases
https://gist.github.com/jvanasco/1686834 # looks awesome
|
|
Reporter | |
Updated•12 years ago
|
Assignee: nobody → sdeckelmann
|
|
Reporter | |
Updated•11 years ago
|
|
|
Reporter | |
Comment 2•11 years ago
|
||
Trying this initially by setting up two schemas -- incoming and matviews.
|
|
Reporter | |
Updated•9 years ago
|
Assignee: sdeckelmann → nobody
|
||
Comment 3•9 years ago
|
||
we're no longer pursuing this pattern
Status: NEW → RESOLVED
Closed: 9 years ago
Resolution: --- → WONTFIX
You need to log in
before you can comment on or make changes to this bug.
Description
•