{"repo":"simonw/sqlite-utils","free":true,"listed":false,"github":"https://github.com/simonw/sqlite-utils","clone":"git clone https://github.com/simonw/sqlite-utils.git","description":"Python CLI utility and library for manipulating SQLite databases","language":"Python","stars":2151,"topics":["sqlite","python","datasette","sqlite-database","click","cli","datasette-io","datasette-tool"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"sqlite-utils Python CLI utility and library for manipulating SQLite databases. Some 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 - Manage database migrations using Python migration files and the sqlite-utils migrate command - Install plugins to add custom SQL functions and additional features Upgrading from sqlite-utils 3.x? See the 4.0 upgrade guide. Read more on my blog, in this series of posts on New features in sqlite-utils and other entries tagged sqlite-utils. Installation pip install sqlite-utils Or if you use Homebrew for macOS: brew install sqlite-utils Using as a CLI tool Now you can do things with the CLI utility like this: $ sqlite-utils memory dogs.csv \"select from t\" [{\"id\": 1, \"age\": 4, \"name\": \"Cleo\"}, {\"id\": 2, \"age\": 2, \"name\": \"Pancakes\"}] $ sqlite-utils insert dogs.db dogs dogs.csv --csv [####################################] 100% $ sqlite-utils tables dogs.db --counts [{\"table\": \"dogs\", \"count","default_branch":null,"files":null,"tree":[],"storefront":"/r/simonw","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/simonw/sqlite-utils/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}