{
    "info": {
        "author": "Tatsuro Yasukawa",
        "author_email": "t.yasukawa01@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 4 - Beta",
            "Environment :: Other Environment",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python",
            "Programming Language :: Python :: 3",
            "Topic :: Software Development :: Libraries :: Python Modules"
        ],
        "description": "[![Circle CI](https://circleci.com/gh/SamuraiT/pandas-rs.svg?style=svg)](https://circleci.com/gh/SamuraiT/pandas-rs)\n\n# pandas-rs\n\npandas-rs is oirginally designed for RedShift but\nalso works for PostgreSQL. Inspired by [pandas-td](https://github.com/treasure-data/pandas-td)\n\nI may should have made the package name as pandas-pg, since It also works for\nPostgreSQL.\n\n# requirement\nTo connect PostgreSQL and RedShift, you have to have the PostgreSQL client.\n\n### Mac\n\n~~~\nbrew update\nbrew install postgresql\n~~~\n\n# installation\n\n~~~\npip install pandas-rs\n~~~\n\n\n# Usage\n\nAs I mentioned, above pandas-rs works for PostgreSQL as well.\nFirst export password via shell(recommended)\n\n~~~shell\nexport REDSHIFT_OR_POSTGRESQL_PASSWORD='password'\n~~~\n\n~~~py\nimport pandas_rs as rs\nimport os # use only if you will access password through environment variables\n\nrs.create_engine(\n    dbname='dev',\n    user='test',\n    password=os.environ['REDSHIFT_OR_POSTGRESQL_PASSWORD'],\n    host='foobar.redshift.exmple',\n    port='5439'\n)\n\n\nprint(rs.read_sql(\"\"\"select 'hello PostgreSQL or redshift' greeting\"\"\"))\n~~~\n\nresult\n\n~~~py\n         greeting\n0  hello PostgreSQL or redshift\n~~~",
        "description_content_type": null,
        "docs_url": null,
        "download_url": "UNKNOWN",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/SamuraiT/pandas-rs",
        "keywords": "pandas,PostgreSQL,RedShift,sql",
        "license": "UNKNOWN",
        "maintainer": null,
        "maintainer_email": null,
        "name": "pandas-rs",
        "package_url": "https://pypi.org/project/pandas-rs/",
        "platform": "UNKNOWN",
        "project_url": "https://pypi.org/project/pandas-rs/",
        "project_urls": {
            "Download": "UNKNOWN",
            "Homepage": "https://github.com/SamuraiT/pandas-rs"
        },
        "release_url": "https://pypi.org/project/pandas-rs/0.1.6/",
        "requires_dist": null,
        "requires_python": null,
        "summary": "pandas extension for PostgreSQL and AWS RedShift (Not Officail library)",
        "version": "0.1.6"
    },
    "last_serial": 1814974,
    "releases": {
        "0.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "822bf0fca9699f1198c74c3814381902",
                    "sha256": "924d0d2a7c119a574ceb935bbafbe0c2a34ea65aaaf4138ef43424ffe88520ab"
                },
                "downloads": -1,
                "filename": "pandas-rs-0.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "822bf0fca9699f1198c74c3814381902",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2473,
                "upload_time": "2015-11-11T14:21:30",
                "url": "https://files.pythonhosted.org/packages/4d/6b/4d86f91584656abb74bdd7d27374e179347276a7ef6ca9edaa760d0df0ff/pandas-rs-0.1.0.tar.gz"
            }
        ],
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "6114c76d678c1161c0f3a0409738dc60",
                    "sha256": "9e3e20e66ff91de77f29989c407b3f6e00397251e6d98d3c900aec5e20162476"
                },
                "downloads": -1,
                "filename": "pandas-rs-0.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "6114c76d678c1161c0f3a0409738dc60",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2543,
                "upload_time": "2015-11-11T14:30:06",
                "url": "https://files.pythonhosted.org/packages/be/d1/184a873e51ca8502ee58b41db6bf019e895d975b12557d2d0c6ef3334c97/pandas-rs-0.1.1.tar.gz"
            }
        ],
        "0.1.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "292f1eee22975a135899efc4bf0ee1f3",
                    "sha256": "8bb6156dcca28db99527e309fc0b3fa270fd5df406d10bf220b94ed3c4b657dd"
                },
                "downloads": -1,
                "filename": "pandas-rs-0.1.2.tar.gz",
                "has_sig": false,
                "md5_digest": "292f1eee22975a135899efc4bf0ee1f3",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2539,
                "upload_time": "2015-11-12T00:58:22",
                "url": "https://files.pythonhosted.org/packages/7b/0c/c0f27d4d850f7b7d7d5958b065eb50553b406724a057f9fc283a35b738e7/pandas-rs-0.1.2.tar.gz"
            }
        ],
        "0.1.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "884df3e1c30e9386b52b28760e8c94f5",
                    "sha256": "25670ccbe5b0762a181cb5f3612f9ed92444b519accac21aa0cc2e2bb1f8ea44"
                },
                "downloads": -1,
                "filename": "pandas-rs-0.1.3.tar.gz",
                "has_sig": false,
                "md5_digest": "884df3e1c30e9386b52b28760e8c94f5",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2549,
                "upload_time": "2015-11-12T01:23:01",
                "url": "https://files.pythonhosted.org/packages/e2/b9/a751f60bebbfe497270716baae2efc1c6218629c933c48778ece1e446b7e/pandas-rs-0.1.3.tar.gz"
            }
        ],
        "0.1.4": [],
        "0.1.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "c2bb817f92828b8bffb5de03a1b9cb31",
                    "sha256": "a0a867c8720a1153ef5ab02d06aec62abda5b10cffdad873b84bdcb3ce2b1a30"
                },
                "downloads": -1,
                "filename": "pandas-rs-0.1.5.tar.gz",
                "has_sig": false,
                "md5_digest": "c2bb817f92828b8bffb5de03a1b9cb31",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2775,
                "upload_time": "2015-11-12T14:54:13",
                "url": "https://files.pythonhosted.org/packages/20/f6/1ebb1c8ce698b881ac565ebc96ce3609ef4a3e7dad5b02e91907c51be563/pandas-rs-0.1.5.tar.gz"
            }
        ],
        "0.1.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "4e3cbf8c2f25419384626f9856a7ed08",
                    "sha256": "1a7a451a364180d742909221fa91ae6f321f1226b2ddda43b9e3dfcaef380155"
                },
                "downloads": -1,
                "filename": "pandas-rs-0.1.6.tar.gz",
                "has_sig": false,
                "md5_digest": "4e3cbf8c2f25419384626f9856a7ed08",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2824,
                "upload_time": "2015-11-13T15:01:14",
                "url": "https://files.pythonhosted.org/packages/23/5b/4dd40415bafe3c786457e8c56f70ea2bf7f5dc466fb0cfcfecee19f0c3af/pandas-rs-0.1.6.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "4e3cbf8c2f25419384626f9856a7ed08",
                "sha256": "1a7a451a364180d742909221fa91ae6f321f1226b2ddda43b9e3dfcaef380155"
            },
            "downloads": -1,
            "filename": "pandas-rs-0.1.6.tar.gz",
            "has_sig": false,
            "md5_digest": "4e3cbf8c2f25419384626f9856a7ed08",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 2824,
            "upload_time": "2015-11-13T15:01:14",
            "url": "https://files.pythonhosted.org/packages/23/5b/4dd40415bafe3c786457e8c56f70ea2bf7f5dc466fb0cfcfecee19f0c3af/pandas-rs-0.1.6.tar.gz"
        }
    ]
}