What is the best database for Java desktop applications?

Question

Java

Guys, tell me which database is better suited for this task:
Provide the user with access to the catalog of nomenclature with a size of > 140k positions in the form of a desktop application. Provide convenient and high-quality search in the nomenclature database with the ability to add the found items to the application and its further processing.
Tell us how to store data so that you can make a really useful search by item name (one field), and what database is suitable for this?
I look towards Firebird. What do you think?
I will implement it in java and, accordingly, the solution should be compatible.
Also, the solution should be as local as possible and easy to install. The program installer will be sent to dinosaur users who are with the computer on "you". It is necessary that they launch it and the program is installed and working)

Answer 1

stackoverflow.com/questions/784173/what-are-the-pe...
might help.

Answer 2

140k can be stored in a regular file, implement your pojo from externalizable and implement serialization, so it will be faster, for example, use cqengine to search.

Answer 3

sqlite

Answer 4

h2db - written in java, can be run in embedded mode (+ additional performance). hsqldb is also embedded but is designed for one connection, i.e. not multi-threaded - also very nimble and easily screwed to the project. in my opinion, they do not require any separate installation and can be simply unpacked along with the project.
at least they are often built into even large projects as a default base

Answer 5

I use Apache Derby in my project , connecting via JDBC. Depending on the JDBC driver, you can use either many or one connection. The server can also be embedded and then thin clients can connect to the main application db.apache.org/derby/papers/DerbyTut/ns_intro.html