CLI tool for exporting tables or queries from any SQL database to a SQLite file
Project description
db-to-sqlite
CLI tool for exporting tables or queries from any SQL database to a SQLite file.
Installation
Install from PyPI like so:
pip install db-to-sqlite
If you want to use it with MySQL, you can install the extra dependency like this:
pip install db-to-sqlite[mysql]
For PostgreSQL, use this:
pip install db-to-sqlite[postgresql]
Usage
Usage: db-to-sqlite [OPTIONS] PATH
Load data from any database into SQLite.
https://github.com/simonw/db-to-sqlite
Options:
--version Show the version and exit.
--connection TEXT SQLAlchemy connection string [required]
--all Detect and copy all tables
--table TEXT Name of table to save the results (and copy)
--skip TEXT When using --all skip these tables
--sql TEXT Optional SQL query to run
--pk TEXT Optional column to use as a primary key
--help Show this message and exit.
For example, to save the content of the blog_entry
table from a PostgreSQL database to a local file called blog.db
you could do this:
db-to-sqlite blog.db \
--connection="postgresql://localhost/myblog" \
--table=blog_entry
You can also save the data from all of your tables, effectively creating a SQLite copy of your entire database. Any foreign key relationships will be detected and added to the SQLite database. For example:
db-to-sqlite blog.db \
--connection="postgresql://localhost/myblog" \
--all
When running --all
you can specify tables to skip using --skip
:
db-to-sqlite blog.db \
--connection="postgresql://localhost/myblog" \
--all \
--skip=django_migrations
If you want to save the results of a custom SQL query, do this:
db-to-sqlite output.db \
--connection="postgresql://localhost/myblog" \
--table=query_results \
--sql="select id, title, created from blog_entry" \
--pk=id
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 Distributions
Built Distribution
Hashes for db_to_sqlite-0.7-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7631d8f2e5f308517ff944049409a568a6999d2ca213b2f24db754b093e69c36 |
|
MD5 | 315c0876aa90304f32d827b85efb4749 |
|
BLAKE2b-256 | e729b038d1d3db17a2820fa543a5e98a152f5643e4e9503632196fc2d6f920ab |