jupysql


Namejupysql JSON
Version 0.10.10 PyPI version JSON
download
home_pagehttps://github.com/ploomber/jupysql
SummaryBetter SQL in Jupyter
upload_time2024-02-08 03:28:45
maintainer
docs_urlNone
authorPloomber
requires_python
license
keywords database ipython postgresql mysql duckdb
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            # JupySQL
![CI](https://github.com/ploomber/jupysql/workflows/CI/badge.svg)
![CI Integration Tests](https://github.com/ploomber/jupysql/workflows/CI%20-%20DB%20Integration/badge.svg)
![Broken Links](https://github.com/ploomber/jupysql/workflows/check-for-broken-links/badge.svg)
[![PyPI version](https://badge.fury.io/py/jupysql.svg)](https://badge.fury.io/py/jupysql)
[![Twitter](https://img.shields.io/twitter/follow/edublancas?label=Follow&style=social)](https://twitter.com/intent/user?screen_name=ploomber)
[![Code style: black](https://img.shields.io/badge/code%20style-black-000000.svg)](https://github.com/psf/black)
[![Downloads](https://static.pepy.tech/badge/jupysql/month)](https://pepy.tech/project/jupysql)

<p align="center">
  <a href="https://ploomber.io/community">Join our community</a>
  |
  <a href="https://share.hsforms.com/1E7Qa_OpcRPi_MV-segFsaAe6c2g">Newsletter</a>
  |
  <a href="mailto:contact@ploomber.io">Contact us</a>
  |
  <a href="https://jupysql.ploomber.io/">Docs</a>
  |
  <a href="https://ploomber.io/blog">Blog</a>
  |
  <a href="https://ploomber.io">Website</a>
  |
  <a href="https://www.youtube.com/channel/UCaIS5BMlmeNQE4-Gn0xTDXQ">YouTube</a>
</p>

> [!TIP]
> Deploy AI apps for free on [Ploomber Cloud!](https://ploomber.io/?utm_medium=github&utm_source=jupysql)

Run SQL in Jupyter/IPython via a `%sql` and `%%sql` magics.

## Features

- [Pandas integration](https://jupysql.ploomber.io/en/latest/integrations/pandas.html)
- [SQL composition (no more hard-to-debug CTEs!)](https://jupysql.ploomber.io/en/latest/compose.html)
- [Plot massive datasets without blowing up memory](https://jupysql.ploomber.io/en/latest/plot.html)
- [DuckDB integration](https://jupysql.ploomber.io/en/latest/integrations/duckdb.html)

## Installation

```
pip install jupysql
```

or:

```
conda install jupysql -c conda-forge
```

## Documentation

[Click here to see the documentation.](https://jupysql.ploomber.io)


## Credits

This project is a fork of [ipython-sql](https://github.com/catherinedevlin/ipython-sql); the objective is to turn this project into a full-featured SQL client for Jupyter. We're looking for feedback and taking feature requests, so please [join our community](https://ploomber.io/community) and enter the #jupysql channel.

            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/ploomber/jupysql",
    "name": "jupysql",
    "maintainer": "",
    "docs_url": null,
    "requires_python": "",
    "maintainer_email": "",
    "keywords": "database ipython postgresql mysql duckdb",
    "author": "Ploomber",
    "author_email": "contact@ploomber.io",
    "download_url": "https://files.pythonhosted.org/packages/55/4b/34ca74056a94830586b91a33adf1abbd4c064d8d7aaff4c3cbddec1716ff/jupysql-0.10.10.tar.gz",
    "platform": null,
    "description": "# JupySQL\n![CI](https://github.com/ploomber/jupysql/workflows/CI/badge.svg)\n![CI Integration Tests](https://github.com/ploomber/jupysql/workflows/CI%20-%20DB%20Integration/badge.svg)\n![Broken Links](https://github.com/ploomber/jupysql/workflows/check-for-broken-links/badge.svg)\n[![PyPI version](https://badge.fury.io/py/jupysql.svg)](https://badge.fury.io/py/jupysql)\n[![Twitter](https://img.shields.io/twitter/follow/edublancas?label=Follow&style=social)](https://twitter.com/intent/user?screen_name=ploomber)\n[![Code style: black](https://img.shields.io/badge/code%20style-black-000000.svg)](https://github.com/psf/black)\n[![Downloads](https://static.pepy.tech/badge/jupysql/month)](https://pepy.tech/project/jupysql)\n\n<p align=\"center\">\n  <a href=\"https://ploomber.io/community\">Join our community</a>\n  |\n  <a href=\"https://share.hsforms.com/1E7Qa_OpcRPi_MV-segFsaAe6c2g\">Newsletter</a>\n  |\n  <a href=\"mailto:contact@ploomber.io\">Contact us</a>\n  |\n  <a href=\"https://jupysql.ploomber.io/\">Docs</a>\n  |\n  <a href=\"https://ploomber.io/blog\">Blog</a>\n  |\n  <a href=\"https://ploomber.io\">Website</a>\n  |\n  <a href=\"https://www.youtube.com/channel/UCaIS5BMlmeNQE4-Gn0xTDXQ\">YouTube</a>\n</p>\n\n> [!TIP]\n> Deploy AI apps for free on [Ploomber Cloud!](https://ploomber.io/?utm_medium=github&utm_source=jupysql)\n\nRun SQL in Jupyter/IPython via a `%sql` and `%%sql` magics.\n\n## Features\n\n- [Pandas integration](https://jupysql.ploomber.io/en/latest/integrations/pandas.html)\n- [SQL composition (no more hard-to-debug CTEs!)](https://jupysql.ploomber.io/en/latest/compose.html)\n- [Plot massive datasets without blowing up memory](https://jupysql.ploomber.io/en/latest/plot.html)\n- [DuckDB integration](https://jupysql.ploomber.io/en/latest/integrations/duckdb.html)\n\n## Installation\n\n```\npip install jupysql\n```\n\nor:\n\n```\nconda install jupysql -c conda-forge\n```\n\n## Documentation\n\n[Click here to see the documentation.](https://jupysql.ploomber.io)\n\n\n## Credits\n\nThis project is a fork of [ipython-sql](https://github.com/catherinedevlin/ipython-sql); the objective is to turn this project into a full-featured SQL client for Jupyter. We're looking for feedback and taking feature requests, so please [join our community](https://ploomber.io/community) and enter the #jupysql channel.\n",
    "bugtrack_url": null,
    "license": "",
    "summary": "Better SQL in Jupyter",
    "version": "0.10.10",
    "project_urls": {
        "Homepage": "https://github.com/ploomber/jupysql",
        "Source": "https://github.com/ploomber/jupysql"
    },
    "split_keywords": [
        "database",
        "ipython",
        "postgresql",
        "mysql",
        "duckdb"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "1b4815b271562ced026001a2ff57833bd78dc92ac97dcc740a9be4f6be849d6a",
                "md5": "679f61f867c8c1bc66c79d761d3fa279",
                "sha256": "811031ff2be5289e2840d294bb6d809ab6772d5a61d1ad7c2ab51c8ce807a68b"
            },
            "downloads": -1,
            "filename": "jupysql-0.10.10-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "679f61f867c8c1bc66c79d761d3fa279",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 95708,
            "upload_time": "2024-02-08T03:28:43",
            "upload_time_iso_8601": "2024-02-08T03:28:43.239998Z",
            "url": "https://files.pythonhosted.org/packages/1b/48/15b271562ced026001a2ff57833bd78dc92ac97dcc740a9be4f6be849d6a/jupysql-0.10.10-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "554b34ca74056a94830586b91a33adf1abbd4c064d8d7aaff4c3cbddec1716ff",
                "md5": "add5d2d2f4df65962e9cb9730c4c31c0",
                "sha256": "8259111a943ad0da61ef6bbe1281787c37a1535d15553b8bbcfaca2919c03742"
            },
            "downloads": -1,
            "filename": "jupysql-0.10.10.tar.gz",
            "has_sig": false,
            "md5_digest": "add5d2d2f4df65962e9cb9730c4c31c0",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 81663,
            "upload_time": "2024-02-08T03:28:45",
            "upload_time_iso_8601": "2024-02-08T03:28:45.439890Z",
            "url": "https://files.pythonhosted.org/packages/55/4b/34ca74056a94830586b91a33adf1abbd4c064d8d7aaff4c3cbddec1716ff/jupysql-0.10.10.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2024-02-08 03:28:45",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "ploomber",
    "github_project": "jupysql",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": true,
    "lcname": "jupysql"
}
        
Elapsed time: 0.18713s