Difference between revisions of "VbzCart/coding"
< VbzCart
Jump to navigation
Jump to search
(moved this stuff from main page, because it's all about coding; added overall status) |
(moved data design stuff here) |
||
| Line 1: | Line 1: | ||
At this point (2014-12-18), I'm just trying to get VbzCart back up and running after a massive rewrite that has so far taken over a year. Code has now been published in GitHub, and there's a Redmine repository for tracking bugs and (eventually) features (see links below). | At this point (2014-12-18), I'm just trying to get VbzCart back up and running after a massive rewrite that has so far taken over a year. Code has now been published in GitHub, and there's a Redmine repository for tracking bugs and (eventually) features (see links below). | ||
| + | ==Data Design== | ||
| + | * [[VbzCart/procs]] | ||
| + | * [[VbzCart/queries]] | ||
| + | * [[VbzCart/tables]] | ||
| + | The MySQL user only needs INSERT, SELECT, and UPDATE privileges on most of the tables, but it does need DELETE privileges on the assignment tables (tables whose name is of the form *_X_*). Maybe I should add a WhenVoided field on these tables in order to make that unnecessary. | ||
| − | + | At this point, I'm trying to eliminate the need for PROCs and queries (VIEWs), but work is still in progress. | |
| + | ==Code== | ||
| + | * [https://github.com/woozalia/VbzCart GitHub]: code repository | ||
| + | * [http://rm.vbz.net/projects/vbzcart Redmine @ vbz]: project tracker | ||
==Links== | ==Links== | ||
| − | |||
| − | |||
| − | |||
===Trivia=== | ===Trivia=== | ||
* [http://www.bitboost.com/ref/international-address-formats.html International Address Formats]: reference for how addresses should be formatted for different countries | * [http://www.bitboost.com/ref/international-address-formats.html International Address Formats]: reference for how addresses should be formatted for different countries | ||
| − | |||
| − | |||
Revision as of 18:26, 8 January 2016
At this point (2014-12-18), I'm just trying to get VbzCart back up and running after a massive rewrite that has so far taken over a year. Code has now been published in GitHub, and there's a Redmine repository for tracking bugs and (eventually) features (see links below).
Data Design
The MySQL user only needs INSERT, SELECT, and UPDATE privileges on most of the tables, but it does need DELETE privileges on the assignment tables (tables whose name is of the form *_X_*). Maybe I should add a WhenVoided field on these tables in order to make that unnecessary.
At this point, I'm trying to eliminate the need for PROCs and queries (VIEWs), but work is still in progress.
Code
- GitHub: code repository
- Redmine @ vbz: project tracker
Links
Trivia
- International Address Formats: reference for how addresses should be formatted for different countries