PostgreSQL: use UUID type and store tags in ARRAY not TEXT

Bug #1627946 reported by Xavier Hardy
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mistral
Triaged
Low
Lucky samadhiya

Bug Description

Hi Mistral team,

In PostgreSQL, there is a UUID type, it should be used as it allows to store the UUID as a 16-byte array and not as a 36 character/byte string. SQLAlchemy is able to provide types that match the DB implementation (e.g. it would use String for SQLite and UUID for PostgreSQL).

The same applies to tags, they should be stored as an array of strings instead of a TEXT in PostgreSQL.

http://docs.sqlalchemy.org/en/latest/core/custom_types.html

Regards,
Xavier

Tags: db mistral model
Changed in mistral:
assignee: nobody → Lucky samadhiya (lucky-samadhiya)
Changed in mistral:
status: New → Triaged
importance: Undecided → Low
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.