DB Design

[tdipisa]

A data model needs to be designed and implemented for PostgreSQL to store Assets data and other connected entities like:

• Mission (name, desc, note, date, geom path)
• Frame (index, coordinates, geom)
• Object (info available from the xml file like: type, status, box)
• Telemetry data (drone orientation, altitude, pich, roll, yaw etc)

[sergey-misuk-yotec]

I suggest to use Django and Django REST Frameworks. Database schema will be described using Django models and then all SQL scripts will be generated automatically. For the first version class views can be used to expose DB entities almost for free.

Which version of PostgreSQL should be used? What format should be used as an output? Is it a Docker image? Or application is supposed to be deployed using more traditional approach?

[tdipisa]

@sergey-misuk-yotec

I suggest to use Django and Django REST Frameworks. Database schema will be described using Django models and then all SQL scripts will be generated automatically. For the first version class views can be used to expose DB entities almost for free.

OK

Which version of PostgreSQL should be used?

I think the latest stable minor can be used (11.2)

What format should be used as an output? Is it a Docker image? Or application is supposed to be deployed using more traditional approach?

I would like to use separated containers for each main component/service