#10 Review database schema
Closed: Invalid None Opened 9 years ago by puiterwijk.

The current schema has TEXT columns for everything.
The first column and probably opt columns as well can be VARCHAR(255), which would give us indexing.


Fields changed

milestone: => 1.0 m1
owner: simo => puiterwijk
status: new => assigned

After checking internal postgresql and sqlite implementations and running some benchmarks, the conclusion is that the difference between VARCHAR(n) and TEXT is nothing, as internally it's the same structure.
Because of this, we will just stick to TEXT.

patch_available: => 0
resolution: => invalid
status: assigned => closed

Fields changed

rhbz: => 0

Metadata Update from @nkinder:
- Issue assigned to puiterwijk
- Issue set to the milestone: 1.0 m1

7 years ago

Login to comment on this ticket.

Metadata