Search code examples
javadatabasebackendlocal

Local database connected (no server needed) to Backend with Java for Desktop application


I am working on a project in which i am required to have the backend only local with Java. I finished the fornt end whcih was programmed with framework JavaFxsand and i need to make a backend with a database that doesn't connect to internet not like JDBC whoch is connected to MySQL with local host Can anyone help me and suggest any ideas?

i've already tried the JDBC with local connectivity but it always worked with a server which i shouldn't deal with for this project


Solution

  • An embedded database is a database engine that works within your app.

    You have a choice of database engines written in Java that can be embedded within a Java app. These include:

    All of these are open source projects.

    All three of these can be used as a database server or as an embedded database engine.

    You still use JDBC to connect to these, whether they are operating in server-mode or in embedded-mode.


    By the way… You may want to learn about database migration tools such as Flyway or Liquibase.