{"id":28247,"library":"spotrix","title":"Spotrix","description":"Spotrix is a modern, enterprise-ready business intelligence web application that allows users to explore and visualize data using a no-code viz builder or a state-of-the-art SQL IDE. Version 1.2.0 is the latest stable release, with active development.","status":"active","version":"1.2.0","language":"python","source_language":"en","source_url":"https://github.com/Spotrix/spotrix","tags":["business-intelligence","data-visualization","sql-ide","analytics"],"install":[{"cmd":"pip install spotrix","lang":"bash","label":"Default install"}],"dependencies":[{"reason":"Required for SQL database connectivity","package":"sqlalchemy","optional":false},{"reason":"Web framework used by Spotrix","package":"flask","optional":false},{"reason":"Data manipulation and analysis","package":"pandas","optional":false},{"reason":"Visualization library (may be replaced in future versions)","package":"plotly","optional":true}],"imports":[{"note":"Main application class. No known common mistake.","wrong":"","symbol":"SpotrixApp","correct":"from spotrix import SpotrixApp"},{"note":"Config class is moved to a separate module in 1.1.0+.","wrong":"from spotrix import Config","symbol":"Config","correct":"from spotrix.config import Config"}],"quickstart":{"code":"from spotrix import SpotrixApp\napp = SpotrixApp()\napp.run(host='0.0.0.0', port=8080)","lang":"python","description":"Initialize and run Spotrix with default settings. For production, configure via environment variables or config file."},"warnings":[{"fix":"Refer to the migration guide in the documentation to update your config.yaml.","message":"In version 1.0.0-alpha, the configuration schema was reworked. Configs from older versions may not be compatible.","severity":"breaking","affected_versions":"<1.0.0-alpha"},{"fix":"Replace `from spotrix.views import ...` with `from spotrix.routes import ...`.","message":"The `spotrix.views` module is deprecated as of 1.2.0. Use `spotrix.routes` instead.","severity":"deprecated","affected_versions":"1.2.0+"},{"fix":"Set the `DATABASE_URL` environment variable to a proper database connection string.","message":"Spotrix requires a running database backend (e.g., PostgreSQL) for persistent storage. In-memory SQLite works for development but not for production.","severity":"gotcha","affected_versions":"All"}],"env_vars":null,"last_verified":"2026-05-09T00:00:00.000Z","next_check":"2026-08-07T00:00:00.000Z","problems":[{"fix":"Use `from spotrix import SpotrixApp` instead of `from spotrix import Spotrix`. Also ensure you have installed version >=1.0.0.","cause":"The main class was renamed in version 1.0.0-alpha from 'Spotrix' to 'SpotrixApp'.","error":"ImportError: cannot import name 'SpotrixApp' from 'spotrix'"},{"fix":"Install SQLAlchemy: `pip install sqlalchemy` or use `pip install spotrix[all]`.","cause":"SQLAlchemy is a required dependency but not installed automatically in some packaging environments.","error":"ModuleNotFoundError: No module named 'sqlalchemy'"},{"fix":"Set the environment variable `SPOTRIX_SECRET_KEY` to a random string, or add `SECRET_KEY: '<random>'` to config.yaml.","cause":"Spotrix requires a secret key for session management. Not set via environment or config file.","error":"spotrix.exceptions.ConfigError: Missing required configuration 'SECRET_KEY'"}],"ecosystem":"pypi","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}