| Name | sqlite-utils-shell JSON |
| Version |
0.3
JSON |
| download |
| home_page | |
| Summary | An interactive shell for sqlite-utils |
| upload_time | 2023-12-21 06:25:14 |
| maintainer | |
| docs_url | None |
| author | Simon Willison |
| requires_python | |
| license | Apache-2.0 |
| keywords |
|
| VCS |
 |
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# sqlite-utils-shell
[](https://pypi.org/project/sqlite-utils-shell/)
[](https://github.com/simonw/sqlite-utils-shell/releases)
[](https://github.com/simonw/sqlite-utils-shell/actions?query=workflow%3ATest)
[](https://github.com/simonw/sqlite-utils-shell/blob/main/LICENSE)
An interactive shell for [sqlite-utils](https://sqlite-utils.datasette.io/)
**Alternative**: [sqlite-utils-litecli](https://github.com/simonw/sqlite-utils-litecli) is similar to this but better, because it includes full autocompletion against table and column names.
## Installation
Install this plugin in the same environment as sqlite-utils.
```bash
sqlite-utils install sqlite-utils-shell
```
## Usage
To start a new interactive shell session against a database:
```bash
sqlite-utils shell data.db
```
Type `quit` or `exit` to end the session.
Omit the filename to run against an in-memory database.
To load additional SQLite extensions pass their paths as one or more `--load-extension` arguments:
```bash
sqlite-utils shell data.db \
--load-extension /path/to/extension.so
```
## Development
To set up this plugin locally, first checkout the code. Then create a new virtual environment:
cd sqlite-utils-shell
python3 -m venv venv
source venv/bin/activate
Now install the dependencies and test dependencies:
pip install -e '.[test]'
To run the tests:
pytest
Raw data
{
"_id": null,
"home_page": "",
"name": "sqlite-utils-shell",
"maintainer": "",
"docs_url": null,
"requires_python": "",
"maintainer_email": "",
"keywords": "",
"author": "Simon Willison",
"author_email": "",
"download_url": "https://files.pythonhosted.org/packages/bc/6d/4a542fc95f6df36ae998a7af26d4690b8652659ac9a43921935a838d067c/sqlite-utils-shell-0.3.tar.gz",
"platform": null,
"description": "# sqlite-utils-shell\n\n[](https://pypi.org/project/sqlite-utils-shell/)\n[](https://github.com/simonw/sqlite-utils-shell/releases)\n[](https://github.com/simonw/sqlite-utils-shell/actions?query=workflow%3ATest)\n[](https://github.com/simonw/sqlite-utils-shell/blob/main/LICENSE)\n\nAn interactive shell for [sqlite-utils](https://sqlite-utils.datasette.io/)\n\n**Alternative**: [sqlite-utils-litecli](https://github.com/simonw/sqlite-utils-litecli) is similar to this but better, because it includes full autocompletion against table and column names.\n\n## Installation\n\nInstall this plugin in the same environment as sqlite-utils.\n```bash\nsqlite-utils install sqlite-utils-shell\n```\n\n## Usage\n\nTo start a new interactive shell session against a database:\n```bash\nsqlite-utils shell data.db\n```\nType `quit` or `exit` to end the session.\n\nOmit the filename to run against an in-memory database.\n\nTo load additional SQLite extensions pass their paths as one or more `--load-extension` arguments:\n```bash\nsqlite-utils shell data.db \\\n --load-extension /path/to/extension.so\n```\n\n## Development\n\nTo set up this plugin locally, first checkout the code. Then create a new virtual environment:\n\n cd sqlite-utils-shell\n python3 -m venv venv\n source venv/bin/activate\n\nNow install the dependencies and test dependencies:\n\n pip install -e '.[test]'\n\nTo run the tests:\n\n pytest\n",
"bugtrack_url": null,
"license": "Apache-2.0",
"summary": "An interactive shell for sqlite-utils",
"version": "0.3",
"project_urls": {
"CI": "https://github.com/simonw/sqlite-utils-shell/actions",
"Changelog": "https://github.com/simonw/sqlite-utils-shell/releases",
"Homepage": "https://github.com/simonw/sqlite-utils-shell",
"Issues": "https://github.com/simonw/sqlite-utils-shell/issues"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "74f54e913290b49d6834210d0ec148365bc375fe6fe889a8c10eaac348622f41",
"md5": "21dfe45dbdbcdded9e763c45d423387c",
"sha256": "9168a67577081116301c3c74df99c5d1ee1b4fc074afcecd97660d6c66e8b923"
},
"downloads": -1,
"filename": "sqlite_utils_shell-0.3-py3-none-any.whl",
"has_sig": false,
"md5_digest": "21dfe45dbdbcdded9e763c45d423387c",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 7873,
"upload_time": "2023-12-21T06:25:12",
"upload_time_iso_8601": "2023-12-21T06:25:12.908028Z",
"url": "https://files.pythonhosted.org/packages/74/f5/4e913290b49d6834210d0ec148365bc375fe6fe889a8c10eaac348622f41/sqlite_utils_shell-0.3-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "bc6d4a542fc95f6df36ae998a7af26d4690b8652659ac9a43921935a838d067c",
"md5": "44b0ac15f13a4a30bdde9144f2f23ff1",
"sha256": "fbe62362b3e2bab1e50107bcd4fe283377c9011f80534ffad5531164a8e96e55"
},
"downloads": -1,
"filename": "sqlite-utils-shell-0.3.tar.gz",
"has_sig": false,
"md5_digest": "44b0ac15f13a4a30bdde9144f2f23ff1",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 7762,
"upload_time": "2023-12-21T06:25:14",
"upload_time_iso_8601": "2023-12-21T06:25:14.333957Z",
"url": "https://files.pythonhosted.org/packages/bc/6d/4a542fc95f6df36ae998a7af26d4690b8652659ac9a43921935a838d067c/sqlite-utils-shell-0.3.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-12-21 06:25:14",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "simonw",
"github_project": "sqlite-utils-shell",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "sqlite-utils-shell"
}
