<div align="right">
<img src="spotrix-frontend/images/guinsoolab-badge.png" width="60" alt="badge">
<br />
</div>
<div align="center">
<img src="spotrix-frontend/images/spotrix.svg" width="120" alt="logo" />
<br/>
<small>a modern, enterprise-ready business intelligence web application</small>
</div>
# Spotrix
[Introduction](https://ciusji.gitbook.io/spotrix/) |
[Installation](https://ciusji.gitbook.io/spotrix/installing/installing-from-source) |
[Configuration](https://ciusji.gitbook.io/spotrix/congiguration/basic-configuration) |
[Creating Charts](https://ciusji.gitbook.io/spotrix/creating-charts/creating-your-charts) |
[APIs](https://ciusji.gitbook.io/spotrix/appendix/api) |
[FAQ](https://ciusji.gitbook.io/spotrix/appendix/faq)
A modern, enterprise-ready business intelligence web application.
## Features
- **Embedded and server modes & disk-based or in-memory databases**: Interactive data analysis, e.g. [Joining & aggregate](https://ciusji.gitbook.io/guinsoo/reference/aggregate) multiple large tables, so simple and fast.
- **Powerful yet easy to use**: Quickly and easily integrate and explore your data, using either our simple no-code viz builder or state-of-the-art SQL IDE.
- **Integrates with modern databases**: _Spotrix_ can connect to any SQL based datasource through SQLAlchemy, including modern cloud native databases and engines at petabyte scale.
- **Modern architecture**: Spotrix is lightweight and highly scalable, leveraging the power of your existing data infrastructure without requiring yet another ingestion layer.
- **Rich visualizations and dashboards**: Spotrix ships with a wide array of beautiful visualizations. Our visualization plug-in architecture makes it easy to build custom visualizations that drop directly into Spotrix.
## Quickstart
Firstly, Install & run your spotrix server with python3 env:
```shell
pip install spotrix
spotrix init
spotrix run
```
Then, open your browser with http://localhost:5000, enjoying your explore.
## Why Spotrix?
Spotrix provides:
- An intuitive interface for visualizing datasets and
crafting interactive dashboards
- A wide array of beautiful visualizations to showcase your data
- Code-free visualization builder to extract and present datasets
- A world-class SQL IDE for preparing data for visualization, including a rich metadata browser
- A lightweight semantic layer which empowers data analysts to quickly define custom dimensions and metrics
- Out-of-the-box support for most SQL-speaking databases
- Seamless, in-memory asynchronous caching and queries
- An extensible security model that allows configuration of very intricate rules
on who can access which product features and datasets.
- Integration with major
authentication backends (database, OpenID, LDAP, OAuth, REMOTE_USER, etc)
- The ability to add custom visualization plugins
- An API for programmatic customization
- A cloud-native architecture designed from the ground up for scale
Spotrix is cloud-native and designed to be highly available. It was designed to scale out to large, distributed
environment and works very well inside containers. While you can easily test drive Spotrix on a modest setup or simple
on your laptop, there's virtually no limit around scaling out the platform.
Spotrix is also cloud-naive in the sense that it is flexible and lets you choose the:
* Web server (Gunicorn, Nginx)
* Metadata database engine (MySQL, Postgres, MariaDB, Sqlite, [Guinsoo 🚀](https://github.com/ciusji/guinsoo), etc)
* Message queue (Redis, RabbitMQ, etc)
* Results backend (S3, MinIO, [AnnaStore 🌈](https://github.com/GuinsooLab/annastore), etc)
Spotrix also works well with services like [LeonaLog](https://github.com/LeonaLog), NewRelic, StatsD and DataDog, and has the
ability to run analytic workloads against most popular database technologies.
## Supported Databases
Spotrix can query data from any SQL-speaking datastore or data engine (e.g. Presto or Athena) that has a Python DB-API driver and a SQLAlchemy dialect.
Here are some of the major database solutions that are supported:
<div align="center">
<img src="./spotrix-frontend/images/redshift.png" alt="redshift" border="0" width="106" height="41" />
<img src="./spotrix-frontend/images/google-biquery.png" alt="google-biquery" border="0" width="114" height="43" />
<img src="./spotrix-frontend/images/snowflake.png" alt="snowflake" border="0" width="152" height="46" />
<img src="./spotrix-frontend/images/trino.png" alt="trino" border="0" width="46" height="46" />
<img src="./spotrix-frontend/images/presto.png" alt="presto" border="0" width="152" height="46" />
<img src="./spotrix-frontend/images/druid.png" alt="druid" border="0" width="135" height="37" />
<img src="./spotrix-frontend/images/postgresql.png" alt="postgresql" border="0" width="132" height="81" />
<img src="./spotrix-frontend/images/mysql.png" alt="mysql" border="0" width="119" height="62" />
<img src="./spotrix-frontend/images/guinsoolab-stack.jpg" alt="guinsoolab-stack" border="0" width="46" height="46" />
<img src="./spotrix-frontend/images/mssql-server.png" alt="mssql-server" border="0" width="93" height="74" />
<img src="./spotrix-frontend/images/db2.png" alt="db2" border="0" width="62" height="62" />
<img src="./spotrix-frontend/images/sqlite.png" alt="sqlite" border="0" width="102" height="45" />
<img src="./spotrix-frontend/images/sybase.png" alt="sybase" border="0" width="128" height="47" />
<img src="./spotrix-frontend/images/mariadb.png" alt="mariadb" border="0" width="83" height="63" />
<img src="./spotrix-frontend/images/vertica.png" alt="vertica" border="0" width="128" height="40" />
<img src="./spotrix-frontend/images/oracle.png" alt="oracle" border="0" width="121" height="66" />
<img src="./spotrix-frontend/images/firebird.png" alt="firebird" border="0" width="86" height="56" />
<img src="./spotrix-frontend/images/greenplum.png" alt="greenplum" border="0" width="140" height="45" />
<img src="./spotrix-frontend/images/clickhouse.png" alt="clickhouse" border="0" width="140" height="37" />
<img src="./spotrix-frontend/images/exasol.png" alt="exasol" border="0" width="106" height="59" />
<img src="./spotrix-frontend/images/minds.svg" alt="minds" border="0" width="62" height="62" />
<img src="./spotrix-frontend/images/guinsoo.png" alt="guinsoo" border="0" width="62" height="46" />
<img src="./spotrix-frontend/images/monet-db.png" alt="monet-db" border="0" width="106" height="46" />
<img src="./spotrix-frontend/images/apache-kylin.png" alt="apache-kylin" border="0" width="56" height="64" />
<img src="./spotrix-frontend/images/hologres.png" alt="hologres" border="0" width="71" height="64" />
<img src="./spotrix-frontend/images/netezza.png" alt="netezza" border="0" width="64" height="64" />
</div>
**A more comprehensive list of supported databases** along with the configuration instructions can be found
[here](https://guinsoolab.github.io/glab/#/app/home).
Want to add support for your datastore or data engine? Read more [here](https://guinsoolab.github.io/glab/#/app/home) about the technical requirements.
## License
[Apache 2.0](./LICENSE.txt)
Raw data
{
"_id": null,
"home_page": "https://github.com/Spotrix/spotrix",
"name": "spotrix",
"maintainer": "",
"docs_url": null,
"requires_python": "~=3.7",
"maintainer_email": "",
"keywords": "",
"author": "ciusji",
"author_email": "bqjimaster@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/b6/02/0f5da2fa411fcfc0b7235ed4bd2afc95632e62b9ccb8060e437f3b22f4f2/spotrix-1.2.0.tar.gz",
"platform": null,
"description": "<div align=\"right\">\n <img src=\"spotrix-frontend/images/guinsoolab-badge.png\" width=\"60\" alt=\"badge\">\n <br />\n</div>\n<div align=\"center\">\n <img src=\"spotrix-frontend/images/spotrix.svg\" width=\"120\" alt=\"logo\" />\n <br/>\n <small>a modern, enterprise-ready business intelligence web application</small>\n</div>\n\n# Spotrix\n\n\n\n\n\n[Introduction](https://ciusji.gitbook.io/spotrix/) | \n[Installation](https://ciusji.gitbook.io/spotrix/installing/installing-from-source) | \n[Configuration](https://ciusji.gitbook.io/spotrix/congiguration/basic-configuration) | \n[Creating Charts](https://ciusji.gitbook.io/spotrix/creating-charts/creating-your-charts) | \n[APIs](https://ciusji.gitbook.io/spotrix/appendix/api) | \n[FAQ](https://ciusji.gitbook.io/spotrix/appendix/faq)\n\nA modern, enterprise-ready business intelligence web application.\n\n\n\n\n## Features\n\n- **Embedded and server modes & disk-based or in-memory databases**: Interactive data analysis, e.g. [Joining & aggregate](https://ciusji.gitbook.io/guinsoo/reference/aggregate) multiple large tables, so simple and fast.\n- **Powerful yet easy to use**: Quickly and easily integrate and explore your data, using either our simple no-code viz builder or state-of-the-art SQL IDE.\n- **Integrates with modern databases**: _Spotrix_ can connect to any SQL based datasource through SQLAlchemy, including modern cloud native databases and engines at petabyte scale.\n- **Modern architecture**: Spotrix is lightweight and highly scalable, leveraging the power of your existing data infrastructure without requiring yet another ingestion layer.\n- **Rich visualizations and dashboards**: Spotrix ships with a wide array of beautiful visualizations. Our visualization plug-in architecture makes it easy to build custom visualizations that drop directly into Spotrix.\n\n\n## Quickstart\n\nFirstly, Install & run your spotrix server with python3 env:\n```shell\npip install spotrix\nspotrix init\nspotrix run\n```\nThen, open your browser with http://localhost:5000, enjoying your explore.\n\n\n## Why Spotrix?\n\nSpotrix provides:\n\n- An intuitive interface for visualizing datasets and\n crafting interactive dashboards\n- A wide array of beautiful visualizations to showcase your data\n- Code-free visualization builder to extract and present datasets\n- A world-class SQL IDE for preparing data for visualization, including a rich metadata browser\n- A lightweight semantic layer which empowers data analysts to quickly define custom dimensions and metrics\n- Out-of-the-box support for most SQL-speaking databases\n- Seamless, in-memory asynchronous caching and queries\n- An extensible security model that allows configuration of very intricate rules\n on who can access which product features and datasets.\n- Integration with major\n authentication backends (database, OpenID, LDAP, OAuth, REMOTE_USER, etc)\n- The ability to add custom visualization plugins\n- An API for programmatic customization\n- A cloud-native architecture designed from the ground up for scale\n\n\n\nSpotrix is cloud-native and designed to be highly available. It was designed to scale out to large, distributed \nenvironment and works very well inside containers. While you can easily test drive Spotrix on a modest setup or simple \non your laptop, there's virtually no limit around scaling out the platform.\n\nSpotrix is also cloud-naive in the sense that it is flexible and lets you choose the:\n\n* Web server (Gunicorn, Nginx)\n* Metadata database engine (MySQL, Postgres, MariaDB, Sqlite, [Guinsoo \ud83d\ude80](https://github.com/ciusji/guinsoo), etc)\n* Message queue (Redis, RabbitMQ, etc)\n* Results backend (S3, MinIO, [AnnaStore \ud83c\udf08](https://github.com/GuinsooLab/annastore), etc)\n\nSpotrix also works well with services like [LeonaLog](https://github.com/LeonaLog), NewRelic, StatsD and DataDog, and has the \nability to run analytic workloads against most popular database technologies.\n\n\n## Supported Databases\n\nSpotrix can query data from any SQL-speaking datastore or data engine (e.g. Presto or Athena) that has a Python DB-API driver and a SQLAlchemy dialect.\n\nHere are some of the major database solutions that are supported:\n\n<div align=\"center\">\n <img src=\"./spotrix-frontend/images/redshift.png\" alt=\"redshift\" border=\"0\" width=\"106\" height=\"41\" />\n <img src=\"./spotrix-frontend/images/google-biquery.png\" alt=\"google-biquery\" border=\"0\" width=\"114\" height=\"43\" />\n <img src=\"./spotrix-frontend/images/snowflake.png\" alt=\"snowflake\" border=\"0\" width=\"152\" height=\"46\" />\n <img src=\"./spotrix-frontend/images/trino.png\" alt=\"trino\" border=\"0\" width=\"46\" height=\"46\" />\n <img src=\"./spotrix-frontend/images/presto.png\" alt=\"presto\" border=\"0\" width=\"152\" height=\"46\" />\n <img src=\"./spotrix-frontend/images/druid.png\" alt=\"druid\" border=\"0\" width=\"135\" height=\"37\" />\n <img src=\"./spotrix-frontend/images/postgresql.png\" alt=\"postgresql\" border=\"0\" width=\"132\" height=\"81\" />\n <img src=\"./spotrix-frontend/images/mysql.png\" alt=\"mysql\" border=\"0\" width=\"119\" height=\"62\" />\n <img src=\"./spotrix-frontend/images/guinsoolab-stack.jpg\" alt=\"guinsoolab-stack\" border=\"0\" width=\"46\" height=\"46\" />\n <img src=\"./spotrix-frontend/images/mssql-server.png\" alt=\"mssql-server\" border=\"0\" width=\"93\" height=\"74\" />\n <img src=\"./spotrix-frontend/images/db2.png\" alt=\"db2\" border=\"0\" width=\"62\" height=\"62\" />\n <img src=\"./spotrix-frontend/images/sqlite.png\" alt=\"sqlite\" border=\"0\" width=\"102\" height=\"45\" />\n <img src=\"./spotrix-frontend/images/sybase.png\" alt=\"sybase\" border=\"0\" width=\"128\" height=\"47\" />\n <img src=\"./spotrix-frontend/images/mariadb.png\" alt=\"mariadb\" border=\"0\" width=\"83\" height=\"63\" />\n <img src=\"./spotrix-frontend/images/vertica.png\" alt=\"vertica\" border=\"0\" width=\"128\" height=\"40\" />\n <img src=\"./spotrix-frontend/images/oracle.png\" alt=\"oracle\" border=\"0\" width=\"121\" height=\"66\" />\n <img src=\"./spotrix-frontend/images/firebird.png\" alt=\"firebird\" border=\"0\" width=\"86\" height=\"56\" />\n <img src=\"./spotrix-frontend/images/greenplum.png\" alt=\"greenplum\" border=\"0\" width=\"140\" height=\"45\" />\n <img src=\"./spotrix-frontend/images/clickhouse.png\" alt=\"clickhouse\" border=\"0\" width=\"140\" height=\"37\" />\n <img src=\"./spotrix-frontend/images/exasol.png\" alt=\"exasol\" border=\"0\" width=\"106\" height=\"59\" />\n <img src=\"./spotrix-frontend/images/minds.svg\" alt=\"minds\" border=\"0\" width=\"62\" height=\"62\" />\n <img src=\"./spotrix-frontend/images/guinsoo.png\" alt=\"guinsoo\" border=\"0\" width=\"62\" height=\"46\" />\n <img src=\"./spotrix-frontend/images/monet-db.png\" alt=\"monet-db\" border=\"0\" width=\"106\" height=\"46\" />\n <img src=\"./spotrix-frontend/images/apache-kylin.png\" alt=\"apache-kylin\" border=\"0\" width=\"56\" height=\"64\" />\n <img src=\"./spotrix-frontend/images/hologres.png\" alt=\"hologres\" border=\"0\" width=\"71\" height=\"64\" />\n <img src=\"./spotrix-frontend/images/netezza.png\" alt=\"netezza\" border=\"0\" width=\"64\" height=\"64\" />\n</div>\n\n**A more comprehensive list of supported databases** along with the configuration instructions can be found\n[here](https://guinsoolab.github.io/glab/#/app/home).\n\nWant to add support for your datastore or data engine? Read more [here](https://guinsoolab.github.io/glab/#/app/home) about the technical requirements.\n\n## License\n\n[Apache 2.0](./LICENSE.txt)\n",
"bugtrack_url": null,
"license": "Apache License, Version 2.0",
"summary": "A modern, enterprise-ready business intelligence web application",
"version": "1.2.0",
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"md5": "b55ea4a3ed7e84a0b0776b5da5400b8f",
"sha256": "cf904c54c01823e3ab987a1a2eb216b13ac0f5822ffbe46437cebf6a17074177"
},
"downloads": -1,
"filename": "spotrix-1.2.0.tar.gz",
"has_sig": false,
"md5_digest": "b55ea4a3ed7e84a0b0776b5da5400b8f",
"packagetype": "sdist",
"python_version": "source",
"requires_python": "~=3.7",
"size": 2018831,
"upload_time": "2022-12-01T12:55:23",
"upload_time_iso_8601": "2022-12-01T12:55:23.612969Z",
"url": "https://files.pythonhosted.org/packages/b6/02/0f5da2fa411fcfc0b7235ed4bd2afc95632e62b9ccb8060e437f3b22f4f2/spotrix-1.2.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2022-12-01 12:55:23",
"github": true,
"gitlab": false,
"bitbucket": false,
"github_user": "Spotrix",
"github_project": "spotrix",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"tox": true,
"lcname": "spotrix"
}
JSON
