ddf0127a1dAccepting request 1254384 from home:glaubitz:branches:devel:languages:pythonMatej Cepl2025-03-19 12:39:24 +00:00
e5f9523f53Accepting request 1138236 from devel:languages:pythonAna Guerrero2024-01-12 22:45:48 +00:00
b116d57a3f- update to 3.36: * Support for creating tables in SQLite STRICT mode. Thanks, Taj Khattra. (:issue:344) CLI commands create-table, insert and upsert all now accept a --strict option. Python methods that can create a table - table.create() and insert/upsert/insert_all/upsert_all all now accept an optional strict=True parameter. The transform command and table.transform() method preserve strict mode when transforming a table. * CLI commands create-table, insert and upsert all now accept a --strict option. * Python methods that can create a table - table.create() and insert/upsert/insert_all/upsert_all all now accept an optional strict=True parameter. * The transform command and table.transform() method preserve strict mode when transforming a table. * The sqlite-utils create-table command now accepts str, int and bytes as aliases for text, integer and blob respectively. (:issue:606)Dirk Mueller2024-01-12 08:20:58 +00:00
65a8b285e9Accepting request 1132122 from devel:languages:pythonAna Guerrero2023-12-08 21:33:40 +00:00
567b7d89ad- update to 3.35.2: * The `--load-extension=spatialite option and :ref:find_spatialite() <python_api_gis_find_spatialite> utility function now both work correctly on arm64 Linux. * Fix for bug where sqlite-utils insert could cause your terminal cursor to disappear. Thanks, Luke Plant * `datetime.timedelta values are now stored as TEXT columns. Thanks, Harald Nezbeda * Test suite is now also run against Python 3.12. * Fixed a bug where :ref:table.transform() <python_api_transform> would sometimes re-assign the `rowid values for a table rather than keeping them consistent across the operation. (:issue:592) * Adding foreign keys to a table no longer uses PRAGMA writable_schema = 1 to directly manipulate the sqlite_master table. This was resulting in errors in some Python installations where the SQLite library was compiled in a way that prevented this from working, in particular on macOS. Foreign keys are now added using the :ref:table transformation <python_api_transform> mechanism instead. * This new mechanism creates a full copy of the table, so it is likely to be significantly slower for large tables, but will no longer trigger table sqlite_master may not be modified errors on platforms that do not support PRAGMA writable_schema = 1. * A new plugin, sqlite-utils-fast-fks <https://github.com/simonw/sqlite-utils-fast-fks>__, is now available for developers who still want to use that faster but riskier implementation. * The :ref:table.transform() method <python_api_transform>`Dirk Mueller2023-12-08 14:28:52 +00:00
5cfdd8c4ae- update to 3.24: * SpatiaLite helpers for the `sqlite-utils command-line tool * All commands now include example usage in their --help - see :ref:cli_reference. (:issue:384) * Python library documentation has a new :ref:python_api_getting_started section. (:issue:387) * Documentation now uses Plausible analytics <https://plausible.io/>__. (:issue:389) * CLI and Python library improvements to help run ANALYZE inserting rows, to gain better performance from the SQLite query planner when it runs against indexes. * Three new CLI commands: `create-database, analyze and bulk. * More details and examples can be found in the annotated release notes <https://simonwillison.net/2022/Jan/11/sqlite-utils/>__. * Fixed bug where sqlite-utils upsert ... --detect-types ignored the --detect-types` option.Dirk Mueller2022-02-16 20:42:31 +00:00
Ana Guerrero
Matej Cepl
Dirk Mueller
Dominique Leuenberger
Markéta Machová
Tomáš Chvátal