python3-sqlite-utils Subpackage of python-sqlite-utils

Python CLI utility and library for manipulating SQLite databases. Some features: - 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 - Install plugins to add custom SQL functions and additional features

Releases Overview