peewee will de-dupe it and aggregate the tweets as it iterates through the result set. This method involves a lot of data being transferred over the wire and a lot of logic in Python to de-duplicate rows transferred over the wire since data is not duplicated. There is less Python overhead since we don’t have to de-dupe things. LIMIT works as you’d expect on the outer-most query, but may be difficult to implement the sub-selects. Using aggregate_rows The aggregate_rows() approach selects all data in one go and de-dupes things in- memory. Like prefetch(), it can work with arbitrarily complex queries. To use this

peewee will de-dupe it and aggregate the tweets as it iterates through the result set. This method involves a lot of data being transferred over the wire and a lot of logic in Python to de-duplicate rows over the wire since data is not duplicated. • There is less Python overhead since we don’t have to de-dupe things. • LIMIT works as you’d expect on the outer-most query, but may be difficult to implement the sub-selects. Using aggregate_rows The aggregate_rows() approach selects all data in one go and de-dupes things in-memory. Like prefetch(), it can work with arbitrarily complex queries. To use this

through_model The Model representing the many-to-many junction table. Will be auto-generated if not explicitly de- clared. add(value[, clear_existing=True]) Parameters • value – Either a Model instance, a list indexes=None[, primary_key=None[, constraints=None[, schema=None[, only_save_dirty=False[, table_alias=None[, de- pends_on=None[, options=None[, without_rowid=False[, **kwargs]]]]]]]]]]] ]) Parameters • model (Model) has been removed. Additionally, Select.aggregate_rows() has been removed. This helper was used to de-duplicate left-join queries to give the appearance of efficiency when iterating a model and its relations

has been removed. Additionally, Select.aggregate_rows() has been removed. This helper was used to de-duplicate left-join queries to give the appearance of efficiency when iterating a model and its relations through_model The Model representing the many-to-many junction table. Will be auto-generated if not explicitly de- clared. add(value[, clear_existing=True]) Parameters • value – Either a Model instance, a list indexes=None[, primary_key=None[, constraints=None[, schema=None[, only_save_dirty=False[, table_alias=None[, de- pends_on=None[, options=None[, without_rowid=False[, **kwargs]]]]]]]]]]] ]) Parameters • model (Model)

has been removed. Additionally, Select.aggregate_rows() has been removed. This helper was used to de-duplicate left-join queries to give the appearance of efficiency when iterating a model and its relations through_model The Model representing the many-to-many junction table. Will be auto-generated if not explicitly de- clared. add(value[, clear_existing=True]) Parameters • value – Either a Model instance, a list indexes=None[, primary_key=None[, constraints=None[, schema=None[, only_save_dirty=False[, table_alias=None[, de- pends_on=None[, options=None[, without_rowid=False[, **kwargs]]]]]]]]]]] ]) Parameters • model (Model)

through_model The Model representing the many-to-many junction table. Will be auto-generated if not explicitly de- clared. add(value[, clear_existing=True]) Parameters • value – Either a Model instance, a list indexes=None[, primary_key=None[, constraints=None[, schema=None[, only_save_dirty=False[, table_alias=None[, de- pends_on=None[, options=None[, without_rowid=False[, **kwargs]]]]]]]]]]] ]) Parameters • model (Model) has been removed. Additionally, Select.aggregate_rows() has been removed. This helper was used to de-duplicate left-join queries to give the appearance of efficiency when iterating a model and its relations

has been removed. Additionally, Select.aggregate_rows() has been removed. This helper was used to de-duplicate left-join queries to give the appearance of efficiency when iterating a model and it’s relations

has been removed. Additionally, Select.aggregate_rows() has been removed. This helper was used to de-duplicate left-join queries to give the appearance of efficiency when iterating a model and its relations

has been removed. Additionally, Select.aggregate_rows() has been removed. This helper was used to de-duplicate left-join queries to give the appearance of efficiency when iterating a model and its relations

has been removed. Additionally, Select.aggregate_rows() has been removed. This helper was used to de-duplicate left-join queries to give the appearance of efficiency when iterating a model and its relations