This repo came about as the result of two personal aims:
-
To show that the football club I support, West Bromwich Albion, has historically been a successful football club when it come to the English domestic football scene
-
To showcase how easy it is to integrate YottaDB data with business intellegence tools.
The solution builds primarily on the YottaDB-APIDev repo:
https://github.com/RamSailopal/YottaDB-APIDev
Data was scraped from the following link - https://en.wikipedia.org/wiki/List_of_football_clubs_in_England_by_competitive_honours_won and pulled into a YottaDB global called ^Football A "dump" of this global can be found in:
EnglishFootball/Football.go
The categorised data was then served via various endpoints:
These endpoints were then "consumed" via the Metabase open source business intellegence tool and the Metabase http plugin to view data in graph format.
git clone https://github.com/RamSailopal/YottaDB-Demo.git
cd YottaDB-Demo/demo
export glbviewadd="192.168.240.1"
Where glbviewadd is the address of the server/machine running Docker.
docker-compose up
Then to view globals:
http://ipaddressofdockerserver:8001
To view code:
http://ipofdockerserver:3002/#/home/yottadb-settings/Yottadb.theia-workspace
To view the dashboards:
http://ipofdockerserver:3001/dashboard/1 - Domestic leagues/cups
http://ipofdockerserver:3001/dashboard/2 - International leagues/cups
http://ipofdockerserver:3001/dashboard/3 - Domestic/International leagues/cups
Enter the following username and password:
footiedemo@test.com
Ball1nthenet
Each graph represents a "question/native query" in the format e.g.:
{ "url": "http://demo_yottamgweb_1:8080/api/totinthons" }
This repo contains ssh keys for demonstation/sandpit purposes only. For a production environment, please set up new, none source controlled keys.
-
West Bromwich Albion is the joint 15th most successful football club in England (consisting of 92 professional clubs)!!!
-
YottaDB can be integrated with third party business intellegence tools even without the need for using the SQL Octo plugin.
Special thanks goes to Rob Tweed for developing the initial mgweb-server implementation:
https://github.com/robtweed/mgweb-server
Also:
Eclipse Theia web IDE:
Metabase business intellegence tool:
Tom Robinson - Metabase HTTP driver: