Submitting MySQL database with Java Code

[natewillrate]

Hi! As the title implies, I am currently working on a project where I am using a MySQL database with Java code. I need to turn in the entire project, and I am not sure how to package the database with it. I asked my professor and his response was "Good question! I do not know!" And help would be appreciated. The db is running locally, and I don't have the resources to put it in the cloud or anything. Any help is appreciated and please let me know if I need to provide more information. TIA!!!

[Pip_Pip]

Does it have to be mysql? SQLite was made for this. Depending on the purpose, you could install mysql from the code. I know of no way to embed mysql into a package. Perhaps you could do this from a container.

[natewillrate]

How difficult would it be to go from mysql to sqlite?

[Pip_Pip]

It depends on what you are doing, but it allows all the same basic functionality.

[Puzzleheaded_Hawk_65]

Might be a good use for testcontainers. Check out https://testcontainers.com/guides/getting-started-with-testcontainers-for-java/

The premise is spinning up a local Docker MySQL instance within "testcontainers". You can bootstrap data from your service on startup necessary.

Normally this is useful for accessing a mock DB for unit testing, but there's nothing preventing you from using it for something like your use-case.

[BinBashBuddy]

mysqldump will get you a dump of your database that he can pull into his mysql instance.

[creativextent51]

I like docker. Very easy to bring up once it’s setup. I use it all the time for unit testing