0

I'm new to databases and i need to use it for a project i am working on, i have the following question.

If we use SQLite manager to create a database on java and then produce a jar file of the complete program. To install this project do we have to always have the SQLite Manager add-on for FireFox for every computer this program is going to be installed on. Despite having the ability to add and remove things from the database in my program in a GUI.

  • 1
    Go through first answer here: http://stackoverflow.com/questions/1525444/how-to-connect-sqlite-with-java – guido Jan 08 '13 at 11:45

1 Answers1

1

No, it's not necessary to include extra tools if your program contains every functionality that is needed to operate the database. In some cases it's even better when the end user can't directly access the database, to avoid all kinds of data corruption issues.

That being said, it can be nice to offer a generic tool alongside your solution, and SQLite Manager would be an excellent choice. Check out this list of SQLite management tools for other possible choices.

As a sidenote, there are embeddable database engines that are written in Java and may be easier/more natural to integrate in a Java program than SQLIte - examples of this type of product are Apache Derby and H2

fvu
  • 32,488
  • 6
  • 61
  • 79