The Backend - Pseudo Server

The pseudo server is a remote server with which each bus stop communicates. This server is meant for data logging purposes based on the data received from each bus stop. Initially this server is also intended to create the database and appropriate tables in the database.
The data  received by the server from the bus stop is in the form (bus stop, bus no). Based on the data it received it updates the tables after time stamping the arrival of the information. This is done so that data retrieval at a later stage is accurate and the user gets to see the correct timing which is updated by once central server.


Database :

The server creates a SQLite3  database with a table for each bus and bus stop. Doing this the retrieval of data is much more simplified since memory is not really an issue for a central server.
The tables are updates using prepared statements in C.

For the purpose of simplicity, we have set the ETA for a bus on the bus stop as 1 hour from the current time and  the ETA for the next bus stop as 10 minutes from the current time.