This sequence starts with a freshly installed instance of Ubuntu and leads you through the installation of SQLstream Blaze and the construction of a streaming application in StreamLab. Our application starts with telemetry data on buses in the Sydney area and ends with a map of the buses in motion and with records on the fastest buses being written to an external database (PostgreSQL).
If you’re going to work through the tutorials start with the prerequisites and the first tutorial. If you just want to read through the tutorials to understand more about StreamLab, skip the installation tutorials and start with tutorial #4.
Prerequisites
SQLstream Blaze runs on Linux, in this example we’ll be using Ubuntu 16.04 running in a virtual machine in VirtualBox. The following commands must be run by someone with superuser privileges on the machine:
sudo apt-get install openjdk-8-jdk
java –version to verify that it’s installed
sudo apt-get install postgresql
sudo apt-get install pgadmin3
sudo –u postgres createuser –d –P demo
When prompted, set the password to: demodemo
The rest of the tutorial does not require superuser privileges and should be done from a normal user account. Download the s-Server and StreamLab installers from http://sqlstream.com/download/ and save them in your ~/Downloads directory.
· Tutorial 1: SQLstream s-Server User Installation takes you through installing the s-Server database engine and associated tools.
· Tutorial 2: StreamLab User Installation takes you through installing StreamLab.
· Tutorial 3: Creating the PostgreSQL speeders and drivers tables takes you through creating two tables in PostgreSQL. The drivers table will contain a list of bus driver names and their ID numbers, which will be used in the streaming app. The speeders table will contain records of the fastest buses, output from the streaming app.
Now everything is installed and we’ve got our external tables ready. Creating the Buses streaming app is split into two parts. At the end we go back to PostgreSQL to see the saved records: