{
    "info": {
        "author": "Vlad Balmos",
        "author_email": "vladbalmos@yahoo.com",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: MIT License",
            "Operating System :: POSIX :: Linux",
            "Programming Language :: Python :: 3"
        ],
        "description": "[![Build Status](https://travis-ci.org/vladbalmos/mitzasql.svg?branch=master)](https://travis-ci.org/vladbalmos/mitzasql)\n\n# About\nMitzaSQL is a free Python3 TUI MySQL client for Linux which aims to provide an easy-to-use console alternative to GUI clients. It is not meant to be a full-fledged GUI client, it only provides a read-only view of the database, though you can manipulate the data by using raw SQL queries. Some of the main features are:\n\n* Manage multiple sessions\n* View databases\n* View list of tables, sql views & stored procedures in a database\n* View rows in a table or sql view:\n* Easily sort table data\n* Filter table data using VIM-like commands (`:like`, `:gt`, `:lt`, `:in`...)\n* SQL Query editor with syntax highlighting\n* VIM style keyboard shortcuts\n* VIM style commands with autocomplete support\n* Macros support\n\nMitzaSQL is heavily inspired by [HeidiSQL](https://github.com/HeidiSQL/HeidiSQL) and is licensed under [MIT](https://opensource.org/licenses/MIT).\n\n### Demo\n[![asciicast](https://asciinema.org/a/fbbwVEIdL9f8UbQFtPAw2NsCl.svg)](https://asciinema.org/a/fbbwVEIdL9f8UbQFtPAw2NsCl)\n\n# Website\n[https://vladbalmos.github.io/mitzasql](https://vladbalmos.github.io/mitzasql)\n\n# System requirements\n* Linux\n* Python3 (3.5 - 3.8)\n* MySQL (5.5 - 8)\n\n# Security\nBy default MitzaSQL stores connection credentials in plain text files in your home directory. If security is a concern you could store the file in an encrypted partition/directory and specify the path to the session file when the program starts using the `--sessions_file /path/to/sessions.ini` flag. Another option would be not to persist the connection credentials when creating a new session.\n\n# Performance & known issues\nLoading large datasets will slow down the rendering. By default, when opening a table screen only the first 100 records are loaded. The rest of the data is loaded automatically when scrolling down. When running queries with the SQL Query editor make sure you don't load a large number of records or else your user experience might suffer.\n\n# Dependencies\n* urwid\n* mysql-connector-python\n* appdirs\n* pygments\n\n# Installation\n\n    pip3 install mitzasql\n\n# Development\n## Dependencies\n* tox\n* Docker\n* docker-compose\n\nDocker is only required for running the integration tests, testing during feature development can be done with tox alone (see below).\n\n## Run the development version\n\n    # If your currently installed Python version != 3.6 use TOXENV to specify it\n    tox -e dev\n    source .tox/dev/bin/activate\n    mitzasql\n\nTo run the program using a different Python version using Docker:\n\n    ./run-in-docker.sh [python version] [mysql version]\n    # ./run-in-docker.sh 36 mysql55\n    tox -e dev\n    source .tox/dev/bin/activate\n    mitzasql\n\n## Tests\nThe testing process uses tox & Docker to automate running the tests against multiple versions of Python and MySQL servers.\n\nDuring feature development Docker is not really necessary, I use it to run the test MySQL server but it that can be installed directly on the host. If that is the case, then new connection details have to be specified using environmental variables (see `tests/db/connection_fixture.py` for more details).\n\nTo run the tests during feature development run:\n\n    cp env.template .env # necessary if using Docker\n    docker-compose up # necessary if using Docker\n    tox\n\nTo generate code coverage:\n\n    ./coverage.sh\n\nCode coverage is generated in the `htmlcov` directory.\n\n### Integration testing\nSee `test-mitzasql.sh` for more info.\n\n### UI testing\nSee `test-mitzasql-ui.sh` for more info.\n\n\n",
        "description_content_type": "text/markdown",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/vladbalmos/mitzasql",
        "keywords": "tui cli ncurses console mysql client",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "mitzasql",
        "package_url": "https://pypi.org/project/mitzasql/",
        "platform": "",
        "project_url": "https://pypi.org/project/mitzasql/",
        "project_urls": {
            "Bug Tracker": "https://github.com/vladbalmos/mitzasql/issues",
            "Homepage": "https://github.com/vladbalmos/mitzasql",
            "Website": "https://vladbalmos.github.io/mitzasql"
        },
        "release_url": "https://pypi.org/project/mitzasql/1.2.0/",
        "requires_dist": [
            "urwid (==2.0.1)",
            "mysql-connector-python (==8.0.16)",
            "appdirs (==1.4.3)",
            "pygments (==2.4.2)"
        ],
        "requires_python": "",
        "summary": "Text user interface MySQL client",
        "version": "1.2.0"
    },
    "last_serial": 5441394,
    "releases": {
        "1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "eede826005d9443933f15006ed7f0a1d",
                    "sha256": "ba13f7fea13cb0425af0ea37ac747886a276c94c004218fa42628a754252e12f"
                },
                "downloads": -1,
                "filename": "mitzasql-1.0-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "eede826005d9443933f15006ed7f0a1d",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 112685,
                "upload_time": "2019-05-16T16:50:17",
                "url": "https://files.pythonhosted.org/packages/2c/ed/dce926e3d28d8380c9365b5f40c90a1cca01a669c1b998d24fe03b5b4172/mitzasql-1.0-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "0d6dd0b43bc1d8775beb5cc353eb3598",
                    "sha256": "27b27352e798b976a8e066394216b21a12f88bd4a8aa8e59b5fceea39eeba74e"
                },
                "downloads": -1,
                "filename": "mitzasql-1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "0d6dd0b43bc1d8775beb5cc353eb3598",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 52807,
                "upload_time": "2019-05-16T16:50:20",
                "url": "https://files.pythonhosted.org/packages/21/dc/6df0e0c0c8b29293667d40bce85f9d09482179c571e30aa1cfc7dfa572be/mitzasql-1.0.tar.gz"
            }
        ],
        "1.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "44c914417359fe6574fb9c9f089023f5",
                    "sha256": "84006ef7e3824b3a21200e91accce4d0e1261fd9f88e62b1d2b644eaf59f0043"
                },
                "downloads": -1,
                "filename": "mitzasql-1.0.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "44c914417359fe6574fb9c9f089023f5",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 114910,
                "upload_time": "2019-05-25T19:23:26",
                "url": "https://files.pythonhosted.org/packages/a7/66/8353ac83c3c993a83732f01d52cc73ed759ea6ea65ac044f1787613ce5d7/mitzasql-1.0.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "32c1595e10eaf4ff55dc6cc1dfdf0bf8",
                    "sha256": "0a2651a315293a7ba7f68d2206ae50d3c00a1e05ebb4f037b40c29e6413d6764"
                },
                "downloads": -1,
                "filename": "mitzasql-1.0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "32c1595e10eaf4ff55dc6cc1dfdf0bf8",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 54351,
                "upload_time": "2019-05-25T19:23:28",
                "url": "https://files.pythonhosted.org/packages/1d/b5/350941905cb0e8dcba88fb6a6080578d63f6de19f7f1fff38533d054c292/mitzasql-1.0.1.tar.gz"
            }
        ],
        "1.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "4979b72a8b5d145831fb0f81e9c35599",
                    "sha256": "9cbf5bc25ef235d065b86a693065e69eee3c8b5b5b369ebada8a920890cc133d"
                },
                "downloads": -1,
                "filename": "mitzasql-1.1.0-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "4979b72a8b5d145831fb0f81e9c35599",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 116302,
                "upload_time": "2019-05-31T20:19:38",
                "url": "https://files.pythonhosted.org/packages/fa/4e/1b7de448f7b0ce2257b23d0d2f530dcbd29f7d8d6df6d5037c5b81cbacd7/mitzasql-1.1.0-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "3aedc574112dfb62562aa8dc9533b273",
                    "sha256": "0c4d48b0f0c56213add8d7b5f13690d674a481a0f2db7baf33a208f4f3121d2f"
                },
                "downloads": -1,
                "filename": "mitzasql-1.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "3aedc574112dfb62562aa8dc9533b273",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 54486,
                "upload_time": "2019-05-31T20:19:40",
                "url": "https://files.pythonhosted.org/packages/f4/2e/001d6900f125238b6adc9bbd972d6e0c426d75630f9d098268f036f2c032/mitzasql-1.1.0.tar.gz"
            }
        ],
        "1.2.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "71650a6ba675f2206a03d2f9add89eac",
                    "sha256": "d92d395dc91eca1c60f3112b494d9014b6ae0861430039823e9a2eb5c2d465b3"
                },
                "downloads": -1,
                "filename": "mitzasql-1.2.0-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "71650a6ba675f2206a03d2f9add89eac",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 118001,
                "upload_time": "2019-06-24T16:21:07",
                "url": "https://files.pythonhosted.org/packages/6a/10/f67de8a9c8c7681b61a002b7fe504fc041dbc837dd3baf70c1c471963f80/mitzasql-1.2.0-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "ce78c975c1692933a55952222828699b",
                    "sha256": "643c6f1f21f49d144927dcee86f9dbb4fc7320247c7fc1836bf905ec1b86be56"
                },
                "downloads": -1,
                "filename": "mitzasql-1.2.0.tar.gz",
                "has_sig": false,
                "md5_digest": "ce78c975c1692933a55952222828699b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 57401,
                "upload_time": "2019-06-24T16:21:09",
                "url": "https://files.pythonhosted.org/packages/57/99/78f13e12e2d5e0155c4fdeba8c68979532b508021e7660984d4523d1cec2/mitzasql-1.2.0.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "71650a6ba675f2206a03d2f9add89eac",
                "sha256": "d92d395dc91eca1c60f3112b494d9014b6ae0861430039823e9a2eb5c2d465b3"
            },
            "downloads": -1,
            "filename": "mitzasql-1.2.0-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "71650a6ba675f2206a03d2f9add89eac",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 118001,
            "upload_time": "2019-06-24T16:21:07",
            "url": "https://files.pythonhosted.org/packages/6a/10/f67de8a9c8c7681b61a002b7fe504fc041dbc837dd3baf70c1c471963f80/mitzasql-1.2.0-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "ce78c975c1692933a55952222828699b",
                "sha256": "643c6f1f21f49d144927dcee86f9dbb4fc7320247c7fc1836bf905ec1b86be56"
            },
            "downloads": -1,
            "filename": "mitzasql-1.2.0.tar.gz",
            "has_sig": false,
            "md5_digest": "ce78c975c1692933a55952222828699b",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 57401,
            "upload_time": "2019-06-24T16:21:09",
            "url": "https://files.pythonhosted.org/packages/57/99/78f13e12e2d5e0155c4fdeba8c68979532b508021e7660984d4523d1cec2/mitzasql-1.2.0.tar.gz"
        }
    ]
}