_            _    _        _         _
      /\ \         /\ \ /\ \     /\_\      / /\
      \_\ \       /  \ \\ \ \   / / /     / /  \
      /\__ \     / /\ \ \\ \ \_/ / /     / / /\ \__
     / /_ \ \   / / /\ \ \\ \___/ /     / / /\ \___\
    / / /\ \ \ / / /  \ \_\\ \ \_/      \ \ \ \/___/
   / / /  \/_// / /   / / / \ \ \        \ \ \
  / / /      / / /   / / /   \ \ \   _    \ \ \
 / / /      / / /___/ / /     \ \ \ /_/\__/ / /
/_/ /      / / /____\/ /       \ \_\\ \/___/ /
\_\/       \/_________/         \/_/ \_____\/
python-sqlite-utils 3.38
Propagated dependencies: python-click@8.1.8 python-click-default-group@1.2.4 python-dateutil@2.9.0 python-sqlite-fts4@1.0.3 python-tabulate@0.9.0
Channel: guix
Location: gnu/packages/databases.scm (gnu packages databases)
Home page: https://github.com/simonw/sqlite-utils
Licenses: ASL 2.0
Synopsis: CLI tool and Python utility functions for manipulating SQLite databases
Description:

This package provides a CLI tool and Python utility functions for manipulating SQLite databases. It's main features are:

  • 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.

Total results: 1