Real Time MySQL charts
SqlDashboards is longer actively being maintained. It is in limited maintenance mode for existing customers only.
Pulse is the replacement. Pulse allows building interactive data tools fast.
See: How to build a Live MySQL Dashboard using Pulse.
We are going to create a sqlDashboard to display live charts of stock prices from a MySQL database.
Creating a SQL Dashboard for MySQL
In this demo we:
- Have a database that stores historical stock data and pulls the latest live prices from yahoo finance.
- Display our data in MySQL workbench
- Add Charts to our sqlDashboard
- Data table displaying the static data for a stock
- Time series graph of latest prices today for one particular stock
- OHLC Chart displaying the price history
- Use a form to allow the user to select particular stocks