Report Service Database

The database for keeping the track of the logs and errors

The idea

There are lot of companies whose apps are being used by the users worldwide. It becomes crucial for the company to identify if the app works properly.

This is where the Error Logging and reporting System comes into play. The Report service provides set of tools and software to deal with the errors and logs being thrown by apps used by people worldwide.

Tools and Softwares under ReportService

  • A framework - Used by developer instead of using traditional console logs the framework provides logging the error directly to our server
  • The Server - Connects to the database and post all error to the database post validation.
  • The App - The app provides the way to see all the errors logged by the apps of the particular company.
    • Each developer of the company gets an account for the usage of the app
  • The Database - The mysql database to keep the record of al the companies, their developers(users) and their apps(web or mobile) and the errors logged by these apps

Setting up the database

  • Clone the repository
  • Start the mysql server
  • Create the new database
  • Run the CreateTables.sql
  • Run the insert.sql