Creating and Deploying a "Static" Database

Question

I'm trying to write a Java application that uses a database to store a large amount of encyclopedic-type information, but I don't know how to store and deploy that information in the application itself. Databases are usually stored in one central location (the server), but for a standalone, distributable application this obviously won't work. I've read that JDBC supports "embedded" databases that work out of the application's current working directory, but this would still require a massive SQL script to populate the local database on each installation of the application (so I assume.)

I am not very familiar with the overall deployment process of applications, so perhaps I'm missing a key step, but this seems like a common problem that would have a simple, standardized solution but thus far I have been unable to find it.

Please don't forget to add a '?' to questions! Some people do a search in the page for '?' and if none exists in the 'question' go directly to the next (actual) question in line. — Andrew Thompson
– Andrew Thompson, Commented Dec 27, 2013 at 8:23
Oh, thank you. Is there any way to edit a title once the question has been created? — WannabeCoder
– WannabeCoder, Commented Dec 27, 2013 at 8:38

julemand101 · Accepted Answer · 2013-12-27 08:19:08Z

1

You could save all you information inside a SQLite database and deploy this together with you application. This way you don't need to recreate you database when you install the application on a new system because the database comes with the installation.

SQLite is a minimal database you can have in a single file and use fully inside you application with a library without any SQL-server software running (all interaction with the database is done by the library you include with you application).

answered Dec 27, 2013 at 8:19

julemand101

31.7k5 gold badges59 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jurgen · Accepted Answer · 2013-12-27 08:19:03Z

0

Java comes with its own 'built' in database that you can use.
See http://www.oracle.com/technetwork/java/javadb/overview/index.html

You don't need to populate it each time you install or run, just once during development.

answered Dec 27, 2013 at 8:19

Jurgen

2,1541 gold badge13 silver badges19 bronze badges

Comments

Ivandolchevic · Accepted Answer · 2013-12-27 10:59:53Z

0

I suggest you SQL Server compact edition.it is totaly free and you can incorporate it into your application (add DLL). No need for anything when you deploy your application because your database is embedded.

Here is the download link : SQL Server compact

answered Dec 27, 2013 at 10:59

Ivandolchevic

1841 silver badge3 bronze badges

Collectives™ on Stack Overflow

Creating and Deploying a "Static" Database

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related