These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Java and the static datadump? whats the bestway
Author
Previous Topic Next Topic
Philderbeast
Native Freshfood
Minmatar Republic
#1 - 2012-04-04 10:48:53 UTC
I'm looking at creating an app using the static data dump information however im not sure what the best way to deal with this is in java.

I could use a database connection to a sqllite db (my first though) but im not sure if this is the bes way to deal with this, noting i will only be taking a subset of the data (for manufacturing) has anyone delt with this problem? and is fo what answers did you come up with?

also if you did go down the SLQlite path (or have for a nother project what JDBC driver did you use?
Lutz Major
Austriae Est Imperare Orbi Universo
#2 - 2012-04-05 19:09:39 UTC
The decision of database depends on your application:

if you will only use a local version for your own or want to package it and distribute (like an app) then you should seriously consider using SQLite. The performance is suffice for single (and low-usage) environments and you don't have to install a heavy-weight database server.

if you plan to create a web page with heavy load, you might use MySQL (as its free).

For my own program I use SQLite with the JDBC drivers from Xerial http://www.xerial.org. For some parts I use Spring JDBC 3.something - for various reasons. For data staging and creating cubes I use direct (Prepared)Statements.


You can also go for (packaged) data files if you use only a very small portion of the dump and/or you don't plan to add new features to your app in the future.
Philderbeast
Native Freshfood
Minmatar Republic
#3 - 2012-04-07 09:53:28 UTC
thanks lutz Im ak working on a desktop application so SQLite is the way i am going, xerial was the interface i was looking at so sounds like that part is settled.

thanks for the info.