Ledger Databases

Quick rating

Community listing page, reviews here may not be monitored by the author.

How listings work Are you the author?

Ledger Databases

By Potatoboy9999Owner , drexhdCore Dev

No reviews yet

Adds support for additional database types to Ledger

Mod Loaders
Minecraft
26.2
Hosting Partner

Want to reach Minecraft players?

We're looking for a server hosting partner to feature here and other parts of the site. Interested? Send us a message!

Get in touch

About

Description

Ledger Databases

Adds support for MySQL, PostgreSQL and H2 databases in Ledger

Use

Common

For all database types, you will need to place Ledger Databases in your mods folder along with the latest version of ledger

H2

Add the following to the bottom of your Ledger config file:

[database_extensions]

database = "H2"

MySQL

Add the following to the bottom of your Ledger config file:


[database_extensions]

database = "MYSQL"

url = ""

username = ""

password = ""

properties = []

url: Must be URL of database with /<database_name> appended. An example URL would be localhost/ledger. You can optionally add port information such as localhost:3000/ledger

PostgreSQL


[database_extensions]
database = "MYSQL"
url = ""
username = ""
password = ""
properties = []

Connector properties

For some databases, such as MySQL, you can provide properties to the database connector. For each property, add a string entry to the properties array.

properties = ["useJDBCCompliantTimezoneShift=true", "useLegacyDatetimeCode=false", "serverTimezone=UTC"]

Ledger Databases

Adds support for MySQL, H2, and PostgreSQL databases in Ledger

Use

Common

For both MySQL, H2, and PostgreSQL, you will need to place Ledger Databases in your mods folder along with Ledger 1.1.0 or newer

H2

Add the following to the bottom of your Ledger config file:

[database_extensions]
database = "H2"

MySQL

Add the following to the bottom of your Ledger config file:

[database_extensions]
database = "MYSQL"
url = ""
username = ""
password = ""
properties = []
maxPoolSize = 10
connectionTimeout = 60000

url: Must be URL of database with /<database_name> appended. An example URL would be localhost/ledger. You can optionally add port information such as localhost:3000/ledger

PostgreSQL

[database_extensions]
database = "POSTGRESQL"
url = ""
username = ""
password = ""
properties = []
maxPoolSize = 10
connectionTimeout = 60000

SQLite

[database_extensions]
database = "SQLITE"

Connector properties

For some databases, such as MySQL, you can provide properties to the database connector. For each property, add a string entry to the properties array.

properties = ["useJDBCCompliantTimezoneShift=true", "useLegacyDatetimeCode=false", "serverTimezone=UTC"]