{
    "info": {
        "author": "UNKNOWN",
        "author_email": "UNKNOWN",
        "bugtrack_url": null,
        "classifiers": [],
        "description": "`db_url` provides the `db` command-line utilty for connecting to databases.\n\nInstall via pip:\n\n```\n$ pip install db_url\n```\n\n### Designed for use with PAAS\n\n```\n$ export DATABASE_URL=`heroku config:get DATABASE_URL`\n$ db\npsql (9.4.0, server 9.3.3)\nSSL connection (protocol: TLSv1.2, cipher: DHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)\nType \"help\" for help.\n\nd6p6s3877j3em=>\n```\n\n### Use with mysql, postgres, sqlite\n\n```\n$ export DATABASE_URL='sqlite://'\n$ db\nSQLite version 3.8.5 2014-08-15 22:37:57\nEnter \".help\" for usage hints.\nConnected to a transient in-memory database.\nUse \".open FILENAME\" to reopen on a persistent database.\nsqlite> ^D\n$ export DATABASE_URL='mysql://razzi@localhost/test_database'\n$ db\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\nYour MySQL connection id is 102\nServer version: 5.6.22 Homebrew\n\nCopyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of Oracle Corporation and/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nmysql>\n```\n\n### Database arguments work as expected\n\nSet startup options:\n\n```\n$ db -q --variable=PROMPT1=\"> \" --variable=PROMPT2=\"  \"\n> SELECT table_name, table_schema\n  FROM information_schema.tables\n  WHERE table_schema NOT IN ('pg_catalog', 'information_schema');\n         table_name         | table_schema\n----------------------------+--------------\n django_migrations          | public\n django_content_type        | public\n django_admin_log           | public\n auth_group_permissions     | public\n django_session             | public\n auth_group                 | public\n auth_user_groups           | public\n auth_permission            | public\n auth_user_user_permissions | public\n auth_user                  | public\n(10 rows)\n```\n\nRun a command:\n\n```\n$ db -tA -c '\\dt'\npublic|auth_group|table|razzi\npublic|auth_group_permissions|table|razzi\npublic|auth_permission|table|razzi\npublic|auth_user|table|razzi\npublic|auth_user_groups|table|razzi\npublic|auth_user_user_permissions|table|razzi\npublic|django_admin_log|table|razzi\npublic|django_content_type|table|razzi\npublic|django_migrations|table|razzi\npublic|django_session|table|razzi\n```\n\n### Tips + tricks\n\nConnect to local databases\n\n```\n$ createdb testdb\n$ export DATABASE_URL=postgres:///testdb\n$ db\npsql (9.4.0)\nType \"help\" for help.\n\ntestdb=#\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/razzius/db_url/",
        "keywords": null,
        "license": "Public Domain",
        "maintainer": null,
        "maintainer_email": null,
        "name": "db_url",
        "package_url": "https://pypi.org/project/db_url/",
        "platform": "UNKNOWN",
        "project_url": "https://pypi.org/project/db_url/",
        "project_urls": {
            "Download": "UNKNOWN",
            "Homepage": "https://github.com/razzius/db_url/"
        },
        "release_url": "https://pypi.org/project/db_url/0.3.3/",
        "requires_dist": null,
        "requires_python": null,
        "summary": "connect to the DATABASE_URL environment variable",
        "version": "0.3.3"
    },
    "last_serial": 1531225,
    "releases": {
        "0.2.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "9fd919fe48c575e344aaccc139fbc431",
                    "sha256": "511d8bb9fb0e7cd84c30bbc42212448eb91c43e9acab6afeb27e658b85332cb0"
                },
                "downloads": -1,
                "filename": "db_url-0.2.0.tar.gz",
                "has_sig": false,
                "md5_digest": "9fd919fe48c575e344aaccc139fbc431",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2636,
                "upload_time": "2015-01-29T00:44:43",
                "url": "https://files.pythonhosted.org/packages/f4/1c/b4875baf0a7508adfb3e274ca083faa03d710c6543b8865e2e69b82d62ca/db_url-0.2.0.tar.gz"
            }
        ],
        "0.2.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "67533932343bdfa7f01582840f1a74fa",
                    "sha256": "c35c1b62d0a775bb7e2dfe657275a39b2e405a7d81c15592858bf873881cc97b"
                },
                "downloads": -1,
                "filename": "db_url-0.2.1.tar.gz",
                "has_sig": false,
                "md5_digest": "67533932343bdfa7f01582840f1a74fa",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2972,
                "upload_time": "2015-01-29T00:46:52",
                "url": "https://files.pythonhosted.org/packages/77/40/7cc75d494968fb77846c273f854e86f2de3f5d68bdb5a3aa48dc41ac9d1e/db_url-0.2.1.tar.gz"
            }
        ],
        "0.2.2": [
            {
                "comment_text": "built for Darwin-14.1.0",
                "digests": {
                    "md5": "e9664829a58d397c989b3e471bd97916",
                    "sha256": "be756423f54c55c2a3baee6d849ac1d430887412271826eee44257691e0c9911"
                },
                "downloads": -1,
                "filename": "db_url-0.2.2.macosx-10.10-x86_64.tar.gz",
                "has_sig": false,
                "md5_digest": "e9664829a58d397c989b3e471bd97916",
                "packagetype": "bdist_dumb",
                "python_version": "any",
                "requires_python": null,
                "size": 4031,
                "upload_time": "2015-05-03T06:24:04",
                "url": "https://files.pythonhosted.org/packages/71/d0/6c7c09dfef08bf88806f5e68c46dae3be99afac3e0414f41511946cd6261/db_url-0.2.2.macosx-10.10-x86_64.tar.gz"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "9dcbb1958a48e030c23a7d9481c4f3ed",
                    "sha256": "4aaa2b3223f34bd19754ea9f324b750fe54b41356f0fc13cbefc56ed77017107"
                },
                "downloads": -1,
                "filename": "db_url-0.2.2.tar.gz",
                "has_sig": false,
                "md5_digest": "9dcbb1958a48e030c23a7d9481c4f3ed",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2981,
                "upload_time": "2015-02-04T22:30:45",
                "url": "https://files.pythonhosted.org/packages/3b/cb/617629124b8181012804b3d0a494cda0fae013ab11cdd750b44b86feb4bf/db_url-0.2.2.tar.gz"
            }
        ],
        "0.3.2": [
            {
                "comment_text": "built for Darwin-14.1.0",
                "digests": {
                    "md5": "463e99cdfec6b51c2f2571ccb3eef76a",
                    "sha256": "7973bfbb90cdb47f2524fe4ae95a920860536b7c914222d24b0f6ded5ae2e8a2"
                },
                "downloads": -1,
                "filename": "db_url-0.3.2.macosx-10.10-x86_64.tar.gz",
                "has_sig": false,
                "md5_digest": "463e99cdfec6b51c2f2571ccb3eef76a",
                "packagetype": "bdist_dumb",
                "python_version": "any",
                "requires_python": null,
                "size": 4020,
                "upload_time": "2015-05-03T06:25:52",
                "url": "https://files.pythonhosted.org/packages/ba/2e/35ab313c28bbf886cd3c1d9331fb0e390c72438d8c91b809c3dcef995b5e/db_url-0.3.2.macosx-10.10-x86_64.tar.gz"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "a6390b53d97dbe363e21340941788f77",
                    "sha256": "3c72a7a2d7be5b3a2e0ac8a04268533229a41aee3c5b2a3fc11ad063d0c20514"
                },
                "downloads": -1,
                "filename": "db_url-0.3.2.tar.gz",
                "has_sig": false,
                "md5_digest": "a6390b53d97dbe363e21340941788f77",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3125,
                "upload_time": "2015-05-03T06:26:49",
                "url": "https://files.pythonhosted.org/packages/c3/ed/31c2e29e5331a94995066a6ac0e1e188e8b9a09190ea771b2c367c932874/db_url-0.3.2.tar.gz"
            }
        ],
        "0.3.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ef33bdaf77348b8b06e140e5c5c5682a",
                    "sha256": "a87af45004a96aaa1ca6b571392916ddd6afd62e212a1cd3ff7bb11452feef9a"
                },
                "downloads": -1,
                "filename": "db_url-0.3.3.tar.gz",
                "has_sig": false,
                "md5_digest": "ef33bdaf77348b8b06e140e5c5c5682a",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3180,
                "upload_time": "2015-05-03T07:55:21",
                "url": "https://files.pythonhosted.org/packages/e1/03/03444bbbdc24bd09dc1264fbfda092af3d81a2576ae7a1bcfcc2c96f4fc6/db_url-0.3.3.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "ef33bdaf77348b8b06e140e5c5c5682a",
                "sha256": "a87af45004a96aaa1ca6b571392916ddd6afd62e212a1cd3ff7bb11452feef9a"
            },
            "downloads": -1,
            "filename": "db_url-0.3.3.tar.gz",
            "has_sig": false,
            "md5_digest": "ef33bdaf77348b8b06e140e5c5c5682a",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 3180,
            "upload_time": "2015-05-03T07:55:21",
            "url": "https://files.pythonhosted.org/packages/e1/03/03444bbbdc24bd09dc1264fbfda092af3d81a2576ae7a1bcfcc2c96f4fc6/db_url-0.3.3.tar.gz"
        }
    ]
}