🗄 Database

CustomAchievements1653 supports both SQLite and MySQL databases.

---

SQLite (Default)

SQLite is the default database. Data is stored in a local file.

database:
  type: SQLITE

Data file location: plugins/CustomAchievements1653/data/customachievements.db

Recommended for: Single servers, small to medium player bases.

---

MySQL

For server networks or large servers, MySQL is supported.

database:
  type: MYSQL
  mysql:
    host: localhost
    port: 3306
    database: customachievements
    username: root
    password: "your_password"
    pool:
      maximum-pool-size: 10
      minimum-idle: 2
      connection-timeout: 30000
      idle-timeout: 600000
      max-lifetime: 1800000

Recommended for: Server networks (BungeeCord/Velocity), large servers.

Connection Pool (HikariCP)

The plugin uses HikariCP for efficient connection pooling. Default settings work well for most servers.

Setting	Default	Description
maximum-pool-size	10	Maximum number of connections
minimum-idle	2	Minimum idle connections
connection-timeout	30000	Max time to wait for a connection (ms)
idle-timeout	600000	Max time a connection can be idle (ms)
max-lifetime	1800000	Max lifetime of a connection (ms)

---

Auto Save

Player data is automatically saved at a configurable interval:

auto-save-interval: 5   # Minutes

Data is also saved:

• When a player disconnects

• When the server shuts down

• When the plugin is reloaded

---

Data Stored

The database stores:

• Player UUID

• Progress for each advancement (current count)

• Completion status (completed or not)

• Completion date

• Login streak data

---