Select to view content in your preferred language

Storing features into local db (Postgresql)

287
0
10-19-2022 04:10 PM
Aeseir
by
Frequent Contributor

We have a scenario where the user creates graphic using sketch layer, and on completion adds it as a feature to a local sourced feature layer.

We want to start storing some of these custom features in local db as they don't fit any solid use case to be placed in our dedicated feature services.

What is the best practice to do this?

What is the recommendation for property type to be used on the Postgres side?

 

Currently we are serialising the entire feature (JSON.stringify), then storing it as a string on Postgresql side.

0 Kudos
0 Replies