Hello, i know its broad question, but I would like to ask, what database should I use for game development in javaFX with openJPA persistency?
the game is a desktop management simulation game (sport management), so it will be always reading and updating the database with some stats of players, teams etc.
I thought about HSQL that is in-memory db and it could store the database in the file (at SAVE or automaticaly). Or should i use derby?
i read that these db's are not suitable for production, is it still true? i dont want to allow to edit the database (a.k.a. cheating) - can i secure one of these two? are they good choice for openJPA?