Spigot Plugin Development - 82 - Plugin with MySQL Database and JDBC

In this episode of the Spigot series, I show you how to make your first plugin that connects to and uses a MySQL Database to store player statistics. It uses JDBC to connect and execute SQL statements upon the database. #Spigot #Minecraft #SQL

(Adding video timestamps soon)

Want to Support the Channel?

My Socials:

More Videos coming soon.
Leave a comment for any future video suggestions.

[KodySimpson]

Timestamps coming soon, this is a long video

[double-nico]

right when I needed to learn mysql my buddy Kody comes with the clutch, thankss you

[cadeheinberg]

I wish this video was around 2 years ago man. Well done!

[karlito]

I was waiting for this since i was born

[wildgames]

If I want to add a stat after I already created the table and players have data on it, how do I do that? I keep getting errors that Column 'kills' not found. in console when I try to add kills.

[Nanagos]

I'm not even making a plugin, but this video helped a lot, thank you.

[eyasu.]

Great tutorial, this will vastly assist with my plugin that counts how many times someone says the n word

[enttbot]

At what point did you put setBlocksBroken?

[dylanroberts]

Connection pooling. Some servers have their own data source object types to handle connection pooling: MariaDbPoolDataSource and There are differences and drawbacks of each but HikariCP takes the cake as the best library for doing connection pooling. With connection pooling, you call getConnection on the data source, and you are given a connection that you can do things with. For all purposes, people can think of it as magic and they just get a connection, but under the hood code is intelligently managing a pool of database connections. Only having one connection that you shoot work to is not the best method when you have a lot of work you're trying to do.

[rothman]

What’s the font name? I remember that font looking clean in game in a texture pack I used to have

[Cerdax]

Could you make a video on retrieving data asynchronously

[vqluodv]

Why not just make the methods and fields of the Database class static? Wouldn't it be easier that way?

[WoodsGeorgeJr]

can you connect the mysql to a cloud server or a 24/7 server and just instead of ‘localhost’ do ‘the cloud server’s ipv4’? so you can do it on published plugins?

[vayune]

Can you do a tutorial for hikari connection pool? I would donate to have it working on my plugin

[kifo]

How did you add the colors to the sql string at 10:04?

[soycantabro]

Show how to do the same with h2 or sqlite please

[imnesslol]

Can you show how to create a MySQL config so we can edit the credentials from the file please?

[Waffler]

Any fixes for generate feature not working? When I click it, it doesn't bring up any pop ups. I tried closing and reopening, trying in a new project, and restarting my computer, none of which worked.

[maciejkag]

14:50 just a friendly reminder: you could use CHAR(36) for the uuid as its always 36 chars :)

[clownclicker]

"Cannot invoke because "this.database" is null" any help?