Database question

[crisp aurora]

I'm currently using per-player yml files to store some basic state variables per player, but I want to expand it.

In doing so, I'd like to cleanup my code and use a database & API of some sort, but I don't know which.

I'd like to avoid using something like MySQL that requires server owners to set it up, so I was thinking some sort of flatfile database.

[pale tundra]

Use SQLite

This can be useful https://www.spigotmc.org/threads/how-to-sqlite.56847/

[crisp aurora]

do you have some documentation or examples I can reference?

awesome, I'll take a look into it

[pale tundra]

Be careful when executing queries. Make sure you cannot use sql injection

[crisp aurora]

all player input is already filtered to be part of very specific values, but I'll keep it in mind

[sage shore]

why do you not want to use ymls anyway?

[pastel tulip]

xDDD

[dreamy wigeon]

I recommend using PreparedStatement for queries. And if you need help just dm me

[leaden blaze]

Or continue here where everyone can assist you

[dreamy wigeon]

Yes

[dreamy wigeon]

And the sintaxis for quering its similar to MYSQL one.

For not saying its the same