This project is a SQLITE user-database Viewer, with Java in backend and JavaScript in front-end. In order to work the database need to contain at least one column named 'age' and one other column. When you select a column name, the application display the Top 100 value in this column
- the number of user with this value, and the average Age of user with this value.
To run this locally
Install Maven. Clone this repo to your file system Build with Maven In STS On windows go on [your-folder]/src/main/resources/ * right-clic on sqlite-jdbc-3.21.0.jar * ->build-path * ->add to build path Then Start server as spring boot app. You will be able to access the site at http://localhost:8080.
Base functionality: Select a databse/table/column to see the associated result appears.
Additionnal functionality: Add a sqlite database to the server. Database's table must have one "age" column plus one other column at least.
-make Rest call from front with :
-Actual offset if there is.
Deploy to Heroku.
Implements Unit test.
- Spring - Java Framework
- Maven - Dependency Management
- JQuery - JavaScript library
- Bootstrap4 - Front-end Component Library
- Vincent Balart