A tool to convert sqlite database to duckdb database
Project description
sqlite2duckdb
A tool for converting a sqlite database into a duckdb database
Description
Sqlite is an embedded online database designed for transactional reading and writing. Duckdb is also an embedded database, but column-oriented, designed for analytical process with a very high reading efficiency. See https://towardsdatascience.com/forget-about-sqlite-use-duckdb-instead-and-thank-me-later-df76ee9bb777
Installation
pip install sqlite2duckdb
Usage
As a command line
usage: sqlite2duckdb <sqlite_path> <duckdb_path>
Convert Sqlite database to Duckdb database
positional arguments:
sqlite_path sqlite file path
duckdb_path duckdb file path
options:
-h, --help show this help message and exit
-v, --version show program's version number and exit
Examples
sqlite2duckdb source.db target.db
From python
from sqlite2duckdb import sqlite_to_duckdb
sqlite_to_duckdb("source.sqlite", "target.duckdb")
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
sqlite2duckdb-0.3.0.tar.gz
(5.3 kB
view details)
Built Distribution
File details
Details for the file sqlite2duckdb-0.3.0.tar.gz
.
File metadata
- Download URL: sqlite2duckdb-0.3.0.tar.gz
- Upload date:
- Size: 5.3 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/5.1.0 CPython/3.11.6
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | e1eb45fd595616a659db0091c4b85d40933324122f3c8c45adeeb6696b8d3a17 |
|
MD5 | d9ce3669b53d7b5a26d36a058dcf63fd |
|
BLAKE2b-256 | c9919c54fecafd32218209032fe407bfbc2eddc7694b147cf0f0c98ff26c5856 |
File details
Details for the file sqlite2duckdb-0.3.0-py2.py3-none-any.whl
.
File metadata
- Download URL: sqlite2duckdb-0.3.0-py2.py3-none-any.whl
- Upload date:
- Size: 4.3 kB
- Tags: Python 2, Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/5.1.0 CPython/3.11.6
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8628de7cb2e78bc0246f623f8c84d683e2bec3258584fb38fa79d75835c908e1 |
|
MD5 | 373306aa3a28829aae474fc55713aac4 |
|
BLAKE2b-256 | 7a8c85c8bcbc5c5e62780eeea4d9504199fc051e4a94a6e3ea6b1191711541a3 |