sqlite-utils 3.39

CLI tool and Python library for manipulating SQLite databases

Stars: 2007, Watchers: 2007, Forks: 124, Open Issues: 126

The simonw/sqlite-utils repo was created 7 years ago and the last code push was 3 weeks ago.
The project is very popular with an impressive 2007 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 126 open issues on GitHub

• transform(update_incoming_fks=True) and –update-incoming-fks
• Insert CSV with –detect-types crashes for CSV files that contain only a header row
• docs: fix typo 'Yo ucan' -> 'You can' in cli.rst
• Make square braces only return tables, not views
• Make square braces only return tables, not views
• Add automatic JSON deserialization feature
• sqlite-utils 4.0a1 enable_fts(replace=True): sqlite3.OperationalError: table "{}_fts" already exists
• BM25 ranking with search
• Enable FTS for attached dbs

See more issues on GitHub