Sqlite-utils

Latest version: v3.36

Safety actively analyzes 638396 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

Page 10 of 19

2.19

- New `sqlite-utils add-foreign-keys` command for [Adding multiple foreign keys at once](https://sqlite-utils.readthedocs.io/en/stable/cli.html#cli-add-foreign-keys). ([157](https://github.com/simonw/sqlite-utils/issues/157))
- New `table.enable_fts(..., replace=True)` argument for replacing an existing FTS table with a new configuration. ([160](https://github.com/simonw/sqlite-utils/issues/160))
- New `table.add_foreign_key(..., ignore=True)` argument for ignoring a foreign key if it already exists. ([112](https://github.com/simonw/sqlite-utils/issues/112))

2.18

- `table.rebuild_fts()` method for rebuilding a FTS index, see [Rebuilding a full-text search table](https://sqlite-utils.readthedocs.io/en/stable/python-api.html#python-api-fts-rebuild). ([155](https://github.com/simonw/sqlite-utils/issues/155))
- `sqlite-utils rebuild-fts data.db` command for rebuilding FTS indexes across all tables, or just specific tables. ([155](https://github.com/simonw/sqlite-utils/issues/155))
- `table.optimize()` method no longer deletes junk rows from the `*_fts_docsize` table. This was added in 2.17 but it turns out running `table.rebuild_fts()` is a better solution to this problem.
- Fixed a bug where rows with additional columns that are inserted after the first batch of records could cause an error due to breaking SQLite's maximum number of parameters. Thanks, Simon Wiles. ([145](https://github.com/simonw/sqlite-utils/issues/145))

2.17

This release handles a bug where replacing rows in FTS tables could result in growing numbers of unneccessary rows in the associated `*_fts_docsize` table. ([149](https://github.com/simonw/sqlite-utils/issues/149))

- `PRAGMA recursive_triggers=on` by default for all connections. You can turn it off with `Database(recursive_triggers=False)`. ([152](https://github.com/simonw/sqlite-utils/issues/152))
- `table.optimize()` method now deletes unnecessary rows from the `*_fts_docsize` table. ([153](https://github.com/simonw/sqlite-utils/issues/153))
- New tracer method for tracking underlying SQL queries, see [Tracing queries](http://127.0.0.1:8000/python-api.html#python-api-tracing). ([150](https://github.com/simonw/sqlite-utils/issues/150))
- Neater indentation for schema SQL. ([148](https://github.com/simonw/sqlite-utils/issues/148))
- Documentation for `sqlite_utils.AlterError` exception thrown by in `add_foreign_keys()`.

2.16.1

- `insert_all(..., alter=True)` now works for columns introduced after the first 100 records. Thanks, Simon Wiles! ([139](https://github.com/simonw/sqlite-utils/issues/139))
- Continuous Integration is now powered by GitHub Actions. ([143](https://github.com/simonw/sqlite-utils/issues/143))

2.16

- `--load-extension` option for `sqlite-utils query` for loading SQLite extensions. ([134](https://github.com/simonw/sqlite-utils/issues/134))
- New `sqlite_utils.utils.find_spatialite()` function for finding SpatiaLite in common locations. ([135](https://github.com/simonw/sqlite-utils/issues/135))

2.15.1

- Now available as a `sdist` package on PyPI in addition to a wheel. ([133](https://github.com/simonw/sqlite-utils/issues/133))

Page 10 of 19

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.