{
    "info": {
        "author": "Mathieu Ripert",
        "author_email": "mathieu@instacart.com",
        "bugtrack_url": null,
        "classifiers": [],
        "description": "# instadb \ud83d\udd0c\n\nA simple and light DB python package\n\n## Features\n- query from postgres and reshift\n- load data into pandas dataframe\n- query from sql or filename\n- automatically setup connections from env variables\n- automatic query annotation\n- connect timeout retry with exponential backoff\n\n### Installation\n\n`pip install instadb`\n\n### Basic Usage\n\n```python\n  import instadb\n  db = instadb.Connection(url=database_url)\n  df = db.dataframe(\"select * from users limit 10\")\n```\n\nIf you have env variables that match the pattern `<key>_DATABASE_URL` then you can directly do:\n\n```python\n  import instadb\n  df = instadb.key.dataframe(\"select * from users limit 10\")\n```\n\n### Query from file\n\n```python\n  df = instadb.key.dataframe(filename='./users.sql')\n```\n\n### Query from file with arguments\n\nusers.sql\n```\nselect * from users where limit={limit}\n```\n\n```python\n  df = instadb.key.dataframe(filename='./users.sql', limit=100)\n```\n\n## TODO\n- [ ] load data to list\n- [ ] insert and update queries\n- [ ] caching\n\n\n",
        "description_content_type": null,
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/mathieuripert/instadb",
        "keywords": "",
        "license": "BSD",
        "maintainer": "",
        "maintainer_email": "",
        "name": "instadb",
        "package_url": "https://pypi.org/project/instadb/",
        "platform": "",
        "project_url": "https://pypi.org/project/instadb/",
        "project_urls": {
            "Homepage": "https://github.com/mathieuripert/instadb"
        },
        "release_url": "https://pypi.org/project/instadb/0.4.2/",
        "requires_dist": [
            "pandas",
            "psycopg2"
        ],
        "requires_python": "",
        "summary": "A simple and light DB package",
        "version": "0.4.2"
    },
    "last_serial": 3237214,
    "releases": {
        "0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "b9bf7969468f12bc76346a26aaefb3d6",
                    "sha256": "dbb19b49ce6abbb9e582951675c935c0c4a2c5df1ef6c2f1043c7e940d1fded8"
                },
                "downloads": -1,
                "filename": "instadb-0.1-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "b9bf7969468f12bc76346a26aaefb3d6",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 2873,
                "upload_time": "2017-02-23T18:54:38",
                "url": "https://files.pythonhosted.org/packages/78/a1/b09621fd74ecfb0f47861b025e8796595be92de8c13cdca43e9cdc69efca/instadb-0.1-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "5de8f6bf677f2522ce3819d8d31615b0",
                    "sha256": "1c6237d13796bba56979449b796f6d0688e869c0535e84becc2868efe4061c65"
                },
                "downloads": -1,
                "filename": "instadb-0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "5de8f6bf677f2522ce3819d8d31615b0",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 1657,
                "upload_time": "2017-02-23T18:54:39",
                "url": "https://files.pythonhosted.org/packages/f7/87/0740df9b160c4a25f3b54c5db68e705649058c5303d4fcdce17a9b4514c9/instadb-0.1.tar.gz"
            }
        ],
        "0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "40caf61dae104917117ccd81c4ef111b",
                    "sha256": "210ad757bbd2dfc5e2ef67da43bb8fc1959b04b74e79c83a172f475e4c35746e"
                },
                "downloads": -1,
                "filename": "instadb-0.2-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "40caf61dae104917117ccd81c4ef111b",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 2869,
                "upload_time": "2017-02-23T19:13:09",
                "url": "https://files.pythonhosted.org/packages/d1/8e/97d5f869200a96e5332fcdd902d4d1315248f0c412c38c372d85c0a3bdd8/instadb-0.2-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "eda899d8679105932a8d80159c89ad2b",
                    "sha256": "d74c8704c8cb9fb8cc0bc94e2d0e8c466fec686ddc6bcb19c2ca8d5a064b314e"
                },
                "downloads": -1,
                "filename": "instadb-0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "eda899d8679105932a8d80159c89ad2b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 1650,
                "upload_time": "2017-02-23T19:13:10",
                "url": "https://files.pythonhosted.org/packages/ba/79/770a3647b99f9634c876f1d03f407a8326c43d7b9fe9cac03cfe38dba4c1/instadb-0.2.tar.gz"
            }
        ],
        "0.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "4c4d3367869afafd1c7062b8470a417d",
                    "sha256": "5b83728052c52e591e8611375e4e1da94fb9de60389fc7af582f3db904b18feb"
                },
                "downloads": -1,
                "filename": "instadb-0.3-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "4c4d3367869afafd1c7062b8470a417d",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 3942,
                "upload_time": "2017-10-06T06:38:20",
                "url": "https://files.pythonhosted.org/packages/05/a1/b5d59446c852c0dc7812f564ddaf8f1abb18887cfaa1f3fcef10cea3cbbf/instadb-0.3-py2.py3-none-any.whl"
            }
        ],
        "0.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "6bf6ff4d69484f93e888ca63c8e8324e",
                    "sha256": "13af064bda16941bdeff5c1e813a444b7341111b8a8939029cb336c528fcd57e"
                },
                "downloads": -1,
                "filename": "instadb-0.4-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "6bf6ff4d69484f93e888ca63c8e8324e",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 3958,
                "upload_time": "2017-10-06T06:47:29",
                "url": "https://files.pythonhosted.org/packages/a6/39/681777e274979af0ce361f718ab645f6ea032c08e7d8e0da7db670efeb36/instadb-0.4-py2.py3-none-any.whl"
            }
        ],
        "0.4.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "c4be42400fe94f81c92b8be1426d02fa",
                    "sha256": "de270d3965a2fb0dfd3d74a97580cb436879e873ba274255a4cb14e7f7aa26b1"
                },
                "downloads": -1,
                "filename": "instadb-0.4.1-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "c4be42400fe94f81c92b8be1426d02fa",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 5112,
                "upload_time": "2017-10-06T17:28:19",
                "url": "https://files.pythonhosted.org/packages/98/e0/b105bf09b64987689dffa22ed3e75341afbd7ca8819b9d61b8b687d98815/instadb-0.4.1-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "fe9e222b19471c3a5bf5ba75eba1e7df",
                    "sha256": "61d8b8bdacbfd17448e4a2f54104ad0341a05d43c72545a1dc42129de28adb82"
                },
                "downloads": -1,
                "filename": "instadb-0.4.1.tar.gz",
                "has_sig": false,
                "md5_digest": "fe9e222b19471c3a5bf5ba75eba1e7df",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3311,
                "upload_time": "2017-10-06T17:28:21",
                "url": "https://files.pythonhosted.org/packages/48/41/b9d0112d742afe751cdd8a908eec3f6d86cd89a206bf105a446b72926c08/instadb-0.4.1.tar.gz"
            }
        ],
        "0.4.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "3cb06ca4e31b7fd1e4ebe8d4d21f696a",
                    "sha256": "16659060b9d8bc93592a12aefb59775e21cc2a1a83c769c5c0dec36aae74381c"
                },
                "downloads": -1,
                "filename": "instadb-0.4.2-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "3cb06ca4e31b7fd1e4ebe8d4d21f696a",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 5097,
                "upload_time": "2017-10-09T19:37:45",
                "url": "https://files.pythonhosted.org/packages/12/ec/fa0e21610e6892cfd120223645226eac5c8c642994c622d8add4017d2427/instadb-0.4.2-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "5f3ebb48c4e5a5bdc1d9e845b807c7f3",
                    "sha256": "e2c60820af7480087343919fbe118d4b33acfb2ce8df8d25f96898e0e655cd8c"
                },
                "downloads": -1,
                "filename": "instadb-0.4.2.tar.gz",
                "has_sig": false,
                "md5_digest": "5f3ebb48c4e5a5bdc1d9e845b807c7f3",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3312,
                "upload_time": "2017-10-09T19:37:46",
                "url": "https://files.pythonhosted.org/packages/58/11/6db163187cd89e1842072082b5cf82cee840b9a854987c7a27db4829ffb2/instadb-0.4.2.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "3cb06ca4e31b7fd1e4ebe8d4d21f696a",
                "sha256": "16659060b9d8bc93592a12aefb59775e21cc2a1a83c769c5c0dec36aae74381c"
            },
            "downloads": -1,
            "filename": "instadb-0.4.2-py2.py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "3cb06ca4e31b7fd1e4ebe8d4d21f696a",
            "packagetype": "bdist_wheel",
            "python_version": "py2.py3",
            "requires_python": null,
            "size": 5097,
            "upload_time": "2017-10-09T19:37:45",
            "url": "https://files.pythonhosted.org/packages/12/ec/fa0e21610e6892cfd120223645226eac5c8c642994c622d8add4017d2427/instadb-0.4.2-py2.py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "5f3ebb48c4e5a5bdc1d9e845b807c7f3",
                "sha256": "e2c60820af7480087343919fbe118d4b33acfb2ce8df8d25f96898e0e655cd8c"
            },
            "downloads": -1,
            "filename": "instadb-0.4.2.tar.gz",
            "has_sig": false,
            "md5_digest": "5f3ebb48c4e5a5bdc1d9e845b807c7f3",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 3312,
            "upload_time": "2017-10-09T19:37:46",
            "url": "https://files.pythonhosted.org/packages/58/11/6db163187cd89e1842072082b5cf82cee840b9a854987c7a27db4829ffb2/instadb-0.4.2.tar.gz"
        }
    ]
}