# sqlite2duckdb
A tool for converting a [sqlite](https://www.sqlite.org/) database into a [duckdb](https://duckdb.org/) 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](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
```bash
sqlite2duckdb source.db target.db
```
### From python
```python
from sqlite2duckdb import sqlite_to_duckdb
sqlite_to_duckdb("source.sqlite", "target.duckdb")
```
Raw data
{
"_id": null,
"home_page": null,
"name": "sqlite2duckdb",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": "database, duckdb, olap, oltp, sqlite",
"author": null,
"author_email": "Sacha Schutz <sacha.schutz@pm.me>",
"download_url": "https://files.pythonhosted.org/packages/c9/91/9c54fecafd32218209032fe407bfbc2eddc7694b147cf0f0c98ff26c5856/sqlite2duckdb-0.3.0.tar.gz",
"platform": null,
"description": "# sqlite2duckdb\n\n\n\n\nA tool for converting a [sqlite](https://www.sqlite.org/) database into a [duckdb](https://duckdb.org/) database\n\n\n## Description \n\nSqlite is an embedded online database designed for transactional reading and writing.\nDuckdb is also an embedded database, but column-oriented, designed for analytical process with a very high reading efficiency.\nSee [https://towardsdatascience.com/forget-about-sqlite-use-duckdb-instead-and-thank-me-later-df76ee9bb777](https://towardsdatascience.com/forget-about-sqlite-use-duckdb-instead-and-thank-me-later-df76ee9bb777)\n\n\n## Installation \n\n```\npip install sqlite2duckdb\n```\n\n## Usage \n\n### As a command line \n\n```\n\nusage: sqlite2duckdb <sqlite_path> <duckdb_path>\n\nConvert Sqlite database to Duckdb database\n\npositional arguments:\n sqlite_path sqlite file path\n duckdb_path duckdb file path\n\noptions:\n -h, --help show this help message and exit\n -v, --version show program's version number and exit\n\n\n```\n\n### Examples \n\n```bash\nsqlite2duckdb source.db target.db\n```\n\n### From python \n\n```python\n\nfrom sqlite2duckdb import sqlite_to_duckdb\nsqlite_to_duckdb(\"source.sqlite\", \"target.duckdb\")\n\n```\n\n\n\n",
"bugtrack_url": null,
"license": null,
"summary": "A tool to convert sqlite database to duckdb database",
"version": "0.3.0",
"project_urls": {
"Homepage": "https://github.com/dridk/sqlite2duckdb",
"Issues": "https://github.com/dridk/sqlite2duckdb/issues"
},
"split_keywords": [
"database",
" duckdb",
" olap",
" oltp",
" sqlite"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "7a8c85c8bcbc5c5e62780eeea4d9504199fc051e4a94a6e3ea6b1191711541a3",
"md5": "373306aa3a28829aae474fc55713aac4",
"sha256": "8628de7cb2e78bc0246f623f8c84d683e2bec3258584fb38fa79d75835c908e1"
},
"downloads": -1,
"filename": "sqlite2duckdb-0.3.0-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "373306aa3a28829aae474fc55713aac4",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 4341,
"upload_time": "2024-05-23T22:21:37",
"upload_time_iso_8601": "2024-05-23T22:21:37.995466Z",
"url": "https://files.pythonhosted.org/packages/7a/8c/85c8bcbc5c5e62780eeea4d9504199fc051e4a94a6e3ea6b1191711541a3/sqlite2duckdb-0.3.0-py2.py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "c9919c54fecafd32218209032fe407bfbc2eddc7694b147cf0f0c98ff26c5856",
"md5": "d9ce3669b53d7b5a26d36a058dcf63fd",
"sha256": "e1eb45fd595616a659db0091c4b85d40933324122f3c8c45adeeb6696b8d3a17"
},
"downloads": -1,
"filename": "sqlite2duckdb-0.3.0.tar.gz",
"has_sig": false,
"md5_digest": "d9ce3669b53d7b5a26d36a058dcf63fd",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 5311,
"upload_time": "2024-05-23T22:21:39",
"upload_time_iso_8601": "2024-05-23T22:21:39.303939Z",
"url": "https://files.pythonhosted.org/packages/c9/91/9c54fecafd32218209032fe407bfbc2eddc7694b147cf0f0c98ff26c5856/sqlite2duckdb-0.3.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-05-23 22:21:39",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "dridk",
"github_project": "sqlite2duckdb",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"requirements": [
{
"name": "duckdb",
"specs": []
}
],
"lcname": "sqlite2duckdb"
}
JSON
