releases: 31773390

This data as json

html_url	id	node_id	tag_name	target_commitish	name	draft	author	prerelease	created_at	published_at	body	repo	reactions
https://github.com/simonw/sqlite-utils/releases/tag/2.21	31773390	MDc6UmVsZWFzZTMxNzczMzkw	2.21	main	2.21	0	9599	0	2020-09-24T16:44:30Z	2020-09-24T16:45:44Z	`table.extract()` and `sqlite-utils extract` now apply much, much faster - one example operation reduced from twelve minutes to just four seconds! (#172) `sqlite-utils extract` no longer shows a progress bar, because it's fast enough not to need one. New `column_order=` option for `table.transform()` which can be used to alter the order of columns in a table. (#175) `sqlite-utils transform --column-order=` option (with a `-o` shortcut) for changing column order. (#176) The `table.transform(drop_foreign_keys=)` parameter and the `sqlite-utils transform --drop-foreign-key` option have changed. They now accept just the name of the column rather than requiring all three of the column, other table and other column. This is technically a backwards-incompatible change but I chose not to bump the major version number because the transform feature is so new. (#177) The table `.disable_fts()`, `.rebuild_fts()`, `.delete()`, `.delete_where()` and `.add_missing_columns()` methods all now `return self`, which means they can be chained together with other table operations.	140912432

Links from other tables