Skip to main content

A tool to convert sqlite database to duckdb database

Project description

sqlite2duckdb

PyPI - Python Version PyPI - Downloads

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


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)

Uploaded Source

Built Distribution

sqlite2duckdb-0.3.0-py2.py3-none-any.whl (4.3 kB view details)

Uploaded Python 2 Python 3

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

Hashes for sqlite2duckdb-0.3.0.tar.gz
Algorithm Hash digest
SHA256 e1eb45fd595616a659db0091c4b85d40933324122f3c8c45adeeb6696b8d3a17
MD5 d9ce3669b53d7b5a26d36a058dcf63fd
BLAKE2b-256 c9919c54fecafd32218209032fe407bfbc2eddc7694b147cf0f0c98ff26c5856

See more details on using hashes here.

File details

Details for the file sqlite2duckdb-0.3.0-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for sqlite2duckdb-0.3.0-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 8628de7cb2e78bc0246f623f8c84d683e2bec3258584fb38fa79d75835c908e1
MD5 373306aa3a28829aae474fc55713aac4
BLAKE2b-256 7a8c85c8bcbc5c5e62780eeea4d9504199fc051e4a94a6e3ea6b1191711541a3

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page