[ 原始碼： sqlite-utils ]
套件：sqlite-utils（3.36-1）
CLI tool and Python utility functions for manipulating SQLite
Feature highlights:
- Pipe JSON (or CSV or TSV) directly into a new SQLite database file,
automatically creating a table with the appropriate schema
- 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 of a
column
- Extract columns into separate tables to better normalize your existing data
其他與 sqlite-utils 有關的套件
|
|
|
|
-
- dep: libjs-sphinxdoc (>= 7.2.2)
- JavaScript support for Sphinx documentation
-
- dep: python3
- interactive high-level object-oriented language (default python3 version)
-
- dep: python3-click
- Wrapper around optparse for command line utilities - Python 3.x
-
- dep: python3-click-default-group
- Extension for Python click adding default subcommand to group (Python 3)
-
- dep: python3-dateutil
- powerful extensions to the standard Python 3 datetime module
-
- dep: python3-pluggy
- plugin and hook calling mechanisms for Python 3
-
- dep: python3-sqlite-fts4
- Document scoring Python library for SQLite FTS4
-
- dep: python3-tabulate
- pretty-print tabular data in Python3