sqlite-utils 用于 SQLite 数据库操作的 Python 命令行界面
sqlite-utils is a Python CLI utility and library by Simon Willison for manipulating SQLite databases. It lets you pipe JSON, CSV, or TSV data directly into SQLite, run in-memory SQL queries against files, configure full-text search, and perform schema transformations — all from the command line.
Installation
Use the upstream install or setup path that matches your environment:
- pip install sqlite-utils
- brew install sqlite-utils
Requirements and caveats from upstream:
-
- Python CLI utility and library for manipulating SQLite databases.
- You can also import sqlite_utils and use it as a Python library like this:
Basic usage or getting-started notes:
- Run in-memory SQL queries, including joins, directly against data in CSV, TSV or JSON files and view the results
- Configure SQLite full-text search against your database tables and run search queries against them, ordered by relevance
- Run transformations against your tables to make schema changes that SQLite ALTER TABLE does not directly support, such as changing the type o...
- Source: https://github.com/1991513ccie-png/skills
- Extracted from upstream docs: https://raw.githubusercontent.com/simonw/sqlite-utils/HEAD/README.md
