Skip to content

Allows importing of CVE Data from NVD into PostgreSQL. By taking in JSON data and converting it to a more usable relational dataset

License

Notifications You must be signed in to change notification settings

vercasm/CVE2DBMS

Repository files navigation

Creates LOCAL DB for CVE data, and allows import

This service is responsible in taking in CVE JSON Data and importing them into a Relational Database Management System. We are using PostgreSQL. Most other solutions rely on NO-SQL. This solution provides and easy solution to clean data for Data Science and other Statistical work around the use of CVE data.

Requirements:

  • Java 17 or newer
  • PostgreSQL 13 or newer
  • Curl, Insomnia, or some other way of sending files via POST RESTful API requests
  • Consul (For service discovery). THis service originally part of a much larger system that is private.

Input CVE JSONS

POST: <ip:port>/api/v1/pdata

Development Setup:

  • Go to resources/application-prod.yml
    • copy this file to resources/application-dev.ym
    • insert passwords etc. for your machine.
    • dev.yml should be on gitignore. DO NOT CHANGE THIS (We don't need to know your passwords)
    • the ..-dev.yml is for your personal machine only!!!

About

Allows importing of CVE Data from NVD into PostgreSQL. By taking in JSON data and converting it to a more usable relational dataset

Topics

Resources

License

Code of conduct

Stars

Watchers

Forks

Packages

No packages published

Languages