2022-10-10 08:37:09 +03:00
|
|
|
# Data, databases, etc...
|
2020-07-29 02:26:08 +03:00
|
|
|
|
2022-10-10 08:37:09 +03:00
|
|
|
## Data quality issues
|
2020-07-29 02:26:08 +03:00
|
|
|
|
2022-10-10 08:37:09 +03:00
|
|
|
### username casing
|
2020-07-29 02:26:08 +03:00
|
|
|
|
|
|
|
|
The original table store for usernames (GitHub users, etc.) was case sensitive
|
|
|
|
|
for stored data. However, the newer Postgres system uses case insensitive
|
|
|
|
|
indexes. As a result there may be latent bugs.
|
|
|
|
|
|
2022-10-10 08:37:09 +03:00
|
|
|
### date/times
|
2020-07-29 02:26:08 +03:00
|
|
|
|
|
|
|
|
- Approval 'decisionTime' field was buggy in the past
|
|
|
|
|
- Approval 'requested' field was buggy in the past
|
|
|
|
|
|
|
|
|
|
Going forward these fields are ISO8601 date time fields. Existing data may
|
|
|
|
|
continue to have poor formats, and may be an issue during data migration.
|
|
|
|
|
|
2022-10-10 08:37:09 +03:00
|
|
|
## Migration of data
|
2020-07-29 02:26:08 +03:00
|
|
|
|
|
|
|
|
The `localEnvironment` TypeScript file is intended to permit prototyping and
|
|
|
|
|
local development hacks.
|
|
|
|
|
|
|
|
|
|
A job, `migrateLinks`, is able to move links between providers when proper
|
|
|
|
|
configuration is in place.
|
