drawdb-io
[FEATURE] Add support for table partitioning
Is your feature request related to a problem? Please describe. Table partitioning is a must have for large databases, allowing to split data according a list of values or by a range.
Describe the solution you'd like Several databases support table partitioning, and PostgreSQL, CockroachDB and YugabyteDB are among them. This feature allow great control about data distribution among splitted tables. For example, someone could have a logs table with range by date, and then it's possible to delete records with more than 180 days just by dropping the corresponding partition. There lots of more use cases for partitioning (like transfer data to slower - and cheaper - disks when the partition becomes obsolete (like moving to DuckDB/Parquet files at s3).
Additional context PostgreSQL documentation: https://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETABLE-PARMS-PARTITION-BY CockroachDB documentation: https://www.cockroachlabs.com/docs/v25.2/partitioning Oracle documentation: https://www.oracle.com/database/technologies/partitioning.html MySQL documentation: https://dev.mysql.com/doc/refman/9.0/en/partitioning-overview.html
