Description

Vertical partitioning allows to store tables rows in different files. These files are automatically loaded on database loading. If horizontal partitioning is also enabled, it takes precedence over vertical partitioning, i.e. rows are split first and then tables are split

Why use it?

If you have several developers in your team and if you can make an agreement, that each of them edit only certain tables data exclusively, you can split database file into several files (one for each developer) and update data without using merge tools Note, that database structure is always stored in main database file (bansheegz_database.bytes), so it makes sense to assign one person responsible for updating database structure

Setup

1. Enable partition addon if it's not enabled
2. Enable vertical partitioning
   
3. After that, DbPartitionVertical table will be created with nested field. Each row of this table represents a separate partition
   
4. To add tables to partition, click on DbPartitionVerticalMetas nested field button and add a separate row for each table you want to add to partition
   
5. That's it, next time you save database - data will be split between different partitions files