atviriduomenys / spinta

Spinta is a framework to describe, extract and publish data (a DEP Framework).
MIT License
10 stars 4 forks source link

Use schemas for each dataset #598

Open sirex opened 2 months ago

sirex commented 2 months ago

Currently internal PostgreSQL backend stores all data into a single schema, creating large number of tables wit long table names.

To make database table management easier it would be better, to create a separate schema for each dataset and store tables without dataset prefix, avoiding shortening table names.

Instead of tables named like datasets/gov/example/MyTable, there would be a separate schema name datasets/gov/example and a table named MyTable.