sql2viz

Name	sql2viz JSON
Version	0.2.0 JSON
	download
home_page	None
Summary	SQL query visualization library with DuckDB backend and GUI support
upload_time	2025-11-03 03:12:58
maintainer	None
docs_url	None
author	None
requires_python	>=3.8
license	MIT
keywords	sql visualization duckdb gui chart
VCS
bugtrack_url
requirements	No requirements were recorded.
Travis-CI	No Travis.
coveralls test coverage	No coveralls.

            # sql2viz

Transform Raw SQL queries into visualizations using DuckDB and Iced.

## Installation

```toml
[dependencies]
sql2viz = { version = "0.1", features = ["gui"] }
```

## Usage

```rust
use sql2viz::vizcreate;

fn main() {
    let query = "SELECT 'A' as x, 10 as y UNION ALL SELECT 'B', 20";
    vizcreate(query.to_string()).unwrap();
}
```

### Example with Database and CSV

```rust
use sql2viz::vizcreate;

fn main() {
    let queries = "
-- Connect to existing database
ATTACH 'mydata.db' AS mydb;

-- Query 1: Sales summary by category
SELECT category, SUM(amount) as total_sales
FROM mydb.sales
GROUP BY category
ORDER BY total_sales DESC;

-- Query 2: Load CSV file
SELECT * FROM 'test.csv' LIMIT 100;
";

    vizcreate(queries.to_string()).unwrap();
}
```

### Screenshots

![Table View](./assets/table.png)

![Chart View](./assets/charts.png)

![Multiple Tabs](./assets/multiple.png)

## Features

- SQL query execution with DuckDB
- Interactive charts (Bar, Line, Area, Scatter)
- Table view
- Column selection for chart axes

## License

MIT OR Apache-2.0


            

Raw data

            {
    "_id": null,
    "home_page": null,
    "name": "sql2viz",
    "maintainer": null,
    "docs_url": null,
    "requires_python": ">=3.8",
    "maintainer_email": null,
    "keywords": "sql, visualization, duckdb, gui, chart",
    "author": null,
    "author_email": null,
    "download_url": "https://files.pythonhosted.org/packages/18/a9/557d6106e9883c9cfee2aa0b9d6f6523a212072cb606394317214aecf785/sql2viz-0.2.0.tar.gz",
    "platform": null,
    "description": "# sql2viz\n\nTransform Raw SQL queries into visualizations using DuckDB and Iced.\n\n## Installation\n\n```toml\n[dependencies]\nsql2viz = { version = \"0.1\", features = [\"gui\"] }\n```\n\n## Usage\n\n```rust\nuse sql2viz::vizcreate;\n\nfn main() {\n    let query = \"SELECT 'A' as x, 10 as y UNION ALL SELECT 'B', 20\";\n    vizcreate(query.to_string()).unwrap();\n}\n```\n\n### Example with Database and CSV\n\n```rust\nuse sql2viz::vizcreate;\n\nfn main() {\n    let queries = \"\n-- Connect to existing database\nATTACH 'mydata.db' AS mydb;\n\n-- Query 1: Sales summary by category\nSELECT category, SUM(amount) as total_sales\nFROM mydb.sales\nGROUP BY category\nORDER BY total_sales DESC;\n\n-- Query 2: Load CSV file\nSELECT * FROM 'test.csv' LIMIT 100;\n\";\n\n    vizcreate(queries.to_string()).unwrap();\n}\n```\n\n### Screenshots\n\n![Table View](./assets/table.png)\n\n![Chart View](./assets/charts.png)\n\n![Multiple Tabs](./assets/multiple.png)\n\n## Features\n\n- SQL query execution with DuckDB\n- Interactive charts (Bar, Line, Area, Scatter)\n- Table view\n- Column selection for chart axes\n\n## License\n\nMIT OR Apache-2.0\n\n",
    "bugtrack_url": null,
    "license": "MIT",
    "summary": "SQL query visualization library with DuckDB backend and GUI support",
    "version": "0.2.0",
    "project_urls": {
        "Documentation": "https://github.com/nkwork9999/sql2viz/blob/dev/README.md",
        "Homepage": "https://github.com/nkwork9999/sql2viz",
        "Issues": "https://github.com/nkwork9999/sql2viz/issues",
        "Repository": "https://github.com/nkwork9999/sql2viz"
    },
    "split_keywords": [
        "sql",
        " visualization",
        " duckdb",
        " gui",
        " chart"
    ],
    "urls": [
        {
            "comment_text": null,
            "digests": {
                "blake2b_256": "4cc8d24bd985d2f378e110d36fc5257bd5781cf9ae8bb6193bfa818b1bc02de9",
                "md5": "a9e6358fe8a80c9b58fc72f21e51f468",
                "sha256": "1f314ea0614f598325fdf43ff47728d01ff1a60c282f3b6898504e05f2c7be44"
            },
            "downloads": -1,
            "filename": "sql2viz-0.2.0-cp311-cp311-macosx_11_0_arm64.whl",
            "has_sig": false,
            "md5_digest": "a9e6358fe8a80c9b58fc72f21e51f468",
            "packagetype": "bdist_wheel",
            "python_version": "cp311",
            "requires_python": ">=3.8",
            "size": 11748018,
            "upload_time": "2025-11-03T03:12:54",
            "upload_time_iso_8601": "2025-11-03T03:12:54.731542Z",
            "url": "https://files.pythonhosted.org/packages/4c/c8/d24bd985d2f378e110d36fc5257bd5781cf9ae8bb6193bfa818b1bc02de9/sql2viz-0.2.0-cp311-cp311-macosx_11_0_arm64.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": null,
            "digests": {
                "blake2b_256": "18a9557d6106e9883c9cfee2aa0b9d6f6523a212072cb606394317214aecf785",
                "md5": "35a1106f40a09ff7b5017bf81d9129fa",
                "sha256": "c156a94ad8745dcae4ea87cb2129d51a76f26bf75f0cbc2ac64bc9a02f909dab"
            },
            "downloads": -1,
            "filename": "sql2viz-0.2.0.tar.gz",
            "has_sig": false,
            "md5_digest": "35a1106f40a09ff7b5017bf81d9129fa",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.8",
            "size": 1517626,
            "upload_time": "2025-11-03T03:12:58",
            "upload_time_iso_8601": "2025-11-03T03:12:58.509976Z",
            "url": "https://files.pythonhosted.org/packages/18/a9/557d6106e9883c9cfee2aa0b9d6f6523a212072cb606394317214aecf785/sql2viz-0.2.0.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2025-11-03 03:12:58",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "nkwork9999",
    "github_project": "sql2viz",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": false,
    "lcname": "sql2viz"
}