CLI tool and Python utility functions for manipulating SQLite databases
Project description
sqlite-utils
Python CLI utility and library for manipulating SQLite databases.
Read more on my blog: sqlite-utils: a Python library and CLI tool for building SQLite databases
Installation
pip install sqlite-utils
Using as a CLI tool
Now you can do things with the CLI utility like this:
$ sqlite-utils tables dogs.db --counts
[{"table": "dogs", "count": 2}]
$ sqlite-utils dogs.db "select * from dogs"
[{"id": 1, "age": 4, "name": "Cleo"},
{"id": 2, "age": 2, "name": "Pancakes"}]
$ sqlite-utils dogs.db "select * from dogs" --csv
id,age,name
1,4,Cleo
2,2,Pancakes
$ sqlite-utils dogs.db "select * from dogs" --table
id age name
---- ----- --------
1 4 Cleo
2 2 Pancakes
You can even import data into a new database table like this:
$ curl https://api.github.com/repos/simonw/sqlite-utils/releases \
| sqlite-utils insert releases.db releases - --pk id
Full CLI documentation: https://sqlite-utils.readthedocs.io/en/stable/cli.html
Using as a library
You can also import sqlite_utils
and use it as a Python library like this:
import sqlite_utils
db = sqlite_utils.Database("demo_database.db")
# This line creates a "dogs" table if one does not already exist:
db["dogs"].insert_all([
{"id": 1, "age": 4, "name": "Cleo"},
{"id": 2, "age": 2, "name": "Pancakes"}
], pk="id")
Full library documentation: https://sqlite-utils.readthedocs.io/en/stable/python-api.html
Related projects
- Datasette: A tool for exploring and publishing data
- csvs-to-sqlite: Convert CSV files into a SQLite database
- db-to-sqlite: CLI tool for exporting a MySQL or PostgreSQL database as a SQLite file
- dogsheep: A family of tools for personal analytics, built on top of
sqlite-utils
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sqlite-utils-2.22.tar.gz
(94.7 kB
view hashes)
Built Distribution
Close
Hashes for sqlite_utils-2.22-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f7de6e9a827ade79f2b85d7ebdea00ca165ed1a0da7c0c17f3ec6498e19a8166 |
|
MD5 | 96f37a388f794c896642a910b819823f |
|
BLAKE2b-256 | 775a222ce3841de6d38b3c9d7444f84e61c28e6dc6f1e8d4a9c6d09ba32a18f5 |