user interface - Pro n cons of using JavaFx with sqlite, or better option -

i creating desktop application in javafx.
1.i want save data on client machine (data should big).
2.want simple configuration database (user friendly).
3.i search sqlite better option type of application don't advantages.so please tell me pro n cons.
4.is there option sqlite such application?
fresher javafx . want .

while sql-lite fine , usable java, writing java application, think pure java database might preferable - example h2.

to use h2, include h2 jar file on application's class path , there no additional setup required use. here example of using h2 database javafx on jdbc.

the h2 based example javafx application javafx connection mysql , answer there may provide more basic info started.

once start using standard api jdbc or jpa , have established database connection, great majority of database related code pretty agnostic of backend database system chosen.

as canvasing detailed opinions of pros , cons of 1 particular database on - google search better resource stackoverflow question.