sqlite-utils 3.36

CLI tool and Python library for manipulating SQLite databases

Stars: 1480, Watchers: 1480, Forks: 103, Open Issues: 99

The simonw/sqlite-utils repo was created 5 years ago and the last code push was 1 weeks ago.
The project is very popular with an impressive 1480 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/

Documentation:

https://sqlite-utils.datasette.io/en/stable/

GitHub Repo:

https://github.com/simonw/sqlite-utils

Classifiers

• Database

Related Packages

Errors

A list of common sqlite-utils errors.

Code Examples

Here are some sqlite-utils code examples and snippets.

GitHub Issues

The sqlite-utils package has 99 open issues on GitHub

• Python library docs should start with a self contained example
• Add new gis.py module with spatialite helper methods
• Add examples to every --help
• Research how much of a difference analyze / sqlite_stat1 makes
• Better error message if --convert code fails to return a dict
• MemoryError
• Use RETURNING if available to populate last_pk
• Support for CHECK constraints
• sqlite-utils insert --extract colname
• Test against pysqlite3 running SQLite 3.37
• Idea: conversions= could take Python functions
• Helper methods for working with SpatiaLite

See more issues on GitHub