Contents

sqlite-utils 3.22

0

CLI tool and Python utility functions for manipulating SQLite databases

CLI tool and Python utility functions for manipulating SQLite databases

Stars: 616, Watchers: 616, Forks: 54, Open Issues: 46

The simonw/sqlite-utils repo was created 3 years ago and was last updated 5 hours ago.
The project is popular with 616 github stars!

How to Install sqlite-utils

You can install sqlite-utils using pip

pip install sqlite-utils

or add it to a project with poetry

poetry add sqlite-utils

Package Details

Author
Simon Willison
License
Apache License, Version 2.0
Homepage
https://github.com/simonw/sqlite-utils
PyPi
https://pypi.org/project/sqlite-utils/
GitHub Repo
https://github.com/simonw/sqlite-utils

Classifiers

  • Database
No  sqlite-utils  pypi packages just yet.

Errors

A list of common sqlite-utils errors.

No  sqlite-utils  errors just yet.

Code Examples

Here are some sqlite-utils code examples and snippets.

No  sqlite-utils  code examples just yet.

GitHub Issues

The sqlite-utils package as 46 open issues on GitHub

  • Use RETURNING if available to populate last_pk
  • Support for CHECK constraints
  • sqlite-utils insert --convert option
  • sqlite-utils insert --extract colname
  • Optional caching mechanism for table.lookup()
  • A way of creating indexes on newly created tables
  • Command for creating an empty database
  • Test against pysqlite3 running SQLite 3.37
  • Way to test SQLite 3.37 (and potentially other versions) in CI
  • Support STRICT tables
  • Provide function to generate hash_id from specified columns
  • Idea: conversions= could take Python functions

See more issues on GitHub

See Also