sqlite-utils
Python CLI utility and library for manipulating SQLite databases
File Explorer
- action.yml
- setup-sqlite-version.sh
- codeql-analysis.yml
- documentation-links.yml
- publish.yml
- spellcheck.yml
- test-coverage.yml
- test-sqlite-support.yml
- test.yml
- FUNDING.yml
- custom.js
- base.html
- .gitignore
- changelog.rst
- cli-reference.rst
- cli.rst
- codespell-ignore-words.txt
- conf.py
- contributing.rst
- index.rst
- installation.rst
- Makefile
- migrations.rst
- plugins.rst
- python-api.rst
- reference.rst
- tutorial.ipynb
- upgrading.rst
- __init__.py
- __main__.py
- cli.py
- create_table_parser.py
- db.py
- hookspecs.py
- migrations.py
- plugins.py
- py.typed
- recipes.py
- utils.py
- example1.csv
- example2.csv
- example3.csv
- example4.csv
- __init__.py
- conftest.py
- ext.c
- test_analyze.py
- test_analyze_tables.py
- test_atomic.py
- test_attach.py
- test_cli.py
- test_cli_bulk.py
- test_cli_convert.py
- test_cli_insert.py
- test_cli_memory.py
- test_cli_migrate.py
- test_column_affinity.py
- test_column_casing.py
- test_constructor.py
- test_conversions.py
- test_convert.py
- test_create.py
- test_create_table_parser.py
- test_create_view.py
- test_default_value.py
- test_delete.py
- test_docs.py
- test_duplicate.py
- test_enable_counts.py
- test_extract.py
- test_extracts.py
- test_foreign_keys.py
- test_fts.py
- test_get.py
- test_gis.py
- test_hypothesis.py
- test_insert_files.py
- test_introspect.py
- test_list_mode.py
- test_lookup.py
- test_m2m.py
- test_migrations.py
- test_mutator_transactions.py
- test_plugins.py
- test_query.py
- test_recipes.py
- test_recreate.py
- test_register_function.py
- test_rows.py
- test_rows_from_file.py
- test_sniff.py
- test_suggest_column_types.py
- test_tracer.py
- test_transform.py
- test_update.py
- test_upsert.py
- test_utils.py
- test_wal.py
- .gitignore
- .readthedocs.yaml
- codecov.yml
- Justfile
- LICENSE
- MANIFEST.in
- mypy.ini
- pyproject.toml
- README.md
# Use via CDN
jsDelivrjsDelivr serves any public GitHub repository as a CDN with zero setup. Pick a version and a file to get a ready-to-paste link and snippet.
Command Glossary
Commands referenced in this DOCs, explained below.
brew install
View Details ▼
brew install
Install a Homebrew formula or cask.
brew install {{formula|cask}}
Install a formula/cask:
brew install {{[-s|--build-from-source]}} {{formula}}
Build and install a formula from source (dependencies will still be installed from bottles):
brew install {{[-n|--dry-run]}} {{formula|cask}}
Download the manifest, print what would be installed but don't actually install anything:
pip install
View Details ▼
pip install
Install Python packages.
pip install {{package1 package2 ...}}
Install one or more packages:
pip install {{package1 package2 ...}} {{[-U|--upgrade]}}
Upgrade all specified packages to the latest version, installing any that are not already present:
pip install {{package}}=={{version}}
Install a specific version of a package:
sqlite-utils
View Details ▼
sqlite-utils
Manipulate SQLite databases in a number of different ways.
sqlite-utils create-database {{path/to/database.db}}
Create a database:
sqlite-utils create-table {{path/to/database.db}} {{table_name}} {{id integer name text height float photo blob --pk id}}
Create a table:
sqlite-utils tables {{path/to/database.db}}
List tables:
