sqlite-utils

Brand Details

Type: Product

Description: A Python library and command-line tool designed to simplify the creation and population of SQLite databases. It offers utility functions to streamline the process, focusing on productivity rather than acting as a full-fledged Object-Relational Mapper (ORM). It's particularly useful for quickly creating databases from various data sources like JSON, CSV, and TSV files. Key features include: Directly importing JSON, CSV, or TSV data into a new SQLite database, automatically creating the appropriate table schema. Executing SQL queries (including joins) against data in CSV, TSV, or JSON files. Setting up SQLite full-text search capabilities. Performing table transformations not directly supported by SQLite's `ALTER TABLE` command (like changing column types). Extracting columns into separate tables for data normalization.

Website: https://github.com/simonw/sqlite-utils