The New DB Updater

Note: This project is not dependent on Minecraft at all, and may be used with any of your Java projects. Also, this project is still in Alpha, and may therefor contain bugs.. Please report any you find.

About

The New Database Updater, also known as TNBDU, is a library that loads a table schema from a YAML file, and automatically updates a database to create tables that aren't already present, or if your table is not the same as the one in the schema it'll add, remove, or modify columns to make sure your database contains the tables, with the columns, you expect it to.

Using The New DB Updater all you have to include in your project is a yaml file like this, and TNDBU will do handle updating your tables for you.

Tables:

  _Example:

    Columns:

      example:

        Type: "INTEGER"

        Unique: true

        Increment: true

      exampleVar:

        Type: "VARCHAR"

        Length: 50

        Default: "DEFAULT_STRING"

        Null: false

    Settings:

      Engine: "INNODB"

      Charset: "utf8mb4"

      Collate: "utf8mb4_unicode_ci"

  _ExamplePrimary:

    Columns:

      name:

        Type: "VARCHAR"

        Length: 50

        Null: false

        Primary: true

      value:

        Type: "DECIMAL"

        Length: 49

        Scale: 4

        Null: false

        Primary: true

    Settings:

      Engine: "INNODB"

      Charset: "utf8mb4"

      Collate: "utf8mb4_unicode_ci"


Settings:

  Prefix: "Prefix"

Instructions

Usage instructions are located on the wiki here.

Join us on Discord.