https://www.google.com/search?client=ubuntu&channel=fs&q=covid+stats+india&ie=utf-8&oe=utf-8
We have shared the codes and links for different ubuntu version (>=Ubuntu 18.0 and ubuntu 19.05<=)
Preparing Database of COVID-19 on SQLite (Active cases, Deaths, Recovered). Using QT5 software for GUI and C++ for connecting SQLite to GUI. Here we are tring to Acquired working knowledge of MySQL in real life softwares and projects.
MySQL Connector/C++ is an object-oriented database API library to work with MySQL database and C++.The API is partly built upon the JDBC 4.0 API specification. As a result, the C++ class names and functional interfaces are same as we use in JDBC programming in Java.
MySQL already has a C-style native API library and the problem is that, to fit it with the C++ paradigm, one has to manipulate using cryptic code.MySQL Connector/C++, on the other hand, is purely object-oriented, backed by a well-designed architecture. On the C++ GUI framework, C++ has a variety of options for creating a cross-platform GUI interface.
But, Qt is perhaps the best among them. The library is simple to implement and contains highly intuitive classes and functions to fit almost every need of the developer. This project is an attempt to couple these two techs c++&sql and show how effectively they can be used to create a Qt C++ GUI interface for a MySQL Connector/C++ database application.
Following tools to go hands-on with the following code.The underlying platform for confriguration & settings used here is Linux:
1.MySQL Database
2.MySQL Connector/C++
3.Qt5 Framework with QtCreator
From a programmer's point of view, the key benefits of using MySQL Connector/C++ over native API library are as follows:
1.The API is built to support a Object-Oriented paradigm; therefore, C-style function calls are not required.
2.JDBC 4.0 is an industry standard specification; the MySQL Connector/C++ API is based on this architecture.
3.The evolution of the API will be consistent with industry standards.
4.The API is simple and intuitive.
5.The Qt C++ Framework,a masterpiece work pioneered by Haavard and Eirik,in its present form, has developed a chain of toolkits to suffice almost every need of the developer and has become one of the most versatile frameworks in the C++ arena.
6.It is an excellent framework for building cross-platform C++ applications; it can be ported to all major platforms available in the market. Apart from supporting many other languages, Qt is extensively used for embedded application development.
Hence here, we focus on going hands-on to create a MySQL database application with a Qt interface.That's all!!!
you can view the final output gui video in output file in this project(above)